
Navigate the numbers interface, divided into four sections: menu bar, a bar with icons, inspector, and work area. Start with a template such as a budget sheet to enter data.
Master how to add multiple sheets in Numbers for Mac, use keyboard shortcuts to insert and navigate between sheets, and save time through efficient workflow practices.
Adjust font size, outlines, and gridlines in Numbers for Mac to format tables. Control borders, colors, dotted lines, and header or column headers to tailor appearances.
Explore how to use simple formulas in numbers for mac to calculate sum, average, minimum, maximum, and product, then create custom formulas and apply them across data from two tables.
Learn to create and apply custom formulas in Numbers for Mac using the formula box and formula bar, performing addition, subtraction, and cell-based calculations, and reuse formulas with fill handle.
Learn to build interactive pop up menus in Numbers for Mac, with pre-populated items, default values, and minus and up-down controls, and create your own custom menu.
Learn to create a custom format for selected column in Numbers for Mac, name it, and use a text box to prepend or append text like Mr. to names.
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.