How to Use COUNTIF in Excel: Step-by-Step (+COUNTIFS) The Excel COUNTIF function is a very smart mix of the COUNT and IF functions of Excel. Using this function you can count cells that meet a specified condition. And as it’s you who’s going to define the condition – so you have the world [...]
Freeze Panes in Excel: How to Freeze Rows and Columns (2023) Freezing here means locking particular rows/columns of Excel in place to enhance the readability of a worksheet. By freezing panes rows/columns in Excel, you can still view them when you scroll to other parts of the worksheet 🧐 The guide below will [...]
How to Lock Cells in Excel: Excel Protection Tutorial Protecting your data and maintaining the integrity of your files are super important nowadays. It's only safe to say that one needs to learn how. Better safe than sorry, right? 😉 Well, I have good news for you! Microsoft Excel provides different levels of [...]
How to Remove Duplicates in Excel (and Find Them) In an Excel spreadsheet, you’d often have to collate data from multiple sources. Sometimes from external sources (like webpages) too 🖨 And this might result in duplicates in your Excel sheet. So how can you remove them? By scanning your worksheet for dupes manually? [...]
How to Sort in Excel: Data and Columns (2023) When I say Excel is the most powerful spreadsheet software - that's not an exaggeration. Excel lets you do even the toughest of tasks with immense ease of use, let alone the simple ones. And what's simpler than sorting data? Excel offers a plethora [...]
How to Use the HLOOKUP Function in Excel: Step-by-Step There are a total of four functions in Excel to look up a value. The LOOKUP, VLOOKUP, HLOOKUP, and XLOOKUP functions. Each of these has a different purpose and is useful in its own way. The Excel HLOOKUP function looks up values in a [...]
How to Calculate Average in Excel (With Formula Examples) What is average? It is simply the arithmetic mean of a given set of numbers. Averages are super easy to calculate – no doubt about that 🎉 But if your dataset gets long, it might be that easy to calculate averages manually. And who [...]
How to Print an Excel Spreadsheet on One Page (+ More) Trying to fit your big spreadsheet into 1 tiny page? As easy as it seems, printing Excel spreadsheets can be difficult if you don't know the pro tricks. And even more so if you're new to this software. Luckily, this guide has [...]
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 (2023) 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 (2023) 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 (2023) 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 (2023) 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.
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 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 [...]
Excel INDIRECT Function: Formulas and Examples (2023) Some functions of Excel are simply meant to amaze you. The INDIRECT function is also one of that lot 🙈 Technically speaking, it will not perform any operation, nor will it run any logical tests to return Boolean Values. It is a unique function that’s different [...]
With the release of Excel 2016, several new features were added. Among these 6 new charts! We've created an infographic, showcasing each of the new charts and how you can benefit from using them.
How to Import Text Files Into Excel: Step-by-Step Guide (2023) Don't you just wish you can magically import data that you need into a new usable format faster with nothing to do any manual work? 😩 Well, Microsoft Excel can grant your wish. Excel allows you to open other file formats such as [...]
The 7 Best Excel Add-Ins in 2023: Full Excel Plugin Guide Microsoft Excel has a wide range of features and functionalities. But, there are situations when you need more powerful capabilities than Excel provides 💪🏻 Particularly when performing data analysis, regression analysis, and financial analysis. To increase the efficiency of Excel spreadsheets, there [...]
The 7 Best Excel Alternatives: Free and Paid (and for MAC too) Excel is the oldest, most versatile spreadsheet software out there. But just like all other applications, it has its fair share of limitations too. To reach the maximum potential of your computing and analysis skills, you need to explore more options [...]
How to use the VBA IF Statement: Step-by-Step (2023) IF statements are some of the most foundational concepts in programming. They serve as the basis for many more complicated functions—if you understand them, you’re well on your way to becoming a VBA expert 🧑🎓 But if you don’t have programming experience, understanding how [...]
How to Work with VBA Ranges in Excel: Full Guide (2023) 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 the range object. A range is simply a cell or collection of cells that you tell Excel to [...]
How to use VLOOKUP in Excel VBA: Step-by-Step (2023) Visual Basic for Applications (VBA) has many built-in functions that help you work with spreadsheet data. But "normal" Excel is the undisputed king when it comes to useful functions. Fortunately, you can use worksheet functions to take advantage of that power when you’re writing [...]
How to Use Message Boxes in Excel: Step-by-Step Guide (MsgBox) In this article, we are going to show you how to create a message box in Excel. Also called an Excel message box (VBA style). If you do not have any experience with VBA, do not worry (make sure to check this out [...]
How to Use the VBA Editor in Excel: Quick Guide (2023) 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 VBA editor. But [...]