Watch this 1-hour recorded webinar and learn how to build and troubleshoot formulas and master advanced functions. Whether you are a beginner or an experienced user looking for some extra or new tips, this is a webinar you don’t want to miss. Part 1 of this 2 part series will show you how to –
- Understand Mathematical Operators
- Use AutoFunctions
- Use Relative and Absolute References
- Explore the Function Ribbon
- Use the Insert Function Wizard & Dialog Box
- Use Basic Text, Financial, Date, & Logical Functions
- Name and Use Ranges of Cells in Formulas
- Trace and Remove Trace Arrows
- Use a Watch Window
Recommended Excel Courses
Microsoft Excel- Level 1/ Intro (2010, 2013, 2016)
Microsoft Excel - Level 2 / Med (2010, 2013, 2016)
Microsoft Excel 2010 - Level 3 / Advanced
Microsoft Excel 2013 - Level 3 / Advanced
Microsoft Excel 2016 - Level 3 / Advanced
Power BI Fundamentals for End Users-2016
Denis has been a Microsoft Certified Trainer for over 10 years teaching Office courses such as Word, Excel, PowerPoint, Access, Outlook and OneNote as well as Visual Basic programming.
He rounds out his application training skills with experience in team building, conflict resolution, time management and proposal and report writing.