Excel Automation

Easy-to-undestand video tutorials

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.

Durée 5
Avec : Lauri Sowa-Matson
Formation téléchargeable
FORMATION TÉLÉCHARGÉABLE
Formation téléchargeable
VISIONNAGE ILLIMITÉ
Formation téléchargeable
DISPONIBLE SUR USB

Nos clients ont également vu :

  • Named Ranges

    • (04:12) Defining a Name
    • (02:58) Editing & Using Names
    • (04:11) Name Manager
  • Security

    • (04:13) Adjusting Security Levels
    • (04:18) Using Macro Extension
  • Introduction to Macros

    • (02:49) Tools Menu vs. Developer Toolbar
    • (04:29) Storing Macros
    • (03:40) Working with a Startup Folder
  • Macros

    • (03:36) Getting Started
    • (03:46) Absolute vs. Relative Reference
  • Practice with Macros

    • (03:29) Creating a Routine
    • (03:06) Automating Formats
    • (03:13) Creating a Template for Headers/Footers
  • Understanding Macro Code

    • (04:06) Editing Macros with VBA
    • (05:11) Introduction to Reading Code
  • Buttons vs. Command Buttons

    • (04:12) Creating a Button
    • (05:44) Creating a Command Button
  • The VBA Screen

    • (04:53) The Explorer & Properties
    • (05:46) Objects & User Forms
  • Creating a Routine

    • (03:04) Creating an Object pt. 1
    • (04:38) Creating an Object pt. 2
    • (06:05) Adding Code to an Object
  • Adding Controls

    • (04:23) Creating Dropdown Lists
    • (04:34) Viewing the Code
  • Designing a Pop-Up Calendar

    • (05:13) Creating the Calendar Form
    • (05:17) Writing the Code
  • Writing Code

    • (03:37) Coding with VBA
    • (05:14) Examples
  • Formulas & Functions

    • (03:49) Formulas vs. Functions
    • (04:47) Tips for Formulas
  • Three Dimensional Formulas

    • (03:48) Formulas from Other Worksheets
    • (05:18) Linking External Workbooks
  • Popular Functions

    • (02:43) Conditional Statements
    • (04:40) Nested Statements
    • (05:21) Introduction to V-Lookup
    • (03:29) Tips for Working with V-Lookup
  • VBA & Functions

    • (05:00) Using Functions
    • (04:44) Creating a Custom Function
  • Using an Add-In

    • (03:59) Explaining Add-In
    • (02:37) Creating an Add-In for a Custom
    • (04:21) Using a Function with Goal Seek
  • Pivot Tables

    • (05:01) Using Pivot Tables
    • (04:40) Working with Outside Data
    • (04:30) Formats & Features of Pivots
  • Automating Pivot Tables

    • (04:06) Adding a Pivot Chart
    • (05:54) Macros & Code for Automation
  • Advanced Charts & Graphs

    • (05:39) Single Point Charts
    • (05:44) Specialty Charts
    • (04:44) Combination Charts
  • Automating Charts & Graphs

    • (04:12) Creating a Dynamic Chart
    • (04:51) The Offset Command
  • Pivots & Charts in Legacy Versions

    • (04:13) Creating Pivots in Earlier Versions
    • (05:39) Charts & Graphs in Prior Versions
  • Working with Other Programs

    • (03:41) Linking to PowerPoint
    • (05:40) Dressing up Your Spreadsheets
  • Importing/Exporting Data

    • (05:33) Working with External Data
    • (03:56) Exporting from Excel
  • Analysis Tools

    • (02:18) Understanding the Add-In Tools
    • (03:36) Descriptive Statistics
    • (03:21) Histogram
  • Looking for Help

    • (05:16) The Help Menu for Excel & VBA
    • (02:32) The Microsoft Interactive Tool
  • Wrap Up

    • (03:01) Conclusion
    • (03:06) About the Author
Formateur : Lauri Sowa-Matson
Langue : Anglais
Durée : 5
Nombre de séquences vidéo : 71
SKU : 33964
Réf :
ISBN : 1-935320-28-9
Date de publication : 2009-01-30
Compatibilité : Apple Mac OS X (PPC & Intel) | Windows XP, Vista, 7, 8
Formations compatibles iPad en VOD et via l'application TutoShop sur l'AppStore.

Descriptif :




Lauri Sowa-Matson

Lauri Matson owns and operates a successful consulting business specializing in accounting and computerization. Her company assists small and midsized companies with accounting, networking, and administrative solutions. She has over 30 years of accounting and administrative experience and has taught over 20,000 students in seminar and college settings. As an active consultant, she combines the day-to-day hands-on experience with the tips and tricks that are necessary to successfully incorporate an optimized database in today's business intelligence systems.

+ 10 000 TUTOS EN VIDÉO
FORMEZ-VOUS EN ILLIMITÉ
SUR
VOD.TUTOROM.FR

A partir de 19€/mois seulement
Abonnez-vous