Excel Basics

Alignment in Excel (Types, Change, Shortcut)

In this Excel tutorial, we will discuss how to apply different types of alignment in Excel. We will use different techniques like using control text ...

Excel Fonts (All Things You Need to Know)

Download Practice Workbook Fonts in Excel.xlsx Method 1 - Using the Excel Ribbon Options Select the cell containing the text you ...

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

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

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

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

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

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

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

How to Merge, Find, and Unmerge in Excel: 9 Methods

Method 1 - How to Merge Cells in Excel Using Merge & Center Feature Select the cells from B5 to G5. Go to the Home tab. From the ...

How to Clear Content in Excel (4 Methods)

Method 1 - Clear Content Using a Keyboard Shortcut 1.1 Clear Content of a Single Cell Select the cell from which you want to clear contents and ...

The Cursor in Excel – All You Need to Know

This is the sample dataset. Download Practice Workbook Download the free Excel workbook here. Cursor in Excel.xlsm ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo