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

Case Studies – How To

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

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...

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.