Live Online Microsoft Excel and Microsoft Excel VBA Webinars | Webcasts

Intermediate Microsoft Excel Online Webinar | Webcast Training for Business Professionals

Duration: 1-day

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

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

Intermediate Excel Webcast | Webinar Introduction

Our 1-day "hands-on" online webinar | webcast training focuses on useful formula design in the areas of data processing and analysis. Covered are the key Excel worksheet functions that perform table lookups, analyze logic and parse worksheet text. Also discussed are Excel's data analysis features, pivot tables, naming cells/ranges and basic dashboard construction. Complete Workshop Outline and Signup

In our Intermediate Microsoft Excel online workshop you will learn:

• How to build formulas, debug them and how to name cells and ranges

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

• How to use the VLOOKUP, HLOOKUP, MATCH, INDEX and INDIRECT worksheet functions to perform table lookups

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

• How to build formulas that think using logic functions like IF, OR, AND

• How to build self-adjusting summary formulas that switch tables and track changing header movement

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

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

• How to use Auto Filter, Advanced Filter, Text to Columns and Text Wizard

• How to link Excel to Word and PowerPoint for reports

• How to construct basic pivot tables

Advanced Microsoft Excel Online Webinar | Webcast Training for Business Professionals

Duration: 1-day

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

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

Advanced Excel Webcast | Webinar Introduction

Our 1-day "hands-on" online webinar | webcast training discusses how to create complex solutions in Microsoft Excel in the areas of data processing, dashboard construction and analysis. The webcast focuses on how to build advanced formulas and array formulas from key worksheet functions like MATCH, INDEX, SUM, ROW, COLUMN, IF... Also discussed is how to build names and formulas that adapt to changing data size and headers. It also focuses on combining and using all of Excel's features like ActiveX controls, Data Validation, Conditional Formatting, pivot tables, charts and drawing shapes in your problems in ways you have not seen before. Also reviewed is an introduction to macros (VBA). Complete Workshop Outline and Signup

In our Advanced Microsoft Excel online workshop you will learn:

• How to build advanced array formulas, advanced formulas and use cell and range names

• How to properly layout worksheet data so it can be used in advanced formulas and as a database

• How to perform data summaries on multiple sheets using formulas that shift to changing table sizes, moving headers and start stop points

• How to work with time on the worksheet

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

• How to communicate with databases, text files and workbooks using Microsoft Query

• How to link separate workbooks and worksheets

• How to link with other applications like Word and PowerPoint

• How to import text files

• How to create advanced pivot tables

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

Beginning Microsoft Excel VBA Online Webinar | Webcast Training for Business Professionals

Duration: 2-days

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

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

Beginning Microsoft Excel VBA Webcast | Webinar Introduction

Our 2-day "hands-on" online webinar | webcast training training shows you how to create helpful business tools using Excel and VBA that save time, effort and money. Provided in the webcast is a complete review of the VBA language as well as a review of Excel objects, properties and methods. After the basics, the webcast goes into how to command key Excel program elements, process data, perform basic calculations, create charts, build pivot tables, build basic dashboards, command Word / PowerPoint and more. Complete Workshop Outline and Signup

In our Beginning Microsoft Excel VBA online workshop you will learn:

• How to debug and use the VBA Editor and how to use projects, modules and procedures

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

• How to incorporate loops and logic in your Excel VBA code as well as strategies for assembling programs in VBA

• How to use VBA to control key Microsoft Excel tasks like sorting, filtering, formatting, moving data...

• How to use Excel VBA control workbooks, worksheets and ranges

• How to perform worksheet model and data calculations in VBA using VBA functions, worksheet functions and expressions (formulas)

• How to evaluate data with changing data boundaries using VBA

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

• How to use Excel VBA to create, manage and format basic charts and pivot tables

• How to use Excel features along with VBA to create basic dashboards that control models and data

• How to use Excel VBA to build your own custom worksheet functions for modeling and data analysis purposes

• How to use VBA to create basic report generation tools that use Word and PowerPoint

• How to use the Visual Basic Macro Recorder and interpret its recordings in a useful way

• A simple discussion on how to use ADO, SQL and VBA to control databases, workbooks and text files

Advanced Microsoft Excel VBA Online Webinar | Webcast Training for Business Professionals

Duration: 3-days

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

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

Advanced Microsoft Excel VBA Webcast | Webinar Introduction

Our  3-day "hands-on" online webinar | webcast training shows you how to construct advanced business analysis tools in Excel using VBA. Key Excel VBA topics focused on in the webcast include advanced control of Excel's tools including pivot tables and charts, advanced data processing and analysis methods, advanced modeling, how to control ActiveX controls and userforms, advanced dashboards, advanced information management strategies and advanced database command. Our webcast shows not only how to manage Excel using VBA, it also shows how to use VBA to tie into other programs like PowerPoint and Word as well. Complete Workshop Outline and Signup

In our Advanced Microsoft Excel VBA online workshop you will learn:

• A complete review of both the VBA language and Excel object, properties and methods

• How to use VBA to manage and access the Windows folder/file system and Windows registry

• How advanced expressions, worksheet functions and VBA functions can be used in your code to manage text, calculate times/dates, process data....

• Advanced VBA control strategies for worksheets and workbooks including how to track multiples of them at once in your code

• Advanced VBA data processing techniques for data stored in multiple worksheets, workbooks and folders including summary table construction

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

• Advanced Excel VBA programming strategies for creating and managing charts and pivot tables

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

• How to use Excel and VBA to create event driven programs including programs that run by pressing keys or run at a specific time/date

• How to use VBA to control models, formulas and cell names including how to design custom worksheet functions (UDFs)

• How to use VBA to create your own custom toolbars that run your programs

• How to control the Excel Ribbon using VBA

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

• How to use VBA to communicate with other programs and languages including controlling Word and PowerPoint for report generation tools

Introduction to Microsoft Excel VBA Macros Online Webinar | Webcast Training for Business, Engineering and Science

Duration: 1-day

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

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

Introduction to Microsoft Excel VBA Macros Webinar | Webcast Introduction

Our 1-day "hands-on" online webinar | webcast training shows you how to use VBA to control key Microsoft Excel tasks like formatting, copying and pasting, data processing and automated chart and pivot table construction. It discusses the basics of the VBA language like loops, logic and variables then discusses how to use object properties and methods to control Excel. It is the essential information that you need to start leveraging VBA right away. Complete Outline and Signup

In our Introduction to Microsoft Excel VBA macros online workshop you will learn:

• How to use the Visual Basic (VBA) Editor along with its debugging tools

• How to use the VBA language including Subs, Functions, variables, arrays, loops and logic

• How to use VBA to command Microsoft Excel

• How to process data with VBA

• How to use VBA to perform 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 Dashboards Online Webinar | Webcast Training  for Business, Engineering and Science

Duration: 3-days

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

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

Microsoft Excel Dashboards Webinar | Webcast Introduction

Our 3-day "hands-on" online webinar | webcast training first shows you how to create sophisticated dashboards manually using advanced formulas, data validation, conditional formatting, charts, ActiveX controls and pivot tables. It then shifts towards macros (VBA) and demonstrates how to build adaptive dashboards that 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 online workshop you will learn:

• Advanced formula construction including array formulas that adapt to changing data size, header positions and start stop positions

• How to construct correct worksheet tables that VBA, SQL and advanced 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 dashboard construction and processing data

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

• How to use VBA to summarize multiple workbook/worksheet data

• How to use VBA and Excel's dashboard capabilities to tie into your existing worksheet models

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

• How to create event driven Excel dashboards using VBA

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

Microsoft Excel Online Webinar | Webcast Training for Engineers & Scientists

Duration: 1-day

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

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

Microsoft Excel Webinar | Webcast Introduction

Our 1-day "hands-on" online webinar | webcast training focuses on building formulas for advanced data processing, analysis and modeling. The webinar discusses the formula basics along with cell naming and then proceeds into array formulas and advanced formulas. These powerful formulas that use nested worksheet functions and arrays of information are the backbones to helping engineers and scientists develop sophisticated analytical tools. Also stressed is model construction techniques and the worksheet data layout. 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 Online Webinar | Webcast Training for Engineers & Scientists

Duration: 2-days

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

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

Beginning Microsoft Excel VBA Webinar | Webcast Introduction

Our 2-day "hands-on" online webinar | webcast training discusses the key uses of Excel and VBA in the development of useful, time saving engineering and science tools. Our training shows you from an engineering & science perspective the fundamentals of using VBA to process and reconcile technical data, command Excel, control worksheets and workbooks, control ranges and cells, create charts, create custom worksheet functions, construct powerful models, build basic dashboards and more. Complete Workshop Outline and Signup

In our Beginning Microsoft Excel VBA online workshop you will learn:

• How to use the Visual Basic Editor and its debugging tools

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

• How to use loops and logic to control program operation as well as how to put together a technical program in VBA

• How to use Excel VBA to control Excel through the use of its objects, properties and methods

• How to use worksheet functions, expressions (formulas) and VBA functions to perform technical calculations in VBA

• How to use VBA to control workbooks, worksheets and ranges

• How to fill in technical forms and tables using VBA

• How to analyze engineering and scientific worksheet data and adjust to its changing size using Excel VBA

• How to use Excel VBA to reorganize data on the worksheet

• How to use Excel and VBA to construct basic data analysis and modeling dashboards

• How to control and manage worksheet based models and their formulas using VBA

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

• How to use VBA to command PowerPoint and Word on a basic level for report generation

• How to use VBA to manage technical chart and pivot table construction

• How to use the Macro Recorder to discover key Excel commands used in VBA

• Basic control of databases, workbooks and text files using ADO, DAO, SQL and VBA

Advanced Microsoft Excel VBA Online Webinar | Webcast Training for Engineers & Scientists

Duration: 3-days

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

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

Advanced Microsoft Excel VBA Webinar | Webcast Introduction

Our 3-day "hands-on" online webinar | webcast training shows you how to develop advanced engineering & science models, data analysis tools, database tools, dashboard tools and program integration tools. Important VBA topics covered include advanced control of Excel's objects, properties and methods, how to analyze technical information using advanced worksheet functions and VBA functions in your code, how to analyze data in multiple workbooks and folders, how to manage and control advanced models, how to make advanced dashboards from ActiveX controls and userforms, 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 online workshop 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 use Excel VBA to control command the Windows registry and Windows folder/file system. The registry is a great place to store program information from a workbook file.

• How to process important information like time, dates, lookups and text using advanced worksheet functions and VBA functions in your code

• Advanced looping and object variable techniques for accessing massive amounts of technical data

• How to use Excel VBA to access data in multiple workbooks and folders including text files

• How to use Excel VBA to create automated technical charts and pivot tables

• How to develop programs that run at a certain date/time, keystroke or event like somebody typing on a worksheet or when a workbook opens

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

• How to control worksheet models and their formulas using ActiveX controls and VBA

• 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