Mac Excel Intermediate

Course Content

Naming Cell Ranges

• Concept and Purpose
• Naming individual cells
• Naming ranges of cells
• Deleting and amending named ranges
• Using named cells/ranges in formulae
• Named ranges as a navigation aid

Conditional Functions

• Benefits and purpose
• If Statements
• Nested If
• And, Or, Not Combining If, And, Or, Not, Sumif
• Countif
• Conditional Formatting

Working with Dates and Times

• Entering Dates and Times
• Different date/time formats
• How dates are stored
• Calculating working days
• Using the DAY(),MONTH(),YEAR() functions
• Time calculations

Worksheet Management and Linking

• Inserting and deleting sheets
• Changing the default number of workbook sheets
• Linking sheets in the same file
• Linking different Excel files
• Using Edit, Links
• Viewing different files at once
• Saving a workspace
• Viewing different sheets at once
• Window Split
• Data consolidation

Essential List Management

• Sorting Data
• Adding Subtotals
• Autofilter
• Freeze Panes
• Group and Outline
• Data Form

Charting your data

• Using the Chart Wizard
• Editing and Formatting charts
• Saving custom chart types
• Setting a default chart type

Protecting and Sharing Excel Files

• Sharing a file
• Tracking changes
• Accepting or rejecting changes
• Applying Data validation rules
• Inserting comments
• Protecting cells, sheets, files
• Password protecting a file

Checking for Errors

• Spell-check
• Find and replace
• Autocorrect
• Formula Auditing Tools
• Revealing Formulae
• Tracing Precedents/Dependents
• Goto Special