Microsoft Excel 2016 Essential Training

Introduction

• Welcome
• Using the exercise files

Getting started with Excel

1. What is Excel used for
2. Using the menu system
3. Using the Quick Access Toolbar
4. Understanding workbooks and worksheets
5. Using the formula bar
6. Using the status bar
7. Using navigation bar
8. Using shortcut menus and the Mini toolbar
9. Creating new workbooks
10. Using Excel help

Entering Data

1. Exploring data entry and editing techniques
2. Entering data with AutoFill
3. Working with dates and times
4. Using Undo and Redo
5. Adding comments
6. Using Save or Save As

Formatting

1. Exploring font styles and effects
2. Adjusting row heights and column width
3. Working with alignment and wrap text
4. Designing borders
5. Exploring numeric and special formatting
6. Formatting numbers and dates
7. Using conditional formatting
8. Creating and using tables
9. Inserting shapes, arrows, and other visual features

Adjusting Worksheet Layout and Data

1. Inserting and deleting rows and columns
2. Hiding and unhiding rows and columns
3. Moving, copying and inserting data

Printing

1. Finding and replacing data
2. Exploring the page layout tab and page layout view
3. Previewing page breaks
4. Working with page setup and printing controls

Charts

1. Creating charts
2. Exploring chart types
3. Formatting charts
4. Working with axes, titles, and other chart elements
5. Creating incell charts with sparklines

Adjusting Worksheets views

1. Freezing and unfreezing panes
2. Splitting screens horizontally and vertically
3. Collapsing and expanding data views with outlining

Multiple Worksheets and Workbooks

1. Displaying multiple worksheets and workbooks
2. Renaming, inserting, and deleting sheets
3. Moving, copying, and grouping sheets
4. Using formulas to link worksheets and workbooks
5. Locating and maintaining links

IF VLOOKUP and Power Functions

1. Using IF functions and relational operators
2. Getting approximate table data with the VLOOKUP function
3. Getting exact table data with the VLOOKUP function
4. Using the COUNTIF family of functions

Security and Sharing

1. Unlocking cells and protecting worksheets
2. Protecting workbooks
3. Assigning passwords to workbooks
4. Sharing workbooks
5. Tracking changes

Data Management Features

1. Sorting data
2. Inserting subtotals in a sorted list
3. Using filters
4. Splitting data into multiple columns
5. Splitting and combining columnar data with Flash Fill
6. Removing duplicate records
7. Using validation tools

Data Analysis Tools

1. Using Goal Seek
2. Using Solver
3. Using Scenario Manager
4. Using data tables

PivotTables

1. Creating PivotTables
2. Manipulating PivotTable data
3. Grouping by date and time
4. Grouping by other factors
5. Using slicers to clarify and manipulate fields
6. Using PivotCharts

Introduction to Macros

1. Exploring the need for macros
2. Creating a simple macro
3. Running a macro

 

Conclusion

• Goodbye