Apple Numbers: Complete Basic to Pro Guide For Mac Numbers

• Basic to Advance everything about Apple Numbers or Mac Numbers
• Use formulas to perform calculations
• Building interactive sheets using pop-up menu,checkboxes, star rating etc.
• Create simple lists of records as spreadsheets
• Create single and multi-table spreadsheets in Numbers
• Create charts from spreadsheet data
• Working with 2D,3D and interactive charts to present data.
• Use logical function in spreadsheets
• Manipulate spreadsheet elements to create forms and data sheets
• Working with spreadsheets,tables,cells etc.
• Export and share spreadsheets
• Numbers interface and important terminologies regarding spreadsheets.
• Data manipulation, presentation and formatting.
• Performing basic and advance calculations using simple and complex formulas like IF ,COUNT & COUNTA,COUNTIF & COUNTIFS, SUM, SUMIF & SUMIFS etc.
• Creating Multi-sheets projects and linking different sheets in your file.
• Working with Shapes and Media.
• Much more.

• Introduction to Apple Numbers Basics 43:25

  • 1: Apple Numbers: Complete Basic to Pro Guide For Mac Numbers Preview 02:55
  • 2: Download Premium Resources 01:48
  • 3: 1 Introduction to Numbers Preview 02:26
  • 4: 2 Document Sheet & Tables Preview 02:44
  • 5: 3 Everything about cell Preview 04:42
  • 6: 4 tables Preview 03:35
  • 7: 5 column and rows 02:10
  • 8: 6 Titles & Headers 02:12
  • 9: 7 Special cell formats 07:57
  • 10: 8 Basic Formulas 04:24
  • 11: 9 Practical Example 08:32

• Formulas Using: Tips & Trick 23:18

  • 12: 10 Relative formula 03:06
  • 13: 11 Absolute formula 03:48
  • 14: 12 Formula function 04:11
  • 15: 13 footers 02:27
  • 16: 14 Checkbook report 09:46

• Sorting, Filtering & Multiple Tables 33:37

  • 17: 15 Sort rows 04:01
  • 18: 16 Filter rows 02:56
  • 19: 17 Count if function 02:34
  • 20: 18 Calculate multiple tables 03:14
  • 21: 19 Practical example - Loan or Mortgage 09:16
  • 22: 20 Practical Example - Personal Sheet 11:36

• Cell Orders & Colour Background 11:29

  • 23: 21 Borders 03:08
  • 24: 22 Cell backgrond 04:19
  • 25: 23 Conditional Highlight 04:02

• Creating Charts in Numbers 13:32

  • 26: 24 Creating charts 02:38
  • 27: 25 Chart settings 04:47
  • 28: 26 Multi column chart 03:10
  • 29: 27 Pie charts 02:57

• Designing Spreadsheets 20:04

  • 30: 29 Adding shapes 05:23
  • 31: 30 Text writing 02:42
  • 32: 31 Adding images 02:53
  • 33: 32 Layout & design 02:10
  • 34: 33 Practical - Product Sheet 06:56

• Complex Formula 22:24

  • 35: 34 IF statement 02:08
  • 36: 35 And or Fuction 02:33
  • 37: 36 Durations sheet 02:51
  • 38: 37 Example - Due Dates 07:06
  • 39: 38 Lookup Function 03:06
  • 40: 39 Text Function 04:40

• Exporting & Advanced Topics 23:49

  • 41: 40 Merge & wrap cell 04:17
  • 42: 41 Exporting 03:15
  • 43: Practical Examples 7: Sale Sheet 16:17

• Updates in Numbers 08:21

  • 44: 42 New Feature 06:48
  • 45: 43 New Feature - Collobrate 00:34
  • 46: 44 New Feature - Charts 00:59

Welcome to this course, Apple Numbers: Complete Basic to Pro Guide For Mac Numbers

Mac Numbers is a complete course with video lessons and 12 practical examples taking you from beginner to advanced level. It includes three and a half hours of video tutorials and 12 example files.

This course starts at the start , teaching you the fundamentals like creating a replacement document, starting with the blank template, entering numbers and performing basic calculations. You’ll then advance to make multi-table spreadsheets, perform advanced calculations, sort and filter data, create charts and more.

Whether you would like to use Numbers for work, school, or a project reception , this course can get you up to hurry fast. It doesn't assume that you simply have previous spreadsheet experience. However, if you've got used an application like Excel within the past, you'll also use this course to quickly learn the ins-and-outs of Numbers.

“Mac Numbers - A Journey from Beginners to Advance level” may be a comprehensive course designed to require you from beginners to advance level when it involves working with spreadsheets application like Numbers in Mac.

This video series will start right from the basics like Numbers interface, creating new document using template, entering data, Worksheets, Tables, Cells and gradually move towards advance feature like working with 2D and 3D charts, interactive spreadsheet, simple, complex and custom formulas. Linking spreadsheets etc.

you will also learn skills for Data analysis and custom filtering which can greatly set you aside from other users of numbers.

Throughout the course you'll learn shortcuts for the foremost common task that yon got to perform repeatedly. I even have also added some neat tricks and tips which can enhance your productivity also .

The course is split into section and every section covers one broad area which can gradually build up your skills overtime. I even have recorded short video which can cover one, or at max two, concepts, to facilitate focused learning during this series

I have used small examples throughout the course to show the concepts which you'll find helpful.

This course is ideal for all those that wants to find out about spreadsheet application for his or her work, school or home project. No prior knowledge about any spreadsheet application is required on your part. the sole thing required is that the desire and willingness to find out Numbers.

Enroll Now inside this course, Apple Numbers: Complete Basic to Pro Guide For Mac Numbers.

Enroll Now!!!

• This course is perfect for a first time beginner who wants to learn about spreadsheets program like Numbers.
• This course would be helpful for intermediate user who needs to learn much more than just the basics.
• This course will be helpful for students, accountant, data analyst , office employees etc.
• This course will teach you the basics and many advanced techniques for creating and using spreadsheets with Numbers on your Mac. If you want to use Numbers at home or work but have no previous spreadsheet experience, this course starts at the beginning. If you have used other spreadsheet apps like Excel, this could can help you switch to Numbers.

• Nothing required, everything taught inside this course from scratch to advance
• They should have Numbers version 3.6 or newer installed on their Mac from the Mac App Store.

Currently there are no Q&As for this course. Be the first to ask a question.

Reed courses certificate of completion

Digital certificate - Included