Udemy

Master Microsoft Excel 2013 & 2016 for Beginners

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

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
22 小時 54 分鐘
教學語言
英語
授課導師
Simon Sez IT
證書
  • 可獲發
  • *證書的發放與分配,依課程提供者的政策及安排而定。
評分
4.2
(628 個評分)

課程簡介

Master Microsoft Excel 2013 & 2016 for Beginners

Do all the Excel terms, data, charts and reports get you down? Demystify Excel forever with this effective course.

Quickly Learn How to Master Microsoft Excel 2013 and 2016 – Beginner

Become Proficient with Excel and Its Powerful Data Functions Using These Training Classes

  • Great for personal and professional finances
  • Use conditional formatting to see what numbers matter most
  • Bring information from various files and documents together
  • Unlock the potential of your data with tables, charts, and pivots
  • Master statistical functions and data analysis to identify trends

Effortlessly Bring Important Data Together

If you're new to Excel, then you should take this class, and master all of its frequently used features. From showing you how to do a calculation, to creating useful graphs and tables, all of that is available so that you can understand your data better. There's a lot more to it than that though. This is a tool you just can't be without. In fact, when it comes to making the most of resources, and maximizing return on investment, this is the best thing out there.

Our course was designed for beginners who are familiar with Excel, but would like to improve their skills and see what else they can do with this unique and handy program. One benefit to taking this comprehensive course and using Excel is that it will be a huge time saver.

How, you ask? Excel saves you time by offering an intuitive graphical user interface. When you think of what Excel is good at, you probably first think of data manipulation: filtering, sorting, tabulating and calculating all kinds of information and data. You can use these easy-to-understand classes to reach the next level of database tracking and reporting.

Contents and Overview

Through hours of content, this beginner's course will take you through learning how to use functions for all your work-related issues. Many functions are covered including payments, future value, and depreciation. Learn statistical functions like averages, percentiles, and regression too. Excel's extensive data tools are very impressive as they can also provide the benefit of a shortened workload. In other words, this course shows you how to master this special and versatile spreadsheet program so that you can import and export common and not-so-common data formats, which reduces your need for specialized software.

This new course will easily help improve your efficiency as we cover many of Excel's core concepts. Understanding pivot tables and data analysis, for example, will be important for you moving forward. For help with reporting, you will learn stock charts, surface charts, radar charts, and bubble charts - just to list a few. A very easy to use and well-structured course.

Upon completion of this course, you'll be able to effectively create charts and graphs for personal or company records. You'll also be able to access the ribbon (and other tools), allocate valuable resources, meet tight deadlines, manage extra tasks, manage data, and much more. The material found inside is easily laid out and quite relevant.

So, take this course to possess all the skills necessary to organize and deliver your projects in the most efficient and effective way possible!

課程章節

  • 61 個章節
  • 132 堂課
  • 第 1 章 Excel 2016: Introduction
  • 第 2 章 Excel 2016: What's New
  • 第 3 章 Excel 2016: Using Touch
  • 第 4 章 Excel 2016: Getting Started
  • 第 5 章 Excel 2016: Using Help
  • 第 6 章 Excel 2016: Excel Options
  • 第 7 章 Excel 2016: The Ribbon and Toolbars
  • 第 8 章 Excel 2016: Entering and Editing Data
  • 第 9 章 Excel 2016: Backup and Recovery
  • 第 10 章 Excel 2016: Fill and Series
  • 第 11 章 Excel 2016: Viewing and Printing
  • 第 12 章 Excel 2016: Cut, Copy, and Paste
  • 第 13 章 Excel 2016: Formatting a Worksheet
  • 第 14 章 Excel 2016: Formulas and Functions
  • 第 15 章 Excel 2016: Managing Worksheets
  • 第 16 章 Excel 2016: Working with Multiple Workbooks
  • 第 17 章 Excel 2016: Saving Workbooks
  • 第 18 章 Excel 2016: Proofing
  • 第 19 章 Excel 2016: Inserting Comments
  • 第 20 章 Excel 2016: Basic Functions in Excel
  • 第 21 章 Excel 2016: Graphs and Charts
  • 第 22 章 Excel 2016: Sorting and Filtering Data
  • 第 23 章 Excel 2016: Shapes and Pictures
  • 第 24 章 Excel 2016: Formatting Cells Based on Content
  • 第 25 章 Excel 2016: Protection and Security
  • 第 26 章 Excel 2016: Naming Items
  • 第 27 章 Excel 2016: Finding and Replacing Words
  • 第 28 章 Excel 2016: Borders
  • 第 29 章 Excel 2016: Workbook Inspection
  • 第 30 章 Excel 2016: Privacy Options
  • 第 31 章 Excel 2016: Sharing Options
  • 第 32 章 Excel 2016: Wrap Up
  • 第 33 章 Excel 2013: Introduction
  • 第 34 章 Excel 2013: Using Touch
  • 第 35 章 Excel 2013: Getting Started
  • 第 36 章 Excel 2013: Help
  • 第 37 章 Excel 2013: Settings and Preferences
  • 第 38 章 Excel 2013: The Ribbon and Toolbars
  • 第 39 章 Excel 2013: Backup and Recovery
  • 第 40 章 Excel 2013: Entering and Deleting Data
  • 第 41 章 Excel 2013: Formatting a Worksheet
  • 第 42 章 Excel 2013: Copy, Paste and Paste Special
  • 第 43 章 Excel 2013: Proofing
  • 第 44 章 Excel 2013: Managing Worksheets
  • 第 45 章 Excel 2013: Comments
  • 第 46 章 Excel 2013: Viewing and Printing
  • 第 47 章 Excel 2013: Formulas and Functions
  • 第 48 章 Excel 2013: Working with Workbooks
  • 第 49 章 Excel 2013: Find and Replace
  • 第 50 章 Excel 2013: Conditional Formatting
  • 第 51 章 Excel 2013: Graphing and Charting
  • 第 52 章 Excel 2013: File Types
  • 第 53 章 Excel 2013: Managing Data
  • 第 54 章 Excel 2013: Functions Case Study
  • 第 55 章 Excel 2013: Analyzing Data
  • 第 56 章 Excel 2013: Shapes and Pictures
  • 第 57 章 Excel 2013: Sharing and Protecting
  • 第 58 章 Excel 2013: More Backstage View Options
  • 第 59 章 Excel 2013: Closing
  • 第 60 章 Excel 2013: Assessment
  • 第 61 章 Additional Training

課程內容

  • Discover new and improved features in Excel 2013 and 2016
  • How to effectively use Excel 2013 or 2016 on a touchscreen device
  • How create, save, and open a workbook
  • Learn how to personalize your use of Excel using Excel Options
  • How to use and how to customize the Quick Access Toolbar
  • Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface
  • The basics of entering and editing data in a workbook
  • Discover how to format dates and numbers
  • Learn practical methods in which you can backup and recover your Excel spreadsheets
  • Effectively use autofill and flashfill so you are more productive
  • Discover the essentials of using fomulas and functions
  • How to rename, insert, move, and reference an Excel 2016 worksheet
  • Discover how to create charts and graphs
  • Learn practical methods to sort and filter your data
  • How to protect and secure your Excel data
  • Data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface
  • Tips for mouse and touch screen users
  • Graphs and charts using templates or custom designs
  • SkyDrive and other tools for sharing work
  • Pivot tables and slicing
  • Working with flash fill
  • Bonus exercise files


評價

  • J
    Jabulisile Mabetha
    5.0

    Excellent, thank you so much for everything that i have learnt so far

  • C
    Christopher James Brant
    5.0

    Very insightful and informative course that teaches the basics of Excel very well.

  • K
    Kerry Ross
    5.0

    It was a great course, specifically the 2016 portion. He is a great instructor and I learned a lot!

  • M
    Matthew Wilbur
    3.0

    This course would be far more effective if it were split in to separate courses covering each edition of Excel. As it is, it's far too unwieldly for a new user (the target audience) to take in in an efficient manner. The course material is good, if occasionally a little too talky, but the sheer number of videos makes for a dreary experience.

立即關注瀏覽更多

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

我已閱讀及同意