Description

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.”, ForbesYou 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 havent 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 spreadsheetsManaging large sets of dataMastering 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 PivotTablesUnlock the power and versatility of Microsoft Excel’s AddIn, PowerPivotAudit Excel Worksheet formulas to ensure clean formulasAutomate your day to day Excel tasks by mastering the power of Macros and VBAUnderstand how to use the right syntax in VBAUseful Excel VBA codes you can directly use for your workUse the macro recorder for simpler tasks and improve the codeWorking with the Visual Basic EditorDebugging tools and error handling methodsDifferent ways to reference ranges and cellsDifferent methods to loopHow to work with data typesPivotTables in Excel using VBAImporting data from other files and exporting data to text filesInteracting with other applications (Word, PowerPoint, Outlook)ActiveX and Userforms to enhance the Excel interfaceBasically all the knowledge you need to automate tasks in Excel