Course Overview
Learning Outcomes
- Managing and Organizing Complex Excel Data
- Professional Data Analysis & Visualization
- Advanced Reporting & Presentation Skills
- Sharing and Collaborating on Excel Workbooks
- Data Protection & High-Level Security Management
What We Provide
- Premium Web Resources
- Practical Practice Files (Hands-on training)
- Real-world Practical Project Solutions
- Evaluation Tests & Career Guidance
- 100+ Practice Files & Shortcuts List
Course Curriculum
Module 1: Concept of Data Science & Dashboard
- Desktop, Web, and Server Data Integration (SQL, MYSQL, Oracle)
- Connecting with Google Sheets & Access Database
- Aggregation Functions & Dashboard Basics
- Introduction to Power BI Data Analysis
Module 2: PivotTables, Slicers, and PivotCharts
- Chart Features, Modification, and Formatting
- PivotTable for Calculations, Forecasting, and Advanced Reporting
Module 3: Tally/Software Data Shaping & Trimming
- Data Delimitation and Fixed Width adjustment
- Case Change, Formatting, and Data Mining techniques
Module 4: Presenting Data with Formatting & Filters
- Advanced Conditional Formatting using Formulas
- Advanced Sorting, Filtering, and Managing Hidden Data
- Understanding References (Relative, Mixed, Absolute)
Module 5: Essential Functions & Formulas
- Logical Functions (IF, AND, OR, IFS, Nestedifs)
- Advanced Lookup (Vlookup, Hlookup, Xlookup, Index & Match)
- Mathematical Aggregations (Sumfs, Countifs, Averageifs, Rank)
Module 6: Advanced Reporting & Printing
- Using Subtotal, Sumproduct, and Tables
- Data Delamination and Professional Custom Printing
Module 7: Date, Time & Timeline Tools
- Date and Time Functions & Duration Calculations
- Implementing Interactive Timelines in Excel
Module 8: Protections & Formula Auditing
- Worksheet & Workbook Protections
- Auditing Formulas and Managing diverse Excel Errors (N/A, REF!, etc.)
Module 9: Financial Analytics
- Key Financial Functions: PMT, PV, FV, and related options
Module 10: Power Query, Macros & Advanced Sharing
- Using Power Query for Data Trimming, Merging, and Appending
- Concept of Macros for task automation
- Consolidation and Viewing Multiple Worksheets simultaneously
- Exclusive: 100+ Practice Files & Shortcuts List Included
