How To Print An Excel Spreadsheet Like A Pro Written by co-founder Kasper Langmann, Microsoft Office Specialist. Printing your spreadsheets, aaah... At the surface, it's so simple. Just hit 'Print', right? Not so quick! Getting your spreadsheets to print well can be surprisingly difficult. Sometimes they split in weird places. Or you get just [...]
How to Calculate Percentages in Excel: The Exact Formulas You Need Written by co-founder Kasper Langmann, Microsoft Office Specialist. If you regularly work with numbers, you probably also work with percentages. And when you do, you'll find that Excel can handle them just as well as whole numbers or decimals. Still, you need to [...]
How To Sort Data In Excel: Organize Your Data In A Few Clicks Written by co-founder Kasper Langmann, Microsoft Office Specialist. Excel packs a lot of organizational power. Useful tools like charts, filters, and pivot tables let you slice and dice your data any way you want. But sometimes you need something a little [...]
How To Use The COUNTIF Function in Excel (+COUNTIFS) Written by co-founder Kasper Langmann, Microsoft Office Specialist. In this tutorial, I show you exactly how to use the 2 functions COUNTIF and COUNTIFS (which is new!). In short, these functions count the number of cells within a range that contain a specific value. A quick [...]
How to Delete Blank Rows in Excel — The Right Way Written by co-founder Kasper Langmann, Microsoft Office Specialist. There's something inherently irritating about spreadsheets with blank rows. Excel sets out your data so nicely—and then its hard work is interrupted by blank rows. It seems unjust. Fortunately, you can remove blank rows with just [...]
How to Insert a Checkbox in Excel ✔ Written by co-founder Kasper Langmann, Microsoft Office Specialist. When you use a spreadsheet to manage information, adding a checkbox seems like overkill. You can just type an "x" or a "1" wherever you might place a checkmark. But if many people will be using your spreadsheet, [...]
The Function COUNT Explained: Count Cells In Excel (Easily) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Of all the things that Excel does, counting seems rather rudimentary. But below the surface, there's so much more to it! I guarantee you're going to be surprised by the power of Excel's COUNT function :) And [...]
How to Create a Formula in Excel Add, subtract, multiply, and divide (+more) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Learning how to create a formula in Excel is easy. If you have never known how to write a formula in your Excel spreadsheets, you are in the right place. This guide will walk [...]
How to Transpose Data in Excel: Turn Rows into Columns (vice versa) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Reorganizing data in a spreadsheet can be a pain. Especially when you have to make big changes that a simple copy-and-paste won't fix. One of the common tasks that fall into this category is [...]
All Excel's Date and Time Functions Explained! Written by co-founder Kasper Langmann, Microsoft Office Specialist. This is the complete guide to date and time in Excel. It’s a whopping +5500 words (!), so be sure to bookmark it. The first part of the guide shows you exactly how to deal with dates in Excel. I [...]
How To Password Protect An Excel File: Lock Cells and Formulas (Easily) Written by co-founder Kasper Langmann, Microsoft Office Specialist. In Excel, there are different ways that allow you to protect data and the integrity of your files. It's super important to know your way around protection Excel files. The most common use-case is [...]
How To Find Duplicates in Excel And Then Remove Them (Or Merge) Written by co-founder Kasper Langmann, Microsoft Office Specialist. As an Excel spreadsheet grows, you start finding a host of new issues to deal with. Especially if it gets updated regularly, and even more so if it gets updated by multiple people. One [...]
How To Calculate The Average In Excel: Use The Function AVERAGE Written by co-founder Kasper Langmann, Microsoft Office Specialist. Finding averages is often required when working with spreadsheets. It's a rather basic task—but Excel can do all sorts of great things with averages. In this tutorial, we'll take a look at the AVERAGE function, [...]
How to Freeze Cells, Rows, and Columns in Excel Using "Freeze Panes" Written by co-founder Kasper Langmann, Microsoft Office Specialist. I bet you’ve been working in a spreadsheet that had so many rows, that as you scrolled down, you couldn’t see your headers? Remember the frustration of not remembering which column was what? It [...]
How To Use The HLOOKUP Function In Excel + Examples Written by co-founder Kasper Langmann, Microsoft Office Specialist. When you're working with a small spreadsheet, it's easy to scan through and find the values you're looking for. When you start working with hundreds, thousands, or even tens of thousands of cells, though, that becomes [...]
How to Create a Pivot Table in Excel [The Complete Guide] Written by co-founder Kasper Langmann, Microsoft Office Specialist. Who else wants to handle and visualize data without breaking a sweat? I know I do! That's why I've written this ultimate tutorial for you on "Pivot Tables" in Excel. Pivot Tables make it easy to [...]
VLOOKUP is one of the most well-known Excel functions – and not without reason. VLOOKUP’s ease of use and simplicity when “looking up” data is unparalleled in Excel. In this tutorial you'll learn how to create and troubleshoot a VLOOKUP.
How to Move Columns in Excel Fast & Easy Written by co-founder Kasper Langmann, Microsoft Office Specialist. The need to move columns and rows in Excel is as old as Excel itself. It could be due to a simple mistake or to unforeseen circumstances. The point is, data has to be moved sometimes. [...]
7 Frequently Asked Excel Interview Questions [Interview Tips] Written by co-founder Kasper Langmann, Microsoft Office Specialist. It’s been more than 30 years since Excel was released. And yet, the number of companies who would like an Excel ninja to work for them keeps increasing! The answer to that is simple: The range of [...]
How to Make a Scatter Plot in Excel - in Just 4 Clicks! Written by co-founder Kasper Langmann, Microsoft Office Specialist. A scatter plot is one of the most useful visualization tools you can use in Excel. Scatter charts are great for comparing values and showing their relationships among the values in the [...]
How to Make a Box and Whisker Plot in Excel [2019 Tutorial] Written by co-founder Kasper Langmann, Microsoft Office Specialist. If you’re working with statistical data in Excel, a box and whisker plot is one of the best charts you can use. In the past, creating one came with a price — it [...]
The SUMPRODUCT Function:Basic and Advanced UsesWritten by co-founder Kasper Langmann, Microsoft Office Specialist. The ‘SUMPRODUCT’ function is mostly known for calculating weighted averages in a much simpler way. But the truth is, this function is a lot more powerful and useful than that. Before ‘SUMIFS’, ‘AVERAGEIFS’, and ‘COUNTIFS’ came into being, there already [...]
How To Calculate The Weighted Average in Excel Written by co-founder Kasper Langmann, Microsoft Office Specialist. Calculating averages is one of the most common tasks people do on a regular basis. But when the values have varying importance (or weight) against each other, you should use the weighted average instead. In this tutorial, we’ll [...]
How To Use The PMT Function In Excel - Free Exercise File Included! Written by co-founder Kasper Langmann, Microsoft Office Specialist. The PMT function — which stands for Payment — is one of Excel’s financial functions. It is an advanced Excel formula that calculates the periodic loan payment based on the constant interest rate, [...]
How to Make a Histogram Chart in Excel [Step-By-Step] Written by co-founder Kasper Langmann, Microsoft Office Specialist. A histogram is the best chart you can use to illustrate the frequency distribution of your data. Before Excel 2016, making a histogram is a bit tedious. But now, you can make one in a matter of seconds. [...]
How to Make a Pareto Chart in Excel in 10 Seconds [2019 Tutorial] Written by co-founder Kasper Langmann, Microsoft Office Specialist. A Pareto chart is one of the best ways to emphasize the major factors to anything that can be counted and categorized. The Pareto principle, which this chart depicts, states that 80% of results [...]
How To Add The Analysis ToolPak in Excel [Step-by-Step Guide] Written by co-founder Kasper Langmann, Microsoft Office Specialist. The Analysis ToolPak is one of Excel's most beloved ‘Application Add-ins’. And for a good reason! This add-in, with its financial, statistical, and engineering data analysis tools, can save you a great deal of time. [...]
