Microsoft Excel
How to Set Print Area in Excel? Step-by-Step Guide
(Note: This guide on how to set print area in Excel is suitable for all Excel versions including Office 365.) In Excel, there are 1,048,576 rows and 16,384 columns in one sheet. But, when you hit the print command the entire sheet is printed by default. Obviously, we don’t need to print all of it…
How to VLOOKUP From Another Sheet?
(Note: This guide on how to do VLOOKUP from another sheet is suitable for all Excel versions including Office365) VLOOKUP is a widely used Excel lookup formula used to retrieve information from a large worksheet. You might have used it to search for information inside a sheet. But, did you know that you can use…
How to Move Rows in Excel? 5 Easy Methods
(Note: This guide on how to move rows in Excel is suitable for all Excel versions including Office 365) While creating data on an Excel spreadsheet, it’d be a lot helpful if the data is organized or personalized to our needs. That’s why we keep moving and organizing our data all the time. It provides…
How to Use the ROUND Function in Excel?
(Note: This guide on how to round in Excel is suitable for all Excel versions including Office 365) The Round function in Excel is used to handle irrational numbers or numbers with trailing digits after the decimal point. It is the same concept as in mathematics to adjust the digits of a decimal number to give…
How to Fix the Excel Circular Reference Error?
(Note: This guide on how to fix the Excel circular reference error is suitable for all Excel versions including Office 365.) As an Excel user, you might have come across the ‘circular reference’ error occasionally. This appears when a formula directly or indirectly refers back to its own cell. Although a circular reference should be…
How to Use the Excel Collapse Rows Feature? — 4 Easy Steps
(Note: This guide on the Excel collapse rows feature is suitable for all Excel versions including Office 365.) If you ever had to use an Excel sheet with thousands of rows, you will certainly agree that it was a daunting task. It is definitely confusing to keep track and analyze all the information, especially with…
How to Filter in Excel? A Step-by-Step Guide
Note: This guide on how to filter in Excel is suitable for all Excel versions including Office 365. The data filter is probably the most underrated feature in Excel. It is very robust and gets more things done easily than its counterparts. I feel that It doesn’t get the attention it deserves, especially in beginner’s…
The 7 Golden Rules of Excel Spreadsheet Design
This guide on spreadsheet design is suitable for Excel 2016, 2019, 2021, and Microsoft 365 versions Design better spreadsheets by implementing the ‘golden rules’ of good spreadsheet design. You’ll learn: What is a Good Spreadsheet Design? Excel Spreadsheet Design – 7 Golden Rules Rule 1 – Adopt a Standard And Stick To It Rule 2…
How to Group in Pivot Table? ( 2 Easy Methods)
This guide on how to group in Pivot table is suitable for Excel 2016, 2019, 2021, and Excel for Microsoft 365. versions Pivot Tables are the number 1 tool in Excel for analyzing and presenting large amounts of data. However, to do this effectively we need to ensure we organize data into manageable subsets. The…
How to Create an Excel Map Chart from Pivot Table Data? 3 Simple Steps
(Note: This tutorial is suitable for Excel 2019, 2021 and Microsoft 365 versions.) In this guide, let us see how to create an Excel map chart using Pivot Table data to present geographical information. You’ll learn: Map Chart in Excel – An Introduction How to Create an Excel Map Chart? How to Format an…
Start Co-Authoring Excel Workbooks in 6 Easy Steps
(Note: The Co-Authoring Excel feature is only available in Excel 365, Excel for the web, and Mobile versions. ) If you are wondering how to collaborate with your team using Excel, you have come to the right place. In this guide, I’ll teach you how to easily use the Excel co-authoring feature in five simple…
How to Split and Combine Data in Excel?
This guide on how to split data in Excel is suitable for Excel 2016, 2019, 2021 and Excel for Microsoft 365 versions. In this tutorial, learn how to split data in Excel (and combine it) using Excel text functions and other utilities, as part of a robust data cleaning process. You’ll learn: Splitting and…
