Description
Benefits of the course
- 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 to use Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports.
- MIS Reporting
- Learn several hidden Excel tips and tricks
Topics for this course
42 Lessons
ADVANCED ARRAY FUNCTIONS
Basic Examples of Arrays (Using ctrl+shift+enter)
Advanced Use of formulas with Array
Sum product & Aggregate Function
LOOKUP MAHARAJ FUNCTIONS
PIVOT TABLES
INTRODUCTION TO POWER QUERY & POWER PIVOT
CHARTS AND SLICERS
EXCEL REPORTING DASHBOARD
NEW FUNCTION IN EXCEL OFFICE 365
Requirements
- Access to a good internet connection
- Laptop with Microsoft Office Installed
Your Instructor
Sajjad Hussain
MIS & Data Analytics
I am a pro in Excel, Power BI, MIS Reporting & Creating a Visual Dashboard with almost 7 years of corporate working experience.