Udemy

Complete Excel Megacourse: Beginner to Expert

立即報名
  • 24,790 名學生
  • 更新於 12/2024
  • 可獲發證書
4.8
(674 個評分)
  • 提示:
  • 透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期*
全年招生
課程級別
學習模式
教學語言
英語
授課導師
Skillademia Academy
證書
  • 可獲發
  • (證書的發放與分配,依課程提供者的政策及安排而定。)
評分
4.8
(674 個評分)
課程連結
*提示: 以上時間表僅供參考,以機構網站為準。

課程簡介

Complete Excel Megacourse: Beginner to Expert

Learn how to use Microsoft Excel like a pro with this step-by-step course!

Learn Microsoft Excel!

Have you ever wanted to be able to use Microsoft Excel - the largest spreadsheets program, like a pro? From managing your accounts to running your business’ finances, modelling chaos to simulating airports, recording your progress to planning your time; spreadsheets are an invaluable tool to learn and understand. Whether you’re looking to record your home incomings and outgoings, or want to explore Excel for its mathematical opportunities, investigate the statistical tools, and its data analysis wizards, this course is for you.

In this course, you’re going to learn everything you need to know to get started with Excel. You will explore what cells and worksheets are, how to enter formulae, manipulate data through functions and present the data in an effective fashion. You’ll even learn how to use Excel to develop diverse and interesting solutions to problems, as well as learn the individual techniques and how to apply them to a solution.

Our instructor has many years of experience teaching Excel to a wide range of audiences - from very young children through to professionals, and the expertly-crafted syllabus is designed to be easy to follow and thorough. We’ve also included plenty of practical examples explained and done on-screen for you to study. That’s why this is the only Microsoft Excel course you’ll ever need to master this software!

Start using Excel today!


After taking this course you’ll be able to:


  • Work professionally with Microsoft Excel and its advanced features

  • Solve real work problem with the help of Excel

  • Use the elements and theories in Excel to make your work processes better

  • Create your own KPI or Investment Dashboard

  • Create a Web Analytics Report

  • Make a Daily Activity Tracker

  • Use predictive analysis and Excel’s predictive shortcuts to gain insights and make data- drive decisions

  • Confidently analyze large datasets using Excel’s advanced data analysis tools

課程章節

  • 48 個章節
  • 266 堂課
  • 第 1 章 Introduction
  • 第 2 章 Getting to know the Interface
  • 第 3 章 Using Formulae in Excel
  • 第 4 章 Protecting Cells and Worksheets
  • 第 5 章 Data, Formatting and the First Function
  • 第 6 章 Basic Functions in Excel
  • 第 7 章 Shapes and Images
  • 第 8 章 Importing Data into Excel
  • 第 9 章 Averages in Excel
  • 第 10 章 Using Lookups in Excel
  • 第 11 章 More Functions in Excel
  • 第 12 章 Functions and Conditions
  • 第 13 章 Working with Dates and Text
  • 第 14 章 Simple Graphs and Charts
  • 第 15 章 Handling Text and Importing WWW Data
  • 第 16 章 Generating Test Data
  • 第 17 章 Creating a Budgetary System
  • 第 18 章 Revision Exercise: Astronomical Modelling
  • 第 19 章 New Functions in Excel 365
  • 第 20 章 More Basic Features of Excel
  • 第 21 章 Introduction to Data Visualization
  • 第 22 章 Data Visualization through Tables
  • 第 23 章 From Tabular to Graphical Representation
  • 第 24 章 Chart Customizations
  • 第 25 章 Must-Know Charts & Graphs
  • 第 26 章 Specialized Charts & Graphs
  • 第 27 章 Useful Visualizations
  • 第 28 章 Dashboards in Excel
  • 第 29 章 Excel for Cartography
  • 第 30 章 Excel Add-Ins for Visualization
  • 第 31 章 Managing and Presenting Visualizations
  • 第 32 章 Introduction to Data Analysis
  • 第 33 章 Reviewing the Basics
  • 第 34 章 Data Cleaning and Preparation
  • 第 35 章 Pivot Tables
  • 第 36 章 Power Query
  • 第 37 章 Power Pivot
  • 第 38 章 Dynamic Array Formulas
  • 第 39 章 Predictive Analysis
  • 第 40 章 Additional Practice and Exercises
  • 第 41 章 Capstone Project
  • 第 42 章 Introduction to Excel Programming
  • 第 43 章 Visual Basic for Applications and Getting Started
  • 第 44 章 Menus and Tools
  • 第 45 章 First Code and Statements
  • 第 46 章 Variables
  • 第 47 章 Procedures
  • 第 48 章 Application Methods and Additional Topics

課程內容

  • How to use Microsoft Excel and its basic functions
  • How to create worksheets
  • Everything about using and formatting cells
  • How to use autofill
  • The principles and use of formulas
  • How to manipulate data through different functions
  • How to use and master Excel’s most famous functions: AVERAGE, SUM, PRODUCT, COUNT, COUNTA, IF, COUNTIF
  • Simple graphs and charts
  • How to create a budgetary system
  • All the new functions in Excel 365
  • How to customize your charts
  • How to use dashboards
  • How to create 2D or 3D maps
  • How to use Pivot Tables, Power Query, Power Pivot, and Dynamic Array Formulas to analyze large datasets efficiently
  • Techniques for cleaning and preparing data to ensure accurate analysis results
  • Tips and tricks for using Excel functions to check and manipulate data


評價

  • K
    Khomotso Matlou
    5.0

    Yes, I have learn alot.

  • M
    Melanie H. Ebrole
    5.0

    So far, it is very concise, clear and easy to follow.

  • M
    Matthew Richard Guilfoyle
    5.0

    It was a very educational and enjoyable course.

  • L
    Latif BORA
    5.0

    Good expression, i teach easily.

立即關注瀏覽更多

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

我已閱讀及同意