Insight & Skills for Work and Business

Menu
BOOST YOUR CAREER OR BUSINESS WITH MICROSOFT EXCEL
profile
Instructor

Course Creator

Reviews 0 (0 Reviews)
Course Overview

Are you ready to boost your career and become a sought-after professional? This comprehensive Microsoft Excel training takes you from the very basics to advanced techniques, giving you the skills you need to excel in today’s competitive job market. We understand the unique challenges and opportunities in Africa, and this course is designed to empower you with practical, in-demand skills.

We start with the fundamentals, building a strong foundation that will serve you throughout your career. As you progress through each lesson, you’ll master essential Excel tools, making your daily tasks easier and more efficient. You’ll move from basic concepts to intermediate and advanced topics, gaining the expertise to tackle complex challenges.

By the end of this course, you’ll confidently use the most popular Excel tools to complete any task efficiently and professionally. Here are just a few of the skills you’ll gain:

  1. Creating effective spreadsheets for various purposes.
  2. Managing and analyzing large datasets with ease.
  3. Mastering essential Excel functions like SUM, VLOOKUP, IF, AVERAGE, MATCH, and many more.
  4. Creating dynamic reports using Excel PivotTables.
  5. Auditing Excel formulas for accuracy and efficiency.

What makes this course stand out?

  1. High-quality, engaging videos: We use HD video to make learning enjoyable and effective (no boring lectures!).
  2. Real-world case studies: We use practical examples relevant to the African context to help you apply what you learn.
  3. Dedicated support: We’re here to help! Get your questions answered within 24 hours.
  4. Dynamic and paced learning: We respect your time and keep the course engaging and efficient.

Why learn Excel?

  1. Unlock career opportunities: Excel skills are in high demand across many industries in Africa.
  2. Advance your career: Excel proficiency can lead to promotions and better job prospects.
  3. Build a secure future: These skills are valuable and portable, providing you with long-term career security.

This course is perfect for:

  1. University students looking to enhance their employability.
  2. Entry-level finance, business, and marketing professionals seeking career advancement.
  3. Anyone with no prior Excel experience who wants to gain valuable skills.

What you will learn:

  1. Master Microsoft Excel from beginner to advanced.
  2. Build a strong foundation in Excel basics.
  3. Learn essential Excel functions used in offices across Africa.
  4. Manage large datasets effectively.
  5. Create dynamic reports with PivotTables.
  6. Use powerful formulas like IF, VLOOKUP, SUMIF, COUNTIF, and more.
  7. Work confidently with Excel 2016 and its advanced features.
  8. Increase your efficiency and productivity.
  9. Become your team’s Excel expert.

Who is this course for?

This course is for anyone who wants to learn Excel, regardless of their current skill level.

Requirements:

  1. No prior Excel experience is needed.
  2. Microsoft Excel 2007, 2010, 2013, 2016, 2019, or Microsoft 365 is recommended for following along with the instructor.

Course Curriculum

  • MODULE 1- EXCEL - THE BASICS

    • 1.1 Excel - The Basics

      00:14:59

    • 1.2 Excel - Create & Close Files

      00:03:26

    • 1. 3 Excel - Tabs and Group

      00:07:35

    • 1.4 Excel - Editing Data

      00:14:17

    • 1.5-Excel - Formatting

      00:17:41

    • 1.6-Excel - Characteristics of Cell

      00:02:05

    • 1.7 Excel - Cell Referencing

      00:12:05

    • 1.8 Excel - Speak Cells

      00:09:11

    • 1.9 Excel - Text to Column

      00:06:30

    • 1.10 Excel - Comments

      00:05:20
  • MODULE 2-FILLING

    • 2.1 Copying and Filling

      00:10:29

    • 2.2 Fill Series

      00:03:07

    • 2.3 Advanced Fill

      00:08:29

    • 2.4 Flash Fill

      00:05:04
  • MODULE 3-WORKSHEET

    • 3.1 Viewing Worksheet

      00:10:19

    • 3.2 Custom View

      00:04:21

    • 3.3 Adjusting Worksheets

      00:10:21

    • 3.4 Working with Worksheets

      00:10:39

    • 3.5 Compare Two Sheets

      00:05:35

    • 3.6 View Files Side by Side

      00:05:55
  • MODULE 4- LOGICAL FUNCTIONS

    • 4.1 Logical Test

      00:05:28

    • 4.2 IF Function

      00:07:35

    • 4.3 Nested IF

      00:05:20

    • 4.4 AND Functions

      00:05:58

    • 4.5 NOT And If Error

      00:04:35

    • 4.6 Auditing Tools

      00:08:53
  • MODULE 5 - FUNCTIONS AND FORMULAS

    • 5.1 Text Functions

      00:15:29

    • 5.2 Date Functions Pt. 1

      00:10:34

    • 5.3 Date Functions Pt. 2

      00:09:53

    • 5.4 Date Functions Pt. 3

      00:06:10

    • 5.5 Name Range

      00:06:26

    • 5.6 Name Range with Formulas

      00:09:25

    • 5.7 Basic Formulas

      00:07:33

    • 5.8 Count Functions

      00:07:02

    • 5.9 Statistical Functions

      00:11:22
  • MODULE 6- LOOKUP

    • 6.1 Vlookup with Exact Match

      00:08:24

    • 6.2 Vlookup Approximately Match

      00:05:41

    • 6.3 Vlookup with Trim

      00:07:58

    • 6.4 H-Lookup

      00:02:13

    • 6.5 Vlookup Rules

      00:06:12

    • 6.6 Lookup Full Record

      00:05:58

    • 6.7 Index Function

      00:05:25

    • 6.8 Match Function

      00:02:20
  • MODULE 7 -PROTECTION

    • 7.1 Protect Cells

      00:06:03

    • 7.2 Protect Sheets

      00:04:02

    • 7.3 Protect File

      00:02:49

    • 7.4 Protect Workbook

      00:01:58
  • MODULE 8-HYPERLINK

    • 8.1 Hyperlink to Sheet

      00:04:38

    • 8.2 Hyperlink to File

      00:02:36

    • 8.3 Hyperlink to Webpage

      00:05:57
  • MODULE 9-PAGE SET UP

    • 9.1 Header and Footer

      00:11:42

    • 9.2 Print Page Setup

      00:17:56
  • MODULE 10- SORT AND FILTERS

    • 10.1 Data Sorting

      00:10:01

    • 10.2 Advanced Filters

      00:06:54

    • 10.3 Filtering Data

      00:13:11
  • MODULE 11 -TABLES AND SUBTOTAL

    • 11.1 Basic Table

      00:08:02

    • 11.2 Advanced Table

      00:08:52

    • 11.3 Subtotal

      00:05:28
  • MODULE 12-CHARTS

    • 12.1 Column Chart

      00:10:39

    • 12.2 Design a Column Chart Pt. 1

      00:06:42

    • 12.3 Design a Column Chart Pt. 2

      00:19:23

    • 12.4 Pie, Bar, Column and Line Chart

      00:11:06

    • 12.5 XY Chart

      00:14:54

    • 12.6 Spark Line Chart

      00:08:37

    • 12.7 Pivot Chart

      00:10:22
  • MODULE 13-PIVOT TABLES

    • 13.1 Pivot Table Example I

      00:18:17

    • 13.2 Pivot Table Example II

      00:08:42

    • 13.3 Pivot Table Example III

      00:07:39

    • 13.4 Pivot Table Example IV

      00:06:17

    • 13.5 Pivot Table Example V

      00:10:20

    • 13.6 Pivot Table Example VI

      00:07:59
  • MODULE 14-CONSOLIDATE

    • 14.1 Consolidation

      00:12:13

    • 14.2 Consolidation Extended

      00:07:36
  • MODULE 15-CONDITIONAL FORMATTING

    • 15.1 Conditional Formatting Pt. 1

      00:15:07

    • 15.2 Conditional Formatting Pt. 2

      00:08:32

    • 15.3 Advanced Conditional Formatting

      00:10:21
  • MODULE 16- DATA VALIDATION

    • 16.1 Data Validation Pt. 1

      00:16:06

    • 16.2 Data Validation Pt. 2

      00:09:17
  • MODULE 17-INSERTING

    • 17.1 Inserting Objects

      00:05:15

    • 17.2 Creating Objects

      00:05:33
  • MODULE 18-SHORTCUTS

    • 18.1 -Shortcuts Ctrl+A to Ctrl+Z

      00:15:53
Original price was: $10.28.Current price is: $2.74.
  • Duration 04:33:00
  • Lessons 81
  • Skill Intermediate
  • Last Update February 16, 2025
Select your currency
NGN Nigerian naira
USD United States (US) dollar