My lessons Sign in on VTC

Microsoft Excel Automation / Pivot Tables

Loading…

Working with Outside Data

Pivot Tables

← Previous lesson Next lesson →

Course content

Introduction
- Course ObjectivesFree
- Command Reference (2003 - 2007)Free
Time Saving Techniques
- Shortcuts & Quick Tips1 credit or ad
- Auto Correct Options1 credit or ad
Validation & Protection
Named Ranges
Security
- Adjusting Security Levels1 credit or ad
- Using Macro Extension1 credit or ad
Introduction to Macros
Macros
- Getting Started1 credit or ad
- Absolute vs. Relative Reference1 credit or ad
Practice with Macros
Understanding Macro Code
- Editing Macros with VBA1 credit or ad
- Introduction to Reading Code1 credit or ad
Buttons vs. Command Buttons
- Creating a Button1 credit or ad
- Creating a Command Button1 credit or ad
The VBA Screen
- The Explorer & Properties1 credit or ad
- Objects & User Forms1 credit or ad
Creating a Routine
Adding Controls
- Creating Dropdown Lists1 credit or ad
- Viewing the Code1 credit or ad
Designing a Pop-Up Calendar
- Creating the Calendar Form1 credit or ad
- Writing the Code1 credit or ad
Writing Code
- Coding with VBA1 credit or ad
- Examples1 credit or ad
Formulas & Functions
- Formulas vs. Functions1 credit or ad
- Tips for Formulas1 credit or ad
Three Dimensional Formulas
- Formulas from Other Worksheets1 credit or ad
- Linking External Workbooks1 credit or ad
Popular Functions
VBA & Functions
- Using Functions1 credit or ad
- Creating a Custom Function1 credit or ad
Using an Add-In
Pivot Tables
Automating Pivot Tables
- Adding a Pivot Chart1 credit or ad
- Macros & Code for Automation1 credit or ad
Advanced Charts & Graphs
Automating Charts & Graphs
- Creating a Dynamic Chart1 credit or ad
- The Offset Command1 credit or ad
Pivots & Charts in Legacy Versions
- Creating Pivots in Earlier Versions1 credit or ad
- Charts & Graphs in Prior Versions1 credit or ad
Working with Other Programs
- Linking to PowerPoint1 credit or ad
- Dressing up Your Spreadsheets1 credit or ad
Importing/Exporting Data
- Working with External Data1 credit or ad
- Exporting from Excel1 credit or ad
Analysis Tools
Looking for Help
- The Help Menu for Excel & VBA1 credit or ad
- The Microsoft Interactive Tool1 credit or ad
Wrap Up
- Conclusion1 credit or ad
- About the Author1 credit or ad