Aaw Excel (2024)

10/05/2023

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,...

09/05/2023

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...

08/05/2023

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...

06/05/2023

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...

05/05/2023

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...

04/05/2023

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 ...

03/05/2023

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...

02/05/2023

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...

29/04/2023

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...

28/04/2023

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 ...

27/04/2023

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...

26/04/2023

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...

25/04/2023

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...

25/04/2023

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...

24/04/2023

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...

21/04/2023

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...

21/04/2023

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...

20/04/2023

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 ...

20/04/2023

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...

19/04/2023

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...

18/04/2023

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 ...

18/04/2023

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...

17/04/2023

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...

15/04/2023

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...

13/04/2023

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...

13/04/2023

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...

12/04/2023

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...

11/04/2023

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...

11/04/2023

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...

10/04/2023

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...

10/04/2023

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...

07/04/2023

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...

07/04/2023

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...

07/04/2023

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 ...

06/04/2023

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...

06/04/2023

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...

06/04/2023

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...

05/04/2023

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 ...

05/04/2023

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. ...

05/04/2023

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...

10/05/2023

09/05/2023

08/05/2023

06/05/2023

05/05/2023

04/05/2023

03/05/2023

02/05/2023

29/04/2023

28/04/2023

27/04/2023

26/04/2023

25/04/2023

25/04/2023

24/04/2023

21/04/2023

21/04/2023

20/04/2023

20/04/2023

19/04/2023

18/04/2023

18/04/2023

17/04/2023

15/04/2023

13/04/2023

13/04/2023

12/04/2023

11/04/2023

11/04/2023

10/04/2023

10/04/2023

07/04/2023

07/04/2023

07/04/2023

06/04/2023

06/04/2023

06/04/2023

05/04/2023

05/04/2023

05/04/2023

Address

Website

Alerts

Contact The Business

Shortcuts

Share