IIRF Online > Office Productivity > Apple > Numbers For Mac > Mac Numbers: Creating and Using Spreadsheets On Your Mac
Mac Numbers: Creating and Using Spreadsheets On Your Mac by Udemy
Build spreadsheets, perform calculations, create charts and design forms with practical examples.
Course Highlights
- Create single and multi-table spreadsheets in Numbers
- Use formulas to perform calculations
- Create simple lists of records as spreadsheets
- Create charts from spreadsheet data
- Manipulate spreadsheet elements to create forms and data sheets
- Use logical function in spreadsheets
- Export and share spreadsheets
Skills you will learn!
Curriculum
11 Topics
Using this Course
Introduction
Getting Started
Documents Sheets Tables and Cells
Cells
Tables
Columns and Rows
Titles and Headers
Special Cell Formats
Formula Basics
Example 1: Business Trip Expenses
5 Topics
Relative Formula References
Absolute Formula References
Formula Functions
Footers
Example 2: Simple Checkbook
6 Topics
Sorting Rows
Filtering Rows
Using the COUNTIF Function
Multiple Tables
Example 3: Mortgage Extra Payment Calculator
Example 4: Personal Book Inventory
4 Topics
Borders
Cell Backgrounds
Conditional Highlighting
Example 5: Student Grade Tracker
5 Topics
Creating Charts
Chart Settings
Multi-Column Charts
Pie Charts
Example 6: Sales Charts
6 Topics
Adding Shapes
Text Boxes
Adding Images
Layout and Design
Example 7: Product Sheets
Example 8: Football Squares
8 Topics
IF Statements
AND OR NOT
Durations
Example 9: Due Dates
The LOOKUP Function
The INDIRECT Function
Text Functions
Example 10: Chore Chart
5 Topics
Merging Cells and Wrapping
Exporting
Using iCloud to Share Numbers Documents
Example 11: Physics Experiment
Another Look at AND OR NOT
4 Topics
New Features in Numbers 4.1
Collaboration
New Features in Numbers 5.0
Smart Categories (Pivot Tables) in Numbers 5.2
Mac Numbers: Creating and Using Spreadsheets On Your Mac
Thank You!
Your review has been submitted successfully.