Microsoft Excel Tutorials: Including Free Practice Exercises!

Right below you find +100 Excel-tutorials. All tutorials are super practical and include free exercises.
Simply download the included sample file and start practicing your Excel skills today!


Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

7 Little-Known But Super Useful Excel Shortcuts [For Windows and Mac]

2019-07-25T09:43:21+00:00

7 Little-Known But Super Useful Excel Shortcuts [For Windows and Mac] Written by co-founder Kasper Langmann, Microsoft Office Specialist. Keyboard shortcuts help save time and increase productivity. Unfortunately, most people only know the holy trinity of shortcuts — COPY, PASTE, and UNDO. In Excel, there are more than 500 keyboard shortcuts. Some [...]

7 Little-Known But Super Useful Excel Shortcuts [For Windows and Mac]2019-07-25T09:43:21+00:00

How To Use The Function Concatenate To Combine Texts in Excel [2 Simple Methods]

2019-07-25T09:24:58+00:00

How to Combine Texts with the Concatenate Function [2 Simple Methods] Written by co-founder Kasper Langmann, Microsoft Office Specialist. The 'CONCATENATE' function is one of the most awesome 'Text Functions' in Excel. It's one of the text-combining functions that would save you a lot of time. Gone are the days when you had [...]

How To Use The Function Concatenate To Combine Texts in Excel [2 Simple Methods]2019-07-25T09:24:58+00:00

Guide to Ribbon Hero 2 – Clippy’s Second Chance [Free Download]

2019-07-10T12:02:45+00:00

Ribbon Hero 2: Learning Microsoft Office Has Never Been More Fun! Ribbon Hero 2: Clippy's Second Chance (how awesome a name is that?) is Microsoft's answer to learning Office in a fun, free easy way. Ribbon Hero 2 was released for Office 2007 and 2010. Despite the game being a few years old, the fact [...]

Guide to Ribbon Hero 2 – Clippy’s Second Chance [Free Download]2019-07-10T12:02:45+00:00

How to Calculate Standard Deviation in Excel

2019-03-29T09:10:10+00:00

How to Calculate Standard Deviation in Excel Are your data points concentrated? Or spread out? That's what standard deviation will tell you. And when you present your data to someone else, it's a great way to provide more information. First we'll define standard deviation. Then we'll talk about populations and samples, and why they're [...]

How to Calculate Standard Deviation in Excel2019-03-29T09:10:10+00:00

How to Add and Modify Error Bars in Excel

2019-07-30T09:12:56+00:00

How to Add and Modify Error Bars in Excel A naked bar graph makes your data look uniform. In most cases, that's misleading. Wouldn't it be nice if you could show the variability in your data right in the graph? That's what error bars are for. They show (or predict) variability. It might not [...]

How to Add and Modify Error Bars in Excel2019-07-30T09:12:56+00:00

The VALUE Function Explained: Convert Text to Numbers

2019-05-16T11:29:38+00:00

The VALUE Function Explained: Convert Text to Numbers Written by co-founder Kasper Langmann, Microsoft Office Specialist. In this tutorial, you learn how to use the 'VALUE' function in Excel. The VALUE function convert numbers stored as text into number format. Don't worry if it sounds a bit complicated, I show you everything step-by-step. Later, you'll [...]

The VALUE Function Explained: Convert Text to Numbers2019-05-16T11:29:38+00:00

The TEXT Function Explained: Convert A Number To Text

2019-03-28T15:25:37+00:00

The TEXT Function Explained: Convert A Number To Text Written by co-founder Kasper Langmann, Microsoft Office Specialist. In this tutorial, you learn exactly how to use the ‘TEXT’ function in Excel. You use ‘TEXT’ to convert a numeric value to text in a specific number format. For instance, you learn how to convert a [...]

The TEXT Function Explained: Convert A Number To Text2019-03-28T15:25:37+00:00

Visual Studio Community

2019-06-13T13:30:12+00:00

Visual Studio Express Is No More. What Is Visual Studio Community? If you’ve looked for Microsoft’s Visual Studio Express IDE lately, you’ll have noticed that it’s no longer available. Which may have made you nervous. Express was the free version of Visual Studio, so now that it’s gone, will you have to fork over [...]

Visual Studio Community2019-06-13T13:30:12+00:00

VBA VLOOKUP: How to Use Worksheet Functions in VBA

2019-04-13T07:08:29+00:00

VBA VLOOKUP: How to Use Worksheet Functions in VBA Written by co-founder Kasper Langmann, Microsoft Office Specialist. Visual Basic for Applications (VBA) has many built-in functions that help you work with spreadsheet data. But Excel is the undisputed king when it comes to useful functions. Fortunately, you can use worksheet functions to take advantage of [...]

VBA VLOOKUP: How to Use Worksheet Functions in VBA2019-04-13T07:08:29+00:00

How to Use For Loops in VBA

2019-03-29T09:10:27+00:00

How to Use For Loops in VBA Written by co-founder Kasper Langmann, Microsoft Office Specialist. In programming, loops allow you to run commands multiple times. It's simple, but it’s one of the most powerful things you can do with VBA code. (And it saves you a huge amount of typing.) Let’s take a look [...]

How to Use For Loops in VBA2019-03-29T09:10:27+00:00