Level 3 Diploma in Microsoft Excel 2016

COURSE CURRICULUM

Module: 1

• Identify the Elements of the Excel Interface
• Activity – Identify the Elements of the Excel Interface
• Create a Basic Worksheet
• Activity – Create a Basic Worksheet
• Use the Help System
• Activity – Use the Help System
• Create Formulas in a Worksheet
• Activity – Create Formulas in a Worksheet
• Insert Functions in a Worksheet
• Activity-Insert Functions in a Worksheet
• Reuse Formulas
• Activity – Reuse Formulas
• Manipulate Data
• Activity – Manipulate Data
• Insert, Manipulate, and Delete Cells, Columns, and Rows
• Activity-Insert, Manipulate, and Delete Cells, Columns, and Rows
• Search For and Replace Data
• Activity – Search For and Replace Data
• Spell Check a Worksheet
• Activity – Spell Check a Worksheet
• Modify Fonts
• Activity – Modify Fonts
• Add Borders and Colors to Cells
• Activity – Add Borders and Colors to Cells
• Apply Number Formats
• Activity – Apply Number Formats
• Align Cell Contents
• Activity – Align Cell Contents
• Apply Cell Styles
• Activity – Apply Cell Styles
• Define the Basic Page Layout for a Workbook
• Activity – Define the Basic Page Layout for a Workbook
• Refine the Page Layout and Apply Print Options
• Activity-Refine the Page Layout and Apply Print Options
• Format Worksheet Tabs
• Activity – Format Worksheet Tabs
• Manage Worksheets
• Activity-Manage Worksheets
• Manage the View of Worksheets and Workbooks
• Activity-Manage the View of Worksheets and Workbooks
• Customize General and Language Options
• Activity – Customize General and Language Options
• Customize Formula Options
• Activity – Customize Formula Options
• Customize Proofing and Save Options
• Activity – Customize Proofing and Save Options
• Customize the Ribbon and Quick Access Toolbar
• Activity – Customize the Ribbon and Quick Access Toolbar
• Customize the Functionality of Excel by Enabling Add-Ins
• Activity – Customize the Functionality of Excel by Enabling Add-Ins
• Customize Advanced and Trust Center Options
• Activity – Customize Advanced and Trust Center Options

Module: 2

• Apply Range Names
• Use Specialized Functions
• Use Text Functions
• Use Logical Functions
• Use Lookup Functions
• Use Date Functions
• Use Financial Functions
• Create and Modify Tables
• Sort and Filter Data
• Use Subtotal and Database Functions to Calculate Data
• Create Charts
• Modify and Format Charts
• Create a Trendline
• Create Advanced Charts
• Create a PivotTable
• Filter Data by Using Slicers
• Analyze Data with PivotCharts
• Insert and Modify Graphic Objects
• Layer and Group Graphic Objects
• Incorporate SmartArt
• Customize Workbooks
• Manage Themes
• Create and Use Templates
• Protect Files
• Preparing a Workbook for Multiple Audiences

Module : 3

• Update Workbook Properties
• Activity-Update Workbook Properties
• Create and Edit a Macro
• Activity-Create and Edit a Macro
• Apply Conditional Formatting
• Activity-Apply Conditional Formatting
• Add Data Validation Criteria
• Activity-Add Data Validation Criteriaty
• Trace Cells
• Activity-Trace Cells
• Troubleshoot Invalid Data and Formula Errors
• Activity-Troubleshoot Invalid Data and Formula Errors
• Watch and Evaluate Formulas
• Activity-Watch and Evaluate Formulas
• Create a Data List Outline
• Activity-Create a Data List Outline
• Create Sparklines
• Activity_Create Sparklines
• Create Scenarios
• Activity-Create Scenarios
• Perform a What-If Analysis
• Activity-Perform a What-If Analysis
• Perform a Statistical Analysis with the Analysis ToolPak
• Activity-Perform a Statistical Analysis with the Analysis ToolPak
• Create Interactive Data with Power View
• Activity-Create Interactive Data with Power View
• Consolidate Data
• Activity-Consolidate Data
• Link Cells in Different Workbooks
• Activity-Link Cells in Different Workbooks
• Merge Workbooks
• Activity-Merge Workbooks
• Export Excel Data
• Activity-Export Excel Data
• Import a Delimited Text File
• Activity- Import a Delimited Text File
• Activity-Integrate Excel Data with the Web
• Activity-Integrate Excel Data with the Web
• Create a Web Query
• Activity-Create a Web Query
• Import and Export XML Data
• Activity-Import and Export XML Data

Module: 4

• Create a Macro Using the Macro Recorder
• Edit a Macro
• Debug a Macro
• Customize the Quick Access Toolbar and Hotkeys
• Set Macro Security
• Insert Text
• Format Text
• Sort Data
• Duplicate Data
• Generate a Report
• Determine the Dialog Box Type
• Capture User Input
• Insert, Copy, and Delete Worksheets
• Rename Worksheets
• Modify the Order of Worksheets
• Print Worksheets
• Create User-Defined Functions
• Automate SUM Functions

Module: 5

• Enable and Navigate
• Import Data from Various Data Sources
• Refresh Data from a Data Source
• Create Linked Tables
• Organize and Format Tables
• Create Calculated Columns
• Sort and Filter PowerPivot Data
• Create and Manage Table Relationships
• Create PivotTables
• Create PivotCharts
• Create Power Views
• Filter Data Using Slicers
• Present PivotTable Data Visually
• Manipulate PowerPivot Data Using DAX Functions
• Extract Data from Tables Using Functions
• Save Reports in Different File Formats
• Work with Time Dependent Data
• Protect Reports