IIRF Online > Office Productivity > Apple > Numbers For Mac > Apple Numbers: Complete Basic to Pro Guide For Mac Numbers
Apple Numbers: Complete Basic to Pro Guide For Mac Numbers by Udemy
With Apple Mac Numbers build spreadsheets, perform calculations, create charts and design forms with practical examples.
Course Highlights
- Basic to Advance everything about Apple Numbers or Mac Numbers
- Use formulas to perform calculations
- Building interactive sheets using pop-up menu,checkboxes, star rating etc.
- Create simple lists of records as spreadsheets
- Create single and multi-table spreadsheets in Numbers
- Create charts from spreadsheet data
- Working with 2D,3D and interactive charts to present data.
- Use logical function in spreadsheets
- Manipulate spreadsheet elements to create forms and data sheets
- Working with spreadsheets,tables,cells etc.
- Export and share spreadsheets
- Numbers interface and important terminologies regarding spreadsheets.
- 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.
- Creating Multi-sheets projects and linking different sheets in your file.
- Working with Shapes and Media.
- Much more.
Skills you will learn!
Curriculum
12 Topics
Apple Numbers: Complete Basic to Pro Guide For Mac Numbers
Watch This Before Learning Course
Download Premium Resources
Introduction to Apple Numbers
Documents Sheet & Tables
Everything About Cell
Tables in More In-depth
Column & Rows
Titles & Headers
Special Cell Formats
Basic Formulas in Numbers
Practical Examples 1: Expenses Report
5 Topics
Relative Formula Implementation
Absolute Formula Implementation
Using Formula Fuctions
Calculations Using Footers
Practical Examples 2: Checkbook Report
6 Topics
Sorting rows
Filtering rows
Count IF function
Multiples tables
Practical Examples 3: Mortgage Report
Practical Examples 4: Personal Review
3 Topics
Borders
Cell Background
Conditional Highlights
4 Topics
Creating Charts
Chart Settings
Multi Column Charts
Pie charts
5 Topics
Adding Shapes
Text Boxes
Adding Images
Layout & Design
Practical Examples 5: Product Sheet
6 Topics
IF Statement Function
AND / OR Function
Duration Sheet
Practical Examples 6: Due Date
Lookup Function
Text Function
3 Topics
Merge Cell & Word Wrap
Exporting Excel
Practical Examples 7: Sale Sheet
5 Topics
New Feature - Functions
New Feature - Collobrate
New Feature - Charts
Watch Free Courses From Here
Bonus
Apple Numbers: Complete Basic to Pro Guide For Mac Numbers
Thank You!
Your review has been submitted successfully.