|
Microsoft Excel Automation Tutorials Online |
![]() |
|
Description
Microsoft Excel Automation
VTC's Microsoft Excel Automation course is intended for intermediate and advanced users who wish to increase their efficiency, accuracy, and productivity. Students should have already completed Excel introduction courses or have equivalent knowledge. Created for all versions of Excel, this course will help students master the art of spreadsheet design and will provide comprehensive instruction in the automation and simplification of even the most complex data. Expanding upon our basic Excel courses, Lauri Matson explores the more advanced features of Excel such as VLookup functions, validation, pivot tables, analysis tools, charting, and more. To begin learning Excel Automation today, simply click on the movie links. |
01 Introduction
0101 Course Objectives
0102 Command Reference (2003 - 2007)
02 Time Saving Techniques
0201 Shortcuts & Quick Tips
0202 Auto Correct Options
03 Validation & Protection
0301 Introducing Data Validation
0302 Creating a List with Validation
0303 Setting up Protection
04 Named Ranges
0401 Defining a Name
0402 Editing & Using Names
0403 Name Manager
05 Security
0501 Adjusting Security Levels
0502 Using Macro Extension
06 Introduction to Macros
0601 Tools Menu vs. Developer Toolbar
0602 Storing Macros
0603 Working with a Startup Folder
07 Macros
0701 Getting Started
0702 Absolute vs. Relative Reference
08 Practice with Macros
0801 Creating a Routine
0802 Automating Formats
0803 Creating a Template for Headers/Footers
09 Understanding Macro Code
0901 Editing Macros with VBA
0902 Introduction to Reading Code
10 Buttons vs. Command Buttons
1001 Creating a Button
1002 Creating a Command Button
11 The VBA Screen
1101 The Explorer & Properties
1102 Objects & User Forms
12 Creating a Routine
1201 Creating an Object pt. 1
1202 Creating an Object pt. 2
1203 Adding Code to an Object
13 Adding Controls
1301 Creating Dropdown Lists
1302 Viewing the Code
14 Designing a Pop-Up Calendar
1401 Creating the Calendar Form
1402 Writing the Code
15 Writing Code
1501 Coding with VBA
1502 Examples
16 Formulas & Functions
1601 Formulas vs. Functions
1602 Tips for Formulas
17 Three Dimensional Formulas
1701 Formulas from Other Worksheets
1702 Linking External Workbooks
18 Popular Functions
1801 Conditional Statements
1802 Nested Statements
1803 Introduction to V-Lookup
1804 Tips for Working with V-Lookup
19 VBA & Functions
1901 Using Functions
1902 Creating a Custom Function
20 Using an Add-In
2001 Explaining Add-In
2002 Creating an Add-In for a Custom
2003 Using a Function with Goal Seek
21 Pivot Tables
2101 Using Pivot Tables
2102 Working with Outside Data
2103 Formats & Features of Pivots
22 Automating Pivot Tables
2201 Adding a Pivot Chart
2202 Macros & Code for Automation
23 Advanced Charts & Graphs
2301 Single Point Charts
2302 Specialty Charts
2303 Combination Charts
24 Automating Charts & Graphs
2401 Creating a Dynamic Chart
2402 The Offset Command
25 Pivots & Charts in Legacy Versions
2501 Creating Pivots in Earlier Versions
2502 Charts & Graphs in Prior Versions
26 Working with Other Programs
2601 Linking to PowerPoint
2602 Dressing up Your Spreadsheets
27 Importing/Exporting Data
2701 Working with External Data
2702 Exporting from Excel
28 Analysis Tools
2801 Understanding the Add-In Tools
2802 Descriptive Statistics
2803 Histogram
29 Looking for Help
2901 The Help Menu for Excel & VBA
2902 The Microsoft Interactive Tool
30 Wrap Up
3001 Conclusion
3002 About the Author
sku |
|
