If you import data into Excel then you will have probably used Excel’s CSV import routines and have no doubt got frustrated that Excel’s default is to see all the number columns as numbers and format them accordingly. Sounds like a reasonable idea but if you are importing data where a zero at the front is important then it is not sure a great idea. Take for example Zip Codes. 07047 is different to 7047 and that leading zero is important. Excel CSV import routine is explained in this video and the all important step where most of us click [More]
Suppose you want to adjust a project’s schedule date by adding two weeks to see what the new completion date will be, or you want to determine how long a single activity will take to complete in a list of project tasks. And you might be thinking now how you can do this as simple as possible…. …. and sometimes Excel Date’s seem a but of a mystery …. The DATE function is the solution. There are a lot of cool functions for dealing with dates in Excel. But this video shows you how to add Years, Months or Days [More]
Excel provides many formulas for finding a particular string or text in a list or array.  In this video, you will learn how to use the MATCH function. Excel defines MATCH function as “Returns the relative position of an item in an array that matches a specified value in a specified order”. In simple plain language Match function searches for a value in a defined range and then returns its position. You will definitely love this video as it not only shows how to compare 2 lists but also demonstrate 2 ways how to handle errors when the comparison finds [More]
Click here to Download the spreadsheet used in this presentation Create an Excel Chart Budget vs Actuals chart using the clear instructions in this video the Queen of Excel Charts Mynda Tracey. The video is divided into two parts – the first showing how to create a Excel Chart Budget vs Actuals chart in Excel 2007/2010 and the second part (starting at around 8 mins) shows how to create the same graph in Excel 2013. The video shows some cool tricks along the way to creating the Excel Chart Budget vs Actuals chart – Including how to cut and paste [More]
Excel panel charts are usually created by taking more than one area chart and lining them up so they look like one chart. In this video you can see how you can set up one of the panels and then use some pretty cool cut and pasting techniques to line the charts up to start to form a panel chart. Once you have one of the charts set up you will see it is easy to copy and change the necessary details for each panel. There is a very cool top at 4 minutes that shows you just how easy [More]
I hope you enjoy this video – if you are inspired to create better charts then you should check out our recommended Excel Dashboard Course Excel Dashboard course that is currently open for registration again. A funnel chart is often used to show how a process generates results.  the most common use for a Funnel Chart would be to show how users convert on your website, from visitors to leads to sales. This video clearly shows how to create a funnel chart in the first 4 minutes but what I really like about this example is it shows you just how configurable [More]
This video shows you how to use the course website for the Excel Dashboard course – a number of users of this website have already signed up and are benefiting from the great teaching methods of Mynda and her team – if you need to create spreadsheets distil a lot of imformation into a single page and add some dynamic features then I recommend that you you read my full review of the course here and claim a 20% discount before the 7th November.
Protecting your worksheet and formulas is important if you are going send other users your spreadsheet to use.   Chances are they may change one of your award winning equations either on purpose or by mistake.  That makes the QA of the worksheet difficult to gauge and can be a nightmare for you to unravel later. This is a great video – the first two minutes show you some pretty cool skills on making a dummy dataset (RANDBETWEEN is a new one for me) and it is worth watching what he does here some great tips. After this the video [More]
A nested IF statement is an IF statement that sits inside of another IF statement and this video shows you how to created a nested IF statement. I have to be honest here – in this video you will learn how to use the insert Function dialogue to insert nested functions and I did not know you could do.  In fact over the 5 years I have been teaching Excel to my classes I have told them this is not possible!  Opps I had better change that! It just goes to show you that no matter how long you have been using [More]
This video shows you all the options for adding a hyperlink to your spreadsheet.  I like this video because it covers everything you may want to do with simple hyperlinks in just one video. The video starts with linking to a webpage, then shows you how to link to a different sheet or cell within the same file and then how to link to a different file or word document. Watch out for the navigation tip at around 5.40 – I never knew you could do that! If you have found this video useful please let me know using the [More]
This is a simple and short video that shows you how to turn off the automatic hyperlinking options in Excel.  This option is the one that turns a web address or email address into a clickable link.  Sometimes this is useful but it can also get very annoying if you do not want the link to appear underlined and coloured when you print the sheet out.    
This video is taken from the Excel Dashboard course run by  Mytraininghub – read my full review of this course here The video shows how you can add text labels to the title of a graph so that when the data the graph is plotting changes the title keeps in sync with the data.  It is a surprisingly simply idea and as you will see from the video it is easy to do and the presenter explains it very clearly.  
Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.