[share_ebook] VTC Excel Automation

Description

VTC's MS 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. 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 MS Interactive Tool (02:32) Wrap Up Conclusion (03:01) About the Author (03:06)

Disclaimer:
Contents of this page are indexed from the Internet. All actions are under your responsability. Email us to report illegal contents or external links and we'll remove them immediately.

Please check the description for download links if any or do a search to find alternative books.

Can't Download?
Please search mirrors if you can't find download links for "[share_ebook] VTC Excel Automation" in "Description" and someone else may update the links. Check the comments when back to find any updates.

Search Mirrors
Maybe some mirror pages will be helpful, search this book at top of this page or click here to find more info.

1. Ebooks list page : 3046
2. F1 Get The Most Out Of Excel!: The Ultimate Excel Tip Help Guide: Excel 97, Excel 2000, Excel 2002, Excel 2003
3. F1 Get the Most out of Excel! The Ultimate Excel Tip Help Guide: Excel 97, Excel
4. [share_ebook] Excel Essentials: Using Microsoft Excel For Data Analysis And Decision Making
5. [share_ebook] Excel 2007 for Scientists and Engineers (Excel for Professionals series)
6. [share_ebook] Excel Gurus Gone Wild: Do the IMPOSSIBLE with Microsoft Excel
7. Learn Excel 97 Through Excel 2007 from Mr. Excel: 377 Excel Mysteries Solved!
8. Learn Excel 97 Through Excel 2007 from Mr. Excel: 377 Excel Mysteries Solved!
9. IT Process Automation and VMware - Workload Automation for Real and Virtual Environments, Free UC4 Software, Inc White Paper
10. IT Process Automation and VMware - Workload Automation for Real and Virtual Environments, Free UC4 Software, Inc White Paper
11. IT Process Automation and VMware - Workload Automation for Real and Virtual Environments, Free UC4 Software, Inc White Paper
12. IT Process Automation and VMware - Workload Automation for Real and Virtual Environments, Free UC4 Software, Inc White Paper
13. IT Process Automation and VMware - Workload Automation for Real and Virtual Environments, Free UC4 Software, Inc White Paper
14. [request_ebook] Substation Automation Handbook
15. Microsoft Excel Functions and Formulas: Excel 97–Excel 2003
16. Microsoft Excel Functions and Formulas: Excel 97–Excel 2003