Home / All Courses / Microsoft / Microsoft Office / Excel 2016: Core Data Analysis, Manipulation, and Presentation

Excel 2016: Core Data Analysis, Manipulation, and Presentation Training & Certification Course


Successful candidates for the Microsoft Office Specialist Excel 2016 certification exam have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They know and demonstrate the correct application of the principal features of Excel 2016. Candidates create and edit a workbook with multiple sheets, and they use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

Microsoft Office Specialist (MOS) 2016 certification exams introduce a new performance-based format for improved testing of a candidate’s knowledge, skills, and abilities using the MOS 2016 programs:

  • MOS 2016 exam task instructions generally do not include the command name, as in previous versions. For example, function names are avoided and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects.
  • The MOS 2016 exam format incorporates multiple projects.



Familiarity with the exam objectives listed below and skills and competencies being measured in the associated certification exam.

Full Description

 Getting started with Excel 2016


  1. Identifying the different Excel 2016 programs
  2. Identifying new features of Excel 2016
  • If you are upgrading from Excel 2010
  • If you are upgrading from Excel 2007
  • If you are upgrading from Excel 2003
  • Working with the ribbon

     3.Customizing the Excel 2016 program window

  • Zooming in on a worksheet
  • Arranging multiple workbook windows
  • Adding buttons to the Quick Access Toolbar
  • Customizing the ribbon
  • Maximizing usable space in the program window

     4. Creating workbooks

     5. Modifying workbooks

     6. Modifying worksheets

  • Inserting rows, columns, and cells

     7. Merging and unmerging cells

     8. Key points

Working with data and Excel tables

  1. Entering and revising data
  2. Managing data by using Flash Fill
  3. Moving data within a workbook
  4. Finding and replacing data
  5. Correcting and expanding upon worksheet data
  6. Defining Excel tables
  7. Key points

Performing calculations on data

  1. Naming groups of data
  2. Creating formulas to calculate values
  3. Summarizing data that meet specific conditions
  4. Working with iterative calculation options and automatic workbook calculation
  5. Using array formulas
  6. Finding and correcting errors in calculations
  7. Key points

Changing workbook appearance

  1. Formatting cells
  2. Defining styles
  3. Applying workbook themes and Excel table styles
  4. Making numbers easier to read
  5. Changing the appearance of data based on its value
  6. Adding images to worksheets
  7. Key points

Focusing on specific data by using filters

  1. Limiting data that appears on your screen
  2. Filtering Excel table data by using slicers
  3. Manipulating worksheet data
  • Selecting list rows at random
  • Summarizing worksheets by using hidden and filtered rows
  • Finding unique values within a data set

      4. Defining valid sets of values for ranges of cells

      5. Key points

Reordering and summarizing data

  1. Sorting worksheet data
  2. Sorting data by using custom lists
  3. Organizing data into levels
  4. Looking up information in a worksheet
  5. Key points

Combining data from multiple sources

  1. Using workbooks as templates for other workbooks
  2. Linking to data in other worksheets and workbooks
  3. Consolidating multiple sets of data into a single workbook
  4. Key points

Analyzing data and alternative data set

  1. Examining data by using the Quick Analysis Lens
  2. Defining an alternative data set
  3. Defining multiple alternative data sets
  4. Analyzing data by using data tables
  5. Varying your data to get a specific result by using Goal Seek
  6. Finding optimal solutions by using Solver
  7. Analyzing data by using descriptive statistics
  8. Key points

Creating charts and graphics

  1. Creating charts
  2. Customizing the appearance of charts
  3. Finding trends in your data
  4. Creating dual-axis charts
  5. Summarizing your data by using sparklines
  6. Creating diagrams by using SmartArt
  7. Creating shapes and mathematical equations
  8. Key points

Using PivotTables and PivotCharts

  1. Analyzing data dynamically by using PivotTables
  2. Filtering, showing and hiding PivotTable data
  3. Editing PivotTables
  4. Formatting PivotTables
  5. Creating PivotTables from external data
  6. Creating dynamic charts by using PivotCharts
  7. Key points

Printing worksheets and charts

  1. Adding headers and footers to printed pages
  2. Preparing worksheets for printing
  • Previewing worksheets before printing
  • Changing page breaks in a worksheet
  • Changing the page printing order for worksheets

      3. Printing worksheets

      4. Printing parts of worksheets

      5. Printing charts

      6. Key points

Working with other Office programs

  1. Linking to Office documents from workbooks
  2. Embedding workbooks into other Office documents
  3. Creating hyperlinks
  4. Pasting charts into other Office documents
  5. Key points

Fees & Schedule

Delivery Mode Course Duration Fees
Live Virtual Training 2 Days Ask for Quote
Onsite Classroom Training 2 Days Ask for Quote
Customized Training 2 Days Ask for Quote


SpireTec solutions is the latest technology enabled I.Tmanagement training company specialized in offering 1500+ courses with the state of art training facilities backed by a team of industry experts in various domains with assuring best quality services.
Since SpireTec provides 24X7 training and support for your training needs is very adaptable to your time availabilities and offers customized training programs according to your availability and time zones of your contingent.
Because SpireTec aims for the personal & professional growth of you as individual & corporate as a whole, providing training on the latest and updated versions in the designated domains.
It is preferable but not mandatory to have domain experience in the area of your interest in which you want to opt training, supported by good English communication skills, a good Wi-Fi and computer or laptop system in case you want remote training
Spire Tec aims and ensure to offer finest and world-class training to the participants by giving them a proper counselling and a guided career path by our industry experts which leads guaranteed success for you in the corporate world
We offer online training (1-1, Group training), Classroom training, Onsite training with state of art facilities.
You can make payment online via PayPal with any of the debit & credit cards or via direct bank transfer.