Latest Blog Posts

How to Create GST Late Fees Calculator in Excel

Are you looking for an easy way to create GST late fees calculator in Excel? Don’t worry! You have landed in the right place. In this article, I will ...

How to Color Code Cells in Excel (3 Methods)

We'll use a sample dataset of students and their grades to color code cells. Why Is Color Coding Cells in Excel Important? Visual ...

Plotting Row Number Instead of Value in Excel (with Easy Steps)

While working in Microsoft Excel sometimes we need to plot row numbers instead of values for working advantage. This might seem difficult to you if ...

How to Auto Refresh Excel File Without Opening (2 Easy Ways)

Method 1 - Using VBA Macro to Auto-Refresh a Specific Excel File Without Opening The Countdown Excel file has TODAY() and NOW() functions for ...

How to Flip Table in Excel (2 Quick Ways)

Although Excel offers no direct ways to do so, in this article we will demonstrate how to flip data by columns and rows using Excel’s built-in ...

How to Insert the Current Date and Time in Cell A1 (6 Easy Ways)

Need to learn how to insert the current date and time in cell A1? Sometimes we want to enter the latest time when an employee arrives at his ...

How to Create World Time Zone Clock in Excel (2 Easy Methods)

We have city names and their respective time differences from the current time in a sheet. We'll use this dataset to make a time zone clock. ...

How to Highlight Text in Text Box in Excel (3 Handy Ways)

If you are looking for ways to highlight text in the Excel text box, then you are in the right place. So, let’s get started with the main article to ...

How to Apply Formula to Entire Column Using Excel VBA

We have a sample dataset of product prices and taxes to be applied to them. We have formatted all the data cells in the Accounting format. We saved ...

How to Get Data from a Data Model in Excel – 2 Methods

What Is a Data Model? Data models are essential to perform data analysis. You can load and connect data, using tables and column references. ...

How to Determine the Protein Concentration from a Standard Curve in Excel – 2 Methods

The sample dataset showcases the Known Protein Concentration (g/L) and the Absorbance at 610 nm. Method 1 - Using a Linear Equation ...

How to Convert Hours and Minutes to Minutes in Excel

Method 1 -Using Multiplication to Convert Hours and Minutes to Minutes in Excel The relationship between time units is, 1 Day = 24 Hours = 24*60 ...

How To Select All Rows to Below in Excel (3 Easy Methods)

While using an Excel dataset we may need to select an entire row below a specific cell. Sometimes we may need to select some of the columns in a row. ...

How to Change Chart Style in Excel (with Easy Steps)

Charts are essential tools to visualize data in Excel. When you start to work with an extensive dataset, you will need to visualize your data to ...

How to Unhide a Sheet Tab in Excel (7 Methods)

Method 1 - Using View Tab Suppose you have a workbook where the sheet tabs are accidentally hidden. To restore them, follow these steps: Go ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo