ADVANCED EXCEL TRAINING

18, Sep 2025 12:58 AM LIMITED SEATS

---

📊 ADVANCED EXCEL TRAINING

🎓 Master Excel Like a Pro – From Functions to VBA Automation

📘 INTRODUCTION TO EXCEL

• Excel Interface Overview & Navigation
• Selection Techniques for Data
• Must-Know Shortcut Keys

🛠 CUSTOMIZING EXCEL

• Personalizing the Ribbon & Quick Access Toolbar
• Customizing AutoCorrect Settings
• Modifying Default Excel Options

🔢 USING BASIC FUNCTIONS

• SUM, AVERAGE, MAX, MIN, COUNT, COUNTA
• Understanding Cell Referencing (Absolute, Mixed, Relative)

🎨 FORMATTING & PROOFING

• Formatting Numbers, Dates, Text
• Using Format Painter
• Conditional Formatting Rules

➕ MATHEMATICAL FUNCTIONS

• SUMIF, COUNTIF, AVERAGEIF for Dynamic Analysis
• Logical Statements: IF, IFERROR, AND, OR, NOT

🔒 PROTECTING YOUR WORK

• Worksheet, Workbook, and File Protection Techniques

✂️ TEXT FUNCTIONS

• UPPER, LOWER, PROPER, LEFT, MID, RIGHT, TRIM, LEN
• CONCATENATE, FIND, SUBSTITUTE

⏰ DATE & TIME FUNCTIONS

• TODAY, NOW, DAY, MONTH, YEAR
• EOMONTH, WEEKDAY, DATEDIF

📋 ADVANCED PASTE SPECIAL

• Paste Values, Formulas, Formats
• Transpose Data Easily

💡 NEW FEATURES (Excel 2013/2016/365)

• Modern Charts: Treemap, Waterfall, Sunburst, Box & Whisker
• Combo Charts with Secondary Axis
• Power Tools: Power View, Power Map, Forecast Sheet
• Quick Tools: Smart Lookup, Slicers, Quick Analysis

🔍 SORTING & FILTERING

• Multi-Criteria Sorting
• Advanced Data Filtering by Text, Numbers, or Color

🖨️ PRINTING WORKBOOKS

• Page Setup and Print Area
• Headers, Footers, and Page Titles

📐 ADVANCED EXCEL TECHNIQUES

• What-If Analysis: Goal Seek, Scenario Manager, Data Tables
• Data Validation: Custom Rules & Dynamic Dropdowns
• Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH
• Logical & Nested Functions

🔁 PIVOT TABLES

• Creating, Modifying, and Grouping in Pivot Tables
• Calculated Fields & Pivot Charts

🧮 ARRAY FORMULAS

• Understanding and Applying Array Formulas
• Use Cases with IF, LEN, MID, and LOOKUP

📊 CHARTS & SLICERS

• Building Visual Charts: Bar, Line, Pie
• Using Slicers for Interactive Filtering
• Managing Axes: Primary vs. Secondary

📈 EXCEL DASHBOARDS

• Planning & Designing Effective Dashboards
• Adding Interactive Tables, Charts & KPIs

🤖 VBA MACRO

• Introduction to VBA and Automation
• Recording Macros for Routine Tasks
• Writing Simple VBA Scripts with Loops & Conditions

🧠 ADVANCED VBA

• Automating Emails through Excel
• Sheet Manipulation: Merge, Split, Rename
• Building Powerful & Reusable Macros