MS Excel 2013 Basic/Advanced

Course details

The Basics

• Creating a New Workbook
• Navigating in Excel
• Moving the Cell Pointer
• Using Excel Menus
• Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
• Entering Values in a Worksheet and Selecting a Cell Range
• Previewing and Printing a Worksheet
• Getting Help from the Office Assistant
• Saving a Workbook & Re-opening a saved workbook

Formatting a Worksheet

• 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

Managing your workbooks

• 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

• 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

Formulas

• Creating a basic Formula
• Calculating Value Totals with AutoSum
• Editing & Copying Formulas
• Fixing Errors in Your Formulas
• Formulas with Several Operators and Cell Ranges

Working with the Forms Menu

• Sorting, Subtotaling & Filtering Data
• Copy & Paste Filtered Records
• Using Data Validation

Creating & Working with Charts

• Creating a Chart
• Moving and Resizing a Chart
• Formatting and Editing Objects in a Chart
• Changing a Chart's Source Data
• Changing a Chart Type and Working with Pie Charts
• Adding Titles, Gridlines, and a Data Table
• Formatting a Data Series and Chart Axis
• Annotating a Chart
• Working with 3-D Charts
• Selecting and Saving a Custom Chart
• Using Fill Effects
• Mapping Data
• Modifying a Map

Data Analysis & Pivot Tables

• Creating a PivotTable
• Specifying the Data a PivotTable Analyzes
• Changing a PivotTable's Calculation
• Selecting What Appears in a PivotTable
• Grouping Dates in a PivotTable
• Updating a PivotTable
• Formatting and Charting a PivotTable

Automating Tasks with Macros

• Recording a Macro
• Playing a Macro and Assigning a Macro a Shortcut Key
• Adding a Macro to a Toolbar

Working with Other Programs

• 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