Excel Basics

10 Excel Formulas Every Non-Power User Ends Up Googling

In this tutorial, we will show 10 Excel formulas every non-power user ends up Googling.

5 Ways to Make Your Boring Data Interactive

In this tutorial, we’ll show 5 ways to make your boring data interactive in Excel.

5 Essential Excel Add-Ins for Beginners

In this article, we’ll list 5 essential Excel add-ins for beginners.

7 Excel Dashboard Design Principles That Make Data Beautiful

In this article, we will explore 7 Excel dashboard design principles that make data beautiful.

Transforming Date Formats: Month, Quarter, and Year Manipulations in Excel

In this article, we will show how to transform date format to month, quarter, and year in Excel using practical examples.

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 Insert Pictures in Excel?

In this Excel tutorial, you will learn how to - Insert pictures in Excel - Insert a picture into an Excel cell and fit it to its size - Add a ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo