This course will enable you to get to grips with Excel formulas, allowing you to perform calculations within Excel quickly and easily.
You will learn how to:
The course includes :
This course is presented by Jane Hames, lead IT trainer at Glide Training. Jane has over twenty years' experience in delivering Excel training to users of all levels and from a variety of backgrounds.
Here you'll find an overview of the course, the areas we'll be covering, and what you can expect to be able to achieve at the end of the course. NOTE: Download the Formulas Reference Sheet and keep it with you throughout the course. It will then become a valuable reference guide for after you have completed this course.
A couple of quick questions to ease you in gently!
Make sure you're on top of the basics before moving forwards with this course!
You might want to look at the workbook attached to Lecture 3 in order to get some hands-on experience before taking this quiz. Or if you're confident, jump straight in!
There are large numbers of named functions accessible from within Excel.
We couldn't possibly cover all of them in a course such as this, but here is a quick test on the common functions that we looked at in the previous lecture.
Combining text and numbers within formulas can be very useful, especially when using Excel for doing things such as generating reports. Make sure you're able to do this properly!
Put your understanding of calculation order and brackets to the test!
We'll start with a question on the theory, then move on to some practical examples which will become more difficult as they go on.
This quiz is a bit shorter as it applies only to the extra things you need to bear in mind when using multiple sets of brackets
Some exercises to test your understanding of the difference between absolute and relative cell references.
Test yourself on using partial absolute cell references to fix columns or rows
Sometimes you might need to refer to cells on other worksheets, not just the one that's open in front of you.
There may be times that the cells you need to refer to in your formulas are in different workbook files altogether.
Coming from a creative background, I explain software use in a “non-techy” way. I very much focus on the big picture benefits of software use in order to save you time and get more value from the software.
I have been a trainer since 1998 working mainly in the UK and occasionally in Europe. During that time, I have worked with clients from a wide range of industries including, finance, legal, creative, engineering, charities, schools, colleges, government, healthcare, police and more.
I spend several days a week delivering face to face live training and regularly get feedback about how easy I am to learn from and how the training is actually really engaging and enjoyable! My courses are short because I appreciate that not everyone wants to learn everything that the software has to offer. You can pick what's most important to you at the time and select an appropriate course.
Of course, there are lots of people who love Microsoft Office but there are many others who just want to make it work for them and make life easier for themselves. My aim in all of my training is help you to work more quickly, efficiently and with less frustration.
Thanks for stopping by and enjoy your training!
I am one of the Directors at Glide Training, responsible for our online presence and for all the online technology that our company makes use of.
I have over fifteen years' experience in training people how to make best use of software, business systems, online and offline marketing in order to achieve success in the workplace.