Blog
Quality Analysis Report in Power BI
In this tutorial we are going to create a dynamic dashboard that analyses a production business where we have our data scattered in multiple files. With many products, employees and locations, the aud...
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...
