VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft� Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users.

This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.

Learn how to load, shape, model, analyze, and visualize data using Excel's new Business Intelligence features set.

Participants explore four cornerstones of data analysis within the Excel BI suite. The Query Editor (M-code), dimensional data modeling, DAX analytics and creating rich pivots and dashboards.

Investigate a collection of specialized features specifically designed to capture and analyze data. See how simple it can be to flag, consolidate, capture, summarize, and scrutinize large (and small) collections of data.

Data Analysis Features is a must for anyone who needs to assimilate and manipulate large collections of data to interpret and better understand its� story.

This course is built for Power BI for Excel Designers that will be responsible for taking basic PowerPivot data models turning them into power business intelligence solutions.

Boost confidence and productivity by learning how to work in Excel using best practice procedures. Get the inside scoop on how to accomplish tasks using the most efficient and effective means. Find out how to create, modify, format, and distribute workbook files using all the critical time saving tips and tricks.

Getting up to speed with Excel is an ideal course for savvy computer users who use Excel regularly but know they can get more out of the program

Extend your capabilities by learning how to use a collection of features that go well beyond the basics. Examine specialized features to manage large data files, perform 3-dimensional operations, use more functions, create charts, and administer workbook files.

Handy Features, Tips and Tricks is the perfect course for individuals who are comfortable with the fundamental features but need to capitalize on a using Excel to complete a broader range of tasks.

Acquire the deepest level of knowledge and skills to use the full complement of features in Excel.

This comprehensive course incorporates all Excel content needed to pass the Microsoft Office Certification exam. It includes 6 1/2 day sesisons. Call for Date Details.

Examine and learn how to use some of Excel�s coolest and most sophisticated components. Explore how to automate tasks using the top Logical and Lookup functions. Investigate how to create dynamic named ranges, mixed absolute cell references, and how to automate tasks using macro technologies.

Power User Formulas and Features isn�t for the faint hearted. It�s a great choice for power users who want to build automated tools.

Learn how to create custom procedures using Visual Basic for Applications (VBA programming) to build user forms and applications in Excel.

Excel Programming with Visual Basic is the best choice for persons who need to build custom macros that go beyond the built-in macro recorder.