Udemy

Mastering Excel Fundamentals - Excel Beginner Course

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

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
14 小時 56 分鐘
教學語言
英語
授課導師
Michael Bouwer
證書
  • 可獲發
  • *證書的發放與分配,依課程提供者的政策及安排而定。
評分
4.5
(277 個評分)
8次瀏覽

課程簡介

Mastering Excel Fundamentals - Excel Beginner Course

Beginners Course to learn how to use Microsoft Excel, Master the Fundamentals of Microsoft Excel as a Beginner.

Excel expert Michael Bouwer helps new users of Microsoft Excel from the most fundamental and basic principles all the way to creating their own worksheets with functioning formulas and references.

This course guides you through some of the most common knowledges, that is not so common to all.

No prior knowledge of Excel required.


Michael have experienced thousands of users that simply don't know about the essential principles covered in this course, and  so miss out on a multitude of Excel functionality.

If you want to become proficient or even just a great user of Microsoft Excel, then this course comes highly recommended.


Topics include:

  • Understanding the Excel Layout and Screen with Menus

  • Simple Data Entry Techniques

  • Creating Formulas and Common Functions

  • Understanding Formatting Tools and Worksheet Manipulation

  • Printing

  • Creating and Editing Charts and its elements

  • Adjusting your View as well as working with Multiple Worksheets and Workbooks

  • Some Advanced Functions, such as IF, VLOOKUP and COUNTIF Family of Functions

  • How to Protect your Worksheets and Workbooks

  • Features to do Proper Data Management

  • Tools for Data Analysis

  • Entire Module Dedicated to PivotTables, from Creation to Manipulation to Charting

  • An Introduction to Macros


All the Resource Files are provided which can be downloaded for free.

課程章節

  • 16 個章節
  • 69 堂課
  • 第 1 章 What is Excel Used For
  • 第 2 章 Basic Navigation around Excel Interface
  • 第 3 章 Data Entry into Excel
  • 第 4 章 Creating and Mastering Formulas and Functions
  • 第 5 章 Formatting Features in Excel
  • 第 6 章 Adjusting The Worksheet Layout to Suit You
  • 第 7 章 Printing Basics in Excel
  • 第 8 章 Charting Basics in Excel
  • 第 9 章 Adjusting Worksheet Views in Excel
  • 第 10 章 Working with Multiple Worksheets and Workbooks
  • 第 11 章 Advanced Formulas (IF, VLOOKUP & COUNTIF family)
  • 第 12 章 Protection and Passwords
  • 第 13 章 Basic Data Management Features
  • 第 14 章 Basic Data Analysis Tools
  • 第 15 章 PivotTables Basics in Excel
  • 第 16 章 Basic Introduction to Macros

課程內容

  • How to Use Microsoft Excel as a Complete Beginner
  • From Basic Navigation to Entering Data and Creating your Own Formulas and Functions
  • To Understanding Formatting, and Adjusting Your Layouts and Views and Printing
  • Learning How To Create Charts and Tables and Other Management Features
  • Protecting Your Precious Files and Worksheets and Analysis Tools like Add-Ins
  • All the Way to Everything about PivotTables and even an Introduction to Macros


評價

  • D
    David Ault
    3.5

    Yes, I wasn't aware there were so many preset templates for Excel

  • S
    Sarah Campbell
    4.5

    Yes, looking froward to learning all about Excel

  • N
    Niamh King
    5.0

    Great course

  • A
    Alix Dykman
    4.0

    Yes it was a good match.

立即關注瀏覽更多

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

我已閱讀及同意