Excel Advanced

Microsoft Excel is the worlds leader in spreadsheet software. With our courses you will be able to master the ins and outs of Excel, and be able to comfortably produce professional, stunning and functioning spreadsheets. Excel Advanced is an intermediate to expert guide to Microsoft Excel. The class has some assumed prior knowledge based on Excel Essentials.

Please see below for a list of the topics covered.

Fill Techniques

 

Worksheet Techniques

 

Page Setup

 

Applying Borders

 

Essential Functions

 

Complex Formulas

 

Financial Functions

 

Date and Time Functions

 

 

Defined Names

 

Number Formatting Techniques

 

Conditional Formatting

 

Goal Seeking

 

Quick Analysis

 

Worksheet Tables

 

Chart Elements

 

Chart Object Formatting