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...
Live Interview with Brazilian Channel Excel Turbo
It was a pleasure meeting virtually Cristiano Galvao (Excel MVP) and so many of his fans and followers from Brazil and worldwide, on May 14th 2020 We had a lot of fun and I was happy to share my journ...
