Udemy

EXCEL at Work - Complete MS Excel Mastery Beginner to Pro

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

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
6 小時 53 分鐘
教學語言
英語
授課導師
Steve McDonald
評分
4.6
(13,790 個評分)
5次瀏覽

課程簡介

EXCEL at Work - Complete MS Excel Mastery Beginner to Pro

Boost your Excel skills - Boost your career. Master Microsoft Excel worksheets, functions, & more. Excel 2016-2019 & 365

"Your Excel skills could land your next job."

    - Fortune Magazine

A study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don't.

Are you ready to land your next job and increase your pay by 13%?

This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery. It's perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your Excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way.

Note: This course is specifically designed for learning on  a PC. If you are learning on a Mac, the shortcut keystrokes may be different on your machine.

You'll start at the very beginning by opening and saving your first Excel document. Then you'll move on to:

  1. Create a basic Kitchen Remodel Costs worksheet.

  2. Learn to use the 7 most popular functions in Excel, including IF functions and VLOOKUP.

  3. Create professional looking pie charts, bar charts, column charts and more.

  4. Create a table and a range and sort your data.

  5. Create pivot charts and tables to do lightening fast analysis of your data.

  6. Learn to use new features of Excel including 1-click forecasting and 3D maps.

  7. Take your Excel skills to a whole new level to impress your boss and (although it's ultimately up to you) position yourself for the raise or promotion you deserve.

Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do. This includes the 7 most popular functions, which you'll learn in this course:

  1. VLOOKUP

  2. COUNT & COUNTA

  3. COUNTIF & COUNTIFS

  4. AVERAGE & AVERAGEA

  5. SUM, SUMIF & SUMIFS

  6. IF

  7. LEFT, RIGHT & MID

Here are more of the most sought after skills in Excel that are included in this course:

  1. Spreadsheets

  2. Tables

  3. Ranges

  4. Pie, Column, Bar and Line charts

  5. Pivot tables

  6. Pivot charts

  7. Tons of tips and tricks to make using Excel easier every day.

So if you're ready to take your Excel skills to the next level and want to learn in an easy-to-follow way, click the Buy now button or check out one of the free preview lectures and I'll see you in the course.

100% Satisfaction Guaranteed

Did you know that Udemy has a 100% 30-day money back guarantee on all courses? I know that you'll love this course, but Udemy's guarantee means that you can watch this entire course and if it doesn't meet your expectations for mastering Excel, we'll refund your money and all your new Excel knowledge is free.

So if you're even considering learning more about Excel for that new job, raise or promotion, sign up for the course and see what is possible with the right knowledge.

課程章節

  • 10 個章節
  • 67 堂課
  • 第 1 章 Introduction to Microsoft Excel
  • 第 2 章 Creating Your First Excel Document
  • 第 3 章 Create a Kitchen Remodel Cost Worksheet
  • 第 4 章 Introduction to Excel Formulas and Functions
  • 第 5 章 3 Things to Know Before You Start Using Functions
  • 第 6 章 How to Use the 7 Most Popular Excel Functions
  • 第 7 章 Other Popular Excel Functions
  • 第 8 章 Creating Charts From Your Spreadsheet
  • 第 9 章 Pivot Tables and Pivot Charts
  • 第 10 章 Importing Data from Other Sources

課程內容

  • In this course, you'll quickly become comfortable using the entire Excel dashboard including its tabs, ribbon and tools.
  • You'll learn all the basics of opening an Excel document, creating a spreadsheet from scratch, writing formulas and saving your document to your computer.
  • I'll also walk you through how to create professional charts and graphs to visualize your data, and you'll create pivot tables for lightening fast calculations.
  • Use the most commonly used Excel functions to make powerful calculations.
  • Learn to use several of the new Excel features such as 1-click forecasting, 3D maps and the Tell Me What You Want to Do feature.
  • Tons of helpful tips, tricks and shortcuts along the way to help you master the fundamentals of Excel 2016 and beyond.
  • Great for beginners to intermediate Excel users.


評價

  • T
    Terrie Bush
    5.0

    Yes. This was a good match for me.

  • Y
    Yeshi Choden
    3.5

    It was a good learning

  • E
    Emily Puccini
    5.0

    The instructor broke the course into perfectly-sized sections. There is never too much information in one lesson, but I still feel like I'm accomplishing something every time I finish a lesson.

  • T
    Tasheena Mcallister
    5.0

    Easy to understand and fun!

立即關注瀏覽更多

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

我已閱讀及同意