双色球爱彩网专家杀号|爱彩网主页

Microsoft Excel – 高級Excel公式和函數

Microsoft Excel - Advanced Excel Formulas & Functions

掌握75+ Excel公式和功能,以及來自暢銷的Microsoft Excel講師的實際演示(Excel 2010-19)

Chris Dutton

Udemy

計算機

普通(中級)

6 小時

本課程由Udemy和Linkshare共同提供
  • 英語
  • 1338

課程概況

*** Course access includes project files, quizzes & homework exercises, 1-on-1 expert support, LIFETIME access and a 100% money-back guarantee ***

Hear why this is one of the TOP-RATED Excel courses on Udemy:

“One of the best courses I’ve ever taken. You can see through his videos how passionate he is about Excel. Thanks for this awesome course, count me in for the next ones!”

-Julio Garcia

“I have just completed the course and can honestly say that this is the best course I have taken in my life so far. Chris has a real gift of explaining the more difficult Excel functions and making them accessible and understandable. I thought I already knew Excel well but I have learnt so much throughout each section of the course and have already put a lot of it into practice at work. The homework exercises were really beneficial and made sure that each section was fully understood. I love Chris’s teaching style so much I have already purchased his other courses and can’t wait to get started!

-Jon Knights

“Chris Dutton is an EXPERT in Excel. He makes comprehensible to the student the complex (sometimes super-complex) nature of the formulas he uses. Everything that is written at the course description, although it may seem pure marketing and publicity at first glance, is indeed true. If I could rate it higher I definitively would. THANKS Chris!”

-Bruno Ricardo Silva Pinho

FULL COURSE DESCRIPTION:

It’s time to show Excel who’s boss. Whether you’re starting from square one or aspiring to become an absolute Excel badass, you’ve come to the right place.

This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. I will not train you to regurgitate functions and formula syntax; I will teach you how to THINK like Excel.

你將學到什么

學習如何像Excel一樣思考,并從頭開始編寫強大而動態的公式

使用Excel自動化,簡化并徹底改變您的工作流程

掌握您在任何其他課程中找不到的獨特技巧,工具和案例研究

從暢銷的Excel講師那里學習有趣,互動,高效的課程

獲得LIFETIME對項目文件,測驗,家庭作業練習和一對一專家支持的訪問權限

構建公式以分析日期,文本字段,值和數組

課程大綱

Before We Dive In
3 個講座
07:36

Excel Formulas 101
11 個講座
39:20

Conditional Statements & Logical Operators
8 個講座
31:09

Statistical Functions
10 個講座
45:22

Lookup/Reference Functions
17 個講座
01:12:41

Text Functions
10 個講座
35:33

Date & Time Functions
11 個講座
48:32

Formula-Based Formatting
7 個講座
24:38

Array Formulas
14 個講座
49:40

Badass Bonus Functions
5 個講座
35:25

Wrapping Up
2 個講座
01:33

面向人群

Excel users who have basic skills but want to get really, REALLY good
Anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level
Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training

預備知識

Microsoft Excel 2007 - 2019 or Office 365 (Some features may not be available in earlier versions)
Experience with formulas is recommended, but not required (we'll review some of the fundamentals)

Programming Category (English)728x90
聲明:MOOC中國十分重視知識產權問題,我們發布之課程均源自下列機構,版權均歸其所有,本站僅作報道收錄并尊重其著作權益。感謝他們對MOOC事業做出的貢獻!
  • Coursera
  • edX
  • OpenLearning
  • FutureLearn
  • iversity
  • Udacity
  • NovoEd
  • Canvas
  • Open2Study
  • Google
  • ewant
  • FUN
  • IOC-Athlete-MOOC
  • World-Science-U
  • Codecademy
  • CourseSites
  • opencourseworld
  • ShareCourse
  • gacco
  • MiriadaX
  • JANUX
  • openhpi
  • Stanford-Open-Edx
  • 網易云課堂
  • 中國大學MOOC
  • 學堂在線
  • 頂你學堂
  • 華文慕課
  • 好大學在線CnMooc
  • (部分課程由Coursera、Udemy、Linkshare共同提供)

© 2008-2019 MOOC.CN 慕課改變你,你改變世界

双色球爱彩网专家杀号 安徽麻将大全下载 微信红包麻将怎么玩 欢乐麻将好友房技巧 世界杯比分预测瑞典对瑞士 杭州麻将都有哪些app 终于知道百搭麻将听牌技巧 cba决赛2018总比分 辽宁35选7 必赢体育篮球比分球探体育 广东十一选五计划版 四人好友组队麻将 闲来麻将下载手机版 天天盈配资 山东新11选5走势 科乐吉林麻将 下载 东北麻将的基本玩法