Excel Training Agenda

• The Basics - 5 mins
• Help – F1, Google
• Creating a New Workbook
• Navigating in Excel
• Ctrl + Arrow
• Shift + Arrow
• End, Home
• Select all, Row, Column
• Previewing and Printing a Worksheet
• Saving a Workbook & Re-opening a saved workbook
• Formatting a Worksheet - 15 mins
• Creating Headers, Footers, and Page Numbers
• Adjusting Page Margins and Orientation
• Adding Print Titles and Gridlines, rows to repeat at top of each page
• Formatting Fonts & Values
• Adjusting Row Height and Column Width
• Changing Cell Alignment
• Adding Borders
• Applying Colors and Patterns
• Using the Format Painter
• Using AutoFormat
• Merging Cells, Rotating Text, and using AutoFit
• Using AutoFill
• Managing your workbooks - 15 mins
• Switching Between Sheets in a Workbook
• Inserting and Deleting Worksheets
• Renaming and Moving Worksheets
• Protecting a Workbook
• Hiding Columns, Rows and Sheets
• Splitting and Freezing a Window
• Inserting Page Breaks
• Advanced Printing Options
• Editing a Workbook - 20 mins
• Entering Date Values and using AutoComplete
• Editing, Clearing, and Replacing Cell Contents
• Cutting, Copying, and Pasting Cells
• Moving and Copying Cells with Drag and Drop
• Collecting and Pasting Multiple Items
• Using the Paste Special Command
• Inserting and Deleting Cells, Rows, and Columns
• Using Undo, Redo, and Repeat
• Checking Your Spelling
• Finding and Replacing Information
• Inserting Cell Comments
• BREAK - 5 mins
• Formulas - 20 mins
• Creating a basic Formula - Math, F4$, Cell References
• Calculating Value Totals with AutoSum
• Editing & Copying Formulas
• Fixing Errors in Your Formulas
• Formulas with Several Operators and Cell Ranges
• Vlookup
• If
• Len, left, right, find
• Working with the Forms Menu - 5 mins
• Sorting, Subtotaling & Filtering Data
• Copy & Paste Filtered Records
• Using Data Validation
• Charts
• Data Analysis & Pivot Tables - 25 mins
• Creating a PivotTable
• Modifying a Pivot Table
• Change Pivot Table Options
• Working with Other Programs - 5 mins
• Inserting an Excel Worksheet into a Word Document
• Modifying an Inserted Excel Worksheet
• Inserting a Linked Excel Chart in a Word Document
• Inserting a Graphic into a Worksheet
• Connect to external data sources
• BREAK - Q&A 5 mins
• Exercises - 1 hr
• Build a Shopping List, make it pretty
• Add calculations
• Add advanced formulas
• Create Chart
• Create Pivot Table, make it pretty
• Create Pivot Chart
• Make changes, watch how everything links