Mac Numbers - Learn the spreadsheet application in Mac

Dev G.

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
48 Videos (1h 57m)
    • Introduction to the Course

      1:22
    • 1 Numbers Interface

      2:39
    • 2 Saving,Opening,Renaming and Duplicating Numbers file

      3:17
    • 3 Introduction to Sheets

      0:47
    • 4 Adding Multiple Sheets

      1:24
    • 5 Renaming Sheets

      0:58
    • 6 Duplicating and deleting sheets

      0:57
    • 7 Moving Sheets Around

      0:45
    • 8 Introduction to Tables

      2:03
    • 9 Renaming Table and Table style

      2:43
    • 10 Headers and Footers

      4:08
    • 11 Inserting and Deleting Rows and Columns.

      4:48
    • 12 Hiding and Unhiding Rows and Columns

      2:38
    • 13 Table font size outlines and gridlines

      4:09
    • 14 Alternating colour and size of row and column

      3:01
    • 15 Adding new table within a sheet

      1:16
    • 16 Naming of Cells

      1:33
    • 17 Entering Content in cell, copy and move data between cells

      2:44
    • 18 Applying a fill to a cell, cell border

      2:18
    • 19 Using Autofill to fill cell

      3:22
    • 20 Formatting cell content

      4:06
    • 21 Merging cells

      2:06
    • 22 Simple Formula

      6:53
    • 23 Complex Formulas

      3:52
    • 24 Custom Formula

      2:40
    • 25 Grouping Formulas

      2:21
    • 26 Count Function

      3:04
    • 27 IF function

      3:42
    • 28 Absolute and Relative Referencing

      4:13
    • 29 Introduction To Charts

      4:37
    • 30 Creating Custom Charts

      4:07
    • 31 Creating 3D and Interactive Charts

      1:53
    • 32 Inserting Text and Shape in a Worksheet

      1:20
    • 33 Data Sorting

      1:17
    • 34 Data Filtering

      1:22
    • 35 Creating Custom Filter

      2:29
    • 36 Making Interactive Sheet : Checkbox

      2:45
    • 37 Making Interactive Sheet : Star Rating

      2:34
    • 38 Making Interactive Sheet : Slider

      2:09
    • 39 Making Interactive Sheet : PopUp Menu

      1:55
    • 40 Making Interactive Sheet : Custom Format

      1:50
    • 41 Connecting Different Sheets Together

      1:04
    • 42 Customising The Toolbar

      1:09
    • 43 Conditional Highlighting

      1:43
    • 44 Sharing and Exporting File

      1:24
    • 45 Locking And Password Protecting Numbers File

      1:23
    • 46 Printing File

      1:16
    • 47 Shortcut For Inserting Rows and Columns

      0:54

About This Class

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 - Learn the spreadsheet application in Mac” 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.