eLearning Bundle - Excel 2019 Online Course | Certstaffix® Training


eLearning Bundle - Excel 2019 Online Course

Microsoft Excel TrainingeLearning Bundle - Excel 2019

by Certstaffix® Training

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


This eLearning bundle includes three Microsoft Excel 2019 courses:

Excel 2019: Beginner
Excel 2019: Intermediate
Excel 2019: Advanced



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 software needed 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: Beginner - 5 hrs 30 min

This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.

Excel 2019: Intermediate - 4 hrs 40 min

In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features.

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