Excel can be frustrating and challenging. However, these obstacles can be overcome.
How does Excel work with all its sheets, cells, rows, and columns? Why are the $-signs so important when referencing? How do you create a drop-down list? How can you scroll while still seeing the headings?
Learn this and everything else worth knowing inside of Excel!
Studies show that up to 80% of your time is spent preparing and managing your data. For example: extracting all unique values, summarizing units per item, and finding all values above 1,000.
Learn how to make the data cleaning process smoother. Master filtering techniques, apply conditional formatting, and summarize data using PivotTables, among other skills.
Feeling overwhelmed by the 480+ available functions?
Learn the most essential functions and familiarize yourself with the latest must-know functions.
Want to navigate cells and sheets more efficiently?
Learn how to move quickly (please don't scroll to row 1,523), discover the best shortcuts and add frequently used commands to the Quick Access Toolbar.
Need to create clear and professional charts and graphs?
Learn how to derive insights from your data through effective visuals. Remember, good visuals are about clarity, not just aesthetics.
A collegue wanted to know if there were any errors in the dataset and manually scrolled through over a thousand rows of data to check for errors.
Use Conditional Formatting to automatically highlight errors. Add a filter to only see the rows with errors.
Each month, a person in the accounting team matched 300 intercompany balances by scrolling to find the counterparty and performing a simple calculation. About 900 rows of data needed to be reconciled in both directions.
Learn to automatically retrieve the counterparty value using a lookup function (XLOOKUP) or a "sum based on criteria" function (SUMIFS).
The marketing team needed to examine customer feedback from different regions and products to spot trends and areas for improvement. Despite having hundreds of thousands of rows of data, they were unsure how to proceed.
Use PivotTables to efficiently analyze the customer feedback data. A PivotTables can help you group feedback by region and product, making it easy to identify trends and areas for improvement.
Excel - Learn how to write formulas with functions, reference cells and arrays, work with sheets, save your file, and print your data.
The Ribbon - Discover all the important features and tools in the ribbon to help you complete tasks in Excel. For example, protect your sheet from changes and scroll while keeping the heading visible.
Conditional Formatting - Format cells based on criteria. For example, highlight all words containing "ExcelBerry" or all values above 1000.
Data Cleaning - Learn to retrieve characters from a cell, combine data from multiple cells, remove duplicate values, and replace values.
PivotTables - Calculate, summarize, and analyze data effectively with PivotTables. Filter with slicers.
Functions - Master lookup functions, logical functions, date functions, and new improved functions. All the must-know functions to create powerful formulas.
Various ways to work faster - Navigate quickly, use shortcuts, quick access commands, links, and much more.
Macros - Automate clicks and keystrokes without needing to write code yourself. It's easier than you think!
AI - Learn what AI is and how to use it effectively in your Excel work, with a focus on ChatGPT and built-in AI capabilities.
Welcome!!!
Download Course Material
Download Bonus Material
101 - Excel
FREE PREVIEW102 - Function
103 - Ribbon
104 - Navigate within a sheet
FREE PREVIEW105 - Working with sheets
106 - Printing
107 - Save and close
108 - Some final things before we start
201 - Formatting basics
202 - Themes and colors
FREE PREVIEW203 - Freezing panes
204 - Referencing
205 - Naming cells
206 - Drop-down list
FREE PREVIEW207 - Paste special
Quiz - Module 2
301 - Intro
302 - Duplicates and uniques
FREE PREVIEW303 - Text that Contains
304 - Top and Bottom X item(s)
305 - Color Scales
306 - Change and remove
307 - Tips
Quiz - Module 3
401 - Data cleaning
402 - Text to Columns
FREE PREVIEW403 - Find and Replace
404 - IFERROR
405 - Remove duplicates
406 - Combine data
407 - Transpose data
Quiz - Module 4
501 - Upper- and Lowercase
502 - Character Location
503 - Date and time
504 - Logical functions
FREE PREVIEW505 - Statistical functions
Quiz - Module 5
Get ready to dive in!
This is what the course is all about:
From Excel fundamentals to lookup functions and Pivot tables—each module wraps up with a quiz!
Follow along, watch again and learn at your own pace!
$110-value vault of ready-to-use templates & guides! Curious? More details.
We are so confident that this course will meet your learning and growth objectives that we offer a full refund if you are not satisfied within the first 30 days.
In addition to the course material, you'll also gain exclusive access to valuable bonus documents that can further refine your Excel skills and improve your productivity. Valued at $110!
Here's a sneak peek:
“I enrolled in the Excelerator Course as a complete beginner, and it has been a revelation. The course content is structured perfectly, making each concept easy to grasp. The practical exercises helped me apply what I learned immediately. I now feel confident in using Excel for my work projects.”
Jane D
“The Excelerator Course is a must for anyone looking to enhance their Excel skills. The lessons are detailed and I like the explanations and clarity when functions and the theory surrounding the functions are explained.”
Mark T
“Great course, worth both the time and money spend!”
David H
“The workbook we used was fantastic! It's clear that a lot of time went into creating this course. Thanks!”
Tom S
“Shoutout to the Excelerator Course! The tutorials are spot on, and the instructor really knows his stuff. 5/5”
Mike L
“The instructor’s expertise shines through every lesson. The course not only improved my Excel skills but also boosted my confidence in handling complex data tasks.”
Laura M
“The course was extremely helpful for my work as an accountant. I've used Excel a lot but never took the time to learn it this thoroughly.”
Emma J
This course is designed for beginner to intermediate Excel users. If you feel the pace is too slow, you can watch the videos at 2x speed, or skip a chapter if you're already familiar with the content.
Most of the features you will learn can be used on any version of Excel. For new and improved functions, you need Excel 2019 or later. For AI-integrated tools and the latest updates, an Office 365 subscription is recommended. Each video will mention if there is a specific version you need.
Unlike many generic Excel courses, this course is specifically tailored for business roles, leveraging the expertise of instructors with experience at top-tier companies like KPMG. This course is meticulously edited to focus solely on essential skills, avoiding the redundancy often found in 30-hour courses – because, let's face it, who has that kind of time these days? We emphasize real-life examples and ensure our content is always up-to-date, even including new chapters about AI in 2024.
Yes! Upon finishing this course, you'll be awarded a Completion Certificate, which you can proudly add to your LinkedIn profile or resume.
How long time does it take to binge watch a Netflix-series? If you really take the time to go through all material provided, it takes up to 5-10 hours.
No. You can complete the course at your own pace, as it will remain accessible to you at any time that suits your schedule.
Yes, a discount is available! Please email [email protected] to learn more.
