आरंभ Mastering Excel program is intended to make you Excel champion by acquiring the fundamentals of Excel spreadsheets to perform basic data analysis.

Core & Advanced Excel with Dashboard

MS Excel from beginner to Advance excel, Formulas, Chart tips and Tricks in MS Office and Office 365.

This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery. It’s perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way. The topics we have prepared will challenge you as you learn how to use advanced formula techniques and sophisticated lookups. You will clean and prepare data for analysis, and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare you for your big finale, where you will learn how to build professional dashboards in Excel.

What you will learn:

• Build a solid understanding on the Basics of Microsoft Excel
• Master Microsoft Excel from Beginner to Advanced
• Build financial models from scratch (shown step-by-step)
• Format sheets and charts professionally
• Learn new keyboard shortcuts and be even faster in Excel
• Use Cell Styles and format spreadsheets easier and faster
• Writing Formulas and performing Calculations
• Create charts with Trend Lines, and Dual Axis
• Use Excel as a Database with Sort and Filter options
• How to avoid the most common Database Design flaws
• Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more…
• Updated to include the new FILTER, XLOOKUP, SORT & UNIQUE functions
• Learn several hidden Excel tips and tricks
• Learn to use Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports.
• Learn to make dashboards.