Blog
What Are The Volatile Functions in Excel?
Slow Excel Calculations? Search for Volatile Functions There are some functions in Excel called Volatile functions. If you have a large number of these functions in the workbook, they slow down Excel ...
Easy Ways to Track Your Investments
Investing your savings is a great way to secure your financial success. In this day and age where various uncertainties threaten the stability of our day-to-day lives, everyone should try finding alte...
The Basics of Pivot Tables
Table of Contents Download the Exercise Files Because practicing is an integral part of the learning process, I am providing all the exercise files so that you can follow step by step. You can downloa...
Protected: Gift
There is no excerpt because this is a protected post.
Create A Popup Reminder In Excel
This useful project enables you to create a popup Reminder in Excel that Beeps, Displays your Custom Message and reads it aloud. Without any knowledge in VBA, Copy the code here under and paste it int...
What Should I use: Excel or Google Sheets?
Comparing Excel, Excel Online, and Microsoft 365 Microsoft Excel is a member of the Office Suite of applications. Being the most popular spreadsheet software, it is used by over 750 million persons ac...
Create a Dependent Drop List With No Source Data
Geography Data Types and Data Validation Office 365 We learned in previous examples different ways to create a dependent Data Validation list. Whatever the technique used, the source data used for the...
From Data To Analysis with Power Query and CUBEVALUE Function
In this project: We combine multiple text files from a folder. Each file contains thousands of records. We clean and Transform the data in Power Query and create an M function. We send the data to the...
Excel Data Validation… Let’s Push it to the Limit and Beyond
The Magic of Data Validation Introduction Dynamic Data Validation… is a Game changer in Excel, at the basic level it controls what a user can enter or cannot enter in a cell. It also makes data entry ...
