Welcome to AAW Excel, the ultimate destination for mastering Microsoft Excel.
How to Use Excel FLOOR.MATH Function? - https://aawexcel.com/how-to-use-excel-floor-math-function//
Listen to this article
FLOOR.MATH
Excel is a spreadsheet developed by Microsoft. We can perform various mathematical calculations on it. The Excel FLOOR.MATH function can round a given number down to the nearest specified multiple. Whenever you want to round down the values in a huge list,...
How to Use Excel FLOOR Function? - https://aawexcel.com/how-to-use-excel-floor-function//
Listen to this article
FLOOR Function
Excel is a spreadsheet developed by Microsoft. We can perform various mathematical calculations on it. The Excel FLOOR function can round a given number down to the nearest specified multiple. For example, providing the number 10 and its significance v...
How to Use Excel CEILING.PRECISE Function? - https://aawexcel.com/how-to-use-excel-ceiling-precise-function//
Listen to this article
Ceiling.Precise
Excel is a spreadsheet developed by Microsoft. This application will help you to perform various mathematical calculations. In case, you want to round up the values based on specific multiples, we suggest you use Excel CEILING.PRECISE Function. It is...
How to Use Excel CEILING Function? - https://aawexcel.com/how-to-use-excel-ceiling-function//
Listen to this article
CEILING Function
Excel is a spreadsheet developed by Microsoft. This application will help you to create, view, edit, and share your files with others as soon as possible. Sometimes, you want to round up the given value to the nearest multiple. To do so, Excel provid...
How to Use Excel GCD Function? - https://aawexcel.com/how-to-use-excel-gcd-function//
Listen to this article
GCD Function
The term GCD stands for Greatest Common Divisor. It is one of the mathematical operations used to get the greatest common divisor of two or more integer values. To be more precise, GCD is the largest integer value that goes into all supplied numbers with...
How to Use Excel LCM Function? - https://aawexcel.com/how-to-use-excel-lcm-function//
Listen to this article
LCM function
The term LCM stands for Least Common Multiple. It is one of the mathematical operations used to get the least common multiple of two numbers. LCM is the lowest possible number divisible by the given two numbers. You can find LCM for two or more integers ...
How to Use Excel QUOTIENT Function? - https://aawexcel.com/how-to-use-excel-quotient-function//
Listen to this article
QUOTIENT Function
We all know that Microsoft Excel provides various built-in functions and formulas for performing mathematical operations. On that note, sometimes we want to perform division and get the quotient value as a result. For that, we suggest you use the Ex...
How to Use Excel INT Function? - https://aawexcel.com/how-to-use-excel-int-function//
Listen to this article
INT Function
Generally, functions are predefined formulas that allow performing various mathematical operations in Excel. These functions and formulas are already available in Excel by default. You can use the INT function to return the integer portion of a given inp...
How to Use Excel PRODUCT Function? - https://aawexcel.com/how-to-use-excel-product-function//
Listen to this article
Product Function
We all know that multiplication is a basic arithmetic operation that combines two or more numeric values to get the product as a result. If we have larger data in the spreadsheet and we want to find a product of each value stored in a row, then we ca...
How to Use Excel MOD Function? - https://aawexcel.com/how-to-use-excel-mod-function//
Listen to this article
MOD
Microsoft Excel provides plenty of built-in functions and formulas for performing mathematical calculations. Sometimes, we want to perform division operations and get the remainder. In order to do it manually, we can use the MOD function. This function will help ...
How to Use Excel BASE Function? - https://aawexcel.com/how-to-use-excel-base-function//
Listen to this article
Base Function
Microsoft Excel provides plenty of built-in functions and formulas for performing mathematical calculations. The base function in Excel is used to display the base value of a number as a numerical or text representation according to the given radix or b...
How to Use Excel DECIMAL Function? - https://aawexcel.com/how-to-use-excel-decimal-function//
Listen to this article
Decimal function
As we know, decimals are one of the types of numbers, which has a whole number and the fractional part separated by a decimal point. For instance, 3.45, where 3 is the whole number, and .45 is the fraction part. The dot refers to the decimal point. I...
Convert Cell Reference to Relative/Absolute Reference in Excel - https://aawexcel.com/convert-cell-reference-to-relative-absolute-reference-in-excel-365//
In this article, you will learn how to Convert Cell References to Relative/Absolute References in Excel. In Excel, cell references can be either relative or absolute.
A relative reference changes based on its position when it is copied or filled, while an absolute reference remains constant. Co...
How to Use Excel EXP Function? - https://aawexcel.com/how-to-use-excel-exp-function//
Listen to this article
EXP Function
Excel provides various built-in functions and formulas for performing mathematical calculations. The term “EXP” stands for Exponential. For instance, we can write it as “ex“. Excel has this function as an in-built feature that is categorized as a...
How to Use Excel ARABIC Function? - https://aawexcel.com/how-to-use-excel-arabic-function//
Listen to this article
ARABIC Function
We all know that Excel provides various built-in functions and formulas for performing mathematical calculations. On that note, the ARABIC function is categorized as the Math function in Excel. The function converts a Roman numeral to an Arabic numera...
How do Copy the Format to Other Charts in Excel? - https://aawexcel.com/how-do-copy-the-format-to-other-charts-in-excel//
Excel provides various chart options for performing calculations and analyzing them visually. We can also add additional plug-ins like Kutools to increase the performance of the task in Microsoft Excel. It provides plenty of features.
Sometimes, we use multiple charts in our workbook, which mean...
How to Use Excel FACTDOUBLE Function? - https://aawexcel.com/how-to-use-excel-factdouble-function//
Listen to this article
FACTDOUBLE
Generally, the double data type will store the decimal numbers with double precision. FactDouble function allows you to return the double factorial of any positive, even, or odd number. It is one of the built-in functions in Excel that comes under the Mat...
How to Change Chart Color According to Cell Color in Excel? - https://aawexcel.com/how-to-change-chart-color-according-to-cell-color-in-excel//
Microsoft Excel provides various kinds of charts for performing operations. We can also add additional plug-ins like Kutools to increase the performance of the task in Excel. It provides plenty of features.
Most of the charts in Excel use their colors for the bars, columns, and scatter in the ...
How to Use Excel FACT Function? - https://aawexcel.com/how-to-use-excel-fact-function//
Listen to this article
Use FACT Function
Microsoft Excel offers plenty of formulas and functions for performing various mathematical calculations. The Excel Fact function returns the factorial of a given input number. Factorial is nothing but the product of all the positive integers less t...
How to Use Excel TRIM Function? - https://aawexcel.com/how-to-use-excel-trim-function//
Listen to this article
TRIM Function
In Excel, we can manage and store a large amount of data and there might be some mistakes while entering. Sometimes, we may leave some extra spaces while typing a sentence. In order to change them into proper text, we don’t have to check them manually...
How to Use Excel CONCATENATE Function? - https://aawexcel.com/how-to-use-excel-concatenate-function//
Listen to this article
Concatenation
We usually enter values in different or adjacent cells in the Excel spreadsheet. Because, an Excel spreadsheet is made up of rows and columns, both having cells in it. In some cases, we want to group values from different cells in order to get combined ...
How to Freeze the Headings in Excel Sheets? - https://aawexcel.com/how-to-freeze-the-headings-in-excel-sheet//
Listen to this audio for a clear view of this article.
If you have a large table of data in your Excel and want to check them manually, then you might know about the Freeze Panes feature. It will help you to keep your heading rows and columns visible while scrolling through the rest of the works...
How to Use Excel TEXT Function? - https://aawexcel.com/how-to-use-excel-text-function//
Listen to this article
TEXT function in Excel
Microsoft Excel has many built-in formulas and functions for performing mathematical operations. On that note, if you want to convert a numeric value into a text string with the specified format, we suggest you use the TEXT function. It helps t...
How to Use Excel DAYS360 Function? - https://aawexcel.com/how-to-use-excel-days360-function//
Listen to this article
DAYS360
In general, a year has 365 days. A leap year has 366 days. Excel has plenty of functions and features for performing various mathematical operations and we can use them to get the result as quickly as possible. If you want to find out the number of days betwe...
How to Use Excel MONTH Function? - https://aawexcel.com/how-to-use-excel-month-function//
Listen to this article
MONTH
Generally, a month is a unit of time used with calendars. And we all use Calendars for scheduling any events in our lifetime. In Excel, we can print the numerical value of the particular month based on the given date. For that, it offers a special function call...
How to Filter Cells with a Strikethrough in a Specific Column with One Click? - https://aawexcel.com/how-to-filter-cells-with-strikethrough-in-a-specific-column-with-one-click//
Listen to this audio for a clear view of this article.
Filtering cells with a strikethrough in a specific column with one click is a useful feature that allows users to quickly filter out or isolate cells that have strikethrough formatting in a particular column. This can be helpful for tasks su...
How to Use Excel VLOOKUP Function? - https://aawexcel.com/how-to-use-excel-vlookup-function//
Listen to this article
Vlookup gif
The VLOOKUP function is one of the most powerful tools in Excel. We all know that Excel has plenty of functions and formulas to perform calculations on it. On that note, if you are a regular Excel user and manage a huge data, then you might want to look f...
Extract and List all comments to the new worksheet or workbook in Excel! - https://aawexcel.com/extract-and-list-all-comments-to-new-worksheet-workbook-in-excel//
“Extracting and listing all comments” refers to the process of identifying and extracting comments from a particular source, such as a document, website, or social media platform, and then presenting them in a list format.
Comments are a form of user-generated content that can provide valu...
How to Use Excel HOUR Function? - https://aawexcel.com/how-to-use-excel-hour-function//
Listen to this article
HOUR
Generally, the hour is a unit of time in a day. A day has twenty-four hours. Each hour has 60 minutes. In Excel, we can print the numerical value of the particular time value. For that, it offers a special function called “HOUR.” With the help of this funct...
How to Use Excel DATE Function? - https://aawexcel.com/how-to-use-excel-date-function//
Listen to this article
DATE Function
In general, dates are the significant ones for making any events, programs, functions, etc. Because we should decide the time of the event on a particular date. In Excel, they provided a separate DATE function that helps to create dates on the spreadshe...
How to Format Text or Characters as Superscript/Subscript in Excel? - https://aawexcel.com/how-to-format-text-or-characters-as-superscript-subscript-in-excel//
Listen to this audio for a clear view of this article.
Superscript and subscript formatting in Microsoft Word allows you to format text or characters so that they appear smaller and raised or lowered. This formatting is often used in mathematical equations, chemical formulas, and footnotes.
T...
How to Use Excel TRUE Function? - https://aawexcel.com/how-to-use-excel-true-function//
Listen to this article
TRUE Function
Generally, TRUE or FALSE are two logical expressions representing 1 and 0 respectively. On that note, if we want to check whether the given condition is true or false, then we can use Excel’s built-in logical function called “TRUE.” In Excel, ther...
Insert Page Break Every X Rows in the Worksheet in Excel! - https://aawexcel.com/insert-page-break-every-x-rows-in-the-worksheet-in-excel//
Listen to this audio for a clear view of this article.
In Microsoft Excel, a page break is a marker that separates the content of a worksheet into separate pages for printing or display purposes. By default, Excel automatically inserts page breaks based on the size of the paper and the margin se...
CTRL + /: Shortcut to Select Current Array in Excel (Windows & Mac) - https://aawexcel.com/easy-keyboard-shortcuts-to-select-current-array-in-excel//
Excel shortcuts are more efficient and save a lot of time. Once you learn shortcuts for performing tasks on your PC, you will complete the job efficiently. Excel provides plenty of shortcuts to do different kinds of tasks on it.
Let’s see the shortcuts to select the current array in Microsoft ...
How to Use Excel IFNA Function? - https://aawexcel.com/how-to-use-excel-ifna-function//
Listen to this article
Example for IFNA
If you are a regular Excel user and want to return a value as the replacement for the /A error in Excel, then there should be a way for it. In this post, we will let you know a simple solution to your problem which is nothing but a built-in functio...
Printing a List into Multiple Columns to Fit on Each Printed Page in Excel! - https://aawexcel.com/printing-a-list-into-multiple-columns-to-fit-on-each-printed-page-in-excel//
Listen to this audio for a clear view of this article.
Printing a list into multiple columns can be useful when you have a long list of data and want to display it more organized and visually appealing. By dividing the list into multiple columns, you can save space and make it easier for your re...
CTRL + A: Shortcut to Select Current Region in Excel (Windows & Mac) - https://aawexcel.com/quick-shortcut-to-select-current-region-in-excel//
Excel shortcuts are more efficient and save a lot of time. Once you learn shortcuts for performing tasks on your PC, you will complete the job efficiently. Excel provides plenty of shortcuts to do different kinds of tasks on it.
Let’s see the shortcuts to select the current region in Excel. We...
Formula to Count Occurrences of a Character in a String in Excel! - https://aawexcel.com/excel-formula-to-count-the-occurrences-of-a-character-in-a-string//
Listen to this article
Sometimes, we want to find the occurrences of a specific character in a word. Instead of counting it manually, we can use the Excel COUNTCHAR function. In this article, we will guide you to know the simple and useful functions of Excel. This page will describe the Formula ...
SHIFT + F2: Shortcut to Insert or Edit Comment in Excel (Windows & Mac) - https://aawexcel.com/simple-shortcut-to-insert-or-edit-comment-in-excel//
Excel shortcuts are more efficient and save a lot of time. Once you learn shortcuts for performing tasks on your PC, you will complete the job efficiently. Excel provides plenty of shortcuts to do different kinds of tasks on it.
Let’s see the shortcut keys to insert or edit comments in Excel. ...
Insert Multiple Checkboxes at Once in Excel! - https://aawexcel.com/insert-multiple-checkboxes-at-once-in-excel//
Listen to this audio for a clear view of this article.
Checkbox – Checkboxes are graphical elements in user interfaces that allow users to make a binary choice: to select one option among two possible options. A checkbox typically appears as a small square box next to a label or description of...
Be the first to know and let us send you an email when Aaw Excel posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.
Send a message to Aaw Excel:
Want your business to be the top-listed Media Company?
