Advanced Excel
Advanced Excel refers to a higher-level set of skills and tools within Microsoft Excel that go beyond basic data entry and simple formulas. It includes complex functions, data analysis techniques, automation (macros/VBA), and tools used to organize, analyze, visualize, and manage large or complex datasets.
Duration
3 Months
Lectures
24
Projects
4
Course Module
- Introduction to Advanced Excel
- Overview of Excel interface (advanced options)
- Workbook & worksheet management
- Customizing Ribbon & Quick Access Toolbar
- File formats, templates, and security options
- Advanced Formulas & Functions
- Pen Tool , Gradient, Direct & Path selection Tool.
- Data Cleaning & Data Management
- Data validation
- Sorting & filtering (multi-level and custom filters)
- Working with large datasets efficiently
- PivotTables & PivotCharts
- Grouping, filtering, drill-down
- Calculated fields & items
- Building PivotCharts for analysis
- Refreshing data and linking data sources
- Data Analysis Tools
- Goal Seek, Scenario Manager, Data Consolidation & Solver
- Forecast functions & trend analysis
- Advanced Charting & Dashboard Design
- Dynamic charts, Combo charts, Sparklines
- Using shapes & form controls
- KPI charts, Dashboard layout techniques
- Linking charts with slicers & PivotTables
- Excel Automation (Macros & VBA)
- Recording and editing macros
- VBA editor basics
- Writing simple VBA scripts
- Automating repetitive tasks
- Creating custom functions (UDFs)
- Power Query basics (Get & Transform Data)
- Cleaning & transforming data with Power Query
- Introduction to Power Pivot
- Data Model & relationships, DAX fundamentals
- Budget planning, Expense tracking, Sales/Profit analysis, ROI calculations
Admission is going on
Join our exclusive program and take the first step toward building your future. Seats are limited, so don’t miss this opportunity to learn valuable skills, gain hands-on experience, and boost your career.
Why is this course the best for you?
Data-analysis & decision-making power
You’ll be able to process large volumes of data, summarise, visualise, and draw insights. This helps whether you manage finances, track business metrics, do content/ data-heavy work, or need to present data clearly.
Efficiency & automation — less manual work
With formulas, macros, and automation tools (VBA), you can speed up repetitive tasks (report generation, data cleaning, formatting), saving time and reducing errors.
Data Analysis & Summarization
Using tools like PivotTable / PivotCharts, sorting/filtering, summarizing large datasets, grouping data, consolidating data, etc.
Business / Financial Modeling & What-If Analysis
Building budgeting, forecasting or financial models; running scenario analysis; using features like What-If, Goal Seek, data-driven decision modeling.
This Course is only for
Students
Job Hunters
Housekeeper
Anyone interested
immigrants
Students Reviews
Umma Abiha Arza
Arin Rajbongshi
Roksana Akter
Graphic Designer
Behance