Excel Basics

Excel Cell Format: Everything You Need to Know

Excel cell format means the background color, font color/style/size, number format, alignment, orientation, etc. attributes of a cell. In this ...

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 to insert data. Each cell has a unique address. Cell address is a combination of a column letter ...

How to Print in Excel – Basic Guidelines for Beginners

Printing in Excel means making a paper copy or a PDF copy of your Excel sheet. This is handy for meetings or sharing physical documents. In this ...

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

Split in Excel means separating combined data from one cell into multiple cells, either across rows or columns. In this tutorial, we will show you ...

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)

Wrapping text in Excel means displaying all the contents of a cell over multiple lines. It comes in handy when dealing with long text entries. Wrap ...

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

In Excel, cell reference in Excel are used to identify the location of a cell or a range of cells in a worksheet. In this article, you will learn ...

Understanding Excel Parts and Components

Excel parts means knowing all the basic commands, buttons, and built-in features shown in the Excel window. In this Excel tutorial, we will ...

Scrolling in Excel (Options, Smooth Scrolling, Scroll Lock, Custom Scroll Bar, Issues, Etc.)

Scrolling in Excel means moving up, down, left, or right in your spreadsheet. You can do this by using the mouse, arrow keys, or scroll bars. If ...

Find and Replace in Excel (A Complete Guideline)

Finding and replacing data in Excel means Excel will find data first and then replace it with another one. It can be a single character or even ...

How to Extract Data from Excel? (10+ Basic & Advanced Methods)

Data Extraction is the approach of gathering particular data from a source or replicating the data from somewhere else. In this Excel tutorial, you ...

Understanding Excel Ribbon: A Complete Guide for Beginners

The Excel Ribbon is the row of tabs and icons located at the top of the Excel interface. It allows you to find the necessary features or commands to ...

How to Add, Use and Remove Filter in Excel

Filter in Excel means displaying only the data that meets certain criteria and hiding the rest of the data temporarily in an Excel worksheet. In ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo