Excel

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

Find and Replace using excel

Find and Replace… Amazing Functionality You Did Not Know

Table of Contents Mind Blowing Functionality of the “Find and Replace” Command This blog...

Chart in Excel

Impressive Chart with Chart Title Drop List

Download the eBook   Table of Contents Switching Charts with A Drop-Down List 3 1. Creating a d...

Preparing for Excel job

Prepare for a Successful Excel Job Interview

Excel Job Interview With over 15 years of experience in corporate training, I find that many clients...

Power query and Data validation

2 Effective Tools Power Query and Data Validation are Much Stronger Together

  In this tutorial  I am bringing multiple files from a Folder, I combine the Files together, c...

Excel prank

A Funny Excel Prank…

I learned this prank from  Liam Bastick – Excel MVP  (Sumproduct company)…. Hope no one ...

data to dashboard

From Data to Dynamic Dashboard … All In One Dashboard with Form Controls

Complete Course on Dashboards Creation with form controls If you want pre-build templates with dashb...

Comparison Chart For Dashboards

Extremely easy way to Build Comparison Chart For Dashboards

Build a Comparison chart for Dashboard on Microsoft Excel You can download the Exercise File and Fol...

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.