Microsoft Excel - Launch Computer Training & Consulting

Home
	Full Day Series:	q Introduction	q Intermediate	q Advanced	q VBA (Visual Basic for Applications)
	3 Hour Series:	q Getting Started with Excel
		q Useful Features in Microsoft Excel
		q Getting Started with Excel Formulas & Functions
		q Advanced Functions
		q Charting, Linking, Embedding & Working with Multiple Sheets
		q Working with Microsoft Excel Databases
		q Creating Forms and Recording Macros

Microsoft Excel
Title	Introduction to Excel
Length	One Day

Becoming Familiar With The Working Environment How Big Is The Spreadsheet? Navigating around the Spreadsheet Pointers Entering Text Deleting Editing Backspace Vs. Delete Modifying Alignment Moving Copying Undo Using Autofill Adding Numbers Formatting Spreadsheets Changing Column Widths Print Preview Page Setup Sum, Max, Min, Average, and Count Functions Saving Absolute References Databases Sorting Filtering Graphing RETURN TO TOP

Microsoft Excel
Title	Intermediate Excel
Length	One Day

Review of the Basics Auditing Absolute Cell Referencing Splitting Windows Freezing Panes Naming Styles Naming Ranges Auditing a Worksheet Using Paste Special Linking (Dynamic Data Exchange) Object Linking and Embedding Working with Multiple Spreadsheets Sorting Databases Subtotaling Filtering Databases Date Math Protecting Worksheets Creating Templates Graphing RETURN TO TOP

Microsoft Excel
Title	Advanced Excel
Length	One Day

Toolbars Templates Autofill Creating Custom Lists Payment Function Function Wizard IF Function Nested IF Statements H And Vlookups Forms And Controls Outlining Auditing Scenerios Macros Assigning A Macro To A Toolbar Button RETURN TO TOP

Microsoft Excel
Title	Visual Basic for Applications
Length	Two Days

Lesson 1 - Getting Started Introducing VBA Recording a Macro Running a Macro Editing a Macro in the VBA Editor Understanding the Development Environment Using Visual Basic Help Closing the Visual Basic Editor Lesson 2 - Working with Procedures and Functions Understanding Modules Creating a Standard Module Understanding Procedures Creating a Sub Procedure Calling Procedures Using the Immediate Window to Call Procedures Creating a Function Procedure Naming Procedures Working with the Code Editor Setting Code Editor Options Guidelines for Editing Code Commenting Code Finding Code Complete Word Feature Lesson 3 - Understanding Objects Understanding Objects Navigating the Excel Object Hierarchy Understanding Collections Using the Object Browser Working with Properties Using the With Statement Working with Methods Creating an Event Procedure Lesson 4 - Using Expressions, Variables, and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Working with Variable Scope Using Intrinsic Functions Understanding Constants Using Intrinsic Constants Using Message Boxes Using Input Boxes Declaring and Using Object Variables Lesson 5 - Controlling Program Execution Understanding Control-of-Flow Structures Working with Boolean Expressions Using the If�End If Decision Structures If�Then Statements If�Then�Else Statements Using the Select Case�End Select Structure Using the Do�Loop Structure Using the For�To�Next Structure For�Next Statements Using the For Each�Next Structure Guidelines for use of Control-of-Flow Structures Lesson 6 - Working with Forms and Controls Understanding UserForms Using the Toolbox Working with UserForm Properties, Events and Methods Understanding Controls Setting Control Properties in the Properties Window Working with the Label Control Working with the Text Box Control Working with the Command Button Control Working with the Combo Box Control Working with the Frame Control Working with Option Button Controls Working with Control Appearance Setting the Tab Order Populating a Control Adding Code to Controls Launching a Form in Code Lesson 7 - Working with PivotTable Object Understanding PivotTables Creating a PivotTable Working with the PivotTable Wizard Method Working with PivotFields Assigning a Procedure to a Custom Toolbar Lesson 8 - Debugging Code Understanding Errors Using Debugging Tools Setting Breakpoints Stepping Through Code Using Break Mode during Run Mode Determining the Value of Expressions Chapter 9 - Handling Errors Understanding Error Handling Understanding VBA�s Error Trapping Options Trapping Errors with the On Error Statement Understanding the Err Object Writing an Error-Handling Routine Working with Inline Error Handling RETURN TO TOP

Microsoft Excel
Title	Getting Started with Excel
Length	3 Hours

Examining the screen How big is the spreadsheet? Moving around the spreadsheet quickly Pointers Entering text Deleting data Editing data Backspace vs. delete Modifying alignment Moving Copying Undo Using the Autofill handle Adding numbers Formatting spreadsheets Changing column widths Print preview Page Setup RETURN TO TOP

Microsoft Excel
Title	Useful Features in Microsoft Excel
Length	3 Hours

Saving a workspace Password protection Naming ranges Creating custom lists Creating custom views Creating scenarios Using the Format Painter Conditional formatting Creating styles Using Paste Special Printing titles Data validation Using Goal Seek Using Solver RETURN TO TOP

Microsoft Excel
Title	Getting Started with Excel Formulas & Functions
Length	3 Hours

SUM MAX MIN AVERAGE COUNT COUNTA Using AutoFill to Copy Formulas More Advanced Formulas IF HLOOKUP VLOOKUP The Order of Operations Understanding Relative and Absolute References Displaying formulas Displaying Formulas on a Worksheet RETURN TO TOP

Microsoft Excel
Title	Advanced Functions
Length	3 Hours

COUNTA SUMIF COUNTIF MATCH SUMPRODUCT PMT OFFSET UPPER LOWER PROPER ISERROR ISTEXT ISNUMBER STDEV Removing spaces Separating text RETURN TO TOP

Microsoft Excel
Title	Charting, Linking, Embedding & Working with Multiple Sheets
Length	3 Hours

Creating Charts Selecting the Data to Include in a Chart The Chart Wizard Moving a Chart Resizing a Chart Modifying Characteristics of a Chart Changing Bar Colors Changing the Color of the Background Deleting Gridlines Formatting Gridlines Formatting Text Formatting Values Adding Text to a Chart Linking Creating a Link Using an Equation Creating a Link Using Paste Special Linking from Microsoft Excel to Microsoft Word Embedding Embedding an Excel Spreadsheet inside a Word Document Working with Multiple Sheets Renaming Sheets Changing the Color of Tabs Adding New Sheets Deleting Sheets Setting the Default Number of Sheets Reordering Sheets Using Group Mode Creating Equations across Sheets Creating and Using Hyperlinks RETURN TO TOP

Microsoft Excel
Title	Working with Microsoft Excel Databases
Length	3 Hours

Splitting windows Freezing panes Data Forms Sorting AutoFiltering Lists Advanced filters Subtotaling Pivot tables and pivot charts RETURN TO TOP

Microsoft Excel
Title	Creating Forms and Recording Macros
Length	3 Hours

Forms Labels Group Boxes Buttons Check Boxes Option Buttons List Boxes Combo Boxes Scroll Bars Spinners Toggling the Grid Macros Recording a macro Running macros from the macro dialog box Running macros using a button and shortcut keys Creating a macro button on the toolbar Creating a custom menu item on the toolbar Viewing the VBA code Absolute and relative references Assigning shortcut keys to existing macros RETURN TO TOP