The Plus Course is designed for regular users of Excel, be it for personal or professional work. The course assumes that you are aware with the basic functionality of Excel and can use a variety of Excel functions.

This course focuses on the advanced analytical features. You will learn to save time with Excel Tables, work with multiple files and create portfolios. You will summarize data with Subtotals, analyze with Data Tables, Scenario Manager and Goal Seek.

Finally, you will learn to protect your work for structural changes and confidentiality.

After successfully completing this course, you should be able to do the following.

• Organize data quickly
• Create quality worksheets
• Construct formula confidently
• Analyze data for insights
• Scale-up to handle multiple files
• Summarize to conclude
• Perform sensitivity analysis

Apply your learnings to accomplish tasks in real life. Some are mentioned below.

• Calculate EMI and loan repayment schedule
• Build and update Product Portfolio
• Perform common administrative tasks
• Track Budget vs Actuals
• Roll-up monthly cashflows to quarters and years
• Analyze your expenses