Microsoft Excel – Expert (MO 201)
Course Overview Microsoft Excel is the industry standard spreadsheet program used for data calculations, analysis, visualization, and much more. Course Objectives Master Microsoft Excel from Beginner to Advanced Build a solid understanding on the Basics of Microsoft Excel Learn the most common Excel functions used in the Office Harness the full power of Microsoft Excel by automating […]
Course Overview
Microsoft Excel is the industry standard spreadsheet program used for data calculations, analysis, visualization, and much more.
Course Objectives
- Master Microsoft Excel from Beginner to Advanced
- Build a solid understanding on the Basics of Microsoft Excel
- Learn the most common Excel functions used in the Office
- Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
- Maintain large sets of Excel data in a list or table
- Create dynamic reports by mastering one of the most popular tools, PivotTables
- Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
- Access to a Professional Trainer with 10+ years of Excel Training
Target Audience
- This Microsoft Excel courses will take you through 3 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced).
- If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.
Course Content
Excel Basic
- Getting Started with Microsoft Office Excel 2016
- Modifying a Worksheet
- Performing Calculations
- Formatting a Worksheet
- Printing Workbooks
Excel Intermediate
- Working With Functions
- Working With Lists
- Analyzing Data
- Visualizing Data With Charts
- Analyzing Data With PivotTables and PivotCharts
Excel Advanced
- Working With Multiple Worksheets and Workbooks
- Using Lookup Formulas and Formula Auditing
- Sharing and Protecting Workbooks
- Automating Workbook Functionality
- Creating Sparklines and Mapping Data
Section 1.1 Course Overview
-
1
1.1.0 Excel and the Microsoft Office SuiteExcel and the Microsoft Office Suite
-
2
1.1.1 The Microsoft Office Suite
The Microsoft Office Suite
-
3
1.1.2 Introduction to Microsoft ExcelIntroduction to Microsoft Excel
-
4
1.1.3 Excel Tasks Overview
Excel Tasks Overview
-
5
1.2.0 Course Features
Course Features
-
6
1.2.1 Introduction to the Course
Introduction to the Course
-
7
1.2.2 Course Overview
Course Overview
-
8
1.2.3 Course Objectives
Course Objectives
-
9
1.2.4 Tips for Mac Users
Tips for Mac Users
-
10
1.2.5 Using the Simulated Labs
Using the Simulated Labs
-
11
1.2.6 Keyboard Shortcuts in Labs
Keyboard Shortcuts in Labs
-
12
1.2.7 Tips for Chromebook Users
Tips for Chromebook Users
Section 2.1 Common office features
-
13
2.1.0 Getting Started with Office
Getting Started with Office
-
14
2.1.1 Introduction to Office Applications
Introduction to Office Applications
-
15
2.1.2 Microsoft Office Versions
Microsoft Office Versions
-
16
2.1.3 Learning Office Applications
Learning Office Applications
-
17
2.1.4 The Ribbon
The Ribbon
-
18
2.1.5 Beyond the Ribbon
Beyond the Ribbon
-
19
2.1.6 Backstage View Options
Backstage View Options
-
20
2.1.7 Common Office Application Features
Common Office Application Features
-
21
2.1.8 Desktop vs. Web Applications
Desktop vs. Web Applications
-
22
2.2.0 Customizing Views and Options
Customizing Views and Options
-
23
2.2.1 Document Views
Document Views
-
24
2.2.2 Customization Facts
Customizing Toolbars and Ribbons
-
25
2.2.3 Customization Facts
Customization Facts
-
26
2.2.4 Skills Lab: Customize Views and Options
Skills Lab: Customize Views and Options
-
27
2.2.5 Challenge Lab: Customize Views and Options -
28
2.3.0 Printing Files
Printing Files
-
29
Section 2.3.1 Printing Options in Office Applications
Printing Options in Office Applications
-
30
2.3.2 Skills Lab: Print Files
-
31
2.3.4 Challenge Lab: Print Files
-
32
2.4.0 Navigating Files
Navigating Files
-
33
2.4.1 Navigating Through a Word Document
Navigating Through a Word Document
-
34
2.4.2 Navigating Through an Excel Workbook
Navigating Through an Excel Workbook
-
35
2.4.3 Navigation Facts
Navigation Facts
-
36
2.4.4 Skills Lab: Navigate Files
-
37
2.4.5 Challenge Lab: Navigate Files
-
38
2.5.0 Working with Objects
Working with Objects
-
39
2.5.1 Formatting Images
Formatting Images
-
40
2.5.2 Formatting Shapes
Formatting Shapes
-
41
2.5.3 Object Formatting Facts
Object Formatting Facts
-
42
2.5.4 Skills Lab: Work with Objects
-
43
2.5.5 Challenge Lab: Work with Objects
-
44
Section 2.6.0 Using office collaboration Features
Using Office Collaboration Features
-
45
2.6.1 Track Changes and Comments
-
46
2.6.2 Combining Revisions
Combining Revisions
-
47
2.6.3 Distributing Files
Distributing Files
-
48
2.6.4 Collaboration Facts
Collaboration Facts
-
49
2.6.5 Skills Lab: Use Collaboration Features
-
50
2.6.6 Challenge Lab: Use Collaboration Features
-
51
2.6.7 Collaboration Tips
Collaboration Tips
-
52
2.6.8 Applied Lab: Prepare a Business Memo for Distribution
-
53
2.6.9 Applied Lab: Prepare an Online Resume
Section 3.1 Creating and Managing Workbooks
-
54
Section 3.1.0 Creating and Managing Workbooks
Creating and Managing Workbooks
-
55
3.1.1 Spreadsheet Basics
Spreadsheet Basics
-
56
3.1.2 Templates and Themes
Worksheet Management
-
57
3.1.3 Templates and Themes
Templates and Themes
-
58
3.1.4 External Data
External Data
-
59
3.1.5 Workbook Management Facts
Workbook Management Facts
-
60
3.1.6 Skills Lab: Create and Manage Workbooks
-
61
3.1.7 Challenge Lab: Create and Manage Workbooks
-
62
3.1.8 Workbook Management Tips
Workbook Management Tips
-
63
3.1.9 Applied Lab: Organize Budget Worksheets
-
64
3.1.10 Applied Lab: Import & Organize Research Data
-
65
3.2.0 Organizing and Entering Data
Organizing and Entering Data
-
66
3.2.1 Deleting and Clearing Cells
Deleting and Clearing Cells
-
67
3.2.2 Copy and Paste Options
Copy and Paste Options
-
68
3.2.3 Large Data Sets
Large Data Sets
-
69
3.3.3 Large Data Sets
Large Data Sets
-
70
3.3.4 Skills Lab: Organize and Enter Data
-
71
3.2.6 Challenge Lab: Organize and Enter Data
-
72
3.2.7 Data Entry Tips
Data Entry Tips
-
73
3.2.8 Applied Lab: Enter Survey Results Data
-
74
3.2.9 Applied Lab: Organize Sales Data
-
75
Section 3.3.0
Changing Properties and Printing Worksheets
-
76
3.3.1 Data Protection
Data Protection
-
77
3.3.2 Data Validation
Data Validation
-
78
3.3.3 Excel Printing Tips
Excel Printing Tips
-
79
3.3.4 Worksheet Printing Facts
Worksheet Printing Facts
-
80
3.3.5 Skills Lab: Change Properties and Print Worksheets
-
81
3.3.6 Challenge Lab: Change Properties and Print Worksheets
-
82
3.3.7 Worksheet Printing Tips
Worksheet Printing Tips
-
83
3.3.8 Applied Lab: Prepare and Print Sales Data
-
84
3.3.9 Applied Lab: Protect a Budget Worksheet
-
85
3.4.0 Formatting Cells
Formatting Cells
-
86
3.4.1 Number Formats
Number Formats
-
87
3.4.2 Cell Formats
Cell Formats
-
88
3.4.3 Cell Styles and Colors
Cell Styles and Colors
-
89
3.4.4 Cell Borders
Cell Borders
-
90
3.4.5 Cell Formatting Facts
-
91
3.4.6 Skills Lab: Format Cells
-
92
Challenge Lab: Format Cells
-
93
3.4.8 Cell Formatting Tips
Cell Formatting Tips
-
94
3.4.9 Applied Lab: Camping Equipment Store
-
95
3.4.10 Applied Lab: Format a Directory
Section 4.1 Entering Simple Formulas
-
96
Section 4.1 Entering Simple Formulas
Entering Simple Formulas
-
97
4.1.1 Formulas and Functions
Formulas and Functions
-
98
4.1.2 AutoFill Options
AutoFill Options
-
99
4.1.3 Add and Average
Add and Average
-
100
4.1.4 More Number Functions
More Number Functions
-
101
4.1.5 Text Functions
Text Functions
-
102
4.1.6 Concatenating in Excel
Concatenating in Excel
-
103
4.1.7 Formula Facts
Formula Facts
-
104
4.1.8 Skills Lab: Enter Simple Formulas
-
105
4.1.9 Challenge Lab: Enter Simple Formulas
-
106
4.1.10 Formula Tips
Formula Tips
-
107
4.1.11 Applied Lab: Cheese Shop
-
108
4.1.12 Applied Lab: Gradebook
-
109
4.2 Using Advanced Functions
Using Advanced Functions
-
110
4.2.1 Relative and Absolute References
Relative and Absolute References
-
111
4.2.2 Advanced Cell References
Advanced Cell References
-
112
4.2.3 Named Cells and Ranges
Named Cells and Ranges
-
113
4.2.4 The IF Function
The IF Function
-
114
4.2.5 Logical Functions
Logical Functions
-
115
4.2.6 Excel Error Messages
Excel Error Messages
-
116
4.2.7 Spill Functions
Spill Functions
-
117
4.2.8 Advanced Function Facts
Advanced Function Facts
-
118
4.2.9 Skills Lab: Use Advanced Functions
-
119
4.2.10 Challenge Lab: Use Advanced Functions
-
120
4.2.11 Advanced Function Tips
Advanced Function Tips
-
121
4.2.12 Applied Lab: County Fair
-
122
4.2.13 Applied Lab: Toy Company
Section 5.1 Displaying Data in Charts
-
123
Section 5.1 Displaying Data in Charts
Displaying Data in Charts
-
124
5.1.1 Chart Formatting
Chart Formatting
-
125
5.1.2 Chart Types
Chart Types
-
126
5.1.3 Chart Facts
Chart Facts
-
127
5.1.4 Skills Lab: Display Data in Charts
-
128
5.1.5 Challenge Lab: Display Data in Charts
-
129
5.1.6 Chart Tips
Chart Tips
-
130
5.1.7 Applied Lab: Stock Portfolio
-
131
5.1.8 Applied Lab: Election Results
-
132
5.2 Organizing Data in Tables
Organizing Data in Tables
-
133
5.2.1 Conditional Formatting
Conditional Formatting
-
134
5.2.2 Excel Tables
Excel Tables
-
135
5.2.3 Table Customization
Table Customization
-
136
5.2.4 Using Formulas in Tables
Using Formulas in Tables
-
137
5.2.5 Excel Table Facts
-
138
5.2.6 Skills Lab: Organize Data in Tables
-
139
5.2.7 Challenge Lab: Organize Data in Tables
-
140
5.2.8 Excel Table Tips
Excel Table Tips
-
141
5.2.9 Applied Lab: Pizza Chain
-
142
5.2.10 Applied Lab: Baseball Statistics
Section 6.1 Excel Live Projects
-
143
Section 6.1 Excel Live Projects
Excel Live Projects
-
144
6.1.1 How to Use Excel Live Projects
How to Use Excel Live Projects
-
145
6.1.2 Installing the Optional Task Guide in Excel
Installing the Optional Task Guide in Excel
-
146
6.1.3 Additional Tips for Excel Live Projects
Additional Tips for Excel Live Projects
-
147
copy print bookmark toggle menu Next Resource 6.1.4 Excel Project: Modify an Expense Report
-
148
6.1.5 Excel Project: Analyze Sales Data
-
149
6.1.6 Excel Project: Analyze Sales Transactions
Section 7.1 Preparing for MOS Associate Certification
-
150
Section 7.1 Preparing for MOS Associate Certification
Preparing for MOS Associate Certification
-
151
7.1.1 Preparing for the MOS Exams
Preparing for the MOS Exams
-
152
7.1.2 Performing Unfamiliar Tasks
Performing Unfamiliar Tasks
-
153
7.1.3 Which MOS Exam to Take?
Which MOS Exam to Take?
-
154
7.1.4 Using TestOut MOS Practice Exams
Using TestOut MOS Practice Exams
-
155
7.1.5 Excel (Microsoft 365 Apps) Exam Objectives
Excel (Microsoft 365 Apps) Exam Objectives
-
156
7.1.6 Excel Associate 2019 Exam Objectives
-
157
7.1.7 Taking an MOS Exam
-
158
Section 7.2 Domain Domain Practice Labs: Excel Associate 365 (MO-210)
Domain Domain Practice Labs: Excel Associate 365 (MO-210)
-
159
Section 7.3 Practice Exams: Excel Associate 365 (MO-210)
Practice Exams: Excel Associate 365 (MO-210)
-
160
7.3.1 Microsoft Excel Associate Practice - Form A
Microsoft Excel Associate Practice - Form A
-
161
7.3.2 Microsoft Excel Associate Practice - Form B
-
162
Section 7.4 Domain Practice Labs: Excel Associate 2019 (MO-200)
-
163
Section 7.5 Practice Exams: Excel Associate 2019 (MO-200)
Practice Exams: Excel Associate 2019 (MO-200)
-
164
7.5.1 Microsoft Excel Associate Practice - Form A
Microsoft Excel Associate Practice - Form A
-
165
7.5.2 Microsoft Excel Associate Practice - Form B
Microsoft Excel Associate Practice - Form B
Section 8.1 Managing Workbooks
-
166
Section 8.1 Managing Workbooks
Managing Workbooks
-
167
8.1.1 Configuring AutoSave and AutoRecover
Configuring AutoSave and AutoRecover
-
168
8.1.2 Referencing Data in Other Workbooks
Referencing Data in Other Workbooks
-
169
8.1.3 Configuring and Using Language-Specific Features
Configuring and Using Language-Specific Features
-
170
8.1.4 Manage Workbooks Facts
Manage Workbooks Facts
-
171
8.1.5 Skills Lab: Manage Workbooks
-
172
8.1.6 Challenge Lab: Manage Workbooks
-
173
8.1.7 Manage Workbooks Tips
Manage Workbooks Tips
-
174
8.1.8 Applied Lab: Manage IT Expenses
-
175
8.1.9 Applied Lab: Manage Exchange Rates
-
176
8.2 Preparing Workbooks for Collaboration
Preparing Workbooks for Collaboration
-
177
8.2.1 Protecting Cell Ranges, Worksheets, and Workbooks
Protecting Cell Ranges, Worksheets, and Workbooks
-
178
8.2.2 Configuring Formula Calculation Options
Configuring Formula Calculation Options
-
179
8.2.3 Prepare Workbooks for Collaboration Facts
Prepare Workbooks for Collaboration Facts
-
180
8.2.4 Skills Lab: Prepare Workbooks for Collaboration
-
181
8.2.5 Challenge Lab: Prepare Workbooks for Collaboration
-
182
8.2.6 Prepare Workbooks for Collaboration Tips
Prepare Workbooks for Collaboration Tips
-
183
8.2.7 Applied Lab: Protect Budget Summary
-
184
8.2.8 Applied Lab: Protect Monthly Financial Report
Section 9.1 Filling Cells Based on Existing Data
-
185
Section 9.1 Filling Cells Based on Existing Data
Filling Cells Based on Existing Data
-
186
9.1.1 Flash Fill and Advanced Fill Series Options
Flash Fill and Advanced Fill Series Options
-
187
9.1.2 Fill Cells Based on Existing Data Facts
Fill Cells Based on Existing Data Facts
-
188
9.1.3 Skills Lab: Fill Cells Based on Existing Data
-
189
9.1.4 Challenge Lab: Fill Cells Based on Existing Data
-
190
9.1.5 Fill Cells Based on Existing Data Tips
Fill Cells Based on Existing Data Tips
-
191
9.1.6 Applied Lab: Fill Event Data
-
192
9.1.7 Applied Lab: Fill Database Data
-
193
Section 9.2 Formatting and Validating Data
Formatting and Validating Data
-
194
9.2.1 Custom Number Formats
Custom Number Formats
-
195
9.2.2 Configuring Data Validation
Configuring Data Validation
-
196
9.2.3 Using Outlines to Create Groups and Subtotals
-
197
9.2.4 Removing Duplicate Records
-
198
9.2.5 Format and Validate Data Facts
Format and Validate Data Facts
-
199
9.2.6 Skills Lab: Format and Validate Data
-
200
9.2.7 Challenge Lab: Format and Validate Data
-
201
9.2.8 Format and Validate Data Tips
-
202
9.2.9 Applied Lab: Format and Validate Vendor Scorecard
-
203
9.2.10 Applied Lab: Format and Validate Journal Entries
-
204
Section 9.3 Advanced Conditional Formatting and Filtering
Advanced Conditional Formatting and Filtering
-
205
9.3.1 Boolean Operators
Boolean Operators
-
206
9.3.2 Using Boolean Logic in Excel
Using Boolean Logic in Excel
-
207
9.3.3 Custom Conditional Formatting Rules
Custom Conditional Formatting Rules
-
208
9.3.4 Conditional Formatting Rules That Use Formulas
Conditional Formatting Rules That Use Formulas
-
209
9.3.5 Apply Advanced Conditional Formatting and Filtering Facts
Apply Advanced Conditional Formatting and Filtering Facts
-
210
9.3.6 Skills Lab: Apply Advanced Conditional Formatting
-
211
9.3.7 Challenge Lab: Apply Advanced Conditional Formatting
-
212
9.3.8 Apply Advanced Conditional Formatting and Filtering Tips
Apply Advanced Conditional Formatting and Filtering Tips
-
213
9.3.9 Applied Lab: Format Client Data
-
214
9.3.10 Applied Lab: Format Property Data
Section 10.1 Advanced Formulas and Macros
-
215
Section 10.1 Performing Logical Operations in Formulas
Performing Logical Operations in Formulas
-
216
10.1.1 Logical Functions and Nested Functions
Logical Functions and Nested Functions
-
217
10.1.2 Logical Operations with Mathematical Functions
Logical Operations with Mathematical Functions
-
218
bookmark toggle menu Next Resource 10.1.3 The LET Function
The LET Function
-
219
speechify copy print bookmark toggle menu Next Resource 10.1.4 Perform Logical Operations in Formulas Facts
Perform Logical Operations in Formulas Facts
-
220
10.1.5 Skills Lab: Perform Logical Operations in Formulas
-
221
10.1.6 Challenge Lab: Perform Logical Operations in Formulas
-
222
10.1.7 Perform Logical Operations in Formulas Tips
-
223
10.1.8 Applied Lab: Perform Logical Operations on Web Orders
-
224
10.1.9 Applied Lab: Perform Logical Operations on Payroll Data
-
225
Section 10.2 Looking Up Data by Using Functions
Looking Up Data by using Functions
-
226
10.2.1 The VLOOKUP and HLOOKUP Functions
The VLOOKUP and HLOOKUP Functions
-
227
10.2.2 The MATCH and INDEX Functions
The MATCH and INDEX Functions
-
228
10.2.3 The XLOOKUP Function
The XLOOKUP Function
-
229
10.2.4 Look Up Data by Using Functions Facts
Look Up Data by Using Functions Facts
-
230
10.2.5 Skills Lab: Look up Data by Using Functions
-
231
10.2.6 Challenge Lab: Look Up Data by Using Functions
-
232
10.2.7 Look Up Data by Using Functions Tips
Look Up Data by Using Functions Tips
-
233
10.2.8 Applied Lab: Look Up Inventory Data
-
234
10.2.9 Applied Lab: Watch Retailer
-
235
Section 10.3 Using Advanced Date and Time Functions
Using Advanced Date and Time Functions
-
236
10.3.1 Date and Time Functions
Date and Time Functions
-
237
10.3.2 Use Advanced Date and Time Functions Facts
Use Advanced Date and Time Functions Facts
-
238
10.3.3 Skills Lab: Use Advanced Date and Time Functions
-
239
10.3.4 Challenge Lab: Use Advanced Date and Time Functions
-
240
10.3.5 Use Advanced Date and Time Functions Tips
Use Advanced Date and Time Functions Tips
-
241
10.3.6 Applied Lab: Use Advanced Date and Time Functions on Project Timeline
-
242
10.3.7 Applied Lab: Use Advanced Date and Time Functions in Project Planning
-
243
Section 10.4 Performing Data Analysis
Performing Data Analysis
-
244
10.4.1 Summarizing Data from Multiple Ranges
Summarizing Data from Multiple Ranges
-
245
10.4.2 Performing What-If Analysis
Performing What-If Analysis
-
246
10.4.3 Filtering and Sorting with Dynamic Arrays
Filtering and Sorting with Dynamic Arrays
-
247
10.4.4 Common Financial Terminology
Common Financial Terminology
-
248
10.4.5 Calculating Finacial Data
Calculating Financial Data
-
249
10.4.6 Perform Data Analysis Facts
Perform Data Analysis Facts
-
250
10.4.7 Skills Lab: Perform Data Analysis
-
251
10.4.8 Challenge Lab: Perform Data Analysis
-
252
10.4.9 Peform data Analysis Tips
Peform data Analysis Tips
-
253
10.4.10 Applied Lab: Analyze and Consolidate Data
-
254
10.4.11 Applied Lab: Analyze Different Scenarios
-
255
Section 10.5 Troubleshooting Formulas
Troubleshooting Formulas
-
256
10.5.1 Tracing Precedents and Dependents
Tracing Precedents and Dependents
-
257
10.5.2 The Watch Window
The Watch Window
-
258
10.5.3 Errors and Error Checking
Errors and Error Checking
-
259
10.5.4 Evaluating Formulas
Evaluating Formulas
-
260
10.5.5 Troubleshoot Formulas Facts
Troubleshoot Formulas Facts
-
261
10.5.6 Troubleshoot Formulas Tips
Troubleshoot Formulas Tips
-
262
Section 10.6 Creating and Modifying Simple Macros
Creating and Modifying Simple Macros
-
263
10.6.1 Recording and Running Simple Macros
Recording and Running Simple Macros
-
264
10.6.2 Enabling and Disabling Macros
Enabling and Disabling Macros
-
265
10.6.3 Copying Macros Between Workbooks
Copying Macros Between Workbooks
-
266
10.6.4 Create and Modify Simple Macros Facts
Create and Modify Simple Macros Facts
-
267
10.6.5 Skills: Create and Modify Simple Macros
-
268
10.6.6 Challenge Lab: Create and Modify Simple Macros
-
269
10.6.7 Create and Modify Simple Macros Tips
Create and Modify Simple Macros Tips
-
270
10.6.8 Applied Lab: Practice Creating and Configuring Macros
-
271
10.6.9 Applied Lab: Create and Run a Date Insertion Macro
Section 11.1 Advanced and Charts and Tables
-
272
Section 11.1 Creating and Modifying Advanced Charts
Creating and Modifying Advanced Charts
-
273
11.1.1 Selecting Advanced Chart Types
Selecting Advanced Chart Types
-
274
11.1.2 Advanced Chart Formatting
Advanced Chart Formatting
-
275
11.1.3 Dual Axis Charts
Dual Axis Charts
-
276
11.1.4 Create and Modify Advanced Charts Facts
Create and Modify Advanced Charts Facts
-
277
11.1.5 Skills Lab: Create and Modify Advanced Charts
-
278
11.1.6 Challenge Lab: Create and Modify Advanced Charts
-
279
11.1.7 Create and Modify Advanced Charts Tips
Create and Modify Advanced Charts Tips
-
280
11.1.8 Applied Lab: Customer Service Charts
-
281
11.1.9 Applied Lab: Sales Conference Charts
-
282
Section 11.2 Creating and Modifying PivotTables
Creating and Modifying PivotTables
-
283
11.2.1 Introduction to PivotTables
Introduction to PivotTables
-
284
11.2.2 Advanced PivotTable Features
Advanced PivotTable Features
-
285
11.2.3 Calculated Fields in PivotTables
Calculated Fields in PivotTables
-
286
11.2.4 Create and Modify PivotTables Facts
Create and Modify PivotTables Facts
-
287
11.2.5 Skills Lab: Create and Modify PivotTables
-
288
11.2.6 Challenge Lab: Create and Modify PivotTables
-
289
11.2.7 Create and Modify PivotTables Tips
Create and Modify PivotTables Tips
-
290
11.2.8 Applied Lab: Hardware Disposal Data Analysis
-
291
11.2.9 Applied Lab: Product Data Analysis
-
292
Section 11.3 Creating and Modifying PivotCharts
Creating and Modifying PivotCharts
-
293
11.3.1 Creating and Manipulating PivotCharts
Creating and Manipulating PivotCharts
-
294
11.3.2 Drilling Down into PivotChart Details
Drilling Down into PivotChart Details
-
295
11.3.3 Create and Modify PivotCharts Facts
Create and Modify PivotCharts Facts
-
296
11.3.4 Skills Lab: Create and Modify PivotCharts
-
297
11.3.5 Challenge Lab: Create and Modify PivotCharts
-
298
11.3.6 Create and Modify PivotCharts Tips
Create and Modify PivotCharts Tips
-
299
11.3.7 Applied Lab: PivotCharts for Project Data
-
300
11.3.8 Applied Lab: PivotCharts for Gross Profit
Section 12.1 Preparing for MOS Expert Certification
-
301
Section 12.1 Preparing for MOS Expert Certification
Preparing for MOS Expert Certification
-
302
12.1.1 Preparing for the MOS Exams
Preparing for the MOS Exams
-
303
12.1.2 Performing Unfamiliar Tasks
Performing Unfamiliar Tasks
-
304
12.1.3 Which MOS Exam to Take?
Which MOS Exam to Take?
-
305
12.1.4 Using TestOut MOS Practice Exams
Using TestOut MOS Practice Exams
-
306
12.1.5 Excel Expert (Microsoft 365 Apps) Exam Objectives
Excel Expert (Microsoft 365 Apps) Exam Objectives
-
307
12.1.6 Excel Expert Associate 2019 Exam Objectives
Excel Expert Associate 2019 Exam Objectives
-
308
12.1.7 Taking an MOS Exam
Taking an MOS Exam
-
309
12.2 Domain Practice Labs: Excel Expert 365 (MO-211)
Domain Practice Labs: Excel Expert 365 (MO-211)
-
310
12.3 Practice Exams: Excel Expert 365 (MO-211)
Practice Exams: Excel Expert 365 (MO-211)
-
311
12.3.1 Microsdoft Excel Expert Practice - Form A
-
312
12.3.2 Microsdoft Excel Expert Practice - Form B
-
313
12.4 Domain Practice Labs: Excel Expert 2019 (MO-201)
Domain Practice Labs: Excel Expert 2019 (MO-201)
-
314
Section 12.5 Practice Exams: Excel Expert 2019 (MO-201)
Practice Exams: Excel Expert 2019 (MO-201)
-
315
12.5.1 Microsoft Excel Expert Practice - Form A
-
316
12.5.2 Microsoft Excel Expert Practice - Form B
A.1 TestOut Certified: Microsoft Excel Advacnced Certification
-
317
A.1 TestOut Certified: Microsoft Excel Advacnced Certification
TestOut Certified: Microsoft Excel Advacnced Certification
-
318
A.1.1 Pro Exam Objectives
Pro Exam Objectives
-
319
A.1.2 Pro Exam Objectives by Course Section
Pro Exam Objectives by Course Section
-
320
A.1.3 How to take the Pro Exam
How to take the Pro Exam
-
321
A.1.4 Pro Exam FAQs
Pro Exam FAQs
-
322
Section A.2 TestOut Pro Certified: Microsoft Excel® Advanced Exam Domain Review
TestOut Pro Certified: Microsoft Excel® Advanced Exam Domain Review
-
323
A.2.1 Pro Domain 1: Workbooks and Worksheets
-
324
A.2.2 Pro Domain 2: Formatting and Data
-
325
A.2.3 Pro Domain 3: Functions, Formulas, and Macros
-
326
A.2.4 Pro Domain 4: Charts and Tables
-
327
Section A.3 TestOut Pro Certified: Microsoft Excel® Advanced Practice Exams
TestOut Pro Certified: Microsoft Excel® Advanced Practice Exams
-
328
A.3.1 Certification Practice Exam - Form A
-
329
A.3.2 Certification Practice Exam - Form B
Glossary
Be the first to add a review.
Please, login to leave a review
Related Courses
In-person
After learning CompTIA Data+, you can expect to have a comprehensive understanding of data management, analysis, and interpretation within various ...
₦250,000
In-person
Python is a versatile and powerful programming language widely used across various industries and disciplines. Our Python course model offers a com...
₦100,000
