Excel
The Basics of 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
This useful project enables you to create a popup Reminder in Excel that Beeps, Displays your Custom...
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 ...
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...
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...
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...
An Intense Tutorial on Building Surveys and Quizzes
Building A Quiz, Survey or Questionnaire … Step by Step Building Quizzes, Surveys and Questionnaires...
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...
Find and Replace… Amazing Functionality You Did Not Know
Table of Contents Mind Blowing Functionality of the “Find and Replace” Command This blog...