Excel Training Courses
Welcome to my Excel Training Hub!
Whether you’re a beginner, intermediate user, or an advanced Excel enthusiast, I specialise in offering customised courses. These can be either online or in-person, in group settings or one-on-one. Through a combination of practical knowledge and hands-on exercises, you’ll gain confidence and efficiency in using this powerful tool.
1
Beginner Excel Training
Our beginner-level Excel training is perfect for those taking their first steps into the world of spreadsheets.
What You'll Learn:
-
Navigating Excel and understanding workbooks.
-
Inputting data, using dates, and basic cell referencing.
-
Formulas and functions for simple calculations.
-
Formatting fonts, colours, and borders.
-
Printing and sharing spreadsheets.
Can be tailored to meet individual preferences and requirements.
2
Intermediate Excel Training
For those who already have some Excel experience, our intermediate training dives deeper into the application’s features.
What You'll Learn:
-
Creating and formatting charts for data visualisation.
-
Advanced formulas and conditional formatting.
-
Quick analysis tools and data tables.
-
Filtering and managing data effectively.
Can be tailored to meet individual preferences and requirements.
3
Advanced Excel Training
Our advanced Excel training is designed for power users who want to master complex tasks.
What You'll Learn:
-
Logical functions (e.g., VLOOKUP, HLOOKUP, INDEX).
-
Pivot Tables: Creating, editing, and analyzing data.
-
Importing and exporting data seamlessly.
-
Automating tasks with macros.
Can be tailored to meet individual preferences and requirements.
4
Data Analysis with Excel
Dive into data analysis techniques using Excel
What You'll Learn:
-
Pivot Tables and Pivot Charts.
-
Data modeling and Power Query.
-
Statistical functions (e.g., AVERAGE, COUNTIF, SUMIFS).
-
Scenario Manager and Goal Seek.
Can be tailored to meet individual preferences and requirements.
5
Excel Dashboards and Reporting
Create dynamic dashboards and reports
What You'll Learn:
-
Designing interactive charts and graphs.
-
Conditional formatting for visual impact.
-
Connecting Excel to external data sources.
-
Automation using macros.
Can be tailored to meet individual preferences and requirements.
6
Advanced Formulas and Functions
Take participants beyond basic functions.
What You'll Learn:
-
Array formulas (e.g., SUMPRODUCT, TRANSPOSE).
-
Lookup functions (e.g., VLOOKUP, INDEX-MATCH).
-
Text manipulation (e.g., CONCATENATE, SUBSTITUTE).
-
Error handling and auditing.
Can be tailored to meet individual preferences and requirements.
7
Excel Workshops for Specific Industries
Customised Training
What You'll Learn:
-
Tailor content for specific sectors (finance, marketing, HR, etc.).
-
Real-world examples relevant to participants’ work.
-
Industry-specific templates and best practices.
Can be tailored to meet individual preferences and requirements.
8
Excel Automation and Macros
Empower users to automate repetitive tasks
What You'll Learn:
-
Recording and editing macros.
-
Creating custom functions (UDFs).
-
Using VBA (Visual Basic for Applications).
Can be tailored to meet individual preferences and requirements.
9
Excel Tips and Tricks
Share productivity hacks and lesser-known features.
What You'll Learn:
-
Keyboard shortcuts and time-saving techniques.
-
Customising the Ribbon and Quick Access Toolbar.
-
Hidden gems like Flash Fill and AutoCorrect.
Can be tailored to meet individual preferences and requirements.
Contact
Like what you see? Get in touch!
