Udemy

Complete Excel Bootcamp: Zero to Hero in Excel

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

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
14 小時 16 分鐘
教學語言
英語
授課導師
Jose Portilla, Todd Hanford, Pierian Training
評分
4.1
(888 個評分)
3次瀏覽

課程簡介

Complete Excel Bootcamp: Zero to Hero in Excel

Learn how to become a professional Excel wizard

Welcome to the best online resource to become an Excel Professional!

We'll take you from Zero to Excel Hero through an interactive and project based learning experience in this course!

We've carefully designed this course to teach you how to become a pro in excel, using lessons based on real world situations.

We start by covering all the basics to make sure you quickly get up to speed on Excel Versions and the Excel Interface, along with covering Workbooks and the Anatomy of the cell. Afterwards we'll start taking you through Excel functionality that can turn you into a super-user. Including exploring common functions in Excel and creating your own Excel functions. Once we've covered the basics we start to ramp up your skills with List Operations and Logical Functions, including LOOKUP functions in Excel. Then we begin a tour of some more advanced functionality built into Excel, including Text, Math, and Date functions. At this point many courses would stop, but we want to turn you into a Hero! We'll continue your education with advanced topics such as Pivot Tables, Add-ins and Macros, and very advanced tools like Solvers, Linear Optimization, and the Analysis ToolPak.

All along the way we present real-world based projects and template spreadsheets for you to use to practice your new skills. We also include access to our Q&A forums and our Discord chat channel where you can connect with other students to talk about Excel.

This course includes topics such as:

  • Understanding Excel Versions

  • Core Excel Spreadsheet Ideas

  • Common Functions in Excel

  • Creating References and Functions

  • List Operations

  • Logical Functions

  • LOOKUP Functions

  • Text Functions

  • Math Functions

  • Date Functions

  • Pivot Tables

  • Data Imports

  • Charts

  • Debugging

  • Data Hygiene

  • Add-ins and Macros

  • Solvers and Linear Optimization

  • Analysis ToolPak

  • and much more!


All of this comes with a 30-day money back guarantee, so you can try the course completely risk free!

Enroll in the course and become an Excel Hero today! We'll see you inside the course.

- Pierian Training Team

課程章節

  • 10 個章節
  • 76 堂課
  • 第 1 章 Introduction
  • 第 2 章 Excel Setup and Basics
  • 第 3 章 Common Actions in Excel
  • 第 4 章 References and Functions
  • 第 5 章 List Operations
  • 第 6 章 Logical Functions
  • 第 7 章 Lookup Functions in Excel
  • 第 8 章 Excel Text Functions
  • 第 9 章 Excel Math Functions
  • 第 10 章 Date Functions in Excel

課程內容

  • Go from Zero to Hero in Excel
  • Explore the core functions that make you an Excel wizard
  • Understand List Operations and Logical Functions in Excel
  • Create functions with Math, Text, and Date operators inside of Excel
  • Get lifetime access to advanced template spreadsheets and projects
  • Automate your workflow with efficient Excel tricks
  • Explore advanced functionality in Excel, such as Pivot Tables and Macros
  • Learn about Linear Optimization and Solver within Excel


評價

  • V
    Vigninou Houndekon
    5.0

    I like the explanation and the tone

  • M
    Mona F
    1.0

    Warning for Mac/Linux Users Prospective students using macOS or a Linux distribution (such as Ubuntu) should be aware that this course is taught exclusively using the PC/Windows version of the software tool. While the core concepts may be similar, the instruction, shortcuts, interface elements, and troubleshooting provided are tailored 100% to the Windows environment. It is unacceptable that the title and the course description fail to clearly specify that this instruction is Windows-only. This oversight resulted in a waste of money for me, and I strongly recommend the instructors amend the listing immediately to prevent future disappointment and unwarranted purchases by users on non-Windows platforms. The instructor unfortunately dismissed concerns regarding Mac/Linux users, suggesting that the vast majority of users are on PC and that there is no data to support the prevalence of other operating systems. This perspective reveals a significant lack of awareness, especially given the context of fields like bioinformatics. In the bioinformatics community, there is a strong, industry-standard preference for Unix-based operating systems (macOS and Linux, particularly Ubuntu/CentOS) over Windows for core development and analysis due to compatibility with essential tools. Assuming "most people" are on PC ignores a substantial and highly technical segment of the user base who would benefit from, and often require, platform-specific instruction.

  • K
    Kanchana D
    4.0

    GOOD

  • K
    Khushi Gaur
    3.0

    GOOD GOOD

立即關注瀏覽更多

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

我已閱讀及同意