Results 1 to 7 of 7

Thread: intermediate to Advance User Excel Video Trainning

  1. #1

    intermediate to Advance User Excel Video Trainning

    Course: MS Excel Automation
    Author: Lauri Matson
    ISBN: 1-935320-28-9
    Release Date: 2009-01-30
    Duration: 5 hrs / 71 tutorials
    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

    1) Introduction
    Course Objectives
    Command Reference (2003 - 2007)
    2) Time Saving Techniques
    Shortcuts & Quick Tips
    Auto Correct Options
    3) Validation & Protection
    Introducing Data Validation
    Creating a List with Validation
    Setting up Protection
    4) Named Ranges
    Defining a Name
    Editing & Using Names
    Name Manager
    5) Security
    Adjusting Security Levels
    Using Macro Extension
    6) Introduction to Macros
    Tools Menu vs. Developer Toolbar
    Storing Macros
    Working with a Startup Folder
    7) Macros
    Getting Started
    Absolute vs. Relative Reference
    8) Practice with Macros
    Creating a Routine
    Automating Formats
    Creating a Template for Headers/Footers
    9) Understanding Macro Code
    Editing Macros with VBA
    Introduction to Reading Code
    10) Buttons vs. Command Buttons
    Creating a Button
    Creating a Command Button
    11) The VBA Screen
    The Explorer & Properties
    Objects & User Forms
    12) Creating a Routine
    Creating an Object pt.
    Creating an Object pt. 2
    Adding Code to an Object
    13) Adding Controls
    Creating Dropdown Lists
    Viewing the Code
    14) Designing a Pop-Up Calendar
    Creating the Calendar Form
    Writing the Code
    15)Writing Code
    Coding with VBA
    Examples
    16) Formulas & Functions
    Formulas vs. Functions
    Tips for Formulas
    17)Three Dimensional Formulas
    Formulas from Other Worksheets
    Linking External Workbooks
    18) Popular Functions
    Conditional Statements
    Nested Statements
    Introduction to V-Lookup
    Tips for Working with V-Lookup
    19) VBA & Functions
    Using Functions
    Creating a Custom Function
    20) Using an Add-In
    Explaining Add-In
    Creating an Add-In for a Custom
    Using a Function with Goal Seek
    21) Pivot Tables
    Using Pivot Tables
    Working with Outside Data
    Formats & Features of Pivots
    22) Automating Pivot Tables
    Adding a Pivot Chart
    Macros & Code for Automation
    23) Advanced Charts & Graphs
    Single Point Charts
    Specialty Charts
    Combination Charts
    24) Automating Charts & Graphs
    Creating a Dynamic Chart
    The Offset Command
    25) Pivots & Charts in Legacy Versions
    Creating Pivots in Earlier Versions
    Charts & Graphs in Prior Versions
    26)Working with Other Programs
    Linking to PowerPoint
    Dressing up Your Spreadsheets
    27) Importing/Exporting Data
    Working with External Data
    Exporting from Excel
    28) Analysis Tools
    Understanding the Add-In Tools
    Descriptive Statistics
    Histogram
    29) Looking for Help
    The Help Menu for Excel & VBA
    The Microsoft Interactive Tool
    30) Wrap Up
    Conclusion
    About the Author
    31) Exercise Files

    [link Point to another website Only the registered members can access]

    [link Point to another website Only the registered members can access]

    [link Point to another website Only the registered members can access]

    [link Point to another website Only the registered members can access]

    [link Point to another website Only the registered members can access]

    [link Point to another website Only the registered members can access]

    [link Point to another website Only the registered members can access]

    [link Point to another website Only the registered members can access]

    [link Point to another website Only the registered members can access]

    [link Point to another website Only the registered members can access]

    [link Point to another website Only the registered members can access]

    [link Point to another website Only the registered members can access]

    [link Point to another website Only the registered members can access]

    [link Point to another website Only the registered members can access]

    [link Point to another website Only the registered members can access]
    for your conveyniance all rar files are separately playable. each rar files covers 2 topic except the last one which contains exercise file too.
    Hopefully you will find it useful.


    See More: intermediate to Advance User Excel Video Trainning

  2. # ADS
    Spons Circuit
    Join Date
    Always
    Posts
    Many
     
  3. Thank you!

    Good stuff my friend. Hope forumers will find it benefit as I do.

    Keep up your great work! We hope to see similar posts like this from you!

    Regards

    CEO76

  4.    Sponsored Links



    -

  5. #3


  6. #5

  7.    Spons.



  8. Thank you

    My threads; Pedro Romero :


  •   

Similar Threads

  1. Excel VBA VIDEO Tutorial
    By dabdab in forum Computer & Internet
    Replies: 0
    Last Post: 07-16-2010, 08:26 PM
  2. excel and access 2010 new features video training
    By sharmeen in forum Computer & Internet
    Replies: 1
    Last Post: 07-12-2010, 02:38 AM
  3. Excel and Access 2010 New Features Video Training
    By sharmeen in forum Engineering Software Tutorial
    Replies: 7
    Last Post: 06-20-2010, 08:16 PM
  4. Problem with excel user model in aspen plus
    By inzinier in forum Process Simulation Community
    Replies: 0
    Last Post: 04-20-2010, 11:22 PM
  5. Professor Teaches Advance Excel Training
    By sharmeen in forum Computer & Internet
    Replies: 5
    Last Post: 10-22-2009, 09:22 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •