-
Title
-
Excel 2021/365 Advanced
-
Package
-
Digitale SAP-Bibliothek
-
Platform
-
Your learning platform for SAP software
-
URL
-
https://et.training/dashboard/product/video/1084
-
Status
-
Deleted
-
Publication Type
-
Other
-
Medium
-
Empty
-
Language
-
-
First Author
-
Simon Sez IT
-
First Editor
-
Empty
-
Publisher Name
-
Empty
-
Date First in Print
-
Empty
-
Date First Online
-
2022-01-01
-
Access Start Date
-
Empty
-
Access End Date
-
Empty
-
Volume Number
-
Empty
-
Edition Statement
-
Empty
-
Access Type
-
Empty
-
Note
-
Microsoft Excel 2021 Advanced TrainingSubheading/headline:Master Microsoft Excel 2021 and fast-track your knowledge to ‘guru’ status with this advanced course!In this third course of our Excel 2021 series, students will build on the skills learned in the beginner and intermediate courses and take their functional expertise to new heights.Students will be introduced to six brand-new dynamic array functions, learn how to build advanced Excel formulas, analyse data with advanced PivotTable skills, create macros to automate tasks, import and clean data with Power Query, forecast data, and so much more!Excel 2021 Advanced is designed to take advantage of the latest updates from Microsoft including the game-changing LET and LAMBDA functions. These exciting functions allow students to create their own variables and even their own Excel functions.This course is designed to help students tackle problem-solving differently and combine Excel’s myriad of functions to complete practical tasks.Excel 2021 Advanced is designed for students who have intermediate-level knowledge of Excel and are looking to build on those skills. It’s also perfect for students competent with an older version of Excel.The only prerequisites for this course are a working copy of Excel 2021 and an intermediate-level knowledge of the application.In this ten-hour advanced course, students will learn how to:Use the NEW Dynamic Array functions to perform tasksCreate advanced and flexible lookup formulasUse statistical functions to rank data and calculate the MEDIAN and MODEProduce accurate results when working with financial data using math functionsCreate variables and functions with LET and LAMBDAAnalyse data with advanced PivotTable and PivotChart hacksAdd interactivity to reports and dashboards by incorporating form controlsImport and clean data using Power QueryPredict future values using forecast functions and forecast sheetsRecord and run macros to automate repetitive tasksUnderstand and make minor edits to VBA codeCombine functions to create practical formulas to complete specific tasks.
-
Last Changed External
-
Empty
- Date Created
-
2023-08-18 11:30:19
- Last Updated
-
2024-03-14 14:09:55
- UUID
-
ca30e017-c836-4a4a-a740-65e8f96e3d7e
Identifier Namespace Name |
Identifier Namespace Value |
Identifier |
Title_ID
|
title_id
|
1084
|
Dewey Decimal Classification |
-
Series
-
Empty
-
Parent publication title ID
-
Empty
-
Superseding publication title ID
-
Empty
-
Preceding publication title ID
-
Empty
Price Type |
Value |
Currency |