Numbers For Mac A Journey From Beginning To Advance Level

Learn how to work with Numbers (spreadsheet application for mac) and start working with Formulas,Charts,Tables,Sheets.

Last updated 2022-01-10 | 4.4

- Numbers interface and important terminologies regarding spreadsheets.
- Working with spreadsheets
- tables
- cells etc.
- Data manipulation
- presentation and formatting.

What you'll learn

Numbers interface and important terminologies regarding spreadsheets.
Working with spreadsheets
tables
cells etc.
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.
Working with 2D
3D and interactive charts to present data.
Working with Shapes and Media.
Creating Multi-sheets projects and linking different sheets in your file.
Building interactive sheets using pop-up menu
checkboxes
star rating etc.
Much more.

* Requirements

* The students should have Basics knowledge about using Mac.
* They should have Numbers installed in their system.
* Commitment to spend at least two hours per week practicing the skills introduced in the course.

Description

Course Description

Do you want to learn how to work with Numbers in Mac?

Even if you don’t have any prior experience?

Would you like to take your skills to the next level and become an advanced user?

If so, then this is the right course for you!

“Mac Numbers - A Journey from Beginners to Advance level” is a comprehensive course designed to take you from beginners to advance level when it comes to 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 will greatly set you apart from other users of numbers. 

Throughout the course you will learn shortcuts for the most common task that yon need to perform repeatedly. I have also added some neat tricks and tips which will enhance your productivity as well.

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

I have used small examples throughout the course to teach the concepts which you will find helpful. 

This course is perfect for all those who wants to learn about spreadsheet application for their work, school or home project. No prior knowledge about any spreadsheet application is required on your part. The only thing required is the desire and willingness to learn Numbers.




Who this course is for:

  • 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 is not helpful for those who have reached an advance stage in Numbers.

Course content

11 sections • 48 lectures

Numbers' Interface Preview 02:39

Saving,Opening,Renaming and Duplicating Numbers file Preview 03:17

Introduction to Sheets. Preview 00:47

Adding multiple Sheets Preview 01:23

Renaming Sheets. Preview 00:57

Duplicating and Deleting Sheets. Preview 00:57

Moving Sheets around. Preview 00:45

Introduction to Tables Preview 02:02

Renaming Tables and Table Style Preview 02:43

Headers and Footers Preview 04:07

Inserting and Deleting Rows and Columns. Preview 04:47

Hiding and Unhiding Rows and Columns Preview 02:38

Table font size , outline and gridlines Preview 04:09

Alternating colour and size of row and column Preview 03:01

Adding new table within a sheet Preview 01:15

Naming of Cells Preview 01:32

Entering Content in cell, copy and move data between cells Preview 02:43

Applying a fill to a cell, cell border Preview 02:18

Using Autofill to fill cell Preview 03:21

Formatting cell content Preview 04:06

Merging cells Preview 02:06

Simple Formula Preview 06:52

Complex Formulas Preview 03:52

Custom Formula Preview 02:40

Grouping Formulas Preview 02:20

Count Function Preview 03:04

IF function Preview 03:42

Absolute and Relative Referencing Preview 04:13

Introduction To Charts Preview 04:36

Creating Custom Charts Preview 04:07

Creating 3D and Interactive Charts Preview 01:52

Inserting Text and Shape in a Worksheet Preview 01:20

Data Sorting Preview 01:17

Data Filtering Preview 01:22

Creating Custom Filter Preview 02:29

Making Interactive Sheet : Checkbox Preview 02:45

Making Interactive Sheet : Star Rating Preview 02:34

Making Interactive Sheet : Slider Preview 02:09

Making Interactive Sheet : PopUp Menu Preview 01:55

Making Interactive Sheet : Custom Format Preview 01:49

Connecting Different Sheets Together Preview 01:04

Customising The Toolbar Preview 01:09

Conditional Highlighting Preview 01:42

Sharing and Exporting File Preview 01:23

Locking And Password Protecting Numbers File Preview 01:23

Printing Numbers File Preview 01:15

Shortcut For Inserting Rows and Columns Preview 00:54