Excel 2016: Core Data Analysis, Manipulation, and Presentation Training & Certification Course
Overview
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.
Prerequisite
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
- Identifying the different Excel 2016 programs
- 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
- Entering and revising data
- Managing data by using Flash Fill
- Moving data within a workbook
- Finding and replacing data
- Correcting and expanding upon worksheet data
- Defining Excel tables
- Key points
Performing calculations on data
- Naming groups of data
- Creating formulas to calculate values
- Summarizing data that meet specific conditions
- Working with iterative calculation options and automatic workbook calculation
- Using array formulas
- Finding and correcting errors in calculations
- Key points
Changing workbook appearance
- Formatting cells
- Defining styles
- Applying workbook themes and Excel table styles
- Making numbers easier to read
- Changing the appearance of data based on its value
- Adding images to worksheets
- Key points
Focusing on specific data by using filters
- Limiting data that appears on your screen
- Filtering Excel table data by using slicers
- 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
- Sorting worksheet data
- Sorting data by using custom lists
- Organizing data into levels
- Looking up information in a worksheet
- Key points
Combining data from multiple sources
- Using workbooks as templates for other workbooks
- Linking to data in other worksheets and workbooks
- Consolidating multiple sets of data into a single workbook
- Key points
Analyzing data and alternative data set
- Examining data by using the Quick Analysis Lens
- Defining an alternative data set
- Defining multiple alternative data sets
- Analyzing data by using data tables
- Varying your data to get a specific result by using Goal Seek
- Finding optimal solutions by using Solver
- Analyzing data by using descriptive statistics
- Key points
Creating charts and graphics
- Creating charts
- Customizing the appearance of charts
- Finding trends in your data
- Creating dual-axis charts
- Summarizing your data by using sparklines
- Creating diagrams by using SmartArt
- Creating shapes and mathematical equations
- Key points
Using PivotTables and PivotCharts
- Analyzing data dynamically by using PivotTables
- Filtering, showing and hiding PivotTable data
- Editing PivotTables
- Formatting PivotTables
- Creating PivotTables from external data
- Creating dynamic charts by using PivotCharts
- Key points
Printing worksheets and charts
- Adding headers and footers to printed pages
- 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
- Linking to Office documents from workbooks
- Embedding workbooks into other Office documents
- Creating hyperlinks
- Pasting charts into other Office documents
- 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 |