This course is for users who have basic experience with Excel and want to build on their current knowledge to set up their own spreadsheets and manipulate existing ones.
Course Objectives:
To develop a good working knowledge of Excel to include features such as functions and formulae, sorting and filtering data, working with charts and pivot tables.
Course Outline:
Concept And Purpose Naming
Individual Cells
Naming Range Of Cells
Deleting And Amending Named Ranges
Using Name Ranges in Formulae/Functions
Named Ranges As Navigation Aid
Changing the default number of workbook sheets 3D Calculations
Linking sheets in the same file Linking different Excel files
Using Edit, Links
Viewing Different Files on One Screen Window Split / Freeze Panes
Viewing Different Parts of the Sheet On One Screen Custom Views
Logical Functions IF Statements Nested If
Applying and Managing Conditional Formatting
Sorting Data (By Values, By Cell Colour, By Font Colour, By Cell Icons)
Multi Column Sort
Filter (By Values, By Cell Colour, By Font Colour, By Cell Icons)
Multi Column Filter Advanced Filter Adding Subtotals Freeze Panes Group and Outline Data Form
Format as Table Feature
Data Validation
Formulae Auditing Formula View
Tracing Precedents
Tracing Dependents
Using Watch Window
Go To Special…
Charts/Graphs Advanced Techniques
Using Recommended charts
Creating Chart Using Shortcut Keys
Setting Chart as Default
Area, legends, etc…
Using Sparklines (Line, Column, Win/Loss)
Creating a secondary axis
New Charts in Excel 2016
Creating a Pivot Table
Updating the Table
Changing the Table Structure
Formatting the Pivot Table
AutoFormats
Creating Charts from the Data Calculated Items
Using Get Pivot data
Course Summary and Review
Time and Date:
24/09/2025, 9.30am – 12.30pm
via ZOOM. Please note: 2 screens are preferable for this training as it leads to a more productive session.
Cost:
