✔ Custom formats & layouts

✔ Advanced formulas & functions

✔ What-if analysis & scenarios

✔ Pivot tables & pivot charts

✔ Workbook sharing and security 

📚 Detailed Syllabus

1️⃣ Apply Custom Formats and Layouts

·        Apply custom data formats

·        Use advanced fill options

·        Advanced conditional formatting & filtering

·        Custom styles & templates

·        Use form controls

·        Prepare workbooks for international use

·        Use outlines & custom views 

2️⃣ Create Advanced Formulas

·        Functions and applying them in formulas

·        Mathematical functions

·        Financial functions

·        Useful data functions

·        Lookup functions

·        Advanced date & time functions

·        Text manipulation functions

·        Arrays 

3️⃣ Use Scenarios and What-If Analysis

·        What-If Analysis tools

·        Create & merge scenarios

·        Create scenario summaries

·        Use data tables

·        Sparkline charts 

4️⃣ Charts and Visualization

·        Basic Excel charts

·        Area, scatter, stock, surface, radar & combination charts

·        Custom chart templates

·        Use sparklines 

5️⃣ Pivot Tables & Pivot Charts

·        Create & customize PivotTables

·        Create PivotCharts

·        Filter, style & analyze data using pivot features 

6️⃣ Manage and Share Workbooks

·        Manage workbook versions

·        Copy styles & macros between workbooks

·        Track changes & comments

·        Merge workbooks

·        Protect workbooks for sharing

·        Connect to external data sources