This course was designed for anybody who needs to be able to confidently work with formulas in Excel. It is suitable both for complete beginners who want to start from the basics, and for those that have some experience but want to take things further.
The course is broken into different sections. It starts with building an understanding of the different elements of a formula, what the various symbols mean, some basic functions and different techniques for referencing cells.
Each section then focuses on a specific function category such as date or lookup functions. It starts to take things further by tackling mini projects and looking at more advanced formulas.
In over 80 lectures this course will teach you all the necessary skills to write advanced formulas with ease, and make those formula demons a thing of the past.
Working files are provided so that you can follow along and practice. You can also get assistance from myself with any queries you may have.
- Newbies to formulas in Excel who need to learn the formulas on their spreadsheets.
- Excel users who can write formulas but want to take their skills further and learn some advanced Excel formula techniques.
