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