Microsoft Excel Intermediate to Advanced: From Formulas to Smart Insights
Microsoft Excel Intermediate to Advanced: From Formulas to Smart Insights
Target Audience: Users with basic Excel knowledge looking to enhance skills for business, data analysis, and reporting.
Course Objectives
- Master Excel functions & formulas beyond the basics
- Perform advanced data analysis using PivotTables and Power Query
- Build interactive dashboards and reports
- Derive insights using Excel’s built-in tools and AI features
Course Modules
Module 1: Excel Refresher (Optional Pre-Assessment)
- Quick review: cell references, basic formulas
- Best practices in workbook structuring
Module 2: Intermediate Formulas & Functions
- Logical: IF, IFS, AND, OR, IFERROR
- Lookup: VLOOKUP, HLOOKUP, XLOOKUP, INDEX + MATCH
- Text: LEFT, RIGHT, MID, TEXTJOIN, TEXT, CONCAT
- Date & Time: TODAY(), NOW(), DATEDIF, NETWORKDAYS
- Named Ranges and Dynamic Named Ranges
Module 3: Data Validation & Conditional Formatting
- Drop-down lists and dynamic validation
- Using formulas in data validation
- Advanced conditional formatting with formulas
Module 4: Data Tools & Management
- Remove duplicates, text to columns
- Flash Fill and AutoFill
- Sorting and Custom Filters
- Grouping and Subtotals
Module 5: Pivot Tables & Pivot Charts
- Creating and customizing PivotTables
- Calculated fields & items
- Slicers and Timeline filters
- PivotCharts for visual analysis
Module 6: Data Analysis with Power Query
- Introduction to Power Query (Get & Transform)
- Importing data from Excel and external sources
- Data shaping: merge, append, transform
- Creating reusable query steps
- Basic error handling and cleanup
Module 7: Dashboard Creation & Design
- Planning your dashboard
- Key components: KPIs, Charts, Interactivity
- Building dynamic dashboards using:
- Form controls (dropdowns, checkboxes)
- PivotTables & Slicers
- Dynamic charts
- Tips for clean, responsive design
Module 8: Advanced Charting Techniques
- Combo charts
- Sparklines
- Bullet charts
- Conditional charts
Module 9: Excel’s Smart Insights & AI Features
- Ideas in Excel (Automated insights)
- Quick Analysis tool
- Data Types (Linked data e.g., stocks, geography)
- Forecast Sheet
- Goal Seek & Scenario Manager
Details
Start :
23 July 2025 @ 9.00 AM
End :
24 July 2025 @ 5.00 PM
Event Category :
Microsoft Excel
Organizer
Smart Training Solutions
Phone :
+60 11-6367 5521
Email :
ikmal@smarttraining.my
Smart Training Center
01-26, Tingkat 1, Kompleks Permaisuri Q, Jalan Sri Permaisuri, Bandar Sri Permaisuri, 56000 Cheras, Wilayah Persekutuan Kuala Lumpur.
Smart training solutions (STS), a company specializing in providing comprehensive training and consultancy services in Information Technology (IT) and Human Leadership Soft Skills.
CONTACT US
- training@smarttraining.my
- +603-91339006
- Cheras Business Centre (Block G) Jalan 3/101C Batu 5, Cheras 56000 Kuala Lumpur