IIRF Online > Office Productivity > Apple > Numbers For Mac > Numbers for Mac - A Journey from Beginning to Advance level
Numbers for Mac - A Journey from Beginning to Advance level by Udemy
Learn how to work with Numbers (spreadsheet application for mac) and start working with Formulas,Charts,Tables,Sheets.
Course Highlights
- 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.
Skills you will learn!
Curriculum
1 Topic
Introduction and Welcome
2 Topics
Numbers' Interface
SavingOpeningRenaming and Duplicating Numbers file
5 Topics
Introduction to Sheets.
Adding multiple Sheets
Renaming Sheets.
Duplicating and Deleting Sheets.
Moving Sheets around.
8 Topics
Introduction to Tables
Renaming Tables and Table Style
Headers and Footers
Inserting and Deleting Rows and Columns.
Hiding and Unhiding Rows and Columns
Table font size outline and gridlines
Alternating colour and size of row and column
Adding new table within a sheet
6 Topics
Naming of Cells
Entering Content in cell copy and move data between cells
Applying a fill to a cell cell border
Using Autofill to fill cell
Formatting cell content
Merging cells
7 Topics
Simple Formula
Complex Formulas
Custom Formula
Grouping Formulas
Count Function
IF function
Absolute and Relative Referencing
3 Topics
Introduction To Charts
Creating Custom Charts
Creating 3D and Interactive Charts
1 Topic
Inserting Text and Shape in a Worksheet
3 Topics
Data Sorting
Data Filtering
Creating Custom Filter
5 Topics
Making Interactive Sheet : Checkbox
Making Interactive Sheet : Star Rating
Making Interactive Sheet : Slider
Making Interactive Sheet : PopUp Menu
Making Interactive Sheet : Custom Format
7 Topics
Connecting Different Sheets Together
Customising The Toolbar
Conditional Highlighting
Sharing and Exporting File
Locking And Password Protecting Numbers File
Printing Numbers File
Shortcut For Inserting Rows and Columns
Numbers for Mac - A Journey from Beginning to Advance level
Thank You!
Your review has been submitted successfully.