Half-day Bite Sized Microsoft Excel Training Course

Does Your Team Need focussed Half-day
Bite Sized Microsoft Excel Training?

Microsoft Excel Training Pathway – Course Overview

Develop your Excel skills from beginner to advanced level with this comprehensive training pathway. These courses cover everything from creating and formatting spreadsheets through to advanced formulas, data analysis, PivotTables, charts, and VBA automation.

Excel Introduction: Creating Basic Spreadsheets

Learn the fundamentals of Excel, including workbook and worksheet navigation, data entry and editing, formatting techniques, sorting and filtering data, and printing professional spreadsheets. Ideal for beginners with no previous Excel experience.

Excel Introduction: Basic Calculations and Formulas

Build confidence using formulas and functions in Excel. Topics include mathematical operations, AutoSum, common functions (SUM, AVERAGE, COUNT, MIN, MAX), relative and absolute references, and formula auditing tools for troubleshooting and error checking.

Excel Intermediate: More Advanced Formulas and Functions

Develop advanced calculation skills using IF, AND, OR and nested functions, lookup functions such as VLOOKUP, HLOOKUP, INDEX and MATCH, plus date and time calculations. Learn how to create more powerful and dynamic spreadsheets.

Excel Intro – Intermediate: Using Charts in Excel

Transform data into professional visual reports by creating and formatting charts. Learn how to customise chart elements, manage source data, add trendlines, use Goal Seek with charts, and export charts to Word and PowerPoint.

Excel Intermediate: Organising Workbooks and Worksheets

Explore advanced workbook management techniques including linking worksheets and workbooks, data consolidation, conditional formatting, data validation, worksheet protection, change tracking, comments, grouping, outlining, and What-If Analysis tools such as Goal Seek and Scenarios.

Excel Intermediate: Databases and Pivot Tables

Learn how to manage and analyse large datasets using sorting, filtering, subtotals, database functions, and PivotTables. Create PivotCharts, group data, build running totals, import external data, and generate insightful management reports.

Excel Advanced: Introduction to Macros

Discover how macros can automate repetitive tasks in Excel. Learn about the Developer tab, recording macros, assigning macros to buttons and shortcuts, saving macros, understanding VBA code, and creating simple custom VBA functions.

Excel VBA: Recording and Basic Editing of Macros

Gain practical experience recording, running and modifying macros. Topics include macro principles, procedures, modules, editing recorded code, and creating custom buttons to automate routine tasks.

Excel VBA: Introduction to Writing Macros

Move beyond recorded macros and learn VBA programming fundamentals. Explore objects, properties, methods, variables, loops, IF statements, Select Case structures, message boxes, input boxes, debugging techniques, and procedure management.

Excel VBA: Using Form Controls and Events

Advance your VBA skills by creating user forms, controls and event-driven applications. Learn to build interactive solutions using combo boxes, check boxes, option buttons, event procedures, VBA charts, and techniques to protect and secure VBA code.

Please select the Course that you’re interested in

Please choose the Bite-Size course below:

Excel Intermediate - Advanced - Database and Pivot Tables (3 Hours)

Course Overview

Audience:

All Staff – Good basic knowledge of Excel required

Prerequisite:

Delegates should have a good basic knowledge of Excel

Duration:

This is a Half-day Databases and Pivot tables Course. The course starts at 09:30 and runs until 12:30.

Alternate timings can be arranged upon request. The course can be held on a date that suits you.

Location:

Our Microsoft Excel Databases and Pivot tables course can be delivered virtually using online training platforms such as MS Teams or Zoom or face-to-face at any preferred location in the UK, Europe or ROW.

Excel Databases and Pivot tables Course Outline

Working with lists

Creating a list

Creating custom lists

Using the data form

Sorting lists

Single field sorts

Multiple field sorts

Sorting by custom list

Using filters

Using AutoFilter

Using advanced filters

Using wildcards with filters

Using subtotals

Creating subtotals

Adding multiple totals

Removing subtotals

Pivot tables

Creating pivot tables

Changing layouts

Setting functions

Using number formatting

Using data display options (show data as)

Refreshing data

Creating groupings

Creating running totals

Creating pivot formulae

Creating pivot charts

Pivot table options

Database functions

DSum

DAverage

DMax

DMin

Using external data sources

Using Access data

Importing text files

One to One

(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training

Group for up to 6 to 8 learners

The Course outlines on our website are standard, however, we would be happy to tailor them to your specific requirements. Please call us on 020 3696 2796 or send us a message to discuss further.

What Our Clients Say

Extras

This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.