Excel Training, Excel VBA Training, Excel Software Design

Microsoft Excel-Aided Business
for All Business Professionals

Microsoft Excel-Aided Business
Onsite Only

Learn to build useful business tools that will solve your business problems.

Our 4-day "hands-on" Microsoft Excel-Aided Business workshop shows you the steps and strategies behind using Microsoft Excel and VBA to produce business tools that do days of work in seconds. This workshop takes key Excel topics like advanced formula design, key worksheet functions, Excel's data processing features, pivot tables, charts, dashboards and VBA macros and condenses them into one course. Excel for Mac users welcome.

Microsoft Excel-Aided Business: Focus

Microsoft Excel-Aided Business: Focus

Microsoft Excel along with its programming language called VBA (macros), has vast potential for the creation of business tools that save time and money. Most of the time in business, this potential goes unused however. For example, just simple worksheet data layout, the use of cell and range names and proper formula design allow sophisticated worksheets to be laid out that adapt to changing data table size and header movement. In another example, just knowing the basic application of VBA and how it can be used to control Excel will enable applications to be built that formula design alone could never achieve. This workshop takes the most important Excel and VBA topics and condenses them into a 4 day course.


Microsoft Excel-Aided Business: Who Should Attend?

Microsoft Excel-Aided Business: Who Should Attend?

Select this workshop if you or your group have:

  • Opened or saved a workbook
  • Learned about worksheets, cells and cell references like A1
  • Copied and pasted worksheet data
  • Performed basic cell formatting tasks
  • Typed data in cells and built basic formulas
  • Used a worksheet function like SUM, COUNTIF...

Microsoft Excel-Aided Business: Outline

Important: We focus our training on what our customers need. This training can be taught many different ways focusing on basically any Excel topic. Below is a rough outline with some of the more popular topics that companies choose for training. We will custom design the training around your needs.



Day-1

Microsoft Excel-Aided Business: Free Repeats Policy
  • How to build basic formulas on the worksheet and perform formula debugging
  • How to name cells and ranges for use in formulas
  • How to construct proper data tables in Excel that formulas and Excel's data tools can use
  • How to use key Microsoft Excel worksheet functions like SUMIF, VLOOKUP, COUNTA...
  • How to nest Microsoft Excel worksheet functions, key to creating advanced formulas
  • How to construct Microsoft Excel worksheets that "think" using Excel's logic, information and lookup and reference functions including VLOOKUP, SUMIF, INDEX, MATCH, COUNTIF, SUMIF, IF, AND, OR, ROUND, IS and INDIRECT
  • How to use basic sheet formatting, conditional formatting, data validation, charts and formulas to build a basic dashboard on the Excel worksheet
  • How to perform text concatenation in Microsoft Excel worksheet formulas, very important for building advanced formulas
  • How to use Microsoft Excel's data management tools like sort, form, autofilter and advanced filter tools
  • How to use Text Wizard to open a text file
  • How to create and use Microsoft Excel pivot tables


Day-2

  • How to use conditional formatting, data validation and VLOOKUP to make Excel worksheets behave like a database
  • How to create advanced formulas that adapt to changing worksheet conditions using key worksheet functions like IF, SUMIF, INDEX, INDIRECT, COUNTIF, ROW, COLUMN, ROWS, COLUMNS, MATCH, COUNTA, OFFSET, ADDRESS, AND, OR and the IS Functions
  • How to build formulas for cell names that adapt to changing data size on the worksheet
  • How to create advanced array formulas that automatically seek out data patterns, find start and stop points, compare lists of names...etc
  • How to use ActiveX controls, formula driven conditional formatting, formula driven data validation, array formulas, drawing shapes and charts to create advanced dashboards on the Microsoft Excel worksheet
  • How to work with time formulas on the Microsoft Excel worksheet including the TEXT function
  • How to link workbooks and worksheets together including team and network issues
  • How to access text files, other Excel workbooks and external databases from Microsoft Excel using Microsoft Query and ODBC
  • How to use Excel VBA (macros) including creating custom worksheet functions


Day-3

  • How to use the VBA Editor including debugging
  • How to use VBA projects, modules and procedures
  • How to use VBA including variables, data types, constants, arrays, operators, expressions, loops, logic decisions and calling
  • How to command Excel using VBA including a discussion of objects, properties and methods
  • How to analyze business data on a single Excel worksheet using loops and logic
  • How to use Excel VBA to load Excel templates using loops, logic and copying and pasting
  • How to use VBA to control and manage your formula based models
  • How to use VBA to create charts


Day-4

  • How to use the Excel Visual Basic macro recorder to record Excel tasks in VBA and then interpret the code
  • How to analyze and summarize data in multiple workbooks and worksheets
  • How to access the Windows file and folder system to open and close workbooks
  • How to protect your code against errors
  • How to use Excel VBA to create advanced dashboards
  • How to analyze business data on a single Excel worksheet using loops and logic
  • How to automate pivot tables with Excel VBA
  • How to create basic report generation tools using Excel VBA, Microsoft Word and PowerPoint

Microsoft Excel-Aided Business: Additional Information

Additional Microsoft Excel-Aided Business Training Information

  • Duration: 4-days
  • Our workshops cover Excel versions 2007-2016 including Excel for Mac and discuss differences when necessary.

Included in Our Microsoft Excel-Aided Business Training

  • Free Repeats
  • 1800+ page manual filled with key Excel strategies, examples and tips
  • Hands-on training
  • Personal questions answered

Microsoft Excel-Aided Business Training Formats

Onsite Only

Microsoft Excel Aided Business: Question Form

Instructions: Please fill in your contact information.

Name:
Company:
Company Web:
Country:
Phone #:
Ext:
e-mail:
Contact me directly by phone

Please fill out the box below with your workshop questions and EMAGENIT will contact you.

Request Workshop Information (Optional)


Send me on-site workshop information Send me self-study manual information
Send me public seminar workshop information Send me live online webinar information

Privacy Policy



Site Map

Copyright © 2002-2017

EMAGENIT All Rights Reserved