Microsoft Excel Tutorials: Including Free Practice Exercises!

Right below you find +100 tutorials for Excel 2016 (Windows). 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

How to Use Ranges in VBA

2019-03-29T09:11:08+00:00

How to Use Ranges in VBA Written by co-founder Kasper Langmann, Microsoft Office Specialist. When you're working in VBA, you'll have to tell Excel which cells you want a particular command to apply to. To do that, you'll use Ranges. A range is simply a cell or collection of cells that you tell Excel to pay [...]

How to Use Ranges in VBA2019-03-29T09:11:08+00:00

How to Use the VBA Editor in Excel

2019-03-29T09:11:21+00:00

How to Use the VBA Editor in Excel Written by co-founder Kasper Langmann, Microsoft Office Specialist. Excel’s Visual Basic for Applications (VBA) editor is a very powerful tool. It lets you write and edit custom scripts that automate actions in Excel. In fact, when you record a macro it is stored in VBA code in the [...]

How to Use the VBA Editor in Excel2019-03-29T09:11:21+00:00

How to Make a Macro in Excel

2019-05-16T11:30:05+00:00

How to Make a Macro in Excel Written by co-founder Kasper Langmann, Microsoft Office Specialist. Excel is packed with great ways to save time like keyboard shortcuts, templates, the fill handle, and so on... ... but there's no better time-saving tool than a macro! In short: a macro is a sequence of instructions that [...]

How to Make a Macro in Excel2019-05-16T11:30:05+00:00

How to Use Do Until and Do While Loops in VBA

2019-05-16T11:35:04+00:00

How to Use Do Until and Do While Loops in VBA Written by co-founder Kasper Langmann, Microsoft Office Specialist. Like for loops, do until and do while loops are powerful concepts that you’ll find in most programming languages. And if you can master them in VBA, you’ll be prepared to create powerful scripts to work [...]

How to Use Do Until and Do While Loops in VBA2019-05-16T11:35:04+00:00

VBA DIM: How to Declare Variables in VBA

2019-03-29T09:12:02+00:00

VBA DIM: How to Declare Variables in VBA Written by co-founder Kasper Langmann, Microsoft Office Specialist. In VBA, like any other programming language, variables are important. They're one of the core parts of the language, in fact. A variable in programming is like a variable in math: it stands in the place of a value, [...]

VBA DIM: How to Declare Variables in VBA2019-03-29T09:12:02+00:00

How to Use Comments in Excel’s VBA Editor

2019-05-16T11:34:26+00:00

How to Use Comments in Excel's VBA Editor Written by co-founder Kasper Langmann, Microsoft Office Specialist. Like any scripts, Excel’s VBA modules can be very long and complicated to read. Basic VBA scripts are easy to work your way through. But once you start adding more variables and functions, it gets very difficult to figure [...]

How to Use Comments in Excel’s VBA Editor2019-05-16T11:34:26+00:00

How to Make a Line Graph in Excel: Explained Step-by-Step

2019-05-16T11:31:22+00:00

How to Make a Line Graph in Excel: Explained Step-by-Step Written by co-founder Kasper Langmann, Microsoft Office Specialist. The line graph is one of the simplest graphs you can make in Excel. But that doesn't mean it's not one of the best. The most effective visuals are often the simplest—and line charts (another name [...]

How to Make a Line Graph in Excel: Explained Step-by-Step2019-05-16T11:31:22+00:00

How To Make A Bar Graph in Excel + Clustered And Stacked Bar Charts!

2019-05-16T10:23:22+00:00

How To Make A Bar Graph in Excel (+Clustered And Stacked Bar Charts) Written by co-founder Kasper Langmann, Microsoft Office Specialist. A bar graph is one of the simplest visuals you can make in Excel. But it's also one of the most useful. While the amount of data that you can present is limited, [...]

How To Make A Bar Graph in Excel + Clustered And Stacked Bar Charts!2019-05-16T10:23:22+00:00

How To Make A Gantt Chart In Excel For Free [0 Plugins or Add-Ons]

2019-03-28T15:26:32+00:00

How To Make A Gantt Chart In Excel For Free. No Plugins Or Add-Ons Needed! Written by co-founder Kasper Langmann, Microsoft Office Specialist. Gantt charts are used almost exclusively for a single purpose: To show project timelines. You might find another use for a Gantt chart, but that's the main one. Why? Because it's [...]

How To Make A Gantt Chart In Excel For Free [0 Plugins or Add-Ons]2019-03-28T15:26:32+00:00

How To Make A Pie Chart In Excel – In Just 2 Minutes! [2019 Tutorial]

2019-05-16T10:24:49+00:00

How To Make A Pie Chart In Excel. In Just 2 Minutes! Written by co-founder Kasper Langmann, Microsoft Office Specialist. The pie chart is one of the most commonly used charts in Excel. Why? Because it's so useful :) Pie charts can show a lot of information in a small amount of space. They primarily [...]

How To Make A Pie Chart In Excel – In Just 2 Minutes! [2019 Tutorial]2019-05-16T10:24:49+00:00