Skip to main content

Microsoft Office Specialist (MOS): Microsoft Excel

This course will teach students about working with multiple worksheets and workbooks, sharing and protecting workbooks, automating workbook functionality, using Lookup functions and formula auditing, forecasting data, creating spark lines and mapping data, importing and exporting data, internationalizing workbooks, working with Power Pivot, advanced customization options, and working with forms and controls.


ARMY IGNITED CRITERIA

TRAINING NAME:


  • Microsoft Office Excel 2019: Part 3
         

FORMAT:

  • Online, On Demand

ASSOCIATED CREDENTIAL:


  • Microsoft Office Specialist (MOS): Microsoft Excel
  •  
  LOCATION &
SCHEDULES:

  • Virtual - Can be taken from any location, any time according to your schedule.
COST:
  • Contact Learn@AristaLearn.com for $
                TESTING VOUCHER or CERTIFICATE OF COMPLETION?
  • Certificate of completion
TARGET STUDENT:
  • This course is best suited for students looking to further their experience with Microsoft Office or Microsoft Excel. 
  PREREQUISITES:


  • There are no prerequisites for this course.


COURSE MATERIALS INCLUDE:
  • Access to eLearning portal with digital material, videos, quizzes, case studies, and everything you need to successfully learn the material.

                

HOW TO ENROLL:
  • Email Learn@AristaLearn for a Quote and Detailed Course PDF


SYLLABUS TOPICS


                        01 - Working with Multiple Worksheets and Workbooks                      07 - Importing and Exporting Data
02 - Sharing and Protecting Workbooks 08 - Internationalizing Workbooks
03 - Automating Workbook Functionality 09 - Working with Power Pivot
04 - Using Lookup Functions and Formula Auditing 10 - Advanced Customization Options

05 Forecasting Data
11 - Working with Forms and Controls

06 - Creating Sparklines and Mapping Data