In order to get a proper understanding of all of Excel’s capabilities it is critical that you understand the fundamental tools and concepts. These Excel tools and concepts are so important that we always start our live courses with this section, whether it is a beginner, advanced or modelling course. It is surprising how many ‘experts’ do not know about some of these.
This course will cover the following key areas:
- Understanding and using the function wizard
- Using the Formula Auditing tool
- Understanding absolute (e.g. $A$1) and relative referencing (the most important concept you will ever learn)
- Using the IF function
If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar