Excel Basics

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

How to Create and Use Scroll Bar in Excel (3 Easy Ways)

A scroll bar is a tool for displaying huge data tables from top to bottom or left to right and vice versa. Here is an overview of an Excel data ...

Title Bar in Excel – Everything You Need to Know

This is an overview.   Title Bar The title bar is the horizontal bar located at the top of the Excel window. It displays the name ...

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

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

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

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

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

Scrolling in Excel: Options, Smooth Scrolling, Scroll Lock, Custom Scroll Bar, and Issues

Excel Scrolling Options for Vertical and Horizontal Scrolling 1. Scrolling Using the Arrow Keys To scroll up, select a cell => Press the Up ...

Find and Replace in Excel (A Complete Guideline)

In this blog post, you will learn how to find and replace data in Excel- Using the Find and Replace tool Using the Go to Special feature for ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo