How To Print An Excel Spreadsheet Like A Pro + Free Sample File While the world is increasingly going digital, there are some times when you need to print your documents. Even your spreadsheets. It might seem like an easy task - just hit Print, right? Not so quick! Getting your spreadsheets to print [...]
How to Calculate Percentages in Excel: The Exact Formulas You Need 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 know how to get the right numbers in [...]
How To Sort Data In Excel: Organize Your Data In A Few Clicks 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 simpler: you just want to sort. And if [...]
How To Use The COUNTIF Function in Excel (+COUNTIFS) In Excel, there are many built-in functions available to make all kinds of calculations. In this tutorial, you're going to learn about 2 functions. These functions count the number of cells within a range that contain a specific value. Say we have a list of [...]
How to Delete Blank Rows in Excel — The Right Way 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 a few clicks! First, we'll show you the [...]
How to Insert a Checkbox in Excel ✔ 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, or you're concerned about the presentation, inserting a [...]
The Function COUNT Explained: Count Cells In Excel (Easily) Of all the things that Excel does, counting seems rather rudimentary. But you might be surprised by the power of Excel's COUNT function. And when you get into COUNT's sister functions, there are some really cool things you can do. Let's take a look at [...]
How to Create a Formula in Excel Add, subtract, multiply, and divide (+more) 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 you through each step of how to write [...]
How to Transpose Data in Excel: Turn Rows into Columns (vice versa) 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 transposing—turning rows into columns, or columns into rows. [...]
All Excel's Date and Time Functions Explained! 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 will show you how to perform calculations involving [...]
How To Password Protect An Excel File: Lock Cells and Formulas (Easily) 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 where an Excel file is used by many [...]
How To Find Duplicates in Excel And Then Remove Them (Or Merge) 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 of the issues you'll probably come across is [...]
How To Use The Function AVERAGE To Calculate The Mean in Excel 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, as well as its sister functions [...]
How to Freeze Cells, Rows, and Columns in Excel Using "Freeze Panes" 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 sucks! Well, good thing you stopped by because [...]
How To Use The HLOOKUP Function In Excel + Examples 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 impractical. At this point, using Excel's [...]
Excel Pivot Table Tutorial: The Ultimate Guide to Creating Pivot Tables 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 (2016). Pivot Tables make it easy to summarize data and create dynamic [...]
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 Make a Line Graph in Excel: Explained Step-by-Step 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 for the same graph) are some of the [...]
How To Make A Bar Graph in Excel (+Clustered And Stacked Bar Charts) 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, there's nothing clearer than a simple bar chart. [...]
How To Make A Gantt Chart In Excel 2016 For Free. No Plugins Or Add-Ons Needed! 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 perfect for that purpose. Unfortunately, Excel doesn't [...]
How To Make A Pie Chart In Excel. In Just 2 Minutes! 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 show how different values add up to a [...]
How To Make A Column Chart In Excel + Clustered And Stacked Charts! Column charts are by nature very simple. They represent a small amount of data in a clear, concise manner. But they can be eminently useful. No matter what kind of data you have, there's a good chance that a well-crafted column [...]
How to Use the OFFSET Function in Microsoft Excel The OFFSET function is one of the built-in functions in Microsoft Excel. Its purpose is to return a range that is a specified number of rows and columns from a reference cell or range. The range that the OFFSET function returns can be a single cell [...]
How To Use The Excel Functions TRUE And FALSE (Boolean Logic) There are many functions in Microsoft Excel that are conditional by nature. They are based upon logical tests that result in either a TRUE or FALSE outcome. These types of formulas are very powerful in their simplicity. For example, you might manage a [...]
How To Use the SUBTOTAL Function In Microsoft Excel In this tutorial, we turn our attention to the SUBTOTAL function in Excel. You may think of a sum of selected values. But, the SUBTOTAL function is capable of much more. Also to its ability to return a sum, it can also give the user an [...]
Excel Number Format: How To Format Numbers (+Custom Formatting) In Microsoft Excel, there are several formats available when dealing with numeric data. Yet, the application also offers the ability to create custom number formats. That is, if any of the built-in offerings don’t meet your needs. In this article, we will take a quick [...]
How to Create a VBA Message Box in Excel ("msgbox") for Non-Geeks In this article, we are going to show you how to create custom message boxes in Microsoft Excel using VBA. If you do not have any experience with VBA, do not worry. This will be a great introduction for you. Soon you [...]
Send this to a friend