Cosensa - Excel Proficiency Bootcamp: from basics to intermediate skills

> Home > Courses > Excel Proficiency Bootcamp: from basics to intermediate skills

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

View Upcoming Dates Print this Page

Related Courses

I.T. Training

Microsoft PowerPoint 2016 - Advanced

Find Out More

I.T. Training

Microsoft PowerPoint 2016 - Introduction

Find Out More

I.T. Training

Microsoft Project 2016 - Introduction

Find Out More

I.T. Training

Microsoft Access 2016 - Advanced

Find Out More

View Full Course List

Excel Proficiency Bootcamp: from basics to intermediate skills

Course Overview