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 data preparation table 3 Creating a drop list for the different months 3 Creating row labels for the ...
Prepare for a Successful Excel Job Interview
Excel Job Interview With over 15 years of experience in corporate training, I find that many clients are overestimating their knowledge in Excel. That’s why when you apply for a job requiring go...
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, clean and transform the data and create calculations in Power Query to return a nice report to Excel....
A Funny Excel Prank…
I learned this prank from Liam Bastick – Excel MVP (Sumproduct company)…. Hope no one does it to me 🙂 By far and away the most popular ‘trick’ (in all senses of the word!) I demonstrate...
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 dashboards, check out Simple Sheets. Having a la...
Comparison Chart For Dashboards
You can download the Exercise File and Follow along by clicking here below:
Randomize Items in Drop Lists …With Every Use
Is it a New List? Randomizing Drop List with every use Randomizing items in a drop list means every time you use the drop list the contents are the same but appear in a different order. This functiona...
Dependent Drop List – No Preparation Table
Creating dependent Drop List without Any Preparation Table What is a dependent drop List? It’s a drop List where the items change based upon your selection from another drop List. In our example we ha...
Find and Replace… Amazing Functionality You Did Not Know
Table of Contents Mind Blowing Functionality of the “Find and Replace” Command This blog article maps to my video on the same topic. You can Download the Exercise File and follow along by ...