Monthly Archives: July 2018

Load multiple #Excel Tables as separate #Queries quickly…

Posted on July 26, 2018 by

To load an Excel Table into Power Query is easy.  Just click into any cell of the Excel Table, and then click the From Table/Range button (depends on which version you are using, this button resides in different location on the … Continue reading →

Rate this:

Posted in Power Query | 2 Comments

Change the first letter to upper case, first word only please #Excel

Posted on July 19, 2018 by

This is a short story of mine, and an imaginary conversation in my head…  How to change the first letter (of first word only) to upper case in Excel? This was a question from a colleague sitting opposite to me.  … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , | 7 Comments

Creating % of Total, Running Total in a few clicks with #Excel Quick Analysis

Posted on July 5, 2018 by

This post is about showing you how to perform a common task of adding a column of % of Total Running Total with Quick Analysis in Excel 2013 or later. Latest Excel makes things easier, just that you may not be … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment