Call us at:   1.805.498.7162     1.805.558.9277

Home > Microsoft Excel Workshops > Microsoft Excel and Microsoft Excel VBA Public Seminar Training

Microsoft Excel and Microsoft Excel VBA Public Seminar Training

for Business, Engineering and Science

Our Microsoft Excel Public seminar workshops focus on our attendees specific Excel needs and are taught "hands-on" by an experienced Excel software developer. In our workshops, we cover from beginning Excel to the most advanced Excel VBA programming. We cover all the versions of Microsoft Excel in our workshops including Excel for Mac. All of our workshops come with an 1800+ page manual.

Beginning Microsoft Excel Public Seminar Training for Business Professionals

Duration: 1-day

Included: 1800 + page manual , "hands-on" training ,  free repeats

Available: Public Seminar Training Location , Company Onsite , Self-Study Manual

Beginning Excel Public Seminar Introduction

Our 1-day "hands-on" Excel onsite training teaches you not only basics of Microsoft Excel but the thinking and mechanics of how to apply it to your everyday problems. Complete Workshop Outline

In our Beginning Microsoft Excel seminar you will learn:

• The Microsoft Excel interface

• How to format worksheets, copy / paste data, enter data and sort

• How to type basic formulas on the worksheet

• How to set up worksheets to print

• Basic chart construction

• How to use simple Excel functions like Sum

Intermediate Microsoft Excel Public Seminar Training for Business Professionals

Duration: 1-day

Included: 1800 + page manual , "hands-on" training ,  free repeats

Available: Public Seminar Training Location , Live Online Webinar , Company Onsite , Self-Study Manual

Intermediate Excel Public Seminar Introduction

Our 1-day "hands-on" intermediate Excel training focuses on useful formula design for data processing and analysis, using Excel's built-in features for dashboards, useful worksheet functions like VLOOKUP and SUMIF and applying Excel's built-in data processing tools and worksheet functions to analyze worksheet tables. We teach you how to develop analysis and data processing problems on the worksheet then how to determine the proper Excel tools to create a unique solution. Complete Workshop Outline and Signup

In our Intermediate Microsoft Excel seminar you will learn:

• How to construct basic formulas, formula debugging and cell naming

• How to build proper worksheet tables for use with Excel's data features, functions and database features

• How to use Data Validation, Conditional Formatting and charts to develop basic dashboards

• How to perform table lookups using VLOOKUP, HLOOKUP, MATCH, INDEX and INDIRECT

• How to build summary formulas that can toggle between tables and find shifting headers

• How to build formulas and basic array formulas using COUNTIF, MATCH, SUMIF, SUM, MAX, MIN, ROW, COLUMN and <, >, <= ,>= , <>, =

• How to work with data using Excel features like Auto Filter, Advanced Filter and Text to Columns

• How to clean and analyze text using using functions like LEFT, RIGHT, MID, SUBSTITUTE, CLEAN and TRIM

• How to use logic functions like IF, AND, OR in formulas to create smart worksheets

• How to link Excel to Word and PowerPoint for reports

• How to build basic Pivot tables

Advanced Microsoft Excel Public Seminar Training for Business Professionals

Duration: 1-day

Included: 1800 + page manual , "hands-on" training ,  free repeats

Available: Public Seminar Training Location , Live Online Webinar , Company Onsite , Self-Study Manual

Advanced Excel Public Seminar Introduction

Our 1-day "hands-on" advanced Excel training focuses on creating sophisticated Excel analysis and data processing tools using advanced formulas, array formulas, ActiveX controls, dashboards, database queries, pivot tables and charts. We teach you how to develop these advanced solutions on the worksheet then how to assemble the proper Excel tools in ways you have never thought of before. It also provides an introduction to macros (VBA). Complete Workshop Outline and Signup

In our Advanced Microsoft Excel seminar you will learn:

• Advanced formula construction, array formula construction, formula debugging and cell / range naming

• How to build advanced dashboards using data validation, conditional formatting, ActiveX controls, charts and drawing shapes

• How to design a proper worksheet table that can be used in advanced formulas and used as a database

• How to summarize data on multiple sheets using dynamic ranges that shift to changing tables size, moving headers and start stop points

• Advanced Microsoft Excel skills for constructing time formulas on the worksheet

• Advanced Microsoft Excel communication strategies with databases, text files and workbooks using Microsoft Query

• Advanced Microsoft Excel skills for linking separate workbooks and worksheets

• Advanced Excel skills for linking with other applications like Word and PowerPoint

• Advanced Microsoft Excel skills for importing text files

• Advanced Excel pivot table construction

• Introduction to VBA macros and the VBA Editor including custom worksheet function design

Beginning Microsoft Excel VBA Public Seminar Training for Business Professionals

Duration: 2-days

Included: 1800 + page manual , "hands-on" training ,  free repeats

Available: Public Seminar Training Location , Live Online Webinar , Company Onsite , Self-Study Manual

Beginning Microsoft Excel VBA Public Seminar Introduction

Our 2-day "hands-on" Excel VBA public training shows you the basic principles of using Excel with VBA to construct useful business tools. Discussed is a full review of the VBA language including loops, logic, variables, procedures and how to control Excel using objects, properties and methods. Key Excel VBA topics covered include performing calculations in VBA, data processing, creating charts, building pivot tables, building dashboards, commanding Word / PowerPoint for report generation purposes and more. Complete Workshop Outline and Signup

In our Beginning Microsoft Excel VBA seminar you will learn:

• How to use the VBA Editor, its debugging tools and modules

• A complete review of the VBA language including Subs, Functions, variables, arrays, loops and logic

• A complete strategy review of constructing procedures and using loops and logic in your code

• How to use VBA to command Microsoft Excel object, properties and methods

• How to use Excel VBA to control key Excel objects like workbooks, worksheets, charts and ranges

• How to perform calculations inside VBA using expressions (formulas), VBA functions and worksheet functions

• How to use VBA to copy/paste data in patterns and fill in tables in Excel

• How to analyze resizing worksheet data on single and multiple worksheets using Microsoft Excel VBA

• How to use VBA and Excel to assemble basic dashboards

• How to use VBA to create charts and pivot tables

• How to build your own custom worksheet functions in VBA for models and analysis problems

• How to use the Visual Basic Macro Recorder and interpret its recordings

• How to create report generation tools in Excel by using Excel VBA to command Word and PowerPoint

• Basic discussion on controlling data in databases, workbooks and text files using ADO, SQL and VBA

Advanced Microsoft Excel VBA Public Seminar Training for Business Professionals

Duration: 3-days

Included: 1800 + page manual , "hands-on" training ,  free repeats

Available: Public Seminar Training Location , Live Online Webinar , Company Onsite , Self-Study Manual

Advanced Microsoft Excel VBA Public Seminar Introduction

Our  3-day "hands-on" Excel VBA public training shows you how to use Excel and VBA to build advanced business analysis tools. Covered is how to use VBA to fully command Excel's business features, ActiveX controls, userforms, charts and pivot tables. Other Excel VBA topics discussed include advanced data processing methods, advanced information control and analysis strategies, advanced modeling, advanced dashboards and controlling databases using SQL. Our workshop also shows how to use VBA to manipulate other programs like Word and PowerPoint as well as other computer languages to gain functionality. Complete Workshop Outline and Signup

In our Advanced Microsoft Excel VBA seminar you will learn:

• A complete review of the VBA language as well as how to use Excel objects, properties and methods

• Advanced control of ranges, worksheets and workbooks using VBA

• How to scan, build, delete and read the Windows filing system using VBA

• How to use advanced VBA functions, worksheet functions and expressions in your code to parse text, analyze times and dates, process data....

• How to process data in multiple workbooks and worksheets including summary table construction using Excel VBA

• How to create, open, read and close text files using VBA

• How to create multiple business charts using VBA

• How to fill in complex business tables and forms using VBA

• How to create event driven programs using VBA including running procedures at a specific time or by pressing specific keys

• How to create advanced business dashboards on worksheets using ActiveX controls, cells, VBA, charts, shapes and userforms

• How to use VBA to control business models, their formulas and names including creating custom worksheet functions (UDFs)

• How to control the Ribbon and create your own custom toolbars to run your code

• How to use VBA, DAO, ADO and SQL to control databases, workbooks and text files

• How to communicate with other languages and programs using Excel VBA

Excel and Excel VBA General Attendance Workshops

Introduction to Microsoft Excel VBA Macros Public Seminar Training for Business, Engineering and Science

Duration: 1-day

Included: 1800 + page manual , "hands-on" training ,  free repeats

Available: Public Seminar Training Location , Live Online Webinar , Company Onsite , Self-Study Manual

Introduction to Microsoft Excel VBA Public Seminar Introduction

Our 1-day "hands-on" Excel VBA training shows you how to use the VBA language to command central Microsoft Excel tasks like formatting, copying, data processing and automated chart/pivot table construction. It discusses VBA language basics like loops, logic and variables and how to use objects, properties and methods to control Excel. Our training allows you to start using VBA with Excel right away. Complete Outline and Signup

In our Introduction to Microsoft Excel VBA Macros seminar you will learn:

• How to use the Visual Basic Editor and its debugger

• Key VBA language topics like Subs, Functions, variables, arrays, loops and logic

• How to control Microsoft Excel with VBA

• How to process data on worksheets using VBA

• How to use VBA to perform worksheet calculations

• How to create charts and pivot tables using VBA

• How to use the Visual Basic Macro Recorder and interpret its recorded code

Microsoft Excel Dashboard Public Seminar Training for Business, Engineering and Science

Duration: 3-days

Included: 1800 + page manual , "hands-on" training ,  free repeats

Available: Public Seminar Training Location , Live Online Webinar , Company Onsite , Self-Study Manual

Microsoft Excel Dashboards Public Seminar Introduction

Our 3-day "hands-on" Microsoft Excel public training shows you first how to create complex dashboards manually using array formulas, data validation, conditional formatting, charts, ActiveX controls and pivot tables. It then discusses how to build adaptive dashboards from macros (VBA) and demonstrates how to use it to control Excel's data features, modeling features, userforms, ActiveX controls, databases and data stored in multiple worksheets and workbooks. Complete Outline and Signup

In our Microsoft Excel dashboards seminar you will learn:

• Advanced formula construction including array formulas that adapt to changing data conditions

• How to construct tables on the worksheet that VBA, SQL and formulas can use

• How to develop formula based Excel dashboards that use ActiveX controls, conditional formatting, data validation, drawing shapes and charts

• How to construct and use names to identify cells and ranges including how to construct dynamic names

• A Microsoft Excel VBA language review emphasizing useful code for dashboard construction and data analysis

• How to command Excel's dashboard elements including drawing shapes, pictures, cells, pivot tables, charts and ActiveX controls using VBA

• How to use VBA to summarize data in multiple workbooks/worksheets

• How to open multiple workbook files and text files automatically using VBA and the Windows filing system

• How to run VBA function procedures from the worksheet (UDFs)

• How to create Excel dashboards that are VBA event driven

• How to communicate with databases (SQL Server, Access, ...) using DAO and ADO

Microsoft Excel Public Seminar Training for Engineers & Scientists

Duration: 1-day

Included: 1800 + page manual , "hands-on" training ,  free repeats

Available: Public Seminar Training Location , Live Online Webinar , Company Onsite , Self-Study Manual

Microsoft Excel Public Seminar Introduction

Our 1-day "hands-on" Microsoft Excel public training focuses on useful formula design in the areas of data processing, analysis and modeling. It discusses formula basics along with advanced formula and array formula design that help engineers and scientists develop sophisticated analytical tools. Also stressed are model construction techniques and the text worksheet functions that allow data to be parsed (split) and cleaned before being analyzed, a huge problem in data processing. In addition to formula construction, how to create your own custom worksheet functions in VBA is also discussed. How to construct interfaces using ActiveX, data validation and conditional formatting is also covered in the workshop. Rounding out the discussion is how to build reports in Excel using pivot tables and linking Excel with Word and PowerPoint. Complete Workshop Outline and Signup

Beginning Microsoft Excel VBA Public Seminar Training for Engineers & Scientists

Duration: 2-days

Included: 1800 + page manual , "hands-on" training ,  free repeats

Available: Public Seminar Training Location , Live Online Webinar , Company Onsite , Self-Study Manual

Beginning Microsoft Excel VBA Public Seminar Introduction

Our 2-day "hands-on" Excel VBA public training discusses the fundamentals of using Excel VBA to create useful tools for the technical community. Our training shows you from an engineering & science perspective the basics of using VBA to control Excel, process resizing worksheet data, control workbooks and worksheets, control ranges, automate forms and tables, create charts, create custom functions, build powerful models, build basic dashboards and more. Complete Workshop Outline and Signup

In our Beginning Microsoft Excel VBA seminar you will learn:

• How to use the Microsoft Excel Visual Basic Editor, its modules and its debugging tools

• A complete review of the VBA language including procedures, variables, loops, logic, arrays, functions...

• A complete review of how technical programs are assembled and laid out in VBA including loop and logic strategy

• How to use VBA to control Microsoft Excel objects, properties and methods

• How to use VBA to analyze technical data that resizes on the Microsoft Excel worksheet

• How to control workbooks, worksheets, ranges and cells using Excel VBA

• How to use VBA functions, worksheet Functions and create expressions (formulas) to perform calculations in your VBA code

• How to fill in form data or tables using Excel VBA

• How to move and reorganize worksheet data using VBA

• How to build basic dashboards for modeling and data analysis

• How to control model information and formulas using Excel VBA

• How to construct custom worksheet functions (UDF's) using Excel VBA (numerical analysis techniques discussion included)

• How to create simple report tools using Excel VBA to control Word and PowerPoint

• How to automatically create engineering and science charts and pivot tables using VBA

• How to find key Excel commands in VBA using the Macro Recorder

• The basics of using ADO, DAO, SQL and VBA to control databases, workbooks and text files

Advanced Microsoft Excel VBA Public Seminar Training for Engineers & Scientists

Duration: 3-days

Included: 1800 + page manual , "hands-on" training ,  free repeats

Available: Public Seminar Training Location , Live Online Webinar , Company Onsite , Self-Study Manual

Advanced Microsoft Excel VBA Public Seminar Introduction

Our 3-day "hands-on" Excel VBA public training shows you how to create advanced data analysis tools, models, database tools, dashboard tools and program integration tools from an engineering & science perspective. Key Excel VBA topics covered include advanced control of Excel's objects, properties and methods, how to process information using advanced worksheet functions and VBA functions in your code, how to process data in multiple workbooks and folders, how to manage and control advanced models, how to use userforms and ActiveX controls to make advanced dashboards, how to control the Windows folder and file system as well as other programs including databases.  Complete Workshop Outline and Signup

In our Advanced Microsoft Excel VBA seminar you will learn:

• A complete VBA language review including the advanced use of logic, loops, variables, arrays and expressions in your code

• Advanced techniques for commanding key Excel objects, properties and methods

• How to command the file and folder system of Windows including the Windows registry using VBA. The registry is a great way to store program information outside a workbook file.

• How to use advanced worksheet functions and VBA functions in your code to process important information like time, dates and lookups and to parse and control text was well

• How to access massive amounts of data using advanced looping and object variable techniques

• Advanced data processing techniques for accessing multiple workbooks and folders including text files

• How to create automated charts

• How to create event driven applications that run when a certain task happens, certain time occurs or key stroke is made

• How to create advanced dashboards for models and analysis tools using charts, shapes, worksheets, pictures, userforms, ActiveX controls and VBA

• How to integrate ActiveX controls and VBA with existing worksheet models that are formula based

• How to create advanced custom worksheet functions for modeling and data analysis purposes

• How to create custom Excel toolbars from userforms and make buttons on the ribbon

• Advanced programming tips for controlling FORTRAN and VB DLL's with VBA

• Advanced VBA programming strategies for communicating with databases, workbooks and text files