v1.15

Excel Proficiency Bootcamp: from basics to intermediate skills

I.T. Training

Course Duration: Two Days

Course Overview

This intensive two-day Excel Proficiency Bootcamp is designed to take participants from foundational Excel knowledge to confident intermediate-level skills. Delegates will attend an Introduction to Excel on Day 1, then take those skills back into the workplace to practice, before returning to 6-8 weeks later for Day 2. Through hands-on exercises and real-world examples, delegates will learn to navigate Excel efficiently, use formulas and functions, manage data and create insightful reports and charts.

Content

Day 1: Introduction to Excel

  • Navigating the Excel interface
  • Creating, saving, and managing workbooks
  • Entering and formatting data
  • Basic formulas and functions (SUM, AVERAGE, MIN, MAX)
  • Relative vs. absolute cell references
  • Introduction to charts and visual data representation
  • Basic data sorting and filtering
  • Printing and page layout options

Day 2: Intermediate Excel Skills
  • Working with multiple worksheets and workbooks
  • Named ranges and structured references
  • Logical functions (IF, AND, OR)
  • Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP)
  • Conditional formatting
  • Data validation and drop-down lists
  • PivotTables and PivotCharts
  • Introduction to Excel Tables and dynamic ranges
  • Basic error handling (IFERROR, ISERROR)

Learning outcomes

Who should attend

Level

Course benefits

Pre-course work

Further courses to consider

Certificates

Looking For Pricing Information?

Call +44 (0) 28 9043 9624
Or Book Online

View Full Course List

View Full Course List

Excel Proficiency Bootcamp: from basics to intermediate skills

Book Now

We are here to help!

For any queries regarding any of our courses please Contact us at enquiries@cosensa.co.uk

Please click here for more information on how we use cookies on this website

Close
Subscribed