Microsoft Excel Intermediate Training Course

Introduction and Excel Fundamentals Review
• Overview of Excel workplace applications
• Reviewing core spreadsheet functions
• Workbook and worksheet management
• Navigating large spreadsheets efficiently

Formatting and Data Presentation
• Advanced cell formatting techniques
• Conditional formatting
• Creating professional reports
• Managing rows, columns, and worksheet layouts
• Using styles and themes

Working with Formulas and Functions
Intermediate Formula Skills
• Relative and absolute cell references
• Formula auditing and troubleshooting
• Nested formulas overview

Common Excel Functions
• IF statements
• COUNTIF and SUMIF
• AVERAGE and statistical functions
• Date and time functions
• Text functions

Data Management and Organisation
• Sorting and filtering data
• Using Excel tables
• Data validation techniques
• Removing duplicates
• Managing large datasets

Charts and Data Visualisation
• Creating charts and graphs
• Selecting appropriate chart types
• Formatting charts professionally
• Presenting trends and comparisons visually

Pivot Tables and Reporting
• Introduction to Pivot Tables
• Creating summary reports
• Analysing data efficiently
• Grouping and filtering Pivot Table data

Printing and Workbook Management
• Page setup and print formatting
• Protecting worksheets and workbooks
• Sharing and collaboration considerations

Excel Productivity Techniques
• Keyboard shortcuts
• Time-saving Excel tools
• Improving workflow efficiency
• Reducing spreadsheet errors

This course is suitable for employees who use Excel regularly and wish to improve their spreadsheet and reporting capabilities, including:

• Administrative Personnel
• Office Managers
• HR Professionals
• Finance and Accounts Staff
• Operations Teams
• Supervisors and Team Leaders
• Data Entry Personnel
• Project Coordinators
• Business Support Staff
• Managers responsible for reporting and analysis

Participants should have a basic understanding of Microsoft Excel before attending this intermediate-level course.

Productivity Improvement
Strong Excel skills improve efficiency when managing reports, analysing information, and handling operational data.

Data Accuracy
Understanding formulas, functions, and spreadsheet structures helps reduce reporting errors and inconsistencies.

Workplace Efficiency
Employees with intermediate Excel capability can complete tasks faster and manage information more effectively.

Professional Development
Excel proficiency is increasingly recognised as an essential workplace skill across many industries and job functions.

Participants will:

• Improve confidence using Microsoft Excel
• Use intermediate formulas and functions effectively
• Organise and analyse workplace data
• Create professional reports and charts
• Develop practical spreadsheet problem-solving skills
• Use Pivot Tables for reporting and analysis
• Improve spreadsheet accuracy and workflow efficiency

Instructor-led practical training.

Includes:

• Interactive demonstrations
• Guided workbook exercises
• Real workplace spreadsheet examples
• Hands-on Excel activities
• Participant practice sessions

Delivered:

• Onsite at client premises, or
• Online Webinar

The course focuses on practical workplace application and productivity improvement rather than theory-only instruction.

While Microsoft Excel training is not directly legislated, this course supports organisational responsibilities relating to:

• Safety, Health and Welfare at Work Act 2005
• Safety, Health and Welfare at Work (General Application) Regulations 2007 – Chapter 5: Display Screen Equipment

The course supports organisations by helping employees:

• Work more efficiently with display screen equipment
• Improve safe and effective computer-based work practices
• Reduce repetitive manual administrative processes
• Improve accuracy and consistency in workplace reporting

Samson Training delivers practical workplace IT training designed to improve operational efficiency and employee capability.

Our approach focuses on:

• Practical workplace spreadsheet skills
• Real business reporting scenarios
• Interactive hands-on learning
• Clear and structured instruction
• Productivity-focused training delivery

We position Excel training as a practical business skill that supports operational performance, reporting accuracy, and professional development.

Is this course suitable for beginners?
This is an intermediate-level course. Participants should already have a basic understanding of Microsoft Excel.

Does the course include practical exercises?
Yes. The training is highly practical and includes hands-on workbook exercises and real spreadsheet examples.

Will Pivot Tables be covered?
Yes. Participants receive an introduction to Pivot Tables and how they can be used for workplace reporting and data analysis.

Can the course be tailored to our organisation?
Yes. Training can be adapted to reflect specific reporting, spreadsheet, or operational requirements where appropriate.

Is the course suitable for office-based teams?
Yes. The course is designed for employees across administrative, operational, HR, finance, and management functions.