Tech Bridge-City logo
1 of 4

Microsoft Excel: Beginner to Advanced

Part of Data Analytics Programme

1

Module 1

Microsoft Excel: Beginner to Advanced

2

Module 2

Microsoft Power BI Data Analyst

3

Module 3

Database Engineering with SQL

4

Module 4

Business Intelligence For Professionals

Duration

2 Weeks (12+ Hours)

Classes

3 per week (2 Hours each)

Mode

Hybrid (Online & Onsite)

Certificate

Certificate of Completion

About This Module

This module introduces you to microsoft excel: beginner to advanced and teaches you the essential skills needed to work confidently on real-world projects.

You'll build confidence with practical exercises, guided instruction, and a strong foundation before moving to the next module.

Curriculum Overview

Explore what you'll learn in this module.

1Introduction to Spreadsheet8 Lessons
  • Introduction to Spreadsheets
  • Save Workbooks, Access recent workbooks & Pin workbooks
  • Excel Templates
  • Tabs, Ribbons & Groups
  • Cells, Rows, Columns & Ranges
  • Inputting & Formatting Data
  • Creating Basic Excel Formulas
  • Relative & Absolute Cell References
2Structure of an Excel Function7 Lessons
  • Structure of an Excel Function
  • SUM() Function
  • MIN() & MAX() Functions
  • AVERAGE() Function
  • COUNT() Function
  • Adjacent Cell Errors
  • Auto-sum
3Apply simple Formats3 Lessons
  • Applying Simple Formats
  • Conditional Formatting
  • Named Ranges and Tables
4The IF Command7 Lessons
  • Datasets
  • The IF() Function
  • Nested-IF()
  • IFS() Function
  • COUNTIF() Function
  • SUMIF() Function
  • IF ERROR() Function
5LookUp, Index and Match8 Lessons
  • Datasets
  • VLOOKUP() Function
  • HLOOKUP() Function
  • Submit your Assignment
  • INDEX() Function
  • MATCH() Function
  • INDEX() & MATCH() Functions
  • Submit your Assignment
6Basic Excel Charts A8 Lessons
  • Datasets
  • Basic Excel Charts
  • Pivot Tables
  • Grouping Pivot Tables
  • Calculated Fields in Pivot Tables
  • Filtering Pivot Table Data
  • PivotCharts
  • Filtering with Slicers
7Basic Excel Charts (B)7 Lessons
  • Datasets
  • Dashboard - 1
  • Dashboards - 2
  • PowerPivot
  • Activating the PowerPivot Add-in
  • Data Models with PowerPivot
  • Creating PivotTables from Data Models
8What - IF Analysis5 Lessons
  • Datasets
  • What If Analysis - Goal Seek Tool
  • What If Analysis - Solver Tool
  • What If Analysis - Data Tools
  • What If Analysis - Scenario Manager
9Data Cleaning3 Lessons
  • Datasets
  • Data Cleaning in Excel
  • Importing Data from External Sources - Web Example
10Excel Capstone Project2 Lessons
  • Capstone Project
  • Submit Project

Some of our students work at

astut.jpg
technic-fmc.jpg
confinityai_logo.jpg
seepco.jpg
Transcorp.jpg
eastatlantic-logo.png
descasio-logo.jpg
polar.jpg
communal.png
zeniv8-logo-purple.png

Other Modules in This Programme

Module 2

Microsoft Power BI Data Analyst

Continue building your skills with the next part of this programme.

View Module

Module 3

Database Engineering with SQL

Continue building your skills with the next part of this programme.

View Module

Module 4

Business Intelligence For Professionals

Continue building your skills with the next part of this programme.

View Module

Full Programme

Data Analytics Programme

Unlock all modules and complete the full learning journey.

View Full Programme

Ready to start your journey?

Join thousands of learners building in-demand tech skills.

Enroll Now