# Latest Blog Posts

### How to Use Bond Price Calculator in Excel? (A Complete Guide)

You can determine the present value of a bond with the bond price calculator in Excel. It helps you to assess the fair value of a bond and make ...

### Tracker in Excel (Task Tracker, Progress Tracker and so on)

A tracker in Excel can be used for many purposes including project management, inventory management, event planning, data organization, employee ...

### How to Do Web Scraping in Excel (2 Methods)

Method 1 - Using the "Get Data from Web" Feature Go to the Data tab and select From Web under the Get & Transform Data section. ...

### How to Audit Formulas Using Excel Auditing Tools – 7 Tools

The following is an overview: Download Practice Workbook Audit Formulas.xlsx The sample dataset showcases Principal Amount, ...

### How to Generate Financial Statements in Excel: 3 Methods

Method 1 - Creating Balance Sheet To create a Balance Sheet, we need to calculate the net balance. The following formula calculates the Net Balance. ...

### HLOOKUP Practice Exercises with Answers

Why HLOOKUP Matters HLOOKUP is a powerful tool for extracting specific information from large datasets, such as sales records or employee ...

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

### Calculate Percentage with Criteria in Excel (2 Useful Examples)

Method 1 - Use the IF Function to Calculate a Percentage with Criteria in Excel Consider the following dataset with the sales volume of some ...

### 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: 8 Methods

Method 1 - Using the CONVERT Function to Convert Between Units of Measurement To convert a gram unit into a pound mass unit, follow the steps below: ...

### How to Create and Remove Floating Cells in Excel

Method 1 - Using Watch Window to Create Floating Cells To make particular info available all the time while scrolling through big data in Excel, ...

### How to Create a Heatmap in Excel (Static, Dynamic and Geographic)

What Is a Heatmap? A heat map visually represents data using colors in a two-dimensional or geographic area. Each data point corresponds to a ...

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

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