VTC - Microsoft Excel Automation - ISBN:1935320289

VTC - Microsoft Excel Automation

Date: 28 April 2011, 06:32

Free register and download UseNet downloader, then you can FREE Download from UseNet.

Download without Limit " VTC - Microsoft Excel Automation " from UseNet for FREE!

Details of content covered:
Introduction
Course Objectives (04:43)
Command Reference (2003 - 2007) (01:35)
Time Saving Techniques
Shortcuts & Quick Tips (04:44)
Auto Correct Options (03:30)
Validation & Protection
Introducing Data Validation (03:04)
Creating a List with Validation (02:16)
Setting up Protection (04:38)
Named Ranges
Defining a Name (04:12)
Editing & Using Names (02:58)
Name Manager (04:11)
Security
Adjusting Security Levels (04:13)
Using Macro Extension (04:18)
Introduction to Macros
Tools Menu vs. Developer Toolbar (02:49)
Storing Macros (04:29)
Working with a Startup Folder (03:40)
Macros
Getting Started (03:36)
Absolute vs. Relative Reference (03:46)
Practice with Macros
Creating a Routine (03:29)
Automating Formats (03:06)
Creating a Template for Headers/Footers (03:13)
Understanding Macro Code
Editing Macros with VBA (04:06)
Introduction to Reading Code (05:11)
Buttons vs. Command Buttons
Creating a Button (04:12)
Creating a Command Button (05:44)
The VBA Screen
The Explorer & Properties (04:53)
Objects & User Forms (05:46)
Creating a Routine
Creating an Object pt. 1 (03:04)
Creating an Object pt. 2 (04:38)
Adding Code to an Object (06:05)
Adding Controls
Creating Dropdown Lists (04:23)
Viewing the Code (04:34)
Designing a Pop-Up Calendar
Creating the Calendar Form (05:13)
Writing the Code (05:17)
Writing Code
Coding with VBA (03:37)
Examples (05:14)
Formulas & Functions
Formulas vs. Functions (03:49)
Tips for Formulas (04:47)
Three Dimensional Formulas
Formulas from Other Worksheets (03:48)
Linking External Workbooks (05:18)
Popular Functions
Conditional Statements (02:43)
Nested Statements (04:40)
Introduction to V-Lookup (05:21)
Tips for Working with V-Lookup (03:29)
VBA & Functions
Using Functions (05:00)
Creating a Custom Function (04:44)
Using an Add-In
Explaining Add-In (03:59)
Creating an Add-In for a Custom (02:37)
Using a Function with Goal Seek (04:21)
Pivot Tables
Using Pivot Tables (05:01)
Working with Outside Data (04:40)
Formats & Features of Pivots (04:30)
Automating Pivot Tables
Adding a Pivot Chart (04:06)
Macros & Code for Automation (05:54)
Advanced Charts & Graphs
Single Point Charts (05:39)
Specialty Charts (05:44)
Combination Charts (04:44)
Automating Charts & Graphs
Creating a Dynamic Chart (04:12)
The Offset Command (04:51)
Pivots & Charts in Legacy Versions
Creating Pivots in Earlier Versions (04:13)
Charts & Graphs in Prior Versions (05:39)
Working with Other Programs
Linking to PowerPoint (03:41)
Dressing up Your Spreadsheets (05:40)
Importing/Exporting Data
Working with External Data (05:33)
Exporting from Excel (03:56)
Analysis Tools
Understanding the Add-In Tools (02:18)
Descriptive Statistics (03:36)
Histogram (03:21)
Looking for Help
The Help Menu for Excel & VBA (05:16)
The Microsoft Interactive Tool (02:32)
Wrap Up
Conclusion (03:01)
About the Author (03:06)
Video Duration: 5 hrs / 71 tutorials bundled in an ISO format (7 parts), will require quicktime player for playing these files.
Thanks and all credits to the original uploader.
Enjoy!!!

Related Articles:
Excel

DISCLAIMER:

This site does not store VTC - Microsoft Excel Automation on its server. We only index and link to VTC - Microsoft Excel Automation provided by other sites. Please contact the content providers to delete VTC - Microsoft Excel Automation if any and email us, we'll remove relevant links or contents immediately.