by admin | Sep 18, 2012 | Excel Path - Step by Step
A useful skill to have – particularly if you need to do analysis on a list (in pivot tables etc) as you want to ensure that your data entry is kept consistent. It’s also a real time saver it you need someone else to input data for you and you want to...
by admin | Aug 20, 2012 | Excel Path - Step by Step
In this video, I am going to show you how to use conditional formatting to highlight an entire row based on a single criteria (rather than just highlighting the single cell). In another post, I am going to show you how to use the And function with conditional...
by admin | Aug 2, 2012 | Excel Path - Step by Step
One of the most powerful tools in Excel is the if statement. An if statement has the following structure: test a question, if the answer is “Yes”, do one thing. If it’s “No”, do something else. For example, a use of it would be in exam...
by admin | Jul 18, 2012 | Excel Path - Step by Step
As a link to my other tutorial on printing , I am going to show you how to do the following in this tutorial: Set a print area Clear a print area Hide columns/rows if you only want to print specific parts of the spreadsheet, that may not be side by side… As...
by admin | Jul 8, 2012 | Excel Path - Step by Step
In this tutorial, we are going to look at how to link Excel workbooks. For example if you are tracking the same information from three shops – you will probably keep the information on each shop on a separate worksheet but then want to add up the information...
by admin | Jul 8, 2012 | Excel Path - Step by Step
In this tutorial we are going to look at the basics of how to print in Excel. [flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/print_introduction.m4v’] As always here is the file for you to download and practise with. I hope you...
