- 提示:
- 透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。
課程資料
- 可獲發
- (證書的發放與分配,依課程提供者的政策及安排而定。)
課程簡介
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:
20+ hours of video tutorials
180+ individual video lectures
Course and exercise files to follow along
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
此課程所涵蓋的技能
評價
-
MMoshe Touboul
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.
-
PPierina Paola Valvo
I like the teacher's voice which is very clear and she explains very well
-
SStanimir Dimitrov
Very explanatory, and well organized. Instructor knows, and able to teach Excel with pleasant voice.
-
NNoah Olusola Oladokun
Very explanatory and i understand every single step easily