Is your salary on par with others in your field? Learn more in Skillsoft's 2024 IT Skills and Salary Report. Click Here.

Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Contact Sales

Advanced Functions of Excel Formulas: Part 1

Date:
Jan. 26, 2018
Duration:
1h 5 m

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

View Part 2 here >

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

Instructor:
Denis Laflamme

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.