by admin | Sep 3, 2014 | Excel Path - Step by Step
Powerpivot is a new free add-in that first appeared in Excel 2010. As a trainer I’m incredibly excited about the possibilities this offers Excel users to streamline their work and to do a lot more with their data. Imagine just updating your data connection and...
by admin | Aug 11, 2014 | Excel Path - Step by Step
Not so long ago I was asked by a user for help with her file. She wanted people to be able to sort and filter but not do ANYTHING else with it. Of course I went to try my usual things of setting up protection Review – Protect Sheet – tick Sort, tick...
by admin | Apr 28, 2014 | Excel Path - Step by Step
Quickly get the name of the day from a date So you have a list of dates but for analysis purposes you need to be able to show the days of the week as another column. Of course you could spend many happy hours locating a calendar on Google and manually extracting them...
by admin | Sep 26, 2013 | Excel Path - Step by Step
I recently got asked an interesting question via my YouTube channel from someone who wanted to set up a rota using Excel. However he wanted the rota to be coloured according to start time and end time so he could easily see how many people were on duty. So I decided...
by admin | Sep 3, 2013 | Excel Path - Step by Step
In a previous post, I covered some of the basics of using hyperlinks to link to other documents but today I’m going to show you how to link to specific cells (or if you are feeling a bit adventurous :-)) to some named ranges. Also note that you can hyperlink to...
by admin | Jul 3, 2013 | Excel Path - Step by Step
Tables in Excel One of my new favourite features in the “new” Excel is Tables. When you convert your list to a table you quickly do the following: Apply slick formatting Apply filters Enter a formula once and see it whiz down the rest of the...
