Udemy

Excel 2021/365 Starter Pack: Beginner to Intermediate Course

立即報名
  • 235 名學生
  • 更新於 3/2024
  • 可獲發證書
4.7
(73 個評分)
  • 提示:
  • 透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期*
全年招生
課程級別
學習模式
修業期
22 小時 32 分鐘
教學語言
英語
授課導師
Simon Sez IT
證書
  • 可獲發
  • (證書的發放與分配,依課程提供者的政策及安排而定。)
評分
4.7
(73 個評分)
課程連結
*提示: 以上時間表僅供參考,以機構網站為準。

課程簡介

Excel 2021/365 Starter Pack: Beginner to Intermediate Course

Master Excel spreadsheets with this beginner to intermediate training course!

***Exercise and demo files included***


We've combined our Excel 2021/365 for Absolute Beginners and Excel 2021/365 Intermediate courses to give you the ultimate starter pack to jump-start your spreadsheet journey!


Whether you're an Excel novice or already have some Excel knowledge, this course can help you get the ball rolling. This course bundle will give you a great Excel foundation or build on those skills you already have. It’s also perfect for students who have beginner to intermediate skills in an older version of Excel and are looking to explore the newest features.


Excel 2021 is Microsoft's latest stand-alone version of Excel, which opens up many of the features and functionalities that are available only in Excel 365 through a subscription.


The only prerequisite for this course is a working copy of Excel 2021 or Excel 265.


This course covers:

  • Becoming familiar with what’s new in Excel 2021

  • Navigating the Excel 2021 interface

  • Utilizing useful keyboard shortcuts to increase productivity

  • Creating your first Excel spreadsheet

  • Using basic and intermediate Excel formulas and functions

  • Effectively applying formatting to cells and using conditional formatting

  • Using Excel lists and master sorting and filtering

  • Working efficiently by using the cut, copy, and paste options

  • Linking to other worksheets and workbooks

  • Analyzing data using charts

  • Inserting pictures in a spreadsheet

  • Working with views, zooms, and freezing panes

  • Setting page layout and print options

  • Protecting and sharing workbooks

  • Saving your workbook in different file formats

  • Designing better spreadsheets and controlling user input

  • How to use logical functions to make better business decisions

  • Constructing functional and flexible lookup formulas

  • How to use Excel tables to structure data and make it easy to update

  • Extracting unique values from a list

  • Sorting and filtering data using advanced features and new Excel formulas

  • Working with date and time functions

  • Extracting data using text functions

  • Importing data and cleaning it up before analysis

  • Analyzing data using PivotTables

  • Representing data visually with PivotCharts

  • Adding interactions to PivotTables and PivotCharts

  • Creating an interactive dashboard to present high-level metrics

  • Auditing formulas and troubleshooting common Excel errors

  • How to control user input with data validation

  • Using WhatIf analysis tools to see how changing inputs affect outcomes.


This course includes:

  1. 20+ hours of video tutorials

  2. 180+ individual video lectures

  3. Course and exercise files to follow along

  4. Certificate of completion

課程章節

  • 33 個章節
  • 197 堂課
  • 第 1 章 Excel 2021 Beginner: Introduction
  • 第 2 章 Excel 2021 Beginner: Getting Started in Excel 2021
  • 第 3 章 Excel 2021 Beginner: Creating You First Excel Spreadsheet
  • 第 4 章 Excel 2021 Beginner: Introduction to Excel Formulas and Functions
  • 第 5 章 Excel 2021 Beginner: Using Named Ranges
  • 第 6 章 Excel 2021 Beginner: Formatting Numbers and Cells
  • 第 7 章 Excel 2021 Beginner: Formatting Worksheets
  • 第 8 章 Excel 2021 Beginner: Working with Excel Lists
  • 第 9 章 Excel 2021 Beginner: Moving and Linking to Data
  • 第 10 章 Excel 2021 Beginner: An Introduction to Intermediate Formulas
  • 第 11 章 Excel 2021 Beginner: Analyzing Data with Charts
  • 第 12 章 Excel 2021 Beginner: Conditional Formatting
  • 第 13 章 Excel 2021 Beginner: Inserting Items into a Spreadsheet
  • 第 14 章 Excel 2021 Beginner: Working with Views and Zoom
  • 第 15 章 Excel 2021 Beginner: Page Layout and Print Options
  • 第 16 章 Excel 2021 Beginner: Finalizing the Spreadsheet
  • 第 17 章 Excel 2021 Beginner: Course Close
  • 第 18 章 Excel 2021 Intermediate: Introduction
  • 第 19 章 Excel 2021 Intermediate: Designing Better Spreadsheets
  • 第 20 章 Excel 2021 Intermediate: Making Decisions with Logical Functions
  • 第 21 章 Excel 2021 Intermediate: Looking Up Information
  • 第 22 章 Excel 2021 Intermediate: Advanced Sorting and Filtering
  • 第 23 章 Excel 2021 Intermediate: Working with Date and Time
  • 第 24 章 Excel 2021 Intermediate: Preparing Data for Analysis
  • 第 25 章 Excel 2021 Intermediate: PivotTables
  • 第 26 章 Excel 2021 Intermediate: Pivot Charts
  • 第 27 章 Excel 2021 Intermediate: Adding Interaction to PivotTables and Charts
  • 第 28 章 Excel 2021 Intermediate: Interactive Dashboards
  • 第 29 章 Excel 2021 Intermediate: Formula Auditing
  • 第 30 章 Excel 2021 Intermediate: Data Validation
  • 第 31 章 Excel 2021 Intermediate: WhatIf Analysis Tools
  • 第 32 章 Excel 2021 Intermediate: Course Close
  • 第 33 章 Additional Training

課程內容

  • What’s new in Excel 2021
  • Navigating the Excel 2021 interface
  • Utilizing useful keyboard shortcuts to increase productivity
  • Using basic and intermediate Excel formulas and functions
  • Effectively applying formatting to cells and using conditional formatting
  • Linking to other worksheets and workbooks
  • Protecting and sharing workbooks
  • Saving your workbook in different file formats
  • Designing better spreadsheets and controlling user input
  • How to use logical functions to make better business decisions
  • How to use Excel tables to structure data and make it easy to update
  • Sorting and filtering data using advanced features and new Excel formulas
  • Working with date and time functions and extracting data using text functions
  • How to control user input with data validation
  • Importing data and cleaning it up before analysis
  • Using WhatIf analysis tools to see how changing inputs affect outcomes.
  • Analyzing data using PivotTables and representing data visually with charts and PivotCharts
  • Adding interactions to PivotTables and PivotCharts
  • Creating an interactive dashboard to present high-level metrics
  • Auditing formulas and troubleshooting common Excel errors


評價

  • M
    Moshe Touboul
    5.0

    Very good course. The explanation are very clear and the exercises that are linked to each lesson are very helpful.You motivate me to take the advanced course.

  • P
    Pierina Paola Valvo
    4.0

    I like the teacher's voice which is very clear and she explains very well

  • S
    Stanimir Dimitrov
    5.0

    Very explanatory, and well organized. Instructor knows, and able to teach Excel with pleasant voice.

  • N
    Noah Olusola Oladokun
    5.0

    Very explanatory and i understand every single step easily

立即關注瀏覽更多

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

我已閱讀及同意