Registration Fee: $125.00 (USD) | Register |
|
Payment Methods Accepted: |
||
|
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.
Also Included - 4 Courses: An Essential Career Skills Pack with 4 courses in key areas for career management and growth, including Time Management, Digital Skills, Creativity and Soft Skills.
Instant Access After Purchase
Lecture by Recorded Video
Stop and Start as Needed
Certificate of Completion
Software Lab Included?: Yes
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.