Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Excel Articles

Friday, November 29, 2019 John Franco Article , Excel formulas
If you want to follow a proven system to always write perfect VLOOKUP/INDEX & MATCH formulas, then this free crash course is for you! In th...
Tuesday, November 19, 2019 John Franco Article , Pivot Tables
You can generate a Pivot Table report with a mouse click. You can do it using Excel VBA and macros! Let’s suppose you want to generate a Pivot ...
Saturday, September 29, 2018 John Franco Article , Excel formulas
According to this Office article, there are 477 functions in Excel 2016. They are distributed this way: Category Amount Statistical 112 Math...
Saturday, December 02, 2017 John Franco Article , Pivot Tables
This short story shows how I gained the respect and trust of 3 departments in the big company I worked for. Before I knew how Pivot Tables in Excel...
Saturday, December 02, 2017 John Franco Article , Pivot Tables
The reason why many Excel users never learn how to do a Pivot Table in Excel is because they don’t understand why they should learn Pivot Tab...
Wednesday, August 13, 2014 John Franco Article , Excel VBA (Macros)
The best way to go through cells dynamically is using the Cells object inside a loop. This way you can refer to a different cell on each pass of th...
Tuesday, February 28, 2012 John Franco Article , Excel VBA (Macros)
You can run an Excel macro by clicking any Excel object you can imagine: text box, shape, picture, chart, etc. See below the main Excel objects you...
Saturday, February 25, 2012 John Franco Article , Excel VBA (Macros)
If you acquire a brand new car and ignore the location of the keys, you couldn’t open the doors to get in, nor drive the car. In a sense, whe...
Thursday, February 23, 2012 John Franco Article , Excel VBA (Macros)
Are you asking where the macros in a workbook are? Well, you should know that Excel stores VBA stuff: macros, modules, user forms, etc. as well as...
Thursday, February 23, 2012 John Franco Article , Excel VBA (Macros)
You want to record dynamic Excel Macros that work on variable-size arrays, right? Maybe you recorded/created an Excel VBA Macro and worked awesome ...

Dare to simplify your workflow, get more done with less, and be seen like an Excel Authority?

Download my report 'How to Think Like An Excel Guru'!

Works great for intermediate and advanced Excel users!

We promise to do our best to keep your email safe