Excel Basics

How to Select a 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. ...

Excel Picture Format: 12 Different Scenarios

Method 1 - Making Correction to an Image Get picture format, you have to select the image first in every case. Choose Picture Format ...

How to Create a Hierarchy in Excel Using Different Methods

  What Is Hierarchy? Hierarchical Chart: The term hierarchy has a dual meaning. First, it refers to a specific type of ...

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

We will demonstrate how to change table style by choosing table style, creating a custom table, resizing the table style, and removing table style. ...

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)

Here's an overview of the Equations Editor in a cell. Download the Practice Workbook Equation Editor.xlsx What Is the ...

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

This is an overview. Download Practice Workbook Comments in Excel.xlsx How to Insert/Add Comments in Excel 1. Insert ...

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 the Excel Calculation Options – 6 Examples

Below is an overview: Download Practice Workbook Download the Excel file. Use of Excel Calculation Options.xlsm This is ...

Understanding Views in Excel (A Complete Guideline)

Here's an overview of the View tab and the most common View options you'll need in Excel. Download the Practice Workbook Download this ...

How to Highlight in Excel – 6 Examples

Method 1 - Using Cell Styles to Highlight Cells Select cells >> go to the Home tab >>  Styles >> select Cell Styles >> ...

How to Use Conditional Formatting Icon Sets?

"Icon sets" are used as a performance indicator, progress tracking, risk assessment, comparison and analysis, and so on. They are also helpful for ...

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

  Using the Page Layout Tab STEPS: Select the worksheet you want to print. Go to the Page Layout tab, and from Page Layout, select ...

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

We will use the following sample dataset to insert quotes in various cells. Download the Practice Workbook Use of Quotes.xlsm ...

How to Insert Object in Excel (Ultimate Guide)

Here's a basic overview of where you can find the Insert Object command. Download the Practice Workbook Insert Object.xlsm ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo