Udemy

Microsoft Excel 2016 Beginner Level Course

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

課程資料

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

課程簡介

Microsoft Excel 2016 Beginner Level Course

Learn how to use Microsoft Excel 2016 from a beginner level and up with confidence

This Microsoft Excel 2016 Beginner Level Course by Hudson is aimed at anyone considering using Excel 2016 for the first time or those just wanting to refresh or upgrade their current Excel skills.


At the beginning, this course covers simple topics such as:


  • What can Excel 2016 do for you?
  • Understanding common terms used in Excel and the world of spreadsheets
  • Finding your way around Excel
  • Saving and printing your work
  • Understanding formulas and why people create them; and
  • What’s new in Excel 2016

 

The course then progresses onto more complex subjects such as performing basic calculations and using cell references, understanding how to use Autofill and Flash Fill options, analyzing and editing data, understanding data visualization, working with paste special commands, getting to grips with the view options, and building sparklines, plus much more. The course is presented in logical order starting from the bare basics.


Animations are used during the introductory stages to bring the course to life and help the learner to better absorb information. Lessons are taught with the add of video capture software. You can see exactly what parts of Excel 2016 the tutor is referring to when delivering the lesson, whether it be a spreadsheet or save menu.


This course also includes quizzes and project files to practice your skills and test your knowledge. 

課程章節

  • 51 個章節
  • 77 堂課
  • 第 1 章 About this Course
  • 第 2 章 Course Introduction
  • 第 3 章 Introduction to Microsoft Excel 2016
  • 第 4 章 Understanding Common Terms used in Excel and Spreadsheets
  • 第 5 章 Navigating your Way Around Excel
  • 第 6 章 Excel General Options
  • 第 7 章 QUIZ: Excel General Options
  • 第 8 章 Adding, Copying and Moving Worksheets
  • 第 9 章 QUIZ: Adding, Copying and Moving Worksheets
  • 第 10 章 Working with Cells, Columns and Rows
  • 第 11 章 QUIZ: Working with Cells, Columns and Rows
  • 第 12 章 Excel Basic Formatting
  • 第 13 章 QUIZ: Excel Basic Formatting
  • 第 14 章 QUIZ - Basic Formulas and Functions
  • 第 15 章 Autofill and Flash Fill Options
  • 第 16 章 QUIZ: Autofill and Flash Fill Options
  • 第 17 章 Workbook View Options
  • 第 18 章 QUIZ: Workbook View Options
  • 第 19 章 Saving Workbooks
  • 第 20 章 QUIZ: Saving Workbooks
  • 第 21 章 PROJECT FILE: Workbooks
  • 第 22 章 Basic Calculations and Cell References
  • 第 23 章 QUIZ - Basic Calculations
  • 第 24 章 QUIZ - Cell References
  • 第 25 章 PROJECT FILE - Basic Calculations
  • 第 26 章 Working with Comments
  • 第 27 章 QUIZ - Working with Comments
  • 第 28 章 Working with Paste Special Commands
  • 第 29 章 QUIZ - Working with Paste Special Commands
  • 第 30 章 Optimizing the Data (Autofilter)
  • 第 31 章 QUIZ - Optimizing the Data
  • 第 32 章 PROJECT FILE - Optimizing the Data
  • 第 33 章 Basic Sorting Methods
  • 第 34 章 QUIZ - Basic Sorting Methods
  • 第 35 章 Using Subtotal Function to Analyze the Data
  • 第 36 章 QUIZ - Using Subtotal Function to Analyze the Data
  • 第 37 章 Search and Editing the Data
  • 第 38 章 QUIZ - Search and Editing the Data
  • 第 39 章 Data Visualization - Basic Illustrations
  • 第 40 章 QUIZ: Data Visualization - Basic Illustrations
  • 第 41 章 PROJECT FILE: Data Visualization
  • 第 42 章 Building Basic Charts
  • 第 43 章 QUIZ: Building Basic Charts
  • 第 44 章 Manipulate with Chart Elements
  • 第 45 章 QUIZ: Manipulate with Chart Elements
  • 第 46 章 Building Sparklines
  • 第 47 章 QUIZ: Building Sparklines
  • 第 48 章 Page Layout Options
  • 第 49 章 QUIZ: Page Layout Options
  • 第 50 章 PROJECT FILE: Page Layout Options
  • 第 51 章 Conclusion

課程內容

  • Understand common terms used in Excel and spreadsheets
  • Learn how to add, copy and move worksheets
  • Learn how to work with cells, columns and rows
  • Learn how to conduct basic formatting
  • Understand Autofill and Flash Fill options and how to use them
  • Understand workbook view options and how to use them to your advantage
  • Learn how to save workbooks the correct way
  • Perform basic calculations and use cell references
  • Learn how to work with comments
  • Learn how to optimize data using the Autofilter feature
  • Learn how to conduct basic sorting methods
  • Learn how to use the subtotal function to analyze data
  • Learn how to search and edit data effectively
  • Understand data visualization and how best to use it
  • Learn how to build basic charts
  • Understand chart elements
  • Learn how to build sparklines


評價

  • K
    Kate Sinha
    5.0

    Great beginners course that covers a range of excel skills. Recommended for anyone looking to learn basics or as a refresher course.

  • T
    Trista Hayton
    3.0

    The only thing that was really bad is that the sections are out of order. If you are going to give a quiz make sure the content of the quiz is taught first. Same with application of knowledge. The applications sections had you doing things you weren't taught yet because it was not in the correct order. The instructor was clear and showed multiple ways to do things which is nice!

  • M
    Mohannad AlFadhal
    5.0

    The course is amazing, and I liked it a lot because of the vast amount of exercises, and the projects at the end of the sections. The instructor is direct to the point and doesn't waste time, which provided me with a lot of information even though the lectures are small.

  • R
    Raj K Patel
    4.5

    The course is great for the beginners as well as the intermediate highly recommended for graduates

立即關注瀏覽更多

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

我已閱讀及同意