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 2

Date:
Feb. 12, 2018
Duration:
1h 7m

Watch the second installment of this 2-part webinar series and learn how to build and troubleshoot even more formulas and 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 2 part will show you how to –

  • Array Formulas
  • Subtotal Formulas
  • More date and time functions
  • Concatenate vs. Flash Fill
  • Index and Match vs. VLookup
  • Variations of the Round Function

View Part 1 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.