Myonlinetraininghub - myonlinetraininghub.com - My Online Training Hub - Upgrade Your Skills In Excel, Word and Outlook
General Information:
Latest News:
Calculate Elapsed Days, Hours and Minutes in Excel 21 Aug 2013 | 06:59 am
I had an email from Steve a little while ago asking how he could display the number of elapsed days, hours and minutes in one cell as d h:mm, like this in C5 below: Notes: 1. my dates are dd/mm/yyyy...
Excel Test if a Range Contains Text, Numbers or is Empty 14 Aug 2013 | 06:51 am
I received an email from Bill this week asking how he can check if a range of cells contains text or numbers, as opposed to being empty. We can use the ISTEXT function to test for text, and ISNUMBER ...
Excel Quintile Chart 7 Aug 2013 | 04:34 am
One of my Excel Dashboard course members, Mark Maher, emailed me wanting to know if a chart that Stephen Few had mocked up in Adobe Illustrator could be done in Excel. The answer is yes (see below), ...
Excel Pivot Tables to Extract Data 2 Aug 2013 | 08:00 am
I’ve had a few people ask me recently: “What formula can I use to extract a list or subset of data from a master sheet into separate sheets for each division/sales person/product etc., and when I add...
Tour de France Excel Dashboard 23 Jul 2013 | 03:41 pm
Since Phil is somewhat of a cycling fan I have been subjected to late night TV of le Tour. Personally I don’t understand all the complexities of it, what with different jerseys (some of which I must ...
Excel Formulas Not Working? 18 Jul 2013 | 04:20 pm
Excel Formula Help is Here Excel formulas can be frustrating to understand, especially when you start nesting functions. If you’ve used Excel for a while you’ve probably experienced the urge to bang...
Excel CLEAN Formula 17 Jul 2013 | 06:33 am
Ever copy and paste some data from a web page, or import it from another program, and end up with some funky and usually unwanted characters like these nonprinting characters below? Excel’s CLEAN Fun...
Excel SUBSTITUTE Formula 17 Jul 2013 | 06:32 am
The Substitute function replaces new_text for old_text in a text string. The Syntax is: The arguments can be explained as: text– cell containing the characters you want to replace. old_text – the ...
Excel Form Controls 10 Jul 2013 | 03:46 am
Written by Alan Murray of Computergaga. Form controls such as option buttons, combo boxes and check boxes allow you to add interactivity to your spreadsheets. They are familiar to users whether they ...
Interactive Excel Chart with Map 2 Jul 2013 | 04:10 pm
Today I’d like to share with you a video tutorial by Isaac Gottlieb on supply-chain decision making from his book Next Generation Excel. Isaac teaches over 2,000 MBA students a year at Columbia, NYU ...
