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-Organising Workbooks and Worksheets (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 Organising workbooks and worksheets 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 Organising workbooks and worksheets 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 Organising workbooks and worksheets Course Outline

Grouping Worksheets

 Concept
 Selecting multiple sheets
 Using formulae
 Using formatting

Linking data

 Concept
 Linking between worksheets
 Using paste special linking
 Creating 3D formulae
 Linking between workbooks
 Editing links
 Changing source
 Updating values
 Removing links

Move / copy worksheets

 Within workbook
 To another workbook

Data consolidation

 Concept
 Consolidating data between sheets
 Using different functions

Conditional formatting and styles

 Using conditional formatting
 Creating and applying styles

Grouping and outlining data
 Grouping rows/columns
 Removing outlines
 Using automatic outlining
Protecting worksheets
 Creating a read-only file
 Protecting worksheets
 Worksheet protection settings
 Protecting workbooks
Data validation
 Setting validation rules
 Using input messages
 Using error messages
Track changes
 Tracking changes
 Accept/reject changes
 Working with comments
What if analysis
 Using goal seek
 Using scenarios

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.