Excel 2016 Functions Bootcamp With 150+ Examples & 1 Project

New: Master the biggest part of Excel with lots of engaging practice problems, assignments and one comprehensive project

Created by: Sam Esmaeili
Microsoft Office Specialist Expert, CSCP

What Will I Learn?

• Master the most used functions of Excel
• Create complex formulas such as advanced VLOOKUPs, INDEX/MATCH, INDIRECT, CHOOSE, OFFSET, SUMPRODUCT, Database Functions, Array Formulas, Complex Dynamic Formulas, Complex Summary Tables, etc.
• Become comfortable with advanced formula-based conditional formatting
• Have access to numerous practice problems and homework assignments
• Combine different functions and create sophisticated formuals and tables to do better and more efficient analysis.
• Have access to great datasets and more importantly AWESOME examples
• Have access to very easy-to-understand and comprehensive guides (PDF)

Requirements

• This course is designed for students that have an introductory knowledge of Microsoft Excel environment.
• You should have Microsoft Excel installed on your computer as there will be lots of exercises to do.

Target audience

• Anyone who is interested in mastering the most powerful functions and formuals in Excel.
• Business and engineering students, as proficiency in Excel is part of almost every job description.
• Anyone who wants to get very comfortable with the biggest and very important part of Excel, which is its functions and formulas.