Anyone who wants to be faster at Excel ! Learn formulae, tips, and short-cuts that will dramatically improve your speed and productivity with spreadsheets and models. After this advanced Excel training course you will understand what all those commands are, that you’ve been looking at for years- but been too busy/ afraid to click on!
Are you a CEO always asking the juniors to “run the numbers”, because you don’t understand Excel? Or a PA who needs to get results to your boss much quicker? Or just someone who has never taken the time to delve further into the marvels of advanced Excel? If so, this course is for you, as it will solve some of the mysteries of Excel and boost your productivity, as we teach you how easy it is to create advanced formulae and functions in Excel. This course is not finance-specific and would thus suit people from any echelon of any industry i.e. from architects to builders to bankers, from students to PA’s to CEO’s.
Most people have only ever uncovered 10% of Excel’s potential because they are too busy, but sitting down and learning more (even if its just another 10%) will vastly increase your speed i.e. spend some time to save some time. This course will teach you how to easily navigate around the Excel window, and after just one day you will be “flying” around the keyboard via your newly-learned shortcuts (and thus minimal reliance on the mouse), and will have learnt many of Excel’s powerful (but obscure/deeply hidden) functions.
We will give you a file containing our top 100 shortcuts, tips and tricks in Excel. We will work through each of these in class, where you will complete at least one exercise for each- so after 100 exercises you will be “flying” around the keyboard and hardly using the mouse. This is important for people who have to handle large amounts of data : you will find your data quicker, and get the job done in a fraction of the time if you can learn not to use the mouse ( and less chance of RSI as well).
We cover many of the more useful and complex functions in Excel, working through an Excel file with over 50 tabs, each tab illustrating one item (some listed below), and each with at least two examples – thus over 100 examples for you to work through in class. This is your file to take-away and will be a useful reference after the course, as you can look up the (alphabetical) listing if you have problems with a particular Excel item back at the office. The internet is full of Excel help sites however this is an Excel file (not a website / doesn’t require a login / doesn’t have an expiry date) with >50 of Excel’s more advanced functions in alphabetical order.