The Excel Expert Blog
Tracking Training Records in Excel
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Excel Path – Step by Step
15 |Printing made easy, Excel Adept | Quickly transpose
As always, I hope you are well. As per my earlier blog post I am going to be offering two segments here: Excel Novice 5 min tip Learn how to print your spreadsheet so that you don't spend time cutting, pasting, gluing and stapling (awww, the horror!) . This...
04 – Addition, autosum, finding a quick sum using status bar
I was looking through the blog posts I had and I noticed that I had nothing in my beginners' section for an Excel fundamental...addition/autosum and checking your sum on the status bar (a personal favourite of mine I must admit). You can view the video here. [fvplayer...
Doing the “total spend this year”, “total spend this month” shuffle using SumIFS
Recently I went in to do some training with a new manager who had been tearing his hair out with his Excel sheet. The spreadsheet had already been set up for him and the previous incumbent had done some interesting array formula variations using If and Sum - and it...
01 – Powerpivot | Introduction to Powerpivot – what is it and why would you use it?
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 your...
Data Protection | How can I let users sort but not touch?
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 Autofilter. Much...
Case Studies – How To
How to identify top three contributors and analyse frequency of posts and views
I was recently asked by a friend to help her identify who were the top three contributors in a project - based on Page Views and Participation. She also wanted to get some idea of frequency of contribution.. You can download the original (anonymised) file here. ...
Put away the calendar and use a formula
In this tutorial I am going to show you how to calculate the difference in hours/days/working days between two sets of dates. Put away our calendar/s and learn how to use these formulas instead. You can download the completed file here You can view the video here...
How to analyse Case time duration in Excel
I was recently asked by a participant in a class for some help with analysing case time duration - basically what was the average time duration from the opening of a support case to it being closed off and what time band it fell into. This required the use of the ever...
Creating a calendar in Excel –
In this video I want to show you how you would set up a calendar to use in Excel. We will be using the Text() function to extract days and months and then Conditional Formatting to show up the different types of leave. You can download the completed file here. You can...
Cleaning up emails
What happens if you get a list of names and emails from a colleague/customer but they are in a format that you can't use e.g. someone has CC'd you on the email but you need to have them in proper cleaned up format... In this video I use a file from my one of my...
Excel – General
The Power of Powerpivot | Excel’s new free plug-in to help you work with large amounts of data
Well, this week I'm going to write specifically about Powerpivot. Powerpivot is the new free add-in you can download free for Excel 2010 and later. However Powerpivot has a diva side - it's been known to flounce off in a huff and only return when you coax it with a...
Random
Learning how to learn | Help on your Excel journey
I'm currently working through a rather interesting online course called Learning How to Learn: Powerful mental tools to help you master tough subjects which is a free online course hosted at coursera.org. You can do the course for free or if you wish you can pay $40...
Comprehensive set of Excel Pivot Table tutorials | Power up your Excel skills
Well, as you know,I'm a fan of pivot tables. And now I've come across the most comprehensive, thorough pivot table package I have seen in a long time. It's developed by a guy called John Michaloudis from a website called MyExcelOnline.com. I purchased it myself to...
Sharing Excel Tips | A great free resource to help you love Excel even more
Today, I just wanted to let you know about a great free resource that I avail of. It's from Allen Wyatt (one of the Excel gurus) and he publishes a weekly free tip ezine. It's free and it's always got great tips in it. For example... This tip shows you how to make...
Backstage View – Excel 2010 | Forget where you have put your files and folders
One of my favourite features of the "New" Office was the Recent Files feature. This allows you to very quickly access files you have used recently. This has been bumped up a gear in Excel 2010 with what is called the Backstage View. You access the Backstage View by:...
Using Favourites | Making it easier to access frequently used folders and Tour de France
Well I don't know if you are like me, but I've got lots of folders and sub-folders and then sub-sub-folders and sometimes I don't remember where I put what.....so I came across a really simple easy solution to this (one of those "whack me over the head and why haven't...
Personal
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.