Microsoft Excel
How to Fix the #Div/0 Error in Excel? 2 Easy Methods
(Note: This guide on how to fix the #Div/0 Error in Excel is suitable for all Excel versions including Office 365) Ignoring errors in Excel is like stepping on landmines. You never know when they are going to explode and cause enormous confusion. We have been covering the major errors in Excel in our blogs,…
How to Use ISTEXT in Excel? With 3 Different Methods
(Note: This guide on how to use ISTEXT is suitable for all Excel versions including Office 365) The ISTEXT in Excel is categorized under Information functions in the Formulas tab. It returns TRUE if the given value is a text, and FALSE if the cell contains any other value or is empty. You can use the…
Short Date Format in Excel – 3 Different Methods
(Note: This guide on how to apply a short date in Excel is suitable for all Excel versions including Office 365) Excel supports short dates, long dates, and customized dates besides numbers. Date and time are the most common data types used in Excel. The default format to display the date is normally dd-mm-yyyy and the…
How to Graph a Function in Excel? 2 Easy Ways
(Note: This guide on how to graph a function in Excel is suitable for all Excel versions including Office 365) Time and time, Excel has proven to be a beneficial tool for performing various calculations. Excel offers calculations and simplifications on a vast amount of mathematical functions ranging from simple addition functions to complex quadratic, exponential,…
How to use EDATE in Excel? 11 Easy Examples
(Note: This guide is on how to use EDATE in Excel and is suitable for all Excel versions including Office 365) EDATE is a built-in function in Microsoft Excel that falls under the category of DATE and TIME functions. The Excel EDATE function returns the date on the same day of the month, n months in…
How to Use AVERAGEIF in Excel? With 5 Different Criteria
(Note: This guide on how to use AVERAGEIF in Excel is suitable for all Excel versions including Office 365) The AVERAGEIF in Excel calculates the average of all numbers in a range of cells that meets the given criteria. AVERAGEIF includes logical operators (>,<,<>,==) and wildcards (*,?) for partial matching. It is categorized under Statistical Function. …
How to Enable Excel Dark Mode? 2 Easy Methods
Note: This tutorial on Excel Dark Mode is suitable for Excel versions 2013 and later including Office 365. If you spend a lot of time staring at spreadsheets or at a computer screen in general, especially at night, it is advisable to turn on the dark mode. In this tutorial, I’ll show you how to…
How to Calculate Factorial in Excel? Along with 2 Easy Examples
(Note: This guide on how to calculate factorial in Excel is suitable for all Excel versions including Office 365) We all might have learned about the concept of factorials in our high school math. As we grew up, we understood the concept of factorial has various uses while operating on probability, permutations, and combinations. We also…
How to Create an Excel Slicer? 2 Easy Ways
(Note: This guide on how to create an Excel slicer is suitable for all Excel versions including Office 365) Excel is usually preferred for its ability to store and access large amounts of information. To improve user-friendliness, Excel has a lot of options and functions available to help the user search, find, or retrieve data. One…
IFERROR Excel-The Ultimate Guide to Catching Errors in Excel
(Note: This guide on IFERROR in Excel is suitable for all Excel versions including Office 365) The IFERROR Excel function is a built-in formula categorized under the logical functions. It traps and handles errors in a formula. If a formula evaluates to an error, IFERROR returns a value that you specify, otherwise, it returns the…
How to Add Leading Zeros in Excel? 4 Easy Methods
(Note: This guide on how to add leading zeros in Excel is suitable for all Excel versions including Office 365) Excel, despite being one of the most commonly used spreadsheet software, can be confusing to use at times. Leading zeros in Excel is a good case in point. I am almost certain that you tried…
How to Use Nested VLOOKUP in Excel? A Step-by-Step Guide
(Note: This guide on how to use nested VLOOKUP in Excel is suitable for all Excel versions including Office 365) Most of us have become familiar with VLOOKUP in Excel over the years. So many guides and tutorials have been made about this wonderful function. We know that it is used to look up values…
