Latest Blog Posts

Excel Address Format (All Things You Need to Know)

In this tutorial, you will learn how to format addresses in Excel. You will find four different techniques by which you will be able to format your ...

Quick Access Toolbar in Excel: A Complete Guideline

In this article, we will introduce Quick Access Toolbar in Excel to you. We'll show you how to add or remove command buttons, change their order, ...

Excel Percentage Formula Examples

Excel Percentage Formula Examples: Knowledge Hub Calculate Percentage of Month in Excel Calculate Error Percentage in Excel Apply ...

List of Complex Functions in Excel (10+ Functions)

A complex number is a combination of real numbers and imaginary numbers represented in x+iy format. Where x is the real part and y is the coefficient ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo