How to Make A Percentage Formula in Excel: Step-by-Step We use percentages almost everywhere. For example, there's a 50% off this weekend, monthly sales have risen by 30%, you get an annual increment of 15%, etc. The percentage is a genius concept, and the best part – they are super easy to calculate. [...]
How to Create a Formula in Excel: Beginner Tutorial (2022) Excel is all about running calculations! And so creating and operating a formula in Excel is simple. An Excel formula is a combination of operators and operands. For example, 2 + 2 = 4 is a formula where 2s are the operands, plus [...]
How to Use the COUNT function in Excel (and COUNTA) Apart from storing and manipulating numbers, sometimes, you may want to use Excel to simply count numbers. For example, the number of students in a class, the number of items on a list, etc. To do so, Excel offers two functions, the COUNT [...]
How to Transpose Data in Excel: Turn Rows into Columns (2022) Did you ever happen to construct a data table in Excel? Where after it was all done, you realized that it would have made more sense the other way round? In such a situation, don’t rush to recreate the table altogether. Instead, [...]
How to Insert a Checkbox in Excel: Easy Step-by-Step Guide (2022) If you want to collect user input in your spreadsheet there's no better way than the checkbox. User-friendly, slick-looking, and easy for you to work with. Well... After you learn it at least. If you're having a hard time understanding the [...]
How To Delete Blank Rows In Excel: Step-by-Step (2022) Everyone hates empty rows in their data. Fortunately, there are 2 ways to remove all the blank rows in your spreadsheet - in just a few clicks. Which method fits you best comes down to this really important distinction: 1) "I want to delete [...]
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 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 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 Excel-functions COUNTIF and COUNTIFS (new) 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 example: Say we [...]
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 and Remove Duplicates in Excel (or Merge them) 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 of [...]
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 [...]
How to Use Wildcards in Excel: Examples with VLOOKUP, COUNTIF, + more Wildcards are some special characters that play the role of special agents. How? You can use them in place of the characters you are unsure about and find results in Microsoft Excel. Wild characters can not only substitute text values but [...]
How to Round Up in Excel (or Down) - 2022 Full Guide Rounding numbers is a way of simplifying numbers to make them easier to understand or work with. Although by rounding, you only get an estimated value that is still relatively close to the exact value. 😊 But what if you need [...]
How to do Linear Regression in Excel: Full Guide (2022) Linear regression is an easy way to present a statistical analysis between two or more variables in Excel. Previously, running a linear regression in excel involved a lot of functions (and other complexities). But now, only a few steps can lead you to [...]
The 9 Best Project Management Templates for Excel (2022) Project managers are known for their decisiveness and time management. A project's success depends on how a project manager identifies, plans, and employs the resources available for any given project (especially the timespan). If you, too, have a complicated project ahead of you that [...]
How to Find Circular References in Excel (+ How to Fix Them) So, you tried applying a formula to a data set, and instead of getting an answer, excel showed a circular reference warning message. Yeah, we've been there too. Hundreds of thousands of people face this problem simply because they use direct [...]
How to Make a Bar Graph in Excel - and Customize it (2022) A bar chart is one of the most commonly used charts in Excel. It is simple to use and easy to understand. Although there is a limit to the data that you can display using bar charts - they still [...]
How to Make a Line Graph in Excel: Explained Step-by-Step As evident from the name, Line Graph is by far one of the simplest graphs in Excel. It is also known as Line Chart and helps represent statistical data trends plainly. Its ease of use makes it the top choice for a visual [...]
Cell References in Excel: Relative, Absolute, and Mixed (2022) Cell references often confuse Excel users no matter how simple they may sound. Be it Cell A1 or Cell XFD1048576. How are these cell references made?🤔 The guide below will teach you this and much more. So jump right in. And as you go, [...]
How to Fix Arrow Keys Not Moving Cells in Excel (Scroll Lock) We are talking about the times when out of a sudden, your Excel sheet starts behaving weirdly. As you press the arrow keys, you are not navigated to the cells up or down, right or left. Instead, your Excel sheet starts [...]
How to Make a Pie Chart in Excel: Step-By-Step Tutorial A pie chart (also known as a circle chart) pictures the proportion of different items in a data set. It is based on the idea of a pie, where each slice represents an individual item’s contribution to the total (the whole pie). Unlike [...]