Udemy

MICROSOFT EXCEL Complete: Zero to Pro Level With 8 Projects

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

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
10 小時 25 分鐘
教學語言
英語
授課導師
Ivan Lourenço Gomes
證書
  • 可獲發
  • *證書的發放與分配,依課程提供者的政策及安排而定。
評分
4.7
(197 個評分)
1次瀏覽

課程簡介

MICROSOFT EXCEL Complete: Zero to Pro Level With 8 Projects

Complete Microsoft Excel and Google Spreadsheets for Business Professionals. Manage Sales, Make Pivot Tables and Reports

Microsoft Excel and Google Sheets are powerful applications that allow you to create sophisticated spreadsheets. They can help you organize, analyze, and understand your business's most important data.

In this 2-in-1 course, we'll cover everything you need to know to master both Google Sheets and Microsoft Excel. Using these two applications, you'll learn how to create supercharged spreadsheets with sophisticated functions and visualizations that will allow you to speed up data analysis and communicate actionable findings with your team.

Follow along as we go through the exercises, and use multiple spreadsheets to practice your new and exciting skills.

At the end of this course, you’ll be able to master:


  • Sorting and filtering data, filtering views, publishing files, and other data preparation tasks.

  • Increasing productivity by using different data types, formatting cells, formulas, and other advanced techniques.

  • Creating sales sheets, printable invoice templates, pivot tables, and charts for sales statistics.

  • Creating Google spreadsheet scripts to perform programmable actions.

  • Working faster with keyboard shortcuts and techniques.

Now the real office productivity begins! Learn Excel and Google Sheets from the ground up!

This course offers 67 lessons with more than 10 hours of video content, multiple assignments and real-life projects.

About the Instructor

This course is ministered by Ivan Lourenço Gomes, a top-rated Udemy instructor, famous for his easy-to-follow and hands-on teaching style. Ivan has more than 16 years of experience working for multinational companies and has ever since used Microsoft Excel and more recently Google Spreadsheets to boost the productivity and data analysis of his team.

Enroll now and master these wonderful tools for businesses and individuals.

課程章節

  • 8 個章節
  • 67 堂課
  • 第 1 章 First Steps with Microsoft Excel
  • 第 2 章 Pivot Tables & Advanced Functions
  • 第 3 章 More Advanced Functions
  • 第 4 章 Printing Layouts
  • 第 5 章 Date Functions
  • 第 6 章 Reporting and Data Analysis Tools
  • 第 7 章 Project - Diet & Meal Planning on Microsoft Excel
  • 第 8 章 Useful Projects

課程內容

  • Learn all the most important Excel & Google Spreadsheets built-in functions with practical examples: SUM, COUNT, SUMIF, COUNTIF, VLOOKUP, IF, AND, OR, etc.
  • Apply formulas and use dynamic values for high productivity with your day-to-day work
  • Master both Micosoft Excel and Google Spreadsheets for office use and collaborative work
  • Create dynamic management reports and have a better understanding of your business data
  • Have a deep understanding of pivot tables & charts and create corporate knowledge from your data
  • Control the sales, purchases, stock, payroll and other management areas of your organization
  • Create invoices and documents with formulas & calculations
  • Work with several real-life projects: stock system, consumer price calculator, students grades & attendance control, sales projections, meal planner, etc.
  • Learn how to work with CSV files that are interoperable with most software programs in the market to analyze external sources of data on Microsoft Excel
  • Work with Macros and automate actions
  • Protect your workbooks with password and block specific cells to make your worksheets safe and error-free
  • Format your sheets for better usability and add menu with buttons to create your own system for all your office tasks


評價

  • J
    Jaisurya Balan
    4.5

    this Course was very useful for me, I have learned a lot from this course

  • C
    Charles David
    4.5

    It was really help me to know lot of new things. thanks for course

  • A
    Awwal Olalekan
    5.0

    nice course

  • K
    Kaviya Baskar
    5.0

    *****

立即關注瀏覽更多

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

我已閱讀及同意