About the course
Go beyond the basics and unlock the full potential of Microsoft Excel with our comprehensive Advanced Excel Techniques training course.
Designed for users already comfortable with fundamental Excel operations, this hands-on workshop will equip you with powerful tools and techniques to significantly enhance your productivity, perform sophisticated data analysis, and create compelling visualisations.
From mastering advanced formulas and functions to leveraging data manipulation tools, creating dynamic dashboards, and ensuring data integrity and collaboration, this course will empower you to tackle complex tasks with confidence and efficiency in a professional environment.
We can tailor this course to take into account the type of data you're working with, your preferred version of Excel (for instance if you need to upgrade legacy spreadsheets)
Instructor-led online and in-house face-to-face options are available - as part of a wider customised training programme, or as a standalone workshop, on-site at your offices or at one of many flexible meeting spaces in the UK and around the World.
-
- Utilise advanced Excel shortcuts and interface customisation options to maximise productivity.
- Construct complex formulas using a range of advanced functions, including logical, text, lookup, and database functions.
- Effectively manage and analyse data using Excel tables, advanced filtering, and PivotTables.
- Create sophisticated charts and dashboards to visualise data and communicate insights effectively.
- Streamline data manipulation tasks using Flash Fill and Text to Columns.
- Ensure data accuracy and consistency using Paste Special and Data Validation.
- Collaborate effectively on workbooks using commenting and outlining features.
- Enhance worksheet organisation and navigation using Freeze Panes and Split View.
- Apply Conditional Formatting to highlight key data trends and exceptions.
- Understand the principles of creating and using Excel templates for efficiency.
- Implement basic worksheet protection to safeguard data.
-
This course is ideal for data analysts, business analysts, report developers, project managers, administrators, and any professional who regularly uses Microsoft Excel and wants to significantly improve their skills in data manipulation, analysis, reporting, and automation beyond the introductory level.
-
Delegates attending this Advanced Excel course should have a solid working knowledge of basic Microsoft Excel functionality, including:
Navigating the Excel interface.
Entering and formatting data.
Using basic formulas and functions (e.g., SUM, AVERAGE).
Creating simple charts.
Working with worksheets and workbooks.
Basic sorting and filtering.
Familiarity with the concepts of rows, columns, cells, and ranges is essential.
-
This Advanced Excel course is available for private / custom delivery for your team - as an in-house face-to-face workshop at your location of choice, or as online instructor-led training via MS Teams (or your own preferred platform).
Get in touch to find out how we can deliver tailored training which focuses on your project requirements and learning goals.
-
Productivity Power-Ups
Super Shortcuts and Clipboard Mastery
Customising the Quick Access Toolbar and Ribbon
Optimising the Status Bar
Efficient Worksheet Navigation
Exploring Essential Excel Options
Toggling Gridlines and Showing Formulas
Quick Number Formatting Techniques
Advanced Navigation with Go To (F5 and Special)
Leveraging the Format Painter
Mastering Autofill for Efficiency
Worksheet Linking Strategies
Advanced Formula Mastery
Absolute and Mixed References (Using F4)
Creating and Using Named Ranges in Formulas
Working with 3D Formulas
Text Manipulation Functions (&, CONCATENATE, RIGHT, LEFT, LEN, MID, FIND, TRIM, LOWER, UPPER, PROPER)
Logical Functions (IF, IF with Named Ranges, Nested IF Statements, IF with AND/OR)
Counting Functions (COUNT, COUNTA, COUNTIFS)
Conditional Summing with SUMIF
Data Lookup with VLOOKUP
Error Handling with IFERROR
Introduction to Database Functions (DSUM, DCOUNT)
Data Management and Analysis
Harnessing the Power of Excel Tables
Advanced Sorting and Filtering Techniques
Utilising Advanced Filtering Options
Summarising Data with Subtotals
Quick Insights with Quick Analysis
Creating and Customising PivotTables
Advanced PivotTable Formatting and Options
Visualisation and Presentation
Advanced Charting Techniques
Working with Time and Date Functions (Basic and Advanced)
Introduction to Array Formulas and Super Array Formulas
Dashboarding Made Simple: Principles and Techniques
Streamlining Data Tasks
Leveraging Flash Fill for Data Transformation (Splitting, Combining, Formatting, Spacing, Text to Dates)
Efficient Data Parsing with Text to Columns
Advanced Pasting with Paste Special (Skip Blanks, Transpose, Operation)
Ensuring Data Integrity with Data Validation
Collaboration and Protection
Organising Worksheets with Outlining
Improving Workflow with Freeze Panes and Split View
Highlighting Data with Conditional Formatting
Effective Use of Comments for Collaboration
The Benefits of Creating and Using Templates
Protecting Your Worksheet Content
-
Microsoft Excel Help - The official Microsoft Excel support website offers a wealth of articles, tutorials, and how-to guides.
Microsoft Excel Blog - Stay up-to-date with new features, tips, and best practices from the official Microsoft Excel blog.
MrExcel.com Forums - A very active and helpful community forum where you can ask questions and find solutions to Excel challenges.
Trusted by
