Udemy

Microsoft Excel - Complete Beginner to Pro Guide

Enroll Now
  • 329 Students
  • Updated 10/2025
4.6
(71 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
7 Hour(s) 39 Minute(s)
Language
English
Taught by
Alexander Shafe
Rating
4.6
(71 Ratings)
1 views

Course Overview

Microsoft Excel - Complete Beginner to Pro Guide

Format, Analyze, Manipulate Data & Build Interactive Dashboards in Excel

Excel is one of the most used data processing and analysis application. This course is designed to take you from knowing absolutely nothing in Excel to becoming highly proficient.

You will learn how to clean and format data using several commands.

There are wide variety of in-built functions in excel. In this course, you will learn how to use Logical Functions, String Functions, Reference Functions, Date Functions, Statistical Functions and Math Functions, to analyze small and large quantities of data. You will also learn how to write basic and complex formulas.

An important part of data analysis is to derive insights from the data. One of the most compelling ways of presenting information from data is through visualization. You will learn how to create different charts which is subsequently used to build interactive and dynamic dashboard.


IS THIS YOU?

Looking to work with data personally or professionally?

Starting or transitioning into a career as a Data Scientist, Data Analyst, Business Analyst, Report Analyst, ETL Specialist, BI Consultant, Data Engineer, or any data related field? Then you need to learn Excel.


Course Requirement or Prerequisites

This course does not require any prior knowledge or specific academic background. The only requirement is having a laptop or desktop computer. You also need to have Microsoft Excel application installed on your laptop or computer.

Course Content

  • 10 section(s)
  • 108 lecture(s)
  • Section 1 Enter & Find
  • Section 2 Format Text
  • Section 3 Layout
  • Section 4 Data Validation
  • Section 5 Customize
  • Section 6 Excel Formula
  • Section 7 Common Functions
  • Section 8 Logical Functions
  • Section 9 Text/String Functions
  • Section 10 Reference Functions

What You’ll Learn

  • Microsoft Excel
  • Formatting Data
  • Data Analysis & Manipulation
  • Formula & Functions
  • Data Validation
  • Tables
  • Handling Errors
  • Pivot Tables & Charts
  • Macro
  • Charts
  • Interactive Dashboards
  • ...and a lot more


Reviews

  • C
    Chris Ijogbe
    5.0

    Excellent Excel breakdown.

  • M
    Maaz Shariff
    5.0

    Yes

  • B
    Babatunde Oladimeji Ajewol
    5.0

    Excellent

  • E
    Ernest NGIPE
    5.0

    I LOVE EVERYTHING I'M SEEING SO FAR

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed