Excel For Data Analyst
Studying Excel is crucial for mastering essential data management and analysis skills, which are valuable across a wide range of ...
Show more
Category
40
Students
enrolled
- Description
- Curriculum
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
-
143
5.2.11 Applied Lab: Using dataset
Section 6.1 Excel Live Projects
-
144
Section 6.1 Excel Live Projects
Excel Live Projects
-
145
6.1.1 How to Use Excel Live Projects
How to Use Excel Live Projects
-
146
6.1.2 Installing the Optional Task Guide in Excel
Installing the Optional Task Guide in Excel
-
147
6.1.3 Additional Tips for Excel Live Projects
Additional Tips for Excel Live Projects
-
148
6.1.4 Excel Project: Modify an Expense Report
-
149
6.1.5 Excel Project: Analyze Sales Data
-
150
6.1.6 Excel Project: Analyze Sales Transactions
Section 7.1 Preparing for MOS Associate Certification
-
151
Section 7.1 Preparing for MOS Associate Certification
Preparing for MOS Associate Certification
-
152
7.1.1 Preparing for the MOS Exams
Preparing for the MOS Exams
-
153
7.1.2 Performing Unfamiliar Tasks
Performing Unfamiliar Tasks
-
154
7.1.3 Which MOS Exam to Take?
Which MOS Exam to Take?
-
155
7.1.4 Using TestOut MOS Practice Exams
Using TestOut MOS Practice Exams
-
156
7.1.5 Excel (Microsoft 365 Apps) Exam Objectives
Excel (Microsoft 365 Apps) Exam Objectives
-
157
7.1.6 Excel Associate 2019 Exam Objectives
-
158
7.1.7 Taking an MOS Exam
-
159
Section 7.2 Domain Domain Practice Labs: Excel Associate 365 (MO-210)
Domain Domain Practice Labs: Excel Associate 365 (MO-210)
-
160
Section 7.3 Practice Exams: Excel Associate 365 (MO-210)
Practice Exams: Excel Associate 365 (MO-210)
-
161
7.3.1 Microsoft Excel Associate Practice - Form A
Microsoft Excel Associate Practice - Form A
-
162
7.3.2 Microsoft Excel Associate Practice - Form B
-
163
Section 7.4 Domain Practice Labs: Excel Associate 2019 (MO-200)
-
164
Section 7.5 Practice Exams: Excel Associate 2019 (MO-200)
Practice Exams: Excel Associate 2019 (MO-200)
-
165
7.5.1 Microsoft Excel Associate Practice - Form A
Microsoft Excel Associate Practice - Form A
-
166
7.5.2 Microsoft Excel Associate Practice - Form B
Microsoft Excel Associate Practice - Form B
Section 8.1 Managing Workbooks
-
167
Section 8.1 Managing Workbooks
Managing Workbooks
-
168
8.1.1 Configuring AutoSave and AutoRecover
Configuring AutoSave and AutoRecover
-
169
8.1.2 Referencing Data in Other Workbooks
Referencing Data in Other Workbooks
-
170
8.1.3 Configuring and Using Language-Specific Features
Configuring and Using Language-Specific Features
-
171
8.1.4 Manage Workbooks Facts
Manage Workbooks Facts
-
172
8.1.5 Skills Lab: Manage Workbooks
-
173
8.1.6 Challenge Lab: Manage Workbooks
-
174
8.1.7 Manage Workbooks Tips
Manage Workbooks Tips
-
175
8.1.8 Applied Lab: Manage IT Expenses
-
176
8.1.9 Applied Lab: Manage Exchange Rates
-
177
8.2 Preparing Workbooks for Collaboration
Preparing Workbooks for Collaboration
-
178
8.2.1 Protecting Cell Ranges, Worksheets, and Workbooks
Protecting Cell Ranges, Worksheets, and Workbooks
-
179
8.2.2 Configuring Formula Calculation Options
Configuring Formula Calculation Options
-
180
8.2.3 Prepare Workbooks for Collaboration Facts
Prepare Workbooks for Collaboration Facts
-
181
8.2.4 Skills Lab: Prepare Workbooks for Collaboration
-
182
8.2.5 Challenge Lab: Prepare Workbooks for Collaboration
-
183
8.2.6 Prepare Workbooks for Collaboration Tips
Prepare Workbooks for Collaboration Tips
-
184
8.2.7 Applied Lab: Protect Budget Summary
-
185
8.2.8 Applied Lab: Protect Monthly Financial Report
Section 9.1 Filling Cells Based on Existing Data
-
186
Section 9.1 Filling Cells Based on Existing Data
Filling Cells Based on Existing Data
-
187
9.1.1 Flash Fill and Advanced Fill Series Options
Flash Fill and Advanced Fill Series Options
-
188
9.1.2 Fill Cells Based on Existing Data Facts
Fill Cells Based on Existing Data Facts
-
189
9.1.3 Skills Lab: Fill Cells Based on Existing Data
-
190
9.1.4 Challenge Lab: Fill Cells Based on Existing Data
-
191
9.1.5 Fill Cells Based on Existing Data Tips
Fill Cells Based on Existing Data Tips
-
192
9.1.6 Applied Lab: Fill Event Data
-
193
9.1.7 Applied Lab: Fill Database Data
-
194
Section 9.2 Formatting and Validating Data
Formatting and Validating Data
-
195
9.2.1 Custom Number Formats
Custom Number Formats
-
196
9.2.2 Configuring Data Validation
Configuring Data Validation
-
197
9.2.3 Using Outlines to Create Groups and Subtotals
-
198
9.2.4 Removing Duplicate Records
-
199
9.2.5 Format and Validate Data Facts
Format and Validate Data Facts
-
200
9.2.6 Skills Lab: Format and Validate Data
-
201
9.2.7 Challenge Lab: Format and Validate Data
-
202
9.2.8 Format and Validate Data Tips
-
203
9.2.9 Applied Lab: Format and Validate Vendor Scorecard
-
204
9.2.10 Applied Lab: Format and Validate Journal Entries
-
205
Section 9.3 Advanced Conditional Formatting and Filtering
Advanced Conditional Formatting and Filtering
-
206
9.3.1 Boolean Operators
Boolean Operators
-
207
9.3.2 Using Boolean Logic in Excel
Using Boolean Logic in Excel
-
208
9.3.3 Custom Conditional Formatting Rules
Custom Conditional Formatting Rules
-
209
9.3.4 Conditional Formatting Rules That Use Formulas
Conditional Formatting Rules That Use Formulas
-
210
9.3.5 Apply Advanced Conditional Formatting and Filtering Facts
Apply Advanced Conditional Formatting and Filtering Facts
-
211
9.3.6 Skills Lab: Apply Advanced Conditional Formatting
-
212
9.3.7 Challenge Lab: Apply Advanced Conditional Formatting
-
213
9.3.8 Apply Advanced Conditional Formatting and Filtering Tips
Apply Advanced Conditional Formatting and Filtering Tips
-
214
9.3.9 Applied Lab: Format Client Data
-
215
9.3.10 Applied Lab: Format Property Data
Section 10.1 Advanced Formulas and Macros
-
216
Section 10.1 Performing Logical Operations in Formulas
Performing Logical Operations in Formulas
-
217
10.1.1 Logical Functions and Nested Functions
Logical Functions and Nested Functions
-
218
10.1.2 Logical Operations with Mathematical Functions
Logical Operations with Mathematical Functions
-
219
bookmark toggle menu Next Resource 10.1.3 The LET Function
The LET Function
-
220
speechify copy print bookmark toggle menu Next Resource 10.1.4 Perform Logical Operations in Formulas Facts
Perform Logical Operations in Formulas Facts
-
221
10.1.5 Skills Lab: Perform Logical Operations in Formulas
-
222
10.1.6 Challenge Lab: Perform Logical Operations in Formulas
-
223
10.1.7 Perform Logical Operations in Formulas Tips
-
224
10.1.8 Applied Lab: Perform Logical Operations on Web Orders
-
225
10.1.9 Applied Lab: Perform Logical Operations on Payroll Data
-
226
Section 10.2 Looking Up Data by Using Functions
Looking Up Data by using Functions
-
227
10.2.1 The VLOOKUP and HLOOKUP Functions
The VLOOKUP and HLOOKUP Functions
-
228
10.2.2 The MATCH and INDEX Functions
The MATCH and INDEX Functions
-
229
10.2.3 The XLOOKUP Function
The XLOOKUP Function
-
230
10.2.4 Look Up Data by Using Functions Facts
Look Up Data by Using Functions Facts
-
231
10.2.5 Skills Lab: Look up Data by Using Functions
-
232
10.2.6 Challenge Lab: Look Up Data by Using Functions
-
233
10.2.7 Look Up Data by Using Functions Tips
Look Up Data by Using Functions Tips
-
234
10.2.8 Applied Lab: Look Up Inventory Data
-
235
10.2.9 Applied Lab: Watch Retailer
-
236
Section 10.3 Using Advanced Date and Time Functions
Using Advanced Date and Time Functions
-
237
10.3.1 Date and Time Functions
Date and Time Functions
-
238
10.3.2 Use Advanced Date and Time Functions Facts
Use Advanced Date and Time Functions Facts
-
239
10.3.3 Skills Lab: Use Advanced Date and Time Functions
-
240
10.3.4 Challenge Lab: Use Advanced Date and Time Functions
-
241
10.3.5 Use Advanced Date and Time Functions Tips
Use Advanced Date and Time Functions Tips
-
242
10.3.6 Applied Lab: Use Advanced Date and Time Functions on Project Timeline
-
243
10.3.7 Applied Lab: Use Advanced Date and Time Functions in Project Planning
-
244
Section 10.4 Performing Data Analysis
Performing Data Analysis
-
245
10.4.1 Summarizing Data from Multiple Ranges
Summarizing Data from Multiple Ranges
-
246
10.4.2 Performing What-If Analysis
Performing What-If Analysis
-
247
10.4.3 Filtering and Sorting with Dynamic Arrays
Filtering and Sorting with Dynamic Arrays
-
248
10.4.4 Common Financial Terminology
Common Financial Terminology
-
249
10.4.5 Calculating Finacial Data
Calculating Financial Data
-
250
10.4.6 Perform Data Analysis Facts
Perform Data Analysis Facts
-
251
10.4.7 Skills Lab: Perform Data Analysis
-
252
10.4.8 Challenge Lab: Perform Data Analysis
-
253
10.4.9 Peform data Analysis Tips
Peform data Analysis Tips
-
254
10.4.10 Applied Lab: Analyze and Consolidate Data
-
255
10.4.11 Applied Lab: Analyze Different Scenarios
-
256
Section 10.5 Troubleshooting Formulas
Troubleshooting Formulas
-
257
10.5.1 Tracing Precedents and Dependents
Tracing Precedents and Dependents
-
258
10.5.2 The Watch Window
The Watch Window
-
259
10.5.3 Errors and Error Checking
Errors and Error Checking
-
260
10.5.4 Evaluating Formulas
Evaluating Formulas
-
261
10.5.5 Troubleshoot Formulas Facts
Troubleshoot Formulas Facts
-
262
10.5.6 Troubleshoot Formulas Tips
Troubleshoot Formulas Tips
-
263
Section 10.6 Creating and Modifying Simple Macros
Creating and Modifying Simple Macros
-
264
10.6.1 Recording and Running Simple Macros
Recording and Running Simple Macros
-
265
10.6.2 Enabling and Disabling Macros
Enabling and Disabling Macros
-
266
10.6.3 Copying Macros Between Workbooks
Copying Macros Between Workbooks
-
267
10.6.4 Create and Modify Simple Macros Facts
Create and Modify Simple Macros Facts
-
268
10.6.5 Skills: Create and Modify Simple Macros
-
269
10.6.6 Challenge Lab: Create and Modify Simple Macros
-
270
10.6.7 Create and Modify Simple Macros Tips
Create and Modify Simple Macros Tips
-
271
10.6.8 Applied Lab: Practice Creating and Configuring Macros
-
272
10.6.9 Applied Lab: Create and Run a Date Insertion Macro
Section 11.1 Advanced and Charts and Tables
-
273
Section 11.1 Creating and Modifying Advanced Charts
Creating and Modifying Advanced Charts
-
274
11.1.1 Selecting Advanced Chart Types
Selecting Advanced Chart Types
-
275
11.1.2 Advanced Chart Formatting
Advanced Chart Formatting
-
276
11.1.3 Dual Axis Charts
Dual Axis Charts
-
277
11.1.4 Create and Modify Advanced Charts Facts
Create and Modify Advanced Charts Facts
-
278
11.1.5 Skills Lab: Create and Modify Advanced Charts
-
279
11.1.6 Challenge Lab: Create and Modify Advanced Charts
-
280
11.1.7 Create and Modify Advanced Charts Tips
Create and Modify Advanced Charts Tips
-
281
11.1.8 Applied Lab: Customer Service Charts
-
282
11.1.9 Applied Lab: Sales Conference Charts
-
283
Section 11.2 Creating and Modifying PivotTables
Creating and Modifying PivotTables
-
284
11.2.1 Introduction to PivotTables
Introduction to PivotTables
-
285
11.2.2 Advanced PivotTable Features
Advanced PivotTable Features
-
286
11.2.3 Calculated Fields in PivotTables
Calculated Fields in PivotTables
-
287
11.2.4 Create and Modify PivotTables Facts
Create and Modify PivotTables Facts
-
288
11.2.5 Skills Lab: Create and Modify PivotTables
-
289
11.2.6 Challenge Lab: Create and Modify PivotTables
-
290
11.2.7 Create and Modify PivotTables Tips
Create and Modify PivotTables Tips
-
291
11.2.8 Applied Lab: Hardware Disposal Data Analysis
-
292
11.2.9 Applied Lab: Product Data Analysis
-
293
Section 11.3 Creating and Modifying PivotCharts
Creating and Modifying PivotCharts
-
294
11.3.1 Creating and Manipulating PivotCharts
Creating and Manipulating PivotCharts
-
295
11.3.2 Drilling Down into PivotChart Details
Drilling Down into PivotChart Details
-
296
11.3.3 Create and Modify PivotCharts Facts
Create and Modify PivotCharts Facts
-
297
11.3.4 Skills Lab: Create and Modify PivotCharts
-
298
11.3.5 Challenge Lab: Create and Modify PivotCharts
-
299
11.3.6 Create and Modify PivotCharts Tips
Create and Modify PivotCharts Tips
-
300
11.3.7 Applied Lab: PivotCharts for Project Data
-
301
11.3.8 Applied Lab: PivotCharts for Gross Profit
Section 12.1 Preparing for MOS Expert Certification
-
302
Section 12.1 Preparing for MOS Expert Certification
Preparing for MOS Expert Certification
-
303
12.1.1 Preparing for the MOS Exams
Preparing for the MOS Exams
-
304
12.1.2 Performing Unfamiliar Tasks
Performing Unfamiliar Tasks
-
305
12.1.3 Which MOS Exam to Take?
Which MOS Exam to Take?
-
306
12.1.4 Using TestOut MOS Practice Exams
Using TestOut MOS Practice Exams
-
307
12.1.5 Excel Expert (Microsoft 365 Apps) Exam Objectives
Excel Expert (Microsoft 365 Apps) Exam Objectives
-
308
12.1.6 Excel Expert Associate 2019 Exam Objectives
Excel Expert Associate 2019 Exam Objectives
-
309
12.1.7 Taking an MOS Exam
Taking an MOS Exam
-
310
12.2 Domain Practice Labs: Excel Expert 365 (MO-211)
Domain Practice Labs: Excel Expert 365 (MO-211)
-
311
12.3 Practice Exams: Excel Expert 365 (MO-211)
Practice Exams: Excel Expert 365 (MO-211)
-
312
12.3.1 Microsdoft Excel Expert Practice - Form A
-
313
12.3.2 Microsdoft Excel Expert Practice - Form B
-
314
12.4 Domain Practice Labs: Excel Expert 2019 (MO-201)
Domain Practice Labs: Excel Expert 2019 (MO-201)
-
315
Section 12.5 Practice Exams: Excel Expert 2019 (MO-201)
Practice Exams: Excel Expert 2019 (MO-201)
-
316
12.5.1 Microsoft Excel Expert Practice - Form A
-
317
12.5.2 Microsoft Excel Expert Practice - Form B
-
318
12.5.3 Supermarket sales
-
319
12.5.4 Suppermarket sales Questions
A.1 TestOut Certified: Microsoft Excel Advacnced Certification
-
320
A.1 TestOut Certified: Microsoft Excel Advacnced Certification
TestOut Certified: Microsoft Excel Advacnced Certification
-
321
A.1.1 Pro Exam Objectives
Pro Exam Objectives
-
322
A.1.2 Pro Exam Objectives by Course Section
Pro Exam Objectives by Course Section
-
323
A.1.3 How to take the Pro Exam
How to take the Pro Exam
-
324
A.1.4 Pro Exam FAQs
Pro Exam FAQs
-
325
Section A.2 TestOut Pro Certified: Microsoft Excel® Advanced Exam Domain Review
TestOut Pro Certified: Microsoft Excel® Advanced Exam Domain Review
-
326
A.2.1 Pro Domain 1: Workbooks and Worksheets
-
327
A.2.2 Pro Domain 2: Formatting and Data
-
328
A.2.3 Pro Domain 3: Functions, Formulas, and Macros
-
329
A.2.4 Pro Domain 4: Charts and Tables
-
330
Section A.3 TestOut Pro Certified: Microsoft Excel® Advanced Practice Exams
TestOut Pro Certified: Microsoft Excel® Advanced Practice Exams
-
331
A.3.1 Certification Practice Exam - Form A
-
332
A.3.2 Certification Practice Exam - Form B
Glossary
