Excel Boot Camp
Course Length
Learning Objectives
- Enter, edit, and format data to create workbooks
- Work with named ranges
- Use SUM, AVERAGE, COUNTIF, XLOOKUP functions and more
- Display relationships between formulas and cells using formula auditing tools
- Sort and filter data
- Organize worksheet data with tables
- Visualize data with charts
- Use Data Validation to restrict data entry and create drop-downs
- Analyze data with Pivot Tables
Target Student
The target audience for the Excel Boot Camp includes professionals and students who need to improve their Excel skills for work or academic purposes. This course is ideal for beginners seeking a solid foundation in Excel, as well as intermediate users who want to enhance their proficiency in data management, analysis, and visualization. It's suitable for individuals in roles that require frequent use of Excel.
Course Outline
The Excel Boot Camp is a comprehensive one-day (six-hour) course designed to equip participants with essential Excel skills. The course covers key areas such as customizing the Quick Access Toolbar, creating and managing formulas, visualizing data with charts, and performing advanced data management and analysis using Pivot Tables. Participants will gain practical experience in organizing lists, using functions, and enhancing data presentation through various Excel features and tools.
In this course, you will create advanced formulas, utilize and maintain database records, utilize named ranges in your formulas and visualize your data in charts.
Section 1: Excel Essentials
Customizing the Quick Access Toolbar
Understanding Rows, Columns and Cells
Properly Clearing Cell Data
Using Excel’s Fill Handle
Section 2: Formulas and Functions
Creating a Basic Formula
Understanding Order of Operations
Working with Absolute and Relative Cell References
Creating and Editing Named Ranges
Introduction to Basic Functions (SUM, AVERAGE, SUMIF, COUNTIF)
Using the AUTOSUM Feature
Using the Function Library
Working with Advanced Functions (IF, XLOOKUP)
Working with Date Functions (TODAY, NOW)
Section 3: Visualizing Data with Charts
Building Charts
Understanding Chart Terminology and Concepts
Modifying and Formatting Charts
Editing Chart Source Data
Working with Chart Elements
Changing Chart Types
Using the Switch Row/Column Feature
Adding Graphics to Charts
Section 4: Data Management and Analysis
Organizing Lists with Excel Data Tables
Converting a List to a Data Table
Using the Total Row
Removing Duplicate Records
Sorting Records
Applying Table Styles
Analyzing Data with Pivot Tables
Understanding Pivot Tables and Their Benefits
Mastering the Four Quadrants
Customizing and Formatting Your Pivot Tables
Understanding the Pivot Tables Fields Pane
Using the “Show Values As” Functionality
Using the Built-in Calculations
Creating Pivot Charts
Filtering Pivot Table Data with Slicers
Working with Data Validation
Setting Data Validation Rules for Data Consistency
Creating Dropdown Lists to Restrict Data Entry
Delivered by Great Canadian Training
Excel Boot Camp
Upcoming Classes
All Public classes are held onlinewith a live instructor
| Dates | Price | Qty |
|---|---|---|
| January 23, 2025 9:00 AM to 4:00 PM ET | $425.00 Online | |
| February 10-11, 2025 1:00 PM to 4:00 PM ET | $425.00 Online | |
| June 16, 2025 9:00 AM to 4:00 PM ET | $425.00 Online |
Groups of 6 or more? Consider private training
I want a quote for private or customized training
Have questions about this course? See below or reach out to our training coordinators.
The Great Canadian Training & Consulting Company Advantage
When you train with us, your training will not just check a box. We make sure it is GREAT!
- Experienced Trainers
- Learn or Come Back Free Policy on Public Classes
- 24/7 After Training Support
All of our courses include
PDF Reference Guide
Want a summary of what you’ve learned? Save paper and use your PDF Reference Guide, accessible on any of your devices.
Certificate of Completion
Boost your credentials with a Certificate of Completion, confirming the skills you’ve acquired with us.
24/7 After-Training Support
Receive a 30-day after-training support voucher, offering assistance as you apply your new skills on the job. Need help with a specific step? We’re here to provide extra support and clarity even after you’ve left the class!
Want even more?
Check out our add-ons
Printed Reference Guide
While we love technology, we understand that there is something about having a paper copy. Add a printed reference guide to your training, which we will have shipped to your location.
Extended After-Training Support
Extend your support beyond the standard 30 days for ongoing assistance.
Upskilling
You’ve learned how to effectively and efficiently use Excel Boot Camp - now you can stay up to date! Book your Upskilling Workshop now and save for when you want to fill in the gaps and explore Microsoft’s latest tools and features.
Can I customize my course?
OF COURSE!
Customized to meet your unique needs
We can customize your training to fit your exact needs, whether it's making small adjustments or creating entirely new courses. From setting specific objectives and including your own files to addressing unique challenges, we're here to help. We can even tailor the training to align more closely with how you work and to fit perfectly into your schedule. Our goal is to provide training that's as unique as your goals.
Use your own files instead of our exercise files
You can opt to use your working files in your private training sessions (instead of our standard exercise files). This allows you to see how the lessons apply directly to your day-to-day role and get work done while you train—a true win-win!
Access to your recorded session for 60 days
You can request your private session be recorded. You can have access for 60 days to revisit what you’ve learned.