Excel

Excel

EX00 – All Modules (1 - 4)                                                                               $296

EX01 – Module 1 Excel                                                                                   $138

• Starting Excel, closing a workbook and exiting Excel
• Giving commands in Excel
• Entering labels and values into a workbook
• Navigating, naming and saving a workbook
• Previewing and printing a workbook

Editing a Worksheet

• Enter and work with date values
• Edit, clear, and replace cell contents, cut, copy, paste, and move cells
• Work with and understand Absolute and Relative cell references
• Insert and delete cells, rows and columns
• Use Undo and Redo
• Use advanced print options
• Basic file management
• Insert cell comments

Formatting a Worksheet

• Format fonts with the Formatting toolbar and menus
• Format values
• Adjust row height and column width
• Align a cell’s contents, add borders, colours, and patterns to cells
• Use the format painter to copy formatting
• Create a custom number format, create, apply, and modify a style
• Use conditional formatting
• Merge cells

Creating and Working with Charts

• Create, move and resize a chart
• Format objects in a chart
• Change a chart’s source data
• Change a chart type
• Add titles, gridlines, annotations, and a data table to a chart
• Work with a 3-D chart
• Create and work with a custom chart
• Plot data on a map

Managing your Workbooks

• Navigate between the sheets in a workbook
• Insert, delete, rename, and move worksheets
• Work with several worksheets and workbooks
• Split and freeze a window
• Add headers, footers, and page numbers to a worksheet
• Specify what gets printed and where the page breaks
• Adjust the margins, page size and orientation, and print scale
• Protect and hide a worksheet
• Create and use a template
• Consolidate multiple worksheets

Working with Lists

• Create and sort a list
• Add, find, edit, and delete records
• Use the Autofilter to filter a list
• Create a custom Autofilter
• Create and use an advanced filter
• Use data validation when entering records to a list

EX02 – Module 2 Excel                                                                                     $75

More Functions and Formulas

• Create a formula with several operators and cell ranges
• Use the Insert function feature to enter and edit formulas
• Create and use range names
• Select nonadjacent cell ranges
• Use the Autocalculate feature
• Create a conditional formula with the IF function
• Use the PMT function
• Display and print formulas in a worksheet
• Identify and fix formula errors

Automating Tasks with Macros

• Record and play a macro
• Assign a shortcut key and toolbar button to the macro
• Edit a macro’s Visual Basic code
• Insert code into an existing macro
• Declare variables using a DIM statement
• Prompt for user input
• Use IF…THEN statements

EX03 – Module 3 Excel                                                                                     $66

Working with Other Programs and the Internet

• Insert an Excel worksheet into a Word document
• Modify and embedded worksheet
• Link an Excel chart into a Word document
• Insert a graphic into a worksheet
• Open and save files in different formats
• Add hyperlinks to a worksheet
• Browse hyperlinks using the web toolbar
• Save a workbook as a non-interactive web page
• Save a workbook as an interactive web page
• Retrieve information from a web page

EX04 – Module 4 Excel                                                                                     $86

Data Analysis and Pivot Tables

• Create a PivotTable
• Change or “Pivot” a PivotTable
• Use the Page Field to filter what data is displayed in a PivotTable
• How to group information in a PivotTable by date
• Create and work with subtotals
• Use Database functions (DSUM)
• Use Lookup functions (VLOOKUP)
• Group and outline a worksheet

What-If Analysis

• Create a scenario
• Create a Scenario Summary Report
• Create one and two-input data tables
• Use Goal Seek
• Set up complex what-if analysis with Solver

Advanced Topics

• Add, remove and position toolbars
• Create a custom toolbar
• Create a custom Autofill list
• Password protect a workbook
• Change Excel’s default options
• Find a file, view and change its properties
• Share a workbook for group collaboration
• Revise a shared workbook