Course Description
Going beyond Formula and Function Essentials, this course builds an clear understanding of absolute and relative referencing in formulas and functions.
Practical examples are demonstrated from the logical, statistical and text function categories in Excel.
To work efficiently with formulas and functions you must build on good habits and application of correct structure and syntax.
Promote and complete this informative and value-packed 60 minute course with your team to boost efficiency and maximise your ‘return on investment’ in MS Office.
Course Highlights
- Automatic Series and Custom Lists
- Absolute and relative references
- Count Functions
- If Function Basics
- If Function Nested
- Insert Function Wizard
- Upper, lower and Proper Functions
Requirements
- Access to a computer with an internet connection.
- Microsoft Excel 2010, 2013 or 2016