1. 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 and High-Level Security Management.

• What We Provide (আমরা যা প্রদান করব):

  • Premium Web Resources.

  • Practical Practice Files (Hands-on training).

  • Real-world Practical Project Solutions.

  • Evaluation Tests & Career Tips.

২. 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.

  • 100+ Practice Files & Shortcuts List.