Microsoft Excel Complete Course

Welcome to the Learn Microsoft Excel from A-Z: Beginner To Expert Course

In this practical, hands-on course our main objective is to give you the education not just to understand the ins and outs of Microsoft Excel, but also to learn exactly how to master pivot tables, formulas, macros, vba, data analysis, and how to land your first job as an Excel expert!

This course will fully prepare you for virtually any Excel related career path, including those that require advanced skills with this software. Once you complete the course, you’ll have access to the full functionality of Excel, and will know how to use all formulas, functions, and capabilities.

You’ll also learn about calculating depreciation, calculating interest, and even calculating EMI for loans, all by using Excel functions. The course also features information on INDEX and MATCH functions as well as using the CHOOSE formula, and how to create special charts.

Whether you are brand new to the world of Excel, or you have training and knowledge of the software and are looking to improve your skills, this masterclass will take you to the next level. By the time you finish the beginner, intermediate and advanced portions, you too will be an expert in Excel.

We understand that theory is important to build a solid foundation, we understand that theory alone isn’t going to get the job done so that’s why this course is packed with practical hands-on examples that you can follow step by step. Even if you already have some experience, or want to learn about the advanced features of Excel, this course is for you!

What you’ll learn

• Learn to master Excel from A-Z
• How to become a professional Data Analyst
• How to be a better, faster, stronger Excel user
• How to land your first job as an Excel Expert
• How to save hours of time and boost your productivity in Excel
• How to find a value with VLOOKUP, HLOOKUP, INDEX, MATCH
• How to use math, statistical, logic and text functions
• How to use VBA and Macros
• How to use VLOOKUP/HLOOKUP in formulas
• How to create basic and advanced formulas
• Mastering Pivot Tables
• Creating Charts from your data

Requirements

• basic computer skills