Top Financial Functions in Excel (15+ Functions)

1 - FV Function (Future Value) The FV function is an Excel financial function that is used to calculate the future value of an investment based on a ...

How to Use Subscript and Superscript in Excel: A Complete Guide

Understanding Subscript and Superscript In mathematics, computing, and typography: Subscript: A character or symbol written in the bottom-right ...

Logical Functions in Excel

Logical Functions in Excel IF AND OR NOT IFERROR IFNA XOR << Go Back to Excel Function Categories | Excel ...

How to Use the Excel Formula Bar

Show or Hide the Formula Bar 1. Using the View Tab Go to the View tab. In the Show group, select Formula Bar to display it. Deselect it ...

Spell Number in Excel (With/Without Currency)

You can spell out numbers in different currencies as well as without currency as per your requirement. We have a list of numbers and various ...

Excel Scientific Notation (All Things You Need to Know)

In this article, you’ll learn how to add Excel scientific notation using the scientific format, the Format Cells option and the manual process. ...

Excel Shapes

Excel Shapes: Knowledge Hub Inert Shape in Excel Align Shapes in Excel Excel VBA Shape Position << Go Back to Learn Excel

Write, Display and Convert Fraction in Excel: 7 Methods

Method 1 - Using Mixed Fraction Technique to Display Fraction In cell D5, we have written a proper fraction in a mixed fraction manner, where 0 ...

Decimals in Excel (Add, Remove)

In this article, we will discuss how to add and remove decimals in Excel. Decimals are commonly in use while dealing with currency, accounting, ...

Negative Number in Excel (Add, Format, and Convert)

Here's an overview of negative numbers in Excel and how they can be formatted. Download the Practice Workbook Negative Number in ...

Excel Concatenate Date

Excel Concatenate Date: Knowledge Hub How to Concatenate Date and Time in Excel Excel VBA: Combine Date and Time How to Concatenate ...

How to Rotate Text in Excel

In this article, we have discussed 5 different ways in Excel to rotate text. We have also shown you how to rotate text at any custom angle. Then, we ...

Excel Cash Book Template

Excel Cash Book Template: Knowledge Hub Petty cash book format in excel Daily cash book format in excel Double column cash book format in ...

How to Apply Excel Text Format: 5 Methods

Method 1 - Format Numbers in Excel Select cell C5 to write this formula and press Enter. =TEXT(B5,"$###,###.00") You can see that ...

Data Entry in Excel (Basic, Form Creation & Error Handling)

In this article, we are going to learn about data entry in Excel. We will learn about the basics of data entry, form creation, and error handling. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo