Select Page

Microsoft Excel Training Courses

Empower your workforce to enhance their Excel skills with instructor-led Microsoft Excel training courses. Our end user training courses will advance your team’s knowledge and IT skillsets when using the features within the Excel application. Select from beginner and advanced Microsoft Excel training courses to meet different employee usability requirements. 848’s Microsoft training courses can be delivered virtually, at your desired location, or at the 848 Group head office 

Introduction to Microsoft Excel Training Course

Course outline

This introductory course is designed for end users who have limited experience with Microsoft Excel. This course will make you feel more confident using Excel. Learn how to create easy-to-use and professional looking spreadsheets from scratch. You will understand built-in calculation and formula functionality. To help you work faster and more productively in Excel. Learn how to present your data visually using graphs and charts, format your spreadsheets and more. 

The estimated course duration is 6 hours. This can be delivered in one 6-hour session (with breaks) or 2 x 3 hours. You will receive a certificate of completion at the end of the course.

Topics covered

  • Tour the Window 
  • Enter and Edit Data 
  • Create Range Names 
  • AutoFill 
  • Working with Sheets  
  • Working with Columns and Rows  

  • Text and number formatting  
  • Borders and cell styles  
  • Functions and Formulas  
  • Relevant/Absolute Referencing 
  • BODMAS  
  • Graphs and Charts  

  • Spell Check  
  • Headers and Footers  
  • Page Setup  
  • Print Preview  
  • Printing Options  

  • Sort a Database  
  • Multiple Sorting  
  • AutoFilter  
  • Conditional Criteria  
  • Top 10 Filters  
  • Advanced Filters  

Advanced Microsoft Excel Training Course 

Course outline  

This course is designed for regular users of Microsoft Excel who would like to discover and master further advanced capabilities. Enhance your skills in Excel by learning features and functionality such as pivot tables, logical functions (if, and, or, not), lookup functions (VLOOKUP, HLOOKUP), data validation, and protection. 

The estimated course duration is 6 hours. This can be delivered in one 6-hour session (with breaks) or 2 x 3 hours. You will receive a certificate of completion at the end of the course. 

Topics covered

  • Text to columns  
  • Merge cell data  
  • Database functions  
  • Formula and command linking  
  • Linking workbooks 

 

  • Protect sheets  
  • Protect cells  
  • Freeze panes  
  • IF Functions  
  • IF/OR Functions  
  • IF/AND Functions  
  • Nested IF  
  • AND Function  
  • OR Function  
  • NOT Function  
  • COUNT/IF Function  
  • SUM/IF Function  

 

  • Pivot tables  
  • HLOOKUP  
  • VLOOKUP  
  • Data list  
  • Conditional formatting  
  • Data validation  

Contact us

Unit 3,
Marconi Gate,
Staffordshire Technology Park,
Stafford,
ST18 0FZ
///hours.gone.dusty

 

03449 848 848

Find out more

Privacy Policy

Make a complaint 

Remote Support Session

848 Group Support

Copyright © 2021 The 848 Group.
All Rights Reserved. 

Contact us

Unit 3,
Marconi Gate,
Staffordshire Technology Park,
Stafford,
ST18 0FZ
///hours.gone.dusty

03449 848 848

Find out more

Privacy Policy

Make a complaint 

Remote Support Session

848 Group Support

Copyright © 2021 The 848 Group.
All Rights Reserved.