Excel Basics

How to Select Row in Excel (9 Methods)

Method 1 - Clicking on Row Number: The simplest way to select a row in Excel is by clicking on the row number you want to select. Method ...

Excel Picture Format: A Complete Guide

In this article, we are going to explore how we can use Excel picture format feature to correct, resize, color, create an artistic style, make ...

Hierarchy in Excel (Create, Customize, Features)

In this article, we are going to learn about hierarchy in Excel. We shall use the SmartArt feature to create and customize a hierarchical structure ...

Change Table Style in Excel (Change, Create & Remove)

Excel Table Styles & Formats is a powerful feature in Excel that allows you to enhance the presentation and organization of datasets in a ...

Find Last Value in a Range in Excel

Excel Find Last Value in a Range: Knowledge Hub How to Find the Last Non-Blank Cell in Row in Excel How to Find the Last Cell with Value in ...

Equation Editor in Excel (Insert, Create & Format)

The purpose of this article is to provide a concise and comprehensive overview of Equation Editor in Excel. First, we will discuss what the Equation ...

Comments in Excel (Insert, Copy, Format, Hide, Delete & Print)

In this article, we are going to explore how we can insert, copy, hide, format, and delete a comment. Moreover, we will see how we can insert a ...

How to make Excel Auto Calculate (6 Easy Methods)

  The dataset, Sales of Products, has four columns: Product Name, Unit Price, Quantity, and Total Price. To calculate the total ...

How to Use Excel Calculation Options (6 Suitable Examples)

In this article, you’ll learn 6 suitable examples of how to use Excel Calculation Options. The examples include changing the Calculation Options ...

Understanding Views in Excel (A Complete Guideline)

Excel offers various views of the worksheet to make it easy to work with the database. Different views are appropriate in different cases, where each ...

How to Highlight in Excel (6 Suitable Examples)

In this article, you will learn about how to highlight cells in Excel. Here, we will describe how you can highlight a text, an entire row, or even ...

How to Use Conditional Formatting Icon Sets?

This article will summarize all the possible cases in conditional formatting icon sets in Excel. In this Excel tutorial, you will learn about - ...

How to Adjust Margin in Excel (Default/Custom Margins)

In this Excel tutorial, you will learn how to adjust a margin in Excel. There are three types of built-in margins available in Excel: Normal Margin, ...

How to Add Quotes in Excel (Single and Double Quotes)

In this Excel tutorial, we will show how to add single quotes as well as double quotes in Excel. The most common ways to add quotes are by making use ...

How to Insert Object in Excel (Ultimate Guide)

In this article, you will get a comprehensive guide on how to insert an object in Excel. You will learn to insert objects using Built-in features, ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo