Microsoft Excel Advanced (SPS32)
This course will teach you how to build advanced workbooks and worksheets. You will consolidate data, perform data analysis, and audit formulas in spreadsheets. You will also use summary functions, create pivot tables and pivot charts, and work with macros. This course includes training in either Microsoft Excel 2016, or Microsoft Excel 2019/365 software versions.
Prerequisite: Microsoft Excel or an excellent working knowledge of all the topics covered in our Microsoft Excel class.
Estimated length: 30 hrs
Access Time: 90 days
- Microsoft Excel: Students are responsible for their own software access. Software is not included in the course.
- Jasperactive: This software is included in the course. Internet access and software download are required.
- G-Metrix: This software is included in the course. Internet access and software download are required.
This course is offered using Jasperactive, a cutting-edge learning platform; and G-Metrix, a performance-based testing program; leaving you well-equipped to go on to earn your MOS Excel Expert Certification. Registration in this course provides you with course training, realistic MOS Certification Practice Exams, and one (1) final Certification exam attempt.
*We strongly encourage you to obtain your MOS certification by completing the MOS Certification Exam; however, you are not required to do so. Alternatively, you can obtain a GPRC Certificate of Course Completion by taking a final quiz and scoring 70% or above.
Our online courses allow you to invest in your career and personal interests anytime and anywhere. Courses are either stand-alone or may belong to a certificate. Please see the certificate section for more information. Access time to the course is listed above. If you require longer, you can request an extension; however, please note that doing so will incur additional fees. To request an extension, please contact the Continuing Education department at firstname.lastname@example.org, or 780-539-2975.
You may request a refund up to 5 days from the purchase date. The registration fee will only be refunded if less than 10% of the course has been completed. Completion percentage can be viewed on the Course Progress page from within the course.