Blog

power query

4 Easy Ways to Combine Files with Power Query

With the help of Power Query, you can work with multiple files and sheets and be able to combine the data efficiently. When working in Excel, you might be organizing your data in different files, and ...

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

Complete Guide on 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 ...

3 Easy Ways to Track Your Investment Portfolio

Track your Investment Portfolio is one of the important things you need to do once you start investing. Investing in your savings is a great way to secure your financial success. In this day and age w...

The Ultimate Guide to Pivot Tables. Everything you need to know about 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

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

What Should I use: Excel vs Google Sheets?

Comparing Excel, Excel Online, and Microsoft 365 Excel vs Google Sheets is a Never-ending battle. However, we will try to make things clear while choosing a Spreadsheet program for your workflow. Lets...

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

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.