Excel 2013 Essential Training

Introduction

• Welcome
• Using the exercise files

1. Getting Started with Excel 2013

• What is Excel used for?
• Using the menu system
• The Quick Access Toolbar
• The structure of a worksheet or workbook
• Using the Formula bar
• Using the Status bar
• Navigation and mouse pointers
• Shortcut menus and the Mini toolbar
• Using the built-in help
• Creating new files

2. Entering Data

• Exploring data entry and editing techniques
• Entering data with AutoFill
• Working with dates and times
• Using Undo and Redo
• Adding comments
• Using Save or Save As

3. Creating Formulas and Functions

• Creating simple formulas: Totals and averages
• Copying a formula for adjacent cells
• Calculating year-to-date profits
• Creating a percentage-increase formula
• Working with relative, absolute, and mixed references
• Using SUM and AVERAGE
• Using other common functions

4. Formatting

• Exploring font styles and effects
• Adjusting row heights and column widths
• Working with alignment and Wrap Text
• Designing borders
• Exploring numeric and special formatting
• Formatting numbers and dates
• Conditional formatting
• Creating and using tables
• Inserting shapes, arrows, and other visual features

5. Adjusting Worksheet Layout and Data

• Inserting and deleting rows and columns
• Hiding and unhiding rows and columns
• Moving, copying, and inserting data
• Finding and replacing data

6. Printing

• Exploring the Page Layout tab and view
• Previewing page breaks
• Working with Page Setup and printing controls

7. Introduction to Charting

• Creating charts
• Exploring chart types
• Formatting charts
• Working with axes, labels, gridlines, and other chart elements
• Creating in-cell charts with sparklines

8. Adjusting Worksheet Views

• Freezing and unfreezing panes
• Splitting screens horizontally and vertically
• Showing necessary information with the Outlining feature

9. Multiple Worksheets and Workbooks

• Displaying multiple worksheets and workbooks
• Renaming, inserting, and deleting sheets
• Moving, copying, and grouping sheets
• Using formulas to link worksheets and workbooks
• Locating and maintaining links

10. IF, VLOOKUP, and Power Functions

• Using IF functions and relational operators
• Getting approximate table data with the VLOOKUP function
• Getting exact table data with the VLOOKUP function
• Using the COUNTIF family of functions

11. Security and Sharing

• Unlocking cells and protecting worksheets
• Protecting workbooks
• Assigning passwords to workbooks
• Sharing workbooks
• Tracking changes

12. Database Features

• Sorting data
• Inserting subtotals in a sorted list
• Using filters
• Splitting data into multiple columns
• Removing duplicate records

13. PivotTables

• Creating PivotTables
• Manipulating PivotTable data
• Grouping by date and time
• Grouping by other factors
• Using slicers to clarify and manipulate fields
• Using PivotCharts

14. Data Analysis Tools

• Using Goal Seek
• Using Solver
• Using Scenario Manager
• Using Data Tables

15. Introduction to Macros

• Definition and examples
• Creating a simple macro
• Running a macro

Conclusion

• Next steps