Excel Bootcamp A-Z | The Hands-On Excel Training

Name: Excel Bootcamp A-Z | The Hands-On Excel Training
Rating: 4.6 (20 reviews)

Learn how to get the most out of excel

Created byBas Dohmen

Last updated 9/2022

English

English [Auto],

What you'll learn

You will master Excel and boost your work productivity
You will be able to create interactive dashboards using pivot tables and charts
You will be able to create impactful charts and get the most out of Excel's visualization features such as conditional formatting and sparklines
You will be able to leverage formulas and functions for your data analysis to get more insights more quickly
You will learn from hands-on exercises that make sure you are able to implement everything straight away and to ensure you will remember all new information
You will learn the most useful tips and tricks - no time is spent on trivial functionalities or examples
You will have lifetime access to the ultimate excel training, which successfully helped thousands of students master excel
You will have access to a trainer with 10+ years of training who is well-known within the analytics community

Course content

7 sections • 51 lectures • 6h 59m total length

Download Course Files0:02
download link

Shortcuts for selecting data and moving around the workbook5:18
What you need to know about text, values, and dates8:18
Learn how to create a new sheet, enter text and date values, distinguish text from numbers, format dates, adjust alignment, and use fill series to generate booking dates.
So what options do we have for sheets, rows & columns, and cells4:40
Copy pasting data - clipboard tasks4:09
Making everything pretty with formatting6:49
Getting everything ready for printing3:16

Creating a simple formula5:05
Formulas for logical comparisons6:06
Explore using formulas for logical comparisons in Excel to automatically check conditions and return true or false with operators like greater than, less than, not equal, and equal.
Cell references: what's up with the dollar signs $6:59
Exercise: where to put the $ signs?3:33
Aggregation functions: get more done more quickly with functions3:31
Logical functions: how to handle more complex logical conditions6:16
IF function + nesting functions: if within an if, within another if7:41
Some more practice with the IF function6:50
IFS function: maybe easier?3:23
Exercise: cell references, IF function, and returning blanks3:51
Conditional calculations: COUNTIF(S)7:27
Conditional calculations: SUMIF(S), AVERAGEIF(S)8:12
Learn to perform conditional calculations with sumif, sumifs, averageif, and averageifs, including multiple criteria for monthly sales by year, and using zero handling for accurate averages.

The basics of conditional formatting5:35
Apply conditional formatting in Excel by selecting cells, choosing a rule such as greater than 7500, and customizing fill, font, and borders while managing rules for multiple conditions.
What happens if two rules apply to the same cells?6:21
Exploring formatting rules7:32
Writing your own custom rules8:25
Learn to create custom conditional formatting rules in Excel with formulas that return true or false, highlight text or hotels, and use absolute references to apply across rows and columns.
Data bars with icons3:17
Custom formatting strings4:45
Display values in thousands or millions12:25
Custom formatting strings in charts6:18
Learn to combine custom formatting strings with charts in Excel, applying percentage formats with symbols, Unicode arrows for positive and negative values, and axis labeling for growth percentages.
Sparklines to quickly see the trend8:23
KPI cards with sparklines and custom formatting5:31

Requirements

No prior experience is needed
Any windows excel version (Excel 2007, 2010, 2013, 2016, 2019, Office 365)

Description

You want to get up and running quickly in Excel or you already know a bit and want to learn how to get the most out of this wonderful tool. Then this training is for you. With a lot of practical examples and exercises you will learn about the most important topics you need to know. From working with formulas and functions to building dashboards with pivot tables and charts.

This training is what you need if you are starting with Excel, struggling with Excel or want to deepen the Excel knowledge you already have. It is a complete Excel course that will help you build one of the most crucial skills in business- Excel proficiency.

But be aware! It is not another boring copy/paste training where you learn irrelevant shortcuts or explore functionalities that do not provide much value in practice. You will learn tips and tricks that make you more efficient than ever in your everyday work. With a good grasp of key features and how they can be combined you'll be able to tackle common business challenges more effectively.

Topics include: Building dashboards with Pivot Tables & Charts, visualization tools such as conditional formatting and sparklines, and of course everything you need to know about formulas and functions from conditional logic with IF functions to lookup functions like XLOOKUP and INDEX MATCH.

After this training you will be able to gain insights from data quicker, visualize data correctly and automate some common manual tasks.

Let’s go!

Who this course is for:

Anyone that wants a hands-on and fun excel training that focuses on the most impactful features
Excel users that want to deepen their knowledge and see if there are more efficient ways of doing this as well as explore new functionalities
Absolute beginners that want a structured learning path to master excel within a day

Excel Bootcamp A-Z | The Hands-On Excel Training

What you'll learn

Explore related topics

Course content

Let's Get the Training Files First1 lecture • 1min

Getting Started with Excel | Excel Bootcamp Part 16 lectures • 33min

Fun with Formulas & Functions | Excel Bootcamp part 212 lectures • 1hr 9min

Lookup Functions | Excel Bootcamp Part 39 lectures • 1hr 8min

Charts and Data Visualization | Excel Bootcamp Part 45 lectures • 50min

Pivot Tables & Charts | Excel Bootcamp Part 58 lectures • 2hr 12min

Visualisation Tools | Excel Bootcamp Part 610 lectures • 1hr 9min

Requirements

Description

Who this course is for: