Numbers for Mac - A Journey from Beginning to Advance level
3.8 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
598 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Numbers for Mac - A Journey from Beginning to Advance level to your Wishlist.

Add to Wishlist

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.
3.8 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
598 students enrolled
Created by Devrishi Gupta
Last updated 11/2016
English
Curiosity Sale
Current price: $10 Original price: $40 Discount: 75% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
What Will I 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.
View Curriculum
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
48 Lectures
01:56:42
+
Introduction and Welcome
1 Lecture 01:21
+
Getting Started
2 Lectures 05:56

Saving,Opening,Renaming and Duplicating Numbers file
03:17
+
Working with Sheets.
5 Lectures 04:49
Introduction to Sheets.
00:47

Adding multiple Sheets
01:23

Renaming Sheets.
00:57

Duplicating and Deleting Sheets.
00:57

Moving Sheets around.
00:45
+
Working with Tables.
8 Lectures 24:42

Renaming Tables and Table Style
02:43

Headers and Footers
04:07

Inserting and Deleting Rows and Columns.
04:47

Hiding and Unhiding Rows and Columns
02:38

Table font size , outline and gridlines
04:09

Alternating colour and size of row and column
03:01

Adding new table within a sheet
01:15
+
Working With Cells
6 Lectures 16:06
Naming of Cells
01:32

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

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

Using Autofill to fill cell
03:21

Formatting cell content
04:06

Merging cells
02:06
+
Working With Formulas
7 Lectures 26:43

Complex Formulas
03:52

Custom Formula
02:40

Grouping Formulas
02:20

Count Function
03:04

IF function
03:42

Absolute and Relative Referencing
04:13
+
Working With Charts.
3 Lectures 10:35

Creating Custom Charts
04:07

Creating 3D and Interactive Charts
01:52
+
Working With Shapes
1 Lecture 01:20
Inserting Text and Shape in a Worksheet
01:20
+
Data Analysis
3 Lectures 05:08
Data Sorting
01:17

Data Filtering
01:22

Creating Custom Filter
02:29
+
Making Interactive Sheets
5 Lectures 11:12

Making Interactive Sheet : Star Rating
02:34

Making Interactive Sheet : Slider
02:09

Making Interactive Sheet : PopUp Menu
01:55

Making Interactive Sheet : Custom Format
01:49
1 More Section
About the Instructor
Devrishi Gupta
4.6 Average rating
25 Reviews
1,503 Students
2 Courses
Software Engineer by Profession,Teacher and an Entrepreneur.

Hello everyone, My name is Devrishi and i am Software engineer. I have worked in one of India’s best software company. I am active in various programming language like Java, C, C++, HTML5,PHP,JavaScript,J2EE, CSS3, Ruby, Jsp, Swift 2 etc. I have worked with Database management system like Oracle,MySql etc. and also have knowledge about Content management  system like Wordpress,Joomla, Moodle. I have a passion to learn new programming language and update my knowledge as new things developed.Apart from all these, I love to play the Guitar (Classical) and Piano.I hope you will learn from my course and increase your potential.