Microsoft Excel
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…
The FORMULATEXT Excel Function – 2 Best Examples
Note: This guide on the FORMULATEXT Excel function is suitable for Excel 2013 and later versions. What is the FORMULATEXT Function? The FORMULATEXT function converts and returns a given formula as a text string. Use it to display a formula as text in your spreadsheet. It returns a #N/A error if the reference cell doesn’t…
How to Insert Multiple Rows in Excel? The 4 Best Methods
Note: This guide on how to insert multiple rows in Excel is suitable for all Excel users. Have you ever wondered how to insert multiple rows in Excel in one go? In this tutorial, I am going to explain how to do just that. Also, I am going to talk about some lesser-known tricks and…
How to Autofit Excel Cells? 3 Best Methods
Note: This guide on how to autofit Excel cells is suitable for Excel 2010, Excel 2013, Excel 2016, Excel 2019, and Office 365 users. In Microsoft Excel, there is a default row height and column width for all cells. If you enter any text that is larger than the cell size, it will spill out….
How to Extract an Excel Substring? – 6 Best Methods
Note: This guide on how to extract a substring in Excel is suitable for all Excel versions including Office 365. In this guide, I am going to show you how to extract any kind of substring in Excel with ease. I’ll cover: What is a Substring? Excel Substring Extraction – An Overview. How to…
How to Group Worksheets in Excel? (In 3 Simple Steps)
Note: This guide on how to group worksheets in Excel is suitable for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Office 365 users. Grouping worksheets in Excel is the best way to edit multiple sheets at the same time. It allows you to perform the same tasks on multiple worksheets…
How to Make a Line Graph in Excel? 4 Best Line Graph Examples
Note: This guide on how to make a line graph in Excel is suitable for all Excel users including Office 365. Line graphs are one of the most versatile graphs available in Excel. They are very popular because they are easy to plot and easy to interpret. Line graphs’ main purpose is to help…
How to Shade Every Other Row in Excel? (5 Best Methods)
Note: This guide on how to shade every other row in Excel is applicable for all Excel versions including Office 365. Shading alternate arrows in your Excel spreadsheet is one of the easiest ways to make it user friendly. It improves readability and reduces clutter in the spreadsheet. In this guide, I’ll walk you through…
How to Superscript in Excel? (9 Best Methods)
Note: This guide on how to add superscript in Excel is suitable for all Excel versions including Office 365. Have you ever wondered if it is even possible to add a subscript or superscript in Excel sheets? Yes, it is definitely possible to add them in Excel, and also as easy as in Microsoft Word. …
How to Use the Excel Fill Handle Easily? (Top 3 Uses with Examples)
Note: This tutorial on how to use the fill handle in Excel is suitable for all Excel users. The “fill handle” option in Excel is very useful for completing lists of data in an Excel sheet. You must have used the Excel fill handle at least once in your Excel journey. They come in handy…
How to Split Cells in Excel? 3 Easy Methods
Note: This guide on how to split cells in Excel is suitable for all versions of Excel. In your Excel journey, you will come across situations where you have to work with imported data. In these cases, it is very common to find cells of data that are not in the desired format. For example,…
