Microsoft Excel
How to Use the Format Painter Excel Feature? — 3 Bonus Tips
Note: This guide on how to use the Format Painter Excel feature is suitable for all Excel versions including Office 365. In this tutorial, I’ll walk you through how to easily use the Excel format painter feature. You’ll learn: Related: How to Superscript in Excel? (9 Best Methods) How to Indent in Excel? 3 Easy…
How to Make a Scatter Plot in Excel? 4 Easy Steps
Note: This guide on how to make a scatter plot in Excel is suitable for all Excel versions including Office 365. In this tutorial, you will learn everything about scatter plots in Excel including how to properly use them. You can download the sample Excel spreadsheet attached below and follow along with this guide for…
How to Use the Chi Square Test Excel Function? 4 Easy Steps
Note: This tutorial on the Chi Square test Excel function is suitable for Excel versions 2010 and later, including Office 365. The CHISQ.TEST is a statistical function in Excel that calculates the chi-square statistic of two variables in a dataset. Usually, these two variables are categorical in nature and represent the frequency of occurrence of…
The Excel SMALL Function – 3 Best Examples
Note: This tutorial on the Excel SMALL function is suitable for all Excel versions including Office 365. Excel has a rich library of statistical functions you can use. The SMALL function is one of these very important statistical formulas that you must know. It is a very straightforward function that returns the nth smallest value…
How to Delete a Pivot Table in Excel? 4 Best Methods
Note: This tutorial on how to delete a pivot table in Excel is suitable for all Excel versions including Office 365. If you are a regular Excel user, you may already know that the Pivot table is one of the most versatile Excel features. It allows you to slice and dice your data as per…
How to Sort a Pivot Table in Excel? 6 Best Methods
Note: This tutorial on how to sort a pivot table in Excel is suitable for all Excel versions including Office 365. Sorting is a very commonly used Excel feature that I am sure you have come across many times. It is fairly straightforward to sort your data in an Excel spreadsheet. But, when it comes…
How to Unmerge Cells in Excel? 3 Best Methods
Note: This tutorial on how to unmerge cells in Excel is suitable for all Excel versions including Office 365. The merge cells feature in Excel is a very handy tool in presenting the data in a visually appealing way. It helps declutter and align your spreadsheet elements. But, if you rely too heavily on using…
How to Add Subscript in Excel? (6 Best Methods)
Note: This guide on Excel subscript is suitable for all Excel versions including Office 365. If you are confused about how to add subscript in Excel, this is the right guide for you. In this tutorial, I am going to show you how to add Excel subscripts the easy way. Table Of Contents Excel Subscript…
How to Apply the Accounting Number Format in Excel? (3 Best methods)
Note: This tutorial on how to apply the accounting number format in Excel is suitable for all versions of Excel including Office 365. Excel is one of the most used spreadsheet applications cutting across industries. But it has a very special and popular status in business and accounting. This is because it has many built-in…
How to Make Excel Track Changes in a Workbook? 4 Easy Tips
Note: This tutorial on the Excel track changes feature is suitable for Excel 2016 and later versions including Office 365. Sharing your workbooks with your team may introduce unintended errors or data mishaps in your spreadsheets. Even identifying these changes manually will take a lot of time, resulting in confusion. To save your precious time…
How to Add Error Bars in Excel? 7 Best Methods
Note: This guide on how to add error bars in Excel is suitable for Excel 2010, 2013. 2016, 2019, and Office 365 versions. Error bars in Excel help visualise the error margins or standard deviation in your data. Add them to your charts to show the error in absolute or percentage terms or standard deviations. …
The Excel CHOOSE Function – 4 Best Uses
Note: This tutorial on the Excel CHOOSE function is suitable for all Excel versions including Office 365. The CHOOSE function is one of the most versatile tools available in Excel. When combined with other functions, it can solve challenging problems in innovative ways. In this guide, I’ll explain how to use the CHOOSE function along…