Udemy

Microsoft Excel Bootcamp - Learn to Master Excel in 3hrs!

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

課程資料

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

課程簡介

Microsoft Excel Bootcamp - Learn to Master Excel in 3hrs!

In this fun and engaging course, you'll master keyboard shortcuts, VLOOKUPs, IF statements, PivotTables, and more!

This is not your grandma's Excel course! Our Excel course will give you the Excel skills to become an Excel ninja. You'll discover keyboard shortcuts, IF statements, VLOOKUP, PivotTables, and more!


WHAT MAKES OUR EXCEL COURSE UNIQUE?

  • Earn points as you complete the course and unlock your spirit animal

  • Engaging instructor that won't put you to sleep

  • G-rated humor and lighthearted lessons

  • ZERO FLUFF!

  • Real world application that you can start applying today


WHAT YOU'LL BE LEARNING

This course will help you master the most important and widely used formulas and functions in Excel. This course is beneficial to ANYONE who uses Excel. Here's what you'll master in the next 4 hours:

  • Keyboard shortcuts beyond the simple Ctrl+S or Ctrl+C

  • VLOOKUP, IF, and Nested IF statements

  • SUMIFS and COUNTIFS

  • Text formulas including LEFT, RIGHT, and TRIM

  • Date formulas including EOMONTH and EDATE

  • PivotTables and Slicers

  • Conditional Formatting, Remove Duplicates, and Text-to-Columns


By the end of this course, you'll be a total boss at Excel! Then you can take those skills to a whole new level by taking our Advanced Microsoft Excel course and Microsoft Excel VBA (Macros) course.

__________

NOTE: If you would like to receive CPE credit for this course, you must complete the final exam on our website. All lectures are compatible with Excel 2010, Excel 2013 or Excel 2016.

課程章節

  • 7 個章節
  • 39 堂課
  • 第 1 章 Welcome!
  • 第 2 章 Formatting & Keyboard Shortcuts
  • 第 3 章 Formula Bootcamp Pt. I
  • 第 4 章 Formula Bootcaomp Pt. II
  • 第 5 章 Working w/ Data and Conditional Formatting
  • 第 6 章 PivotTables & Slicers
  • 第 7 章 Conclusion

課程內容

  • Learn Excel in a fun, interactive, and entertaining manner (no sleeping in this course)
  • Wow your team with powerful formulas such as VLOOUP, IF, SUMIFS, and more!
  • Gain powerful insights into your data using PivotTables and Slicers
  • Master keyboard shortcuts and become the Usain Bolt of Excel
  • Organize and dissect large quantities of data using Text-to-Columns, Conditional Formatting, Sorting
  • Practice your skills multiple times using real-life case studies


評價

  • P
    Patricia Putri Art Syana
    5.0

    fun ways to learn, easy to follow, and very insightful

  • A
    Ananya Binnu
    5.0

    The course was really amazing and interesting. I learned a lot. It was a well structured course. It would have been more great if there were a lot more excel exercises, so that we can more efficiently practice tough concepts like VLOOKUP and nested IF statements.

  • I
    Isaac Reinhard Bonkey
    4.5

    Excelsior

  • D
    David Hendrickson
    5.0

    Yes - this is a good match - very practical and to the point!

立即關注瀏覽更多

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

我已閱讀及同意