Convert Bytes to MB or GB in Excel
If you are working with data related to storage space or file-size, you will often need to convert between units. You might intend on using the data in calculations or …
Steve Scott
How to Replace Asterisks in Excel
Working with data often involves cleaning up. If your data is imported or copied from an external source, it may contain a number of unwanted characters like commas or asterisks …
How to Remove Decimals in Excel?
Let’s face it, opening a worksheet to see decimals all over it can be quite off-putting. Some people find it intimidating, as decimals give the perception of complexity. As such, …
How to Change Page Orientation in Excel (for Printing)
When you print a worksheet in Microsoft Excel, it gets printed in the portrait orientation by default. However, you might want to change the orientation of the printout to landscape …
Using Application.GetSaveAsFilename in VBA in Excel (Examples)
If you are coding in VBScript, Excel and you need to extract the filename that a user uses when saving a file, the GetSaveAsFilename() method can be useful for you. …
Using Conditional Formatting with OR Criteria in Excel
Conditional Formatting in Excel provides a great way to highlight certain cells that may be more important than others. When combined with the OR criterion, you get added flexibility to …
Using IF Function with Dates in Excel (Easy Examples)
The IF function is one of the most useful Excel functions. It is used to test a condition and return one value if the condition is TRUE and another if …
How to Convert Month Number to Month Name in Excel
When working with date-related data, there might be instances where you need to convert a number to its corresponding month. There might also be instances when you might want to …
Highlight Cell If Value Exists in Another Column in Excel
One of the best things about Microsoft Excel is that it can be customized to suit your needs and preferences. Excel has Conditional Formatting that allows you to format a …
How to Find Range in Excel (Formulas)
We usually require certain metrics to understand the data that we are working with. There are a number of such representative metrics, like the average, the median, etc. Among these …
How to Add a Total Row in Excel Table
Excel provides some really great features in the form of Tables. Excel tables provide an organized way of viewing and reporting data in a tabular format. Besides other advantages, Excel …
How to Select Multiple Rows in Excel?
One of the advantages of using spreadsheet software like Excel is that you get to perform operations in bulk. Instead of working on one cell or one row at a …