MS Excel Masterclass – Excel Essentials To Applications

Excel in Microsoft Excel Starting From The Basics to Advanced With Real World Practical Applications Included

Created by: AllQuant .
Investing Made Simple, Bridging The Knowledge Gap

What Will I Learn?

• Master Microsoft Excel starting from the Basics to Advanced
• Build Microsoft Excel real world applications - personal expense tracker, mortgage calculator, revenue dashboard, perform trend and correlation analysis
• Use Microsoft Excel Macros to automate tasks in Excel
• Use PivotTable to easily manipulate and display data
• See how Microsoft Excel Solver can be used to solve complex problems such as optimization
• Perform data lookups in Microsoft Excel using various lookup functions such as VLOOKUP, HLOOKUP, INDEX, MATCH, OFFSET, etc.
• Use Microsoft Excel logic functions such as IF, AND, OR to apply decision making rules
• Perform basic mathematical to advanced statistical operations such as regression and correlation in Microsoft Excel

Requirements

• No prior knowledge in Microsoft Excel is required. You will learn what you need in this course.
• Recommended: Microsoft 2013 or later

Target audience

• Anyone from beginner to advanced who is keen to learn more about how to use Microsoft Excel