Advanced Excel

Introduction

Across the globe, millions of job advertisements requiring Excel skills are posted every day. Microsoft Excel software remains one of the most ubiquitous pieces of software used in workplaces around the world. Course Module Topics of this course are as follows.

• Spreadsheet Design and Documentation
• Advanced Formula Techniques
• Data Cleaning and Preparation
• Financial Functions
• Advanced Lookup Functions
• Pivot Tables & Pivot Reporting
• VBA & Macros
• Integrating Excel with other tools & Optimizing Excel

What is VBA?

VBA stands for Visual Basic for Applications. Just like you and I have a language, computer programs too have their own language. VBA happens to be the language in which Excel speaks. For that matter, VBA is also the language of MS Word, PowerPoint, Access and other MS Office applications.

What is a Macro?

While VBA is the language which Excel speaks (and understands), Macro is like a paragraph. In other words, a Macro is a set of instructions given to Excel to accomplish something.

With the help of Skylance’sAdvaced Excel course, it will challenge you as you learn how to use advanced formula techniques and sophisticated lookups. You will clean and prepare data for analysis, and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare you for our big finale, where you will learn how to build professional dashboards in Excel.

Enroll Now