ULearning

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.

Course Goal

At the end of my course, students will learn about.

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.

Who should take this course? Who should not?

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.