Udemy

Learning Excel from scratch for productivity in office

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

課程資料

報名日期*
全年招生
課程級別
學習模式
修業期
2 小時 42 分鐘
教學語言
英語
授課導師
Kingsley Tom
評分
4.1
(16 個評分)
課程連結
*提示: 以上時間表僅供參考,以機構網站為準。

課程簡介

Learning Excel from scratch for productivity in office

Important aspect of Excel for office work

Excel is a very powerful and one of the most used analytical tool. very important questions that recruiters ask during job interviews in Excel are being answered in this lesson. this lesson contain very important aspect that you can't attain higher productivity without the knowledge. This lesson highlights are explained stepwisely without rushing. In this course, the detailed step by step process to doing the following are explained.

* How to create a filter in Excel. Filter in Excel is very important area in Excel that helps to sort out information without stress.

* How to create a data entry form in Excel

* How to password your documents against unauthorized access. This particular aspect is very important. It protects the company's data from unauthorized access that's why big organizations don't joke with it. Because of this, it's always one of the important question asked at Excel job interviews. How to do it is explained in steps in this video.

* How to create a primary key in Excel. Primary key is a unique I dentifier that Identify a particular data in a row of a table. This particular feature is mostly obtained in Microsoft access but in this video it is explained in details how to create a primary key in Excel without stress.

* How to create a Vlookup in Excel. This is also very important question usually ask during job interviews in Excel. It is a very necessary aspect of Excel that is very pertinent for optimum productivity in the office. These are skills that if acquired, you'll sell in the labour market.

* Also in this lesson, seventeen Excel Formulas and functions are explained in details and its usability in order to make data analysis simple, fast and accurate.

* In section two of this lesson, how to plot eye catching graphs in Excel are explained in details. Many other lessons are added everyday. I wish you the best as you keep building your knowledge in Excel also don't forget to rate this course as you enroll on it, thanks.

* Various applications of IF function

* what is pivot table and ow to create a pivot table in Excel

課程章節

  • 2 個章節
  • 10 堂課
  • 第 1 章 Important aspect of Excel for Office productivity
  • 第 2 章 Plotting eye catching graphs in Excel

課程內容

  • Create a filter in Excel
  • Create data entry form in Excel
  • Create a primary key in Excel
  • Be able to password your documents against unauthorized access
  • Create a Vlookup in Excel
  • Excel Formulas
  • Excel Functions
  • How to plot eye catching graphs in Excel
  • Application of IF function in Excel
  • How to create a pivot table in Excel


評價

  • J
    José Antonio Hernández Téllez
    5.0

    excellent course congratullations

  • B
    Bill Clinton Onyango
    4.0

    Short and to the point

立即關注瀏覽更多

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

我已閱讀及同意