Latest Blog Posts

Excel Data Connections (Create, Refresh, Manage & Remove)

Here's an overview of one of the ways you can make data connections in Excel. Download Practice Workbook We recommend downloading the ...

How to Do Web Scraping in Excel (Power Query & VBA)

In this article, learn how to - Scrape tabular data from web in Excel. - Scrape entire page data including hyperlinks from web. While ...

How to Audit Formulas Using Excel Auditing Tools – 7 Tools

The following showcases an overview of  Excel auditing tools. Download Practice Workbook Audit Formulas.xlsx The sample ...

How to Generate Financial Statements in Excel?

`In this article, I will try to give a complete overview of preparing financial statements in Excel. It includes the preparation method of a balance ...

HLOOKUP Practice Exercises with Answers

In this article, you will get HLOOKUP exercises with answers for practice. When data is arranged row-wise this article will help you to get exact and ...

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

Calculate Percentage with Criteria in Excel (2 Useful Examples)

In this Excel tutorial, you will learn 2 useful examples of calculating percentage with criteria. We will discuss how to use the IF function to ...

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

Excel ENGINEERING Functions (50++ Functions)

Excel Engineering Functions are the 54 Excel functions that are most preferably used in engineering applications. Engineers may find these Excel ...

Excel Floating Cells (Create and Remove)

We'll talk about different methods to give the spreadsheet a floating effect as we explore the idea of floating cells in Excel. Excel does not have a ...

Heatmap in Excel (Static, Dynamic and Geographic)

In this article, you will learn how to create Heatmap in Excel. Here, we will explain static and dynamic heat maps, we will also learn about ...

How to Use Excel String Functions (Examples of 17 Functions)

  Function 1 – TEXT Function Syntax: =TEXT(value, format_text) Arguments Explanation: Argument Required/Optional ...

Excel Date Functions – A Complete Guide

This is an overview. . Download Practice Workbook Download the workbook here. Excel Date Functions.xlsx 1 - Insert ...

Network Diagram in Excel (Creation Process)

In this article, you will learn how to create a network diagram in Excel. This covers the fundamental network diagram as well as the project network ...

How to Use a Timeline in Excel? – A Visual Presentation

A timeline is a representation of events in chronological order. Download Practice Workbook Timeline in Excel.xlsx How to ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo