Notice: Undefined offset: 1 in /home3/howtoome/public_html/wp-content/themes/DT/framework/class/class_core.php on line 4346

Notice: Undefined offset: 1 in /home3/howtoome/public_html/wp-content/themes/DT/framework/class/class_core.php on line 4348

Notice: Trying to get property of non-object in /home3/howtoome/public_html/wp-content/themes/DT/framework/class/class_core.php on line 4248
MOS Excel 2016 Course (Desktop/Office 365) - UK Training Course Directory UK Training Course Directory

Notice: Trying to get property of non-object in /home3/howtoome/public_html/wp-content/themes/DT/framework/class/class_shortcodes.php on line 1805

Notice: Trying to get property of non-object in /home3/howtoome/public_html/wp-content/themes/DT/framework/class/class_shortcodes.php on line 1830

Notice: Undefined index: class in /home3/howtoome/public_html/wp-content/themes/DT/framework/class/class_media.php on line 585

Notice: Trying to get property of non-object in /home3/howtoome/public_html/wp-content/themes/DT/framework/class/class_shortcodes.php on line 2736

Distance Learning Centre Swaledale 4 Coaley Lane Newbottle Houghton le Spring Tyne & Wear DH4 4SQ United Kingdom 0845 129 7238
Visit Website Add Favorites .
Distance Learning Centre.png


The MOS Excel 2016 Course (Desktop / Office 365) is designed to give students an essential understanding of the Microsoft Excel software environment and aims to give students the ability to complete tasks independently in preparation for their Microsoft Office Specialist exam. You will how to demonstrate the correct application of the principal features of Excel 2016, how to create and edit a workbook with multiple sheets, and how to use a graphic element to represent data visually.

Designated as approved course materials for the Microsoft Office Specialist program, this course will help students prepare for the MOS Core Excel 2016 exam (77-727: Core Data Analysis, Manipulation, and Presentation) and can also be used as a learning resource for the MOS Expert Excel exam (77-728: Interpreting Data for Insights).

The course consists of the following items:

MOS Microsoft Excel 2016 – Part 1 Book (Desktop / Office 365):

This course book is intended to cover the standard functions of Microsoft Office Excel 2016 that are necessary to create and work with spreadsheets.

  • Lesson 1: Getting Started with Microsoft Office Excel 2016
  • Lesson 2: Performing Calculations
  • Lesson 3: Modifying a Worksheet
  • Lesson 4: Formatting a Worksheet
  • Lesson 5: Printing Workbooks
  • Lesson 6: Managing Workbooks

On successful completion of this course book, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse important data.

Objectives:

  1. Get started with Microsoft Office Excel 2016.
  2. Perform calculations.
  3. Modify a worksheet.
  4. Format a worksheet.
  5. Print workbooks.
  6. Manage workbooks.

MOS Microsoft Excel 2016 – Part 2 Book:

This course book builds on the foundational knowledge and skills and covers some of the higher-level functionality in Excel which is designed to analyse and present data.

  • Lesson 1: Working with Functions
  • Lesson 2: Working with Lists
  • Lesson 3: Analysing Data
  • Lesson 4: Visualising Data with Charts
  • Lesson 5: Using PivotTables and PivotCharts

Upon successful completion of this course book, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

Objectives:

  1. Work with functions.
  2. Work with lists.
  3. Analyze data.
  4. Visualize data with charts.
  5. Use PivotTables and PivotCharts.

MOS Microsoft Excel 2016 – Part 3 Book:

This course book covers some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

  • Lesson 1: Working with Multiple Worksheets and Workbooks
  • Lesson 2: Using Lookup Functions and Formula Auditing
  • Lesson 3: Sharing and Protecting Workbooks
  • Lesson 4: Automating Workbook Functionality
  • Lesson 5: Creating Sparklines and Mapping Data
  • Lesson 6: Forecasting Data

Objectives:

On successful completion of this course book, students will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

  1. Work with multiple worksheets and workbooks.
  2. Use Lookup functions and formula auditing
  3. Share and protect workbooks.
  4. Automate workbook functionality.
  5. Create sparklines and map data.
  6. Forecast data.

Student Exercise Files:

Once enrolled students will receive a support email giving them access to their student files and to PowerPoint presentations relevant to the content of each unit. These files are also available through a student page and can be sent on disk on request.

GMetrix Exam Preparation Software:

The course also comes with GMetrix exam preparation software. The GMetrix Skills Management System provides everything you need to prepare for the Microsoft Office Specialist (MOS) Certification.

Overview of Test features:

  1. Practice tests map to the Microsoft Office Specialist (MOS) exam objectives.
  2. All tests are in-application or performance-based simulations to provide the best assessment of the real-world experience.
  3. All tests have both a testing and a training mode providing step-by-step help on each question.
  4. Progress at own pace, save test to resume later, return to skipped questions.
  5. Detailed, printable score report highlighting areas requiring further review.

Please Note: You will need a version of Microsoft Office 2016 to be able to use the GMetrix software package.

To find out more about Mos Excel 2016 Course (Desktop/office 365) visit course provider website.


Course Provider Distance Learning Centre
Course Fee £175.00
Course Delivery Course Books with Student Files & Online Practice Exams
Course Duration 100 Hours (Self-Study)
Website Link Training Providers Website
Phone Number 0845 129 7238
Country United Kingdom
State/Province England
distance: 551 Miles
Address Distance Learning Centre Swaledale 4 Coaley Lane Newbottle Houghton le Spring Tyne & Wear DH4 4SQ United Kingdom
Category
Keywords  
No Feedback Received