Microsoft Excel Training – Beginner to Advanced, Hands‑On
Build strong Excel skills with practical, step‑by‑step labs. Start with data entry and formatting, then master formulas & functions, sorting & filtering, PivotTables, charts, and Power Query. Finish by building an interactive mini dashboard.
Duration: 20 hours
Teaching Methodology: Hands-on, step-by-step labs
Course Schedule: Schedule
Fees: $350
Course Mode: Blended – Face-to-face or online via Zoom
 |
 |
 |
 |
DESCRIPTION
This hands‑on Excel course takes you from zero to confident. You will learn the essentials of data entry and formatting, apply formulas and functions, manage and validate data, analyze information with PivotTables and charts, and automate cleanup with Power Query. The course ends with a mini dashboard project.
OBJECTIVES
By the end of the course, you will be able to:
- Navigate the Excel interface, work with sheets, ranges, and named ranges.
- Use core formulas and functions with absolute/relative references.
- Sort, filter, validate, and conditionally format data for insights.
- Build PivotTables/PivotCharts with slicers and timelines.
- Use Power Query (Get & Transform) to import/clean data.
- Create a simple, interactive dashboard for stakeholders.
PREREQUISITES
No prior Excel knowledge is required. Basic computer skills are recommended.
COURSE CONTENTS
01 - INTRODUCTION TO EXCEL
- Excel interface: Ribbon, tabs, name box, formula bar
- Workbooks & sheets; rows, columns, cells, ranges
- Navigation tips & keyboard shortcuts
- Saving, versions, and basic page setup
02 - EXCEL BASICS
- Data entry & formatting (fonts, borders, alignment)
- Number formats: currency, percentage, dates, custom
- AutoFill, Flash Fill, and Quick Analysis
- Basic formulas: SUM, AVERAGE, MIN, MAX, COUNT
- Relative vs. absolute references
03 - WORKING WITH FUNCTIONS
- Logical: IF, AND, OR, IFERROR
- Lookup & reference: XLOOKUP, INDEX, MATCH, VLOOKUP/HLOOKUP
- Text: LEFT, RIGHT, MID, TEXTJOIN/CONCAT, TRIM
- Date & time: TODAY, NOW, DATEDIF, WORKDAY
- Statistics & rounding: ROUND, RANK, STDEV
04 - DATA MANAGEMENT
- Sorting (multi-criteria) & advanced filtering
- Data Validation (drop-downs, rules, input messages)
- Conditional Formatting (formulas, icon sets, color scales)
- Remove Duplicates, Text-to-Columns, Flash Fill
05 - CHARTS & VISUALIZATION
- Basic charts: Column, Line, Pie, Bar
- Advanced charts: Scatter, Combo, Histogram, Waterfall
- Chart elements & formatting; trendlines
- Sparklines & PivotCharts
06 - PIVOTTABLES & PIVOTCHARTS
- Create PivotTables from clean data
- Grouping, calculated fields
- Filters, slicers, and timelines
- PivotCharts for data visualization
07 - ADVANCED EXCEL FEATURES
- Named ranges
- What‑If Analysis: Goal Seek, Scenario Manager, Data Tables
- Power Query (Get & Transform): import, clean, append/merge
- Power Pivot & data modeling (intro)
- Intro to Macros (VBA) – recording simple tasks
- Protecting sheets & workbooks
08 - COLLABORATION & PRODUCTIVITY
- Comments/Notes, Co‑authoring in Microsoft 365
- Linking with Word/PowerPoint
- Import/Export (CSV, Text) and basics of connecting to data
- Printing & page layout best practices
09 - ADVANCED ANALYTICS (OPTIONAL)
- Dynamic arrays: FILTER, SORT, UNIQUE
- Analysis ToolPak (descriptive stats, regression, forecasting)
- Interactive controls (data validation, slicers) for dashboards
10 - FINAL MINI DASHBOARD PROJECT
- Assemble data model (tables, relationships or tidy ranges)
- PivotTables & PivotCharts with slicers
- KPIs with conditional formatting & formulas
- Publish a one‑page dashboard PDF