Advanced Excel & VBA for Business Analytics

"A Business Analyst Career is one of the top-paying entry-level jobs on the market.” 

"Even in the toughest job markets, the best candidates find great positions.", Forbes

You simply have to find a way to acquire practical skills that will give you an edge over the other candidates.

But how can you do that?

You haven’t had the proper training, and you have never seen how analysts in large firms do their work ...

Stop worrying, please! We are here to help.

At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

• Creating effective spreadsheets

• Managing large sets of data

• Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)

• Create dynamic report with Excel PivotTables

• Unlock the power and versatility of Microsoft Excel's AddIn, PowerPivot

• Audit Excel Worksheet formulas to ensure clean formulas

• Automate your day to day Excel tasks by mastering the power of Macros and VBA

• Understand how to use the right syntax in VBA

• Useful Excel VBA codes you can directly use for your work

• Use the macro recorder for simpler tasks and improve the code

• Working with the Visual Basic Editor

• Debugging tools and error handling methods

• Different ways to reference ranges and cells

• Different methods to loop

• How to work with data types

• PivotTables in Excel using VBA

• Importing data from other files and exporting data to text files

• Interacting with other applications (Word, PowerPoint, Outlook)

• ActiveX and Userforms to enhance the Excel interface

• Basically all the knowledge you need to automate tasks in Excel