805.498.7162       805.728.5681
EMAGENIT Logo

Advanced Microsoft Excel for Business Professionals

Business, Engineering and Science

Workshop Details

Type: Business Professionals

Offering Types: On-Site, Public, Self-Study Manual

Platform: Windows and Mac

Versions: 97-2007

Training: Hands-On

Workshop Manual: Price and Buy

Public Training: Dates and Signup

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

Hotel: Thousand Oaks Inn

Onsite Training: Details


What is Included in the Workshop

  • Our Excel Aided Business manual containing over 1600 pages of Excel and VBA instruction and hundreds of examples

  • If signup for the on-site or public holding of the workshop, you can retake the public offering of the workshop as many times as you wish, no date or repeat limit

*Detailed outline below


Workshop and Manual Overview

In our Advanced Microsoft Excel business 1-day "hands-on" workshop, EMAGENIT covers:

  • Advanced Microsoft Excel communication strategies with databases using Microsoft Query
  • Worksheet techniques for constructing business forms using ActiveX controls and form controls
  • Dashboard construction
  • Advanced Microsoft Excel skills for linking separate workbooks and worksheets
  • Advanced Excel skills for linking with other applications (OLE)
  • Advanced Microsoft Excel skills for importing text files
  • Advanced Excel skills for sharing workbooks
  • Advanced Microsoft Excel skills for constructing time formulas on the worksheet
  • Advanced Excel pivot table construction
  • Advanced Microsoft Excel use of the Macro Recorder and VBA Editor
  • Advanced use of Goal Seek and Solver

*We review personal problems in our workshops.

* If you are looking for advanced formula design, try our Intermediate Microsoft Excel workshop


Workshop Outline (Every part of our workshop is hands-on)

  • Time Formulas: Working with time formulas on the Microsoft Excel worksheet
  • Workbook Templates / Worksheet Templates: How to create and use Microsoft Excel workbook and worksheet templates
  • Business Forms: How to use ActiveX controls and form controls to create advanced business forms on the Microsoft Excel worksheet
  • Dashboards: How to create dashboards using charts, array formulas (SumProduct,SumIF,Index,CountIF...etc)
  • Linking Workbooks: Link workbooks and worksheets together including team and network issues
  • Sharing Workbooks: How to share Microsoft Excel workbooks over a network
  • OLE Automation: How to link Microsoft Excel with other applications
  • Importing Text Files: Importing text files into Microsoft Excel using various file formats
  • Pivot Tables: How to create and build advanced pivot tables
  • Microsoft Query: How to access databases from Microsoft Excel using Microsoft Query and ODBC
  • Microsoft Access: How to update Microsoft Access tables directly from Microsoft Excel
  • Microsoft Excel Security: Microsoft Excel workbook and worksheet security issues
  • Macro Recorder: Introduction to Microsoft Excel VBA code using the Macro recorder

 

Who Should Attend

  • Intermediate Excel users with a basic knowledge of Excel.
  • It is intended for all types of business professionals.

EMAGENIT's Public Training Location

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

Hotel: Thousand Oaks Inn

EMAGENIT is based in Thousand Oaks, California which is in the vicinity of Los Angeles county (LA County), Ventura county, Santa Barbara county and San Diego county. We hold all of our on-site courses nation wide. Our public workshops are a short commute for those living in the Santa Barbara, San Fernando Valley, Santa Clarita, Newbury Park, Camarillo, Calabasas, Sherman Oaks, Reseda, Woodland Hills, Hollywood, Fillmore, Ventura, Moorpark, Simi Valley, Santa Monica and Oxnard areas. For more information about our public workshops, visit our public workshops page our call us at the number above.

EMAGENIT NASA Award

EMAGENIT received an award for its involvement with NASA JPL in helping redesign and integrate their conceptual Rover mission software in Microsoft Excel. Click the picture above for more detail about our Rover involvement. To learn more about the NASA mission to mars click here.

Awards & Customers
 
 
Call Us
Call EMAGENIT between the hours of 8:00 A.M. and 5 P.M. PST at 1.805.498.7162 or 805.728.5681 for more information about this workshop.
 
Email Us
Submit a question to us via email at advexcel@emagenit.com
 

Information Request Form

First Name:
Last Name:
Company:
Zip Code:
Country:
Work Number:
Ext:
e-mail
Information type:
Send me on-site information and pricing
Send your latest public workshop schedule and pricing
Contact me directly via the phone number provided
Keep me informed about EMAGENIT workshops and products
Privacy Policy

 

Request information about our training, products or software design Read about our public training schedule, location and pricing Read about our web cast training schedule and pricing Read about our onsite training workshops Read about our self study manuals and pricing Read about our unique software design services for Windows and Excel Visit our product store for our latest software and manuals Download Excel VBA code for data processing, dashboards, automated charting...

 

 

 



Additional Pages

Microsoft Excel Classes  Microsoft Excel VBA Courses  Microsoft Excel Training  Microsoft Excel Macros  Microsoft Excel VBA Consulting  Microsoft Excel Add-Ins

Copyright © 2002-2008 EMAGENIT All Rights Reserved