Microsoft Excel Training Courses
Our half day Microsoft Excel Training Courses are outlined below, along with video clips of the features we focus on.
Custom courses are available for your organisation, we often adjust the content to focus on your specific requirements.
Contact us today to discuss your Excel training needs.
Case Study
Introduction to Excel
Content Covered
* Microsoft Excel Environment
* File Management
* Formatting/Editing
* Multiple Sheets
* Managing Lists
* Construction of Simple Formulas
* Commonly used Functions
* Page Setup/Printing
Data Analysis
Using functions as tools will assist you in creating meaningful information from your data. Functions are also a useful tool for searching for specific information in sheets of data and for creating re-usable tools that can be used for specific business functions.
Content Covered
* How to construct functions
* Using Absolute vs. Relative Formulas
* Formula AutoComplete
* Using the Function Wizard
* Useful Functions for your business
* Conditional Functions (IF, AND, OR)
* Using Named Ranges in Function Construction
* Lookup Functions
* Formula Auditing
* Transposing Data
Data Presentation
Content Covered
* Creating a Chart
* Working with Charts
* Chart Design
* Chart Layout
* Chart Formatting and Inserting Shapes
* Create a Chart Template
* How to copy a chart to Word or PowerPoint
* Working with Secondary Axis Charts
* Creating Pivot Tables
* Manipulating a Pivot Table and using slicers
* Creating Pivot Charts
* Manipulate a PivotChart
Power Pivot
Content Covered
* What is PowerPivot?
* The PowerPivot Environment
* Attaching data sources
* Working in the PowerPivot Environment
* Creating and managing links between data tables
* Introducing DAX Functions
* Creating and Editing PowerPivot Tables and PowerPivot Charts
* Working with DAX Functions & DAX Measures in PowerPivot
* Working with slicers
* Refreshing data
* Saving