Excel Basics

Excel Data Types – Everything You Need to Know

This is an overview: The Number data type is displayed on the right side of the cells, whereas the Text data type is displayed on the left ...

Print Area in Excel (Set, Modify, Ignore)

In this article, we will go over how you can set up a print area in Excel. The print area determines how your content looks when printed. Clicking ...

Excel Worksheets Basics – A Beginner’s Guide

This is an overview.     What Is an Excel Worksheet? An Excel worksheet is a grid-based document used for organizing and ...

Outline (Or Grouping) in Excel: Features, Creation, Uses & More

Below, we have a dataset containing Member ID, Joining Date, Name, State, Designation, and Member Type. We will outline or group these data based on ...

Columns in Excel (Select, Insert, Delete, Hide, Unhide, Group, Ungroup, Move, Modify Size, Etc.)

Columns are the vertical alignment of cells in an Excel worksheet. A single worksheet contains a total of 16,384 columns. Each column is addressed at ...

How to Format Cells in Excel: Everything You Need to Know

  What Options Are Available to Format Cells in Excel? 1. Ribbon Commands The Ribbon has various commands for formatting a cell in Excel. You ...

Rows in Excel (Select, Insert-Delete, Hide-Unhide, Group-Ungroup, Move, Modify Size, Etc.)

Rows in Excel provide a structured way for all the users to organize and reference data in an Excel worksheet. In this article, you will learn ...

Excel Cells Basics – A Beginner’s Guide

A cell is the smallest unit of an Excel worksheet. Each cell has a unique address. The cell address is a combination of a column letter and a row ...

How to Print in Excel – Basic Guidelines for Beginners

Here's an overview of the Print menu in Excel. You can choose your printer, and you can change print settings including what to print, how many ...

How to Split in Excel (Text, Numbers, Cells & Columns)

The overview shows the summary of splitting first and last names, separating numbers from text, and splitting cells vertically across rows. Here, the ...

Numbering in Excel (Number Rows, Columns, Filtered Data, Alphabetical Order etc.)

Numbering in Excel is essential for organizing, sorting, and referencing data, facilitating efficient data entry, and calculations, and enhancing ...

Excel Basics for Beginner Excel Users (Step by Step)

On this page, we shall accumulate all the basic Excel topics for the beginner level of Excel users. For beginner-level Excel users, Excel can ...

How to Wrap Text in Excel (Wrap, Unwrap, Fix Issues)

Method 1 - Using the Wrap Text Option from the Home Tab Select range D6:D13. Go to the Home tab. Click on Wrap Text in the Alignment ...

Cell Reference in Excel (Absolute, Relative, and Mixed)

In this article, you will learn how to use absolute, relative, and mixed cell references. We'll use a sample dataset for Products and Sales, in ...

Understanding Excel Parts and Components

In the following image, you can see the basic parts of an Excel window. ⏷ What Is an Excel Workbook? ⏷ Basic Parts of Excel Window ⏷ ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo