EXCEL INTERMEDIATE

MODULE 1: Advanced File Tasks

Learning outcomes:

A look at some important administrative features which are useful for managing and controlling Excel files.

Topics covered:

• Saving and File Management
• Converting and Encrypting Files
• File Properties and Digital Signatures
• File Accessibility and Compatibility

MODULE 2: Working with Functions and Formulas

Learning outcomes:

Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.

Topics covered:

• Autosum Functions (SUM & AVERAGE)
• IF and Nested Functions
• Working with Named Ranges
• Array Functions (SUMIF & AVERAGEIF)
• Formula Auditing
• Formulas with Absolute References
• Text Functions

MODULE 3: Managing Tables in Microsoft Excel

Learning outcomes:

Managing spreadsheet data in table format, an excellent feature to administrate large sets of data.

Topics covered:

• Creating Excel Tables
• Working with Records and Filters
• Advanced Filters

MODULE 4: Data Tools in Excel

Learning outcomes:

Features to help with managing spreadsheet data making it a less daunting and repetitive task to manage the data.

Topics covered:

• Text to Columns
• Flash Fill
• Remove Duplicates
• Data Validation
• Consolidate

MODULE 5: Doing More with Charts in Excel

Learning outcomes:

Developing your ability to effectively create charts and format them specific to the reader

Topics covered:

• Trendlines
• Error Bars
• Working with Axis Options
• Advanced Chart Formatting

MODULE 6: Sparklines

Learning outcomes:

Use Sparklines to help analyse data by creating small customisable charts within cells. Edit and format the Sparklines and data points to help your data stand out

Topics covered:

• Creating Sparklines
• Editing Sparklines