Excel

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

Complete Guide on Volatile Functions in Excel

Slow Excel Calculations? Search for Volatile Functions There are some functions in Excel called Vola...

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

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

What Should I use: Excel vs Google Sheets?

Comparing Excel, Excel Online, and Microsoft 365 Excel vs Google Sheets is a Never-ending battle. Ho...

Create a Dependent Drop List With No Source Data

Geography Data Types and Data Validation Office 365 We learned in previous examples different ways t...

Transform data using Power query

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

data validation

Simple ways to 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 th...

Building surveys and quizzes with excel

An Intense Tutorial on Building Surveys and Quizzes

Building A Quiz, Survey or Questionnaire … Step by Step Building Quizzes, Surveys and Questionnaires...

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.