Excel Automation

Visuel non disponible

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.

Formateur : Lauri Matson
Enregistré sur PC | Langue: Anglais
Durée : 5 | Leçons: 71

Compatible Mac, Windows & iPad (en VOD)
143,52 € En stock

Acheter sur CD
ou DVD
Acheter des Crédits
pour Consultation
En savoir plus >>


TVA incluse, Hors Livraison 143,52 €

Accès à l'unité

Cette formation nécessite crédits

10 Crédits 10,00 € TTC commander
35 Crédits 30,00 € TTC commander
60 Crédits 50,00 € TTC commander
130 Crédits 100,00 € TTC commander

  • 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 Matson
Langue : Anglais
Durée : 5
Nombre de séquences vidéo : 71 		SKU : 33964
Réf :
ISBN : 1-935320-28-9

Descriptif :

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.




Lauri 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.

Vous souhaitez recevoir l'aide d'un formateur expérimenté pour parfaire votre apprentissage ? C'est possible grâce a notre centre de formation accompagnée a distance.

Nouveaux Parcours

Tous les parcours »
  • Profitez de conseils personnalisés grâce a des entretiens téléphoniques réguliers avec votre formateur.
  • Confrontez-vous a la réalité des entreprises grâce aux exercices proposés pendant la formation.
  • Obtenez une Attestation de Formation Professionnelle.
  • Contactez-nous pour le financement de votre formation par votre OPCA.