Excel Training – Online or In Person
Over 300 Sessions Delivered
on Excel Training
Customised Business Training
We offer tailored training sessions to meet your business needs, ensuring your team gains relevant skills to enhance their productivity with Excel.
Contact us to schedule your training session today!
Online Session - Up to 3 people
£1298.99
£899.99
- Foundation & Intermediate causes available
- Use data from your business as examples
- Business related presention
In Person Training - Up to 6 people
$1,998.99
£1,499.99*
- In-Person Training provided in UK
- Foundation & Intermediate causes available
- Use data from your business as examples
- Business related presention
Course Content
Excel Training Modules
Module 1: Navigation of the Excel Interface
- Starting Excel
- Excel Tab Interface
- Main Components of the Workbook Screen
- Understanding the Backstage View
- Accessing the Backstage View
- Understanding and Launching Dialog Boxes
- Customising the Quick Access Toolbar (QAT)
- Understanding the Status Bar
Module 2: Use of Lists and Tables
- Understanding and Creating Lists
- Applying Filters and Sorting Data
- Creating and Modifying Tables
- Removing Duplicates
- Converting Tables to Ranges
Module 3: Conditional Formatting
- Understanding Conditional Formatting
- Highlighting Cells Based on Values, Text, and Duplicates
- Using Top and Bottom Rules, Data Bars, Colour Scales, and Icon Sets
- Creating Custom Rules
- Managing and Clearing Rules
Module 4: Using Formulas and Creating Pivot Tables
- Using Sparklines
- Mastering Formulas and Functions
- Working with Names and Ranges
- Using Logical Functions and What If Formulas
- Creating and Customising PivotTables and Pivot Charts
- Using VLOOKUP
- Efficiency Tips: Zoom, Undo, Redo, and Repeat with Keystrokes
Module 5: Introduction to VBA
- Understanding VBA and Excel Macros
- Accessing and Navigating the VBA Editor
Let's Work Together!
With 70% of mobile searches leading to conversions within an hour, it’s important to ensure you have a responsive website. Are you looking to generate more leads online but feel the look and feel of your website is giving off the wrong vibe? Sounds like you could use the help of an expert web design agency. Am Into creating websites, let us help you!‘
