Excel 2016 - Part 1
COURSE OUTLINE
1 - GETTING STARTED WITH MICROSOFT OFFICE EXCEL 2016
- Learn Your Way Around the Excel Menu
- Understand and Apply Excel Formulas
- Create and Save a Basic Workbook
- Enter Data Into Cells
- Access Excel Help
2 - PERFORMING CALCULATIONS
- Build Custom Worksheet Formulas
- Insert Built-In Functions to Your Data
- Save and Reuse Formulas
3 - MODIFYING A WORKSHEET
- Insert, Delete and Resize Cells, Columns and Rows
- Search for and Replace Data
- Use Proofing and Research Tools
4 - FORMATTING A WORKSHEET
- Format Text and Numbers
- Align Cell Data
- Apply Styles, Themes and Basic and Conditional Formatting
- Create and Select Worksheet Templates
5 - PRINTING WORKBOOKS
- Preview and Print a Workbook
- Set Up the Page Layout
- Configure Headers and Footers
6 - MANAGING WORKBOOKS
- Manage Worksheets and Workbook Properties
- Create, Apply or Delete Workbook and Worksheet Views
Excel 2016 - Part 2
COURSE OUTLINE
1 - WORKING WITH FUNCTIONS
- Define Cell Ranges and Reference Them in Formulas
- Perform Conditional Calculations
- Carry Out Logical and Specialized Functions
- Work with Date and Time Functions
- Understand and Execute Text Functions
2 - WORKING WITH LISTS
- Sort and Filter Data
- Learn the Capabilities of Database Functions
- Query Data with Database Functions
- Outline and Subtotal Data
3 - ANALYZING DATA
- Build and Modify Tables
- Create Formatting Rules
- Apply Conditional Formatting to Alter Groups of Cells
4 - VISUALIZING DATA WITH CHARTS
- Organize and Represent Data with Charts
- Modify and Format Charts
- Discover and Implement Advanced Chart Features
5 - ANALYZING DATA WITH PIVOTTABLES AND PIVOTCHARTS
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data Using Timelines and Slicers
Excel 2016 - Part 3
COURSE OUTLINE
1 - WORKING WITH MULTIPLE WORKSHEETS & WORKBOOKS
- Reference Cells and Groups of Cells Across Worksheets
- Link Cells to External Worksheets
- Consolidate Data Across Worksheets
2 - USING LOOKUP FORMULAS AND FORMULA AUDITING
- Search Rows or Columns Using LOOKUP Functions
- Display Relationships Between Cells and Formulas with the Trace Command
- Watch Cells and Formulas From the Watch Tool
3 - SHARING AND PROTECTING WORKBOOKS
- Collaborate on Workbooks
- Apply Varying Levels of Workbook Access and Protections
4 - AUTOMATING WORKBOOK FUNCTIONALITY
- Create and Manage Validation Rules and Lists
- Search for Invalid Data and Formulas with Errors
- Record Macros to Automate Tasks
5 - CREATING SPARKLINES AND MAPPING DATA
- Create Sparklines to Show Trends
- Map Data
6 - FORECASTING DATA
- Determine Potential Outcomes Using Data Tables and Scenarios
- Solve for Desired Outputs with the Goal Seek Feature
- Forecast Data Trends