Subscribe to The Knowledge Academy’s top courses
Get this course, plus 11,000+ of our top-rated courses, with Personal Plan
Microsoft Excel Expert MO201
Microsoft Technical"Excel at Excel: Master Advanced Techniques for Professional Success."
See Related CourseWhat you'll learn
-
Master advanced workbook management, including handling macros, managing versions, and configuring multilingual support for global collaboration.
-
Develop expertise in managing and formatting data with tools like Flash Fill, advanced fill series, data grouping, subtotals, and custom conditional formatting.
-
Learn to create sophisticated formulas and macros to perform logical operations, data look-ups, and complex calculations across diverse functions.
-
Become proficient in data analysis techniques using Excel's Consolidate feature, What-if analysis, Scenario Manager, and financial functions.
-
Gain advanced skills in troubleshooting formulas, including tracing dependencies, monitoring with the Watch Window, and formula evaluation.
-
Explore the creation and modification of advanced charts and tables such as dual-axis charts, PivotTables, PivotCharts, and various dynamic charts.
-
Discover the power of Excel in performing real-time data analysis, forecasting, and visual representation to support strategic decision-making.
-
Enhance your ability to format, validate, and present data effectively, ensuring accuracy and appeal in reporting.
This course includes
tv24h On-demand Video
13 sections
20 Activities
20
Unlock full course by purchasing this course today! Dive deeper into the content and elevate your learning experience.
Manage Workbooks
1h 7m 42s
Manage Workbooks Cont'd
27m 46s
Prepare Workbooks for Collaboration
18m 13s
Prepare Workbooks for Collaboration Cont'd
28m 29s
‘Fill cells based on existing data’
38m 11s
Fill cells based on existing data
15m 20s
Format & Validate Data Part 1 Custom Number Formats
13m 25s
Format & Validate Data Part 2 Excel Data Validation
22m 42s
Format & Validate Data Part 2 Auto Outline, Subtotal & Remove Duplicates
24m 14s
Apply Advanced Conditional Formatting Part 1 Icon Sets, Data Bars & Custom Fill
19m 29s
Apply Advanced Conditional Formatting Part 2 Formatting based on matched text, MOD function, HighLow formats
20m 14s
Apply Advanced Conditional Formatting Part 3
22m 21s
Perform logical operations in formulas
47m 39s
Look up data by using functions
20m 47s
Use advanced date and time functions
14m 54s
Perform data analysis
38m 14s
Troubleshoot formulas
19m 59s
Create and modify advanced charts
15m 39s
Create and modify PivotTables
14m 8s
Create and modify PivotCharts
7m 15s
Unlock badges by purchasing this course today! Dive deeper into the content and elevate your learning experience.
Unlock certificates by purchasing this course today! Dive deeper into the content and elevate your learning experience.
FAQs
Review Summary