Excel 2019: Advanced Online Course | Certstaffix® Training


Excel 2019: Advanced Online Course

Microsoft Excel TrainingExcel 2019: Advanced

by Certstaffix® Training

Length: 1 Course(s)      Price: $175/person (US Dollars)      Bulk Pricing: 6+ Contact Us      Access Length: 6 Months      Category: Microsoft Excel


This course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.

Office Versions That Can Attend: Microsoft Office 2019, 365 and 2016 (Microsoft Windows PC)
Courses Taught With: Office version 2016 (Microsoft Windows PC) Software and Courseware
Not Appropriate For: Macintosh versions of Microsoft Office
Purchase This Course ➥
Course Description: Print It | Download PDF | Email It

  Online Microsoft Excel Classes: Learn at Your Own Pace

We will enroll you into a demo (Windows 10) eLearning session. Login information will be emailed to you.

Prefer a self-paced learning solution to fit your own schedule? Certstaffix® Training offers eLearning courses bundled together:

  • Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screen shots
  • 6 month subscription length
  • Any needed software for training is provided in an online lab environment.
    •

  Detailed Training Topics

Course Description: Print It | Download PDF | Email It
Microsoft Excel Training

Excel 2019: Advanced - 3 hrs 56 min

This course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.
Course Description: Print It | Download PDF | Email It