Udemy

Build a Sales Management Dashboard with Excel

立即報名
  • 36 名學生
  • 更新於 8/2021
4.5
(07 個評分)
  • 提示:
  • 透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期*
全年招生
課程級別
學習模式
修業期
2 小時 46 分鐘
教學語言
英語
授課導師
Marc Augier Programmation Web | Python | Bases de Données
評分
4.5
(07 個評分)
*提示: 以上時間表僅供參考,以機構網站為準。

課程簡介

Build a Sales Management Dashboard with Excel

Learning by Doing

This is not your usual Excel Course!

You have a lot of Data at hand in order to track your business but you need to find an easy way to analyze it.

You have already followed a lot of Excel courses, read books and you know all these funny functions, but you have no idea about what to BUILD with them.

You don't like theory and are better at learning by doing?

In this course I will show you step by step how to start working with raw data and turn it into a meangful, straigtforward, clear, easy to read dashboard. Did I mention it will be friendly as well?

This course is definitely what you were looking for: 100% practice, hands on from the begining. No big theory, no demonstration out of context.

The way it works

In this course you will follow me creating a dashboard to track the activity of a sales team. Starting from a big table of data, we will learn how to analyze and create a clear dashboard.

Lot of context, lot of practice, and lot of learning:

  • Functions (SUMIFS, COUNTIFS, VLOOKUP, MAX,MIN, etc.)

  • Naming cells, relative and absolute addresses

  • Pivot Tables

  • Graphics

All these concepts are covered along the creation of the dashboard.

The best part of it?

You can't be bored in this course, my French accent will keep you on track from the first second to the end!

課程章節

  • 5 個章節
  • 18 堂課
  • 第 1 章 First Step: Discovering the Data
  • 第 2 章 Second Step: Dashboard Creation
  • 第 3 章 Third Step? We restart from the begining and Pivot Table
  • 第 4 章 Fourth Step: Graphics
  • 第 5 章 Epilogue

課程內容

  • Improve your Business with an Excel Dashboard to track your performance, Learn how to turn a raw list of Data into a meaningful Dashboard to analyze your Business, Practice Function and formula developement with Excel, Use Pivot Tables to speed up your work with Excel


評價

  • A
    Anthony Yao
    5.0

    Great so far ! Eagerly waiting for your new excel course

  • K
    Kevin Grant Roman
    5.0

    Great course for setting up basic dashboards. Will definitely start using this for my dashboards.

  • R
    Ritesh Gupta
    4.5

    amazing

立即關注瀏覽更多

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

我已閱讀及同意