Udemy

Microsoft Excel - Complete Beginner to Pro Guide

立即報名
  • 329 名學生
  • 更新於 10/2025
4.6
(71 個評分)
CTgoodjobs 嚴選優質課程,為職場人士提升競爭力。透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
7 小時 39 分鐘
教學語言
英語
授課導師
Alexander Shafe
評分
4.6
(71 個評分)
1次瀏覽

課程簡介

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.

課程章節

  • 10 個章節
  • 108 堂課
  • 第 1 章 Enter & Find
  • 第 2 章 Format Text
  • 第 3 章 Layout
  • 第 4 章 Data Validation
  • 第 5 章 Customize
  • 第 6 章 Excel Formula
  • 第 7 章 Common Functions
  • 第 8 章 Logical Functions
  • 第 9 章 Text/String Functions
  • 第 10 章 Reference Functions

課程內容

  • 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


評價

  • 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

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策使用條款才繼續瀏覽。

我已閱讀及同意