This course provides an overview of Business Analytics using a hands-on approach using one of the most popular Analytics tools in the industry, viz. MS-Excel. This part would cover MS Excel from the basics to point where the learners can make meaningful and actionable Analytics Dashboards in MS Excel.

The Course also covers integrating MS Excel with another powerful tool from Office 365 suite – MS PowerPoint – to help managers and analysts present the findings in a powerful and meaningful manner. We will cover the basics of making a good presentation along with the Dos and Don’ts.

The course will end with an end-to-end analysis experience with a hands-on capstone project to demonstrate the learning and boost learner confidence.

During this instructor-led, hands-on course, you will learn to:

• Understand the need for and jargon of Analytics
• Know the most common Analytics tools and their usage
• Prepare and maintain Excel spreadsheets
• Perform data analysis using sorting and filtering 
• Using basic formulas and functions in Excel
• Perform data mining using conditional statements
• Perform basic analysis with What-If analysis tools
• Create references between tables and search for information with Lookup functions
• Perform data analysis using PivotTables
• Secure data and structure of excel files using Protection feature
• Automate work using macros and VBA
• Use MS PowerPoint to create powerful presentations
• Complete a capstone project with a presentation of the summary of your analysis