Excel
Gantt charts are commonly used in project management and while Excel doesn’t have a native Gantt chart in its chart library we can easily create one. Don’t get too excited, it’s a very basic one. If your job involves complex project management then you probably need a more sophisticated tool like Microsoft Project. However, for [...]
A few weeks ago David T asked me to help him understand a VLOOKUP formula in a workbook he’d inherited from a colleague who had left his company. It was a VLOOKUP formula like nothing I’d ever seen before so I thought I’d share it with you. Drum roll….. =VLOOKUP(E2&F2,IF({1,0},First_Name&Last_Name,Grade),2,FALSE) David’s question was ‘what’s the [...]
A little while ago Brendan asked me how he could check if values in a list fall between two limits. Now, it’d be nice if there was a BETWEEN Function, but there isn’t. Hence why the title of this tutorial isn’t ‘BETWEEN Function’, it’s ‘BETWEEN Formula’. I’ve got two options for you: BETWEEN with MAX [...]
I’ve set up a table with some team names that I want to use in a Data Validation list. The reason I formatted my list in an Excel table is because I want the range to dynamically update when I add or remove teams from the list. My table’s name is Table1, as you can [...]
I recently came back from a family skiing vacation in Whistler, Canada, which by the way was fantastic. Here we are at a lookout on a snowmobile trip we took. Anyway I digress…. one of the key pieces of information you want to know as a skier (or snowboarder) is how much snow is on [...]
To be honest I don’t use Advanced Filters much. I tend to use the regular AutoFilter, or if I need more I’ll use the Custom AutoFilter. Not because they’re necessarily better, it’s probably more out of habit than anything else. But Advanced Filters have a couple of advantages over regular filters: The filter [...]
Moving back and forth between worksheets in a large workbook can be tedious. Of course you can use the shortcut keys CTRL+Page Up or CTRL+Page Down to quickly move from one worksheet to another (and CTRL+Tab to move between workbooks). However if there’s a lot of worksheets in a file the shortcut keys aren’t going [...]
![Post image for Excel PivotTable Month Comparison [Video]](http://images.myonlinetraininghub.com/pivot_tip_mth_change_thumb.png)
In this last tutorial, in my 3 part series on PivotTable tips and tricks, I’m going to show you how to include the month on month change. In the example below we can see that beverage sales in Feb were $10,391 less than the previous month, and in March they were $4,622 less than February: [...]
![Post image for Excel PivotTable Group Data [Video]](http://images.myonlinetraininghub.com/pivot_tip_group_data_thumb.png)
In this second tutorial, in my 3 part series on PivotTable tips and tricks, I’m going to show you how to group data like dates into years, quarters or months, and ages into groups like this PivotTable below: Watch the Video For best viewing watch the video in 720p HD full screen. Download the Workbook [...]
![Post image for Excel PivotTable Add Percentage of Total Column [Video]](http://images.myonlinetraininghub.com/pivot_tip_percent_total_thumb.png)
Excel PivotTables make light work of analysing data but there are a few tricks once you get past the basics. In this first tutorial, in my 3 part series on PivotTable tips and tricks, I’m going to show you how to add a percentage of total sales to your PivotTable like this one in column [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
