Length: 3 courses
Access Length: 6 months
Price: $250/person (USD)
Bulk Pricing: 10+ Contact Us
Instant Access After Purchase
Lecture by Recorded Video
Stop and Start as Needed
Certificate of Completion
Software Lab Included?: Yes
Individuals and Groups
@ Your Location
This eLearning bundle includes three Microsoft Excel 2019 courses: Excel 2019: Beginner, Excel 2019: Intermediate and Excel 2019: Advanced.
This course is a self-paced learning solution to fit your own schedule. Certstaffix Training eLearning courses you take on your own schedule in a web browser.
Have more than 10 students needing this course? Contact Us for bulk pricing.
Versions That Can Attend: Desktop Versions of Microsoft Windows PC or Macintosh
Course Taught With: Desktop Version of Microsoft Windows Software
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.
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.
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.