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 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 [...]
The 5 Best Laptops for Excel and Microsoft Office (2023) Written by co-founder Kasper Langmann, Microsoft Office Specialist. All laptops can open a spreadsheet. But as you're doing more advanced Excel tasks, and opening bigger spreadsheets, you need more power. Especially if you want to have 25 browser tabs open and [...]
The 5 Best Keyboards for Excel Spreadsheets (2023 Update) Written by co-founder Kasper Langmann, Microsoft Office Specialist. If you've worked with spreadsheets for years, you already know how a good keyboard plays a part in maximizing efficiency with Excel. Maybe you came here looking for an upgrade? Tired of typing on [...]
The 5 Best Monitors for Excel and Spreadsheets (2023 Update) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Studies show that going from 1 to 2 monitors can increase your productivity by up to 42%. You definitely don't wanna miss that productivity increase! So, if you're looking into the best monitors [...]
The 5 Best Barcode Scanners for Excel Reviewed (2023 Update) Written by co-founder Kasper Langmann, Microsoft Office Specialist. If you're using Microsoft Excel for stock, inventory, and tracking - you might as well pair it up with a barcode scanner to get data easier from the floor to the (Excel) sheet. [...]
The 5 Best Excel Books To Get For Beginners & Advanced Users Written by co-founder Kasper Langmann, Microsoft Office Specialist. While we at Spreadsheeto are fans of online courses (especially our own) - some of the greatest contributors to the Excel community only teach through books. So, I've picked the 5 [...]
The Best Mouse for Excel and Spreadsheets (5 Mice Reviewed) Written by co-founder Kasper Langmann, Microsoft Office Specialist. To be more productive with Excel, you need to use the best keyboard and mouse there is. But there are TONS of mice, so getting the best one for Excel is super hard. That’s [...]
The 5 Best Laptops with Microsoft Office Installed (2023) Looking for a new laptop for work? Then why not choose one that already has Microsoft Office installed? AND one that has the power to run all your Office applications? This is my list of the 7 best laptops that come with [...]
The 3 Best Tablets for Excel Spreadsheets (2023 Update) Written by co-founder Kasper Langmann, Microsoft Office Specialist. There are times when you want to work someplace else other than your office. In those situations, something compact and light may be perfect for the job. However, you would need to use something that [...]
How to Create a Bubble Chart in Excel: Insert & Edit (2023) A bubble chart displays three variables on a two-dimensional graph3️⃣ Just like the name sounds, a bubble chart is a chart where the data is plotted in the form of bubbles. In this tutorial, we will walk you through the process [...]
How to Use the FILTER Function in Excel + Examples (2023) If you had to filter in Excel, what would you normally do? Use filters, or if the filtering gets more complex, use advanced filters. Both these tools, though very useful, come with one major drawback🤔 They do not update automatically as you [...]