More results...
How to Create a Pivot Table in Excel: Step-by-Step (2023) If you have a huge dataset that’s spread across your entire sheet, and now you want to create a summary out of it – you need a Pivot Table 💪 Pivot Tables make one of the most powerful and resourceful tools of Excel. [...]
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🖋️ By Kasper Langmann, Certified Microsoft Office Specialist. 📅 Updated on August 29, 2023.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 [...]
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 Insert PPT in Excel (Step-by-Step) In the digital age, the ability to integrate various types of data and information is crucial. One such integration that can prove to be extremely useful is inserting a PowerPoint (PPT) into an Excel spreadsheet. This can be particularly beneficial when you want to present complex data alongside [...]
How to Build a CD Ladder in Excel: (Step-by-Step) Building a CD ladder in Excel can be a powerful tool for managing your investments and maximizing your returns. A CD ladder is a strategy that involves buying a series of Certificates of Deposit (CDs) with different maturity dates, which allows you to take advantage of [...]
How to Open Trust Center in Excel (Step-by-Step) The Trust Center in Microsoft Excel is a critical component that helps ensure the security of your data and protects your computer from potential threats. It is a hub where you can manage security settings and add-ins, and it plays a pivotal role in maintaining the integrity [...]
How to Highlight Subtotals in Excel (Step-by-Step) Excel is a powerful tool that offers a wide range of features to help you manage, analyze, and organize your data. One such feature is the ability to create subtotals and highlight them for easy identification. This guide will provide you with a step-by-step process on how to [...]
How to Remove Seconds from Time in Excel (Step-by-Step) Microsoft Excel is a powerful tool that offers a plethora of functionalities to manipulate and analyze data. One such functionality is the ability to manipulate time data. This article will guide you through the process of removing seconds from time in Excel. Understanding Time in Excel [...]
How to Generate QR Codes in Excel (Step-by-Step) QR codes have become an integral part of our digital lives. They are used in a variety of applications, from digital payments to website navigation, and even in marketing campaigns. One of the most common ways to generate QR codes is by using Excel. This guide will [...]
How to Sort Several Columns in Excel (Step-by-Step) Excel is a powerful tool that can help you manage and analyze data. One of the most common tasks in Excel is sorting data. This can be particularly useful when you have large datasets and you need to organize them in a certain way. In this guide, [...]
How to Make Percentages in Excel Pie Chart (Step-by-Step) Excel is a powerful tool that can transform raw data into meaningful information. One of the most popular ways to visualize data in Excel is by using a pie chart. Pie charts are especially useful when you want to compare parts of a whole. They do [...]
How to Create a Toggle in Excel (Step-by-Step) Creating a toggle in Excel is an incredibly useful skill that can help you manage and present your data more effectively. Toggles can be used to switch between different views, data sets, or options, making your spreadsheets more interactive and user-friendly. This guide will walk you through [...]
How to Calculate Dividend Growth Rate in Excel (Fast) Calculating the dividend growth rate in Excel is a crucial skill for financial analysts, investors, and anyone interested in understanding the financial health of a company. The dividend growth rate is a key indicator of a company's profitability and its ability to generate shareholder value over [...]