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
42
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
Skills Lab: Customize Views and Options
-
29
2.3.0 Printing Files
Printing Files
-
30
Section 2.3.1 Printing Options in Office Applications
Printing Options in Office Applications
-
31
2.4.0 Navigating Files
Navigating Files
-
32
2.4.1 Navigating Through a Word Document
Navigating Through a Word Document
-
33
2.4.2 Navigating Through an Excel Workbook
Navigating Through an Excel Workbook
-
34
2.4.3 Navigation Facts
Navigation Facts
-
35
2.5.0 Working with Objects
Working with Objects
-
36
2.5.1 Formatting Images
Formatting Images
-
37
2.5.2 Formatting Shapes
Formatting Shapes
-
38
2.5.3 Object Formatting Facts
Object Formatting Facts
-
39
Section 2.6.0 Using office collaboration Features
Using Office Collaboration Features
-
40
2.6.1 Track Changes and Comments
-
41
2.6.2 Combining Revisions
Combining Revisions
-
42
2.6.3 Distributing Files
Distributing Files
-
43
2.6.4 Collaboration Facts
-
44
2.6.7 Collaboration Tips
Collaboration Tips
Section 3.1 Creating and Managing Workbooks
-
45
Section 3.1.0 Creating and Managing Workbooks
Creating and Managing Workbooks
-
46
3.1.1 Spreadsheet Basics
Spreadsheet Basics
-
47
3.1.2 Worhsheet Management
Worksheet Management
-
48
3.1.3 Templates and Themes
Templates and Themes
-
49
3.1.4 External Data
External Data
-
50
3.1.5 Workbook Management Facts
-
51
3.1.8 Workbook Management Tips
Workbook Management Tips
-
52
3.2.0 Organizing and Entering Data
Organizing and Entering Data
-
53
3.2.1 Deleting and Clearing Cells
Deleting and Clearing Cells
-
54
3.2.2 Copy and Paste Options
Copy and Paste Options
-
55
3.2.3 Large Data Sets
Large Data Sets
-
56
3.2.4 Data Entry Facts
-
57
3.2.7 Data Entry Tips
Data Entry Tips
-
58
3.3.0 Changing Properties and Printing Worksheets
Changing Properties and Printing Worksheets
-
59
3.3.1 Data Protection
Data Protection
-
60
3.3.2 Data Validation
Data Validation
-
61
3.3.3 Excel Printing Tips
Excel Printing Tips
-
62
3.3.4 Worksheet Printing Facts
Worksheet Printing Facts
-
63
3.3.7 Worksheet Printing Tips
Worksheet Printing Tips
-
64
3.4.0 Formatting Cells
Formatting Cells
-
65
3.4.1 Number Formats
Number Formats
-
66
3.4.2 Cell Formats
Cell Formats
-
67
3.4.3 Cell Styles and Colors
Cell Styles and Colors
-
68
3.4.4 Cell Borders
Cell Borders
-
69
3.4.5 Cell Formatting Facts
-
70
3.4.8 Cell Formatting Tips
Cell Formatting Tips
Section 4.1 Entering Simple Formulas
-
71
Section 4.1 Entering Simple Formulas
Entering Simple Formulas
-
72
4.1.1 Formulas and Functions
Formulas and Functions
-
73
4.1.2 AutoFill Options
AutoFill Options
-
74
4.1.3 Add and Average
Add and Average
-
75
4.1.4 More Number Functions
More Number Functions
-
76
4.1.5 Text Functions
Text Functions
-
77
4.1.6 Concatenating in Excel
Concatenating in Excel
-
78
4.1.7.0 Formula Facts
-
79
4.1.7.1 Formula Facts
-
80
4.1.7.2 Formula Facts
-
81
4.1.10 Formula Tips
Formula Tips
-
82
4.2 Using Advanced Functions
Using Advanced Functions
-
83
4.2.1 Relative and Absolute References
Relative and Absolute References
-
84
4.2.2 Advanced Cell References
Advanced Cell References
-
85
4.2.3 Named Cells and Ranges
Named Cells and Ranges
-
86
4.2.4 The IF Function
The IF Function
-
87
4.2.5 Logical Functions
Logical Functions
-
88
4.2.6 Excel Error Messages
Excel Error Messages
-
89
4.2.7 Spill Functions
Spill Functions
-
90
4.2.8 Advanced Function Facts
Advanced Function Facts
-
91
4.2.11 Advanced Function Tips
Advanced Function Tips
Section 5.1 Displaying Data in Charts
-
92
Section 5.1 Displaying Data in Charts
Displaying Data in Charts
-
93
5.1.1 Chart Formatting
Chart Formatting
-
94
5.1.2 Chart Types
Chart Types
-
95
5.1.3 Chart Facts
Chart Facts
-
96
5.1.6 Chart Tips
Chart Tips
-
97
5.2 Organizing Data in Tables
Organizing Data in Tables
-
98
5.2.1 Conditional Formatting
Conditional Formatting
-
99
5.2.2 Excel Tables
Excel Tables
-
100
5.2.3 Table Customization
Table Customization
-
101
5.2.4 Using Formulas in Tables
Using Formulas in Tables
-
102
5.2.5 Excel Table Facts
-
103
5.2.8 Excel Table Tips
Excel Table Tips
Section 6.1 Excel Live Projects
-
104
Section 6.1 Excel Live Projects
Excel Live Projects
-
105
6.1.1 How to Use Excel Live Projects
How to Use Excel Live Projects
-
106
6.1.2.0 Installing the Optional Task Guide in Excel
-
107
6.1.2.1 Installing the Optional Task Guide in Excel
-
108
6.1.3 Additional Tips for Excel Live Projects
Additional Tips for Excel Live Projects
Section 7.1 Preparing for MOS Associate Certification
-
109
Section 7.1 Preparing for MOS Associate Certification
Preparing for MOS Associate Certification
-
110
7.1.1 Preparing for the MOS Exams
Preparing for the MOS Exams
-
111
7.1.2 Performing Unfamiliar Tasks
Performing Unfamiliar Tasks
-
112
7.1.3 Which MOS Exam to Take?
Which MOS Exam to Take?
-
113
7.1.4 Using TestOut MOS Practice Exams
Using TestOut MOS Practice Exams
-
114
7.1.5 Excel (Microsoft 365 Apps) Exam Objectives
Excel (Microsoft 365 Apps) Exam Objectives
-
115
7.1.6 Excel Associate 2019 Exam Objectives
-
116
7.1.7 Taking an MOS Exam
-
117
Section 7.2 Domain Domain Practice Labs: Excel Associate 365 (MO-210)
Domain Domain Practice Labs: Excel Associate 365 (MO-210)
-
118
Section 7.3 Practice Exams: Excel Associate 365 (MO-210)
Practice Exams: Excel Associate 365 (MO-210)
-
119
7.3.1 Microsoft Excel Associate Practice - Form A
Microsoft Excel Associate Practice - Form A
-
120
7.3.2 Microsoft Excel Associate Practice - Form B
-
121
Section 7.4 Domain Practice Labs: Excel Associate 2019 (MO-200)
-
122
Section 7.5 Practice Exams: Excel Associate 2019 (MO-200)
Practice Exams: Excel Associate 2019 (MO-200)
-
123
7.5.1 Microsoft Excel Associate Practice - Form A
Microsoft Excel Associate Practice - Form A
-
124
7.5.2 Microsoft Excel Associate Practice - Form B
Microsoft Excel Associate Practice - Form B
Section 8.1 Managing Workbooks
-
125
Section 8.1 Managing Workbooks
Managing Workbooks
-
126
8.1.1 Configuring AutoSave and AutoRecover
Configuring AutoSave and AutoRecover
-
127
8.1.2 Referencing Data in Other Workbooks
Referencing Data in Other Workbooks
-
128
8.1.3 Configuring and Using Language-Specific Features
Configuring and Using Language-Specific Features
-
129
8.1.4 Manage Workbooks Facts
Manage Workbooks Facts
-
130
8.1.7 Manage Workbooks Tips
Manage Workbooks Tips
-
131
8.2 Preparing Workbooks for Collaboration
Preparing Workbooks for Collaboration
-
132
8.2.1 Protecting Cell Ranges, Worksheets, and Workbooks
Protecting Cell Ranges, Worksheets, and Workbooks
-
133
8.2.2 Configuring Formula Calculation Options
Configuring Formula Calculation Options
-
134
8.2.3 Prepare Workbooks for Collaboration Facts
Prepare Workbooks for Collaboration Facts
-
135
8.2.6 Prepare Workbooks for Collaboration Tips
Prepare Workbooks for Collaboration Tips
Section 9.1 Filling Cells Based on Existing Data
-
136
Section 9.1 Filling Cells Based on Existing Data
Filling Cells Based on Existing Data
-
137
9.1.1 Flash Fill and Advanced Fill Series Options
Flash Fill and Advanced Fill Series Options
-
138
9.1.2 Fill Cells Based on Existing Data Facts
Fill Cells Based on Existing Data Facts
-
139
9.1.5 Fill Cells Based on Existing Data Tips
Fill Cells Based on Existing Data Tips
-
140
Section 9.2 Formatting and Validating Data
Formatting and Validating Data
-
141
9.2.1 Custom Number Formats
Custom Number Formats
-
142
9.2.2 Configuring Data Validation
Configuring Data Validation
-
143
9.2.3 Using Outlines to Create Groups and Subtotals
-
144
9.2.4 Removing Duplicate Records
-
145
9.2.5 Format and Validate Data Facts
Format and Validate Data Facts
-
146
9.2.8 Format and Validate Data Tips
-
147
Section 9.3 Advanced Conditional Formatting and Filtering
Advanced Conditional Formatting and Filtering
-
148
9.3.1 Boolean Operators
Boolean Operators
-
149
9.3.2 Using Boolean Logic in Excel
Using Boolean Logic in Excel
-
150
9.3.3 Custom Conditional Formatting Rules
Custom Conditional Formatting Rules
-
151
9.3.4 Conditional Formatting Rules That Use Formulas
Conditional Formatting Rules That Use Formulas
-
152
9.3.5 Apply Advanced Conditional Formatting and Filtering Facts
Apply Advanced Conditional Formatting and Filtering Facts
-
153
9.3.8 Apply Advanced Conditional Formatting and Filtering Tips
Apply Advanced Conditional Formatting and Filtering Tips
Section 10.1 Advanced Formulas and Macros
-
154
Section 10.1 Performing Logical Operations in Formulas
Performing Logical Operations in Formulas
-
155
10.1.1 Logical Functions and Nested Functions
Logical Functions and Nested Functions
-
156
10.1.2 Logical Operations with Mathematical Functions
Logical Operations with Mathematical Functions
-
157
10.1.3 The LET Function
The LET Function
-
158
10.1.4 Perform Logical Operations in Formulas Facts
Perform Logical Operations in Formulas Facts
-
159
10.1.7 Perform Logical Operations in Formulas Tips
-
160
Section 10.2 Looking Up Data by Using Functions
Looking Up Data by using Functions
-
161
10.2.1 The VLOOKUP and HLOOKUP Functions
The VLOOKUP and HLOOKUP Functions
-
162
10.2.2 The MATCH and INDEX Functions
The MATCH and INDEX Functions
-
163
10.2.3 The XLOOKUP Function
The XLOOKUP Function
-
164
10.2.4 Look Up Data by Using Functions Facts
Look Up Data by Using Functions Facts
-
165
10.2.7 Look Up Data by Using Functions Tips
Look Up Data by Using Functions Tips
-
166
Section 10.3 Using Advanced Date and Time Functions
Using Advanced Date and Time Functions
-
167
10.3.1 Date and Time Functions
Date and Time Functions
-
168
10.3.2 Use Advanced Date and Time Functions Facts
Use Advanced Date and Time Functions Facts
-
169
10.3.5 Use Advanced Date and Time Functions Tips
Use Advanced Date and Time Functions Tips
-
170
Section 10.4 Performing Data Analysis
Performing Data Analysis
-
171
10.4.1 Summarizing Data from Multiple Ranges
Summarizing Data from Multiple Ranges
-
172
10.4.2 Performing What-If Analysis
Performing What-If Analysis
-
173
10.4.3 Filtering and Sorting with Dynamic Arrays
Filtering and Sorting with Dynamic Arrays
-
174
10.4.4 Common Financial Terminology
Common Financial Terminology
-
175
10.4.5 Calculating Finacial Data
Calculating Financial Data
-
176
10.4.6 Perform Data Analysis Facts
Perform Data Analysis Facts
-
177
10.4.9 Peform data Analysis Tips
Peform data Analysis Tips
-
178
Section 10.5 Troubleshooting Formulas
Troubleshooting Formulas
-
179
10.5.1 Tracing Precedents and Dependents
Tracing Precedents and Dependents
-
180
10.5.2 The Watch Window
The Watch Window
-
181
10.5.3 Errors and Error Checking
Errors and Error Checking
-
182
10.5.4 Evaluating Formulas
Evaluating Formulas
-
183
10.5.5 Troubleshoot Formulas Facts
Troubleshoot Formulas Facts
-
184
10.5.6 Troubleshoot Formulas Tips
Troubleshoot Formulas Tips
-
185
10.6 Creating and Modifying Simple Macros
Creating and Modifying Simple Macros
-
186
10.6.1 Recording and Running Simple Macros
Recording and Running Simple Macros
-
187
10.6.2 Enabling and Disabling Macros
Enabling and Disabling Macros
-
188
10.6.3 Copying Macros Between Workbooks
Copying Macros Between Workbooks
-
189
10.6.4 Create and Modify Simple Macros Facts
Create and Modify Simple Macros Facts
-
190
10.6.7 Create and Modify Simple Macros Tips
Create and Modify Simple Macros Tips
Section 11.1 Advanced and Charts and Tables
-
191
Section 11.1 Creating and Modifying Advanced Charts
Creating and Modifying Advanced Charts
-
192
11.1.1 Selecting Advanced Chart Types
Selecting Advanced Chart Types
-
193
11.1.2 Advanced Chart Formatting
Advanced Chart Formatting
-
194
11.1.3 Dual Axis Charts
Dual Axis Charts
-
195
11.1.4 Create and Modify Advanced Charts Facts
Create and Modify Advanced Charts Facts
-
196
11.1.7 Create and Modify Advanced Charts Tips
Create and Modify Advanced Charts Tips
-
197
Section 11.2 Creating and Modifying PivotTables
Creating and Modifying PivotTables
-
198
11.2.1 Introduction to PivotTables
Introduction to PivotTables
-
199
11.2.2 Advanced PivotTable Features
Advanced PivotTable Features
-
200
11.2.3 Calculated Fields in PivotTables
Calculated Fields in PivotTables
-
201
11.2.4 Create and Modify PivotTables Facts
Create and Modify PivotTables Facts
-
202
11.2.7 Create and Modify PivotTables Tips
Create and Modify PivotTables Tips
-
203
Section 11.3 Creating and Modifying PivotCharts
Creating and Modifying PivotCharts
-
204
11.3.1 Creating and Manipulating PivotCharts
Creating and Manipulating PivotCharts
-
205
11.3.2 Drilling Down into PivotChart Details
Drilling Down into PivotChart Details
-
206
11.3.3 Create and Modify PivotCharts Facts
Create and Modify PivotCharts Facts
-
207
11.3.6 Create and Modify PivotCharts Tips
Create and Modify PivotCharts Tips
Section 12.1 Preparing for MOS Expert Certification
-
208
Section 12.1 Preparing for MOS Expert Certification
Preparing for MOS Expert Certification
-
209
12.1.1 Preparing for the MOS Exams
Preparing for the MOS Exams
-
210
12.1.2 Performing Unfamiliar Tasks
Performing Unfamiliar Tasks
-
211
12.1.3 Which MOS Exam to Take?
Which MOS Exam to Take?
-
212
12.1.4 Using TestOut MOS Practice Exams
Using TestOut MOS Practice Exams
-
213
12.1.5 Excel Expert (Microsoft 365 Apps) Exam Objectives
Excel Expert (Microsoft 365 Apps) Exam Objectives
-
214
12.1.6 Excel Expert Associate 2019 Exam Objectives
Excel Expert Associate 2019 Exam Objectives
-
215
12.1.7 Taking an MOS Exam
Taking an MOS Exam
-
216
12.2 Domain Practice Labs: Excel Expert 365 (MO-211)
Domain Practice Labs: Excel Expert 365 (MO-211)
-
217
12.3 Practice Exams: Excel Expert 365 (MO-211)
Practice Exams: Excel Expert 365 (MO-211)
-
218
12.4 Domain Practice Labs: Excel Expert 2019 (MO-201)
Domain Practice Labs: Excel Expert 2019 (MO-201)
-
219
Section 12.5 Practice Exams: Excel Expert 2019 (MO-201)
Practice Exams: Excel Expert 2019 (MO-201)
-
220
12.5.3 Supermarket sales
A.1 TestOut Certified: Microsoft Excel Advacnced Certification
-
221
A.1 TestOut Certified: Microsoft Excel Advacnced Certification
TestOut Certified: Microsoft Excel Advacnced Certification
-
222
A.1.1 Pro Exam Objectives
Pro Exam Objectives
-
223
A.1.2 Pro Exam Objectives by Course Section
Pro Exam Objectives by Course Section
-
224
A.1.3 How to take the Pro Exam
How to take the Pro Exam
-
225
A.1.4 Pro Exam FAQs
Pro Exam FAQs
-
226
Section A.2 TestOut Pro Certified: Microsoft Excel® Advanced Exam Domain Review
TestOut Pro Certified: Microsoft Excel® Advanced Exam Domain Review
-
227
A.2.1 Pro Domain 1: Workbooks and Worksheets -
228
A.2.2 Pro Domain 2: Formatting and Data
-
229
A.2.3 Pro Domain 3: Functions, Formulas, and Macros
-
230
A.2.4 Pro Domain 4: Charts and Tables
-
231
Section A.3 TestOut Pro Certified: Microsoft Excel® Advanced Practice Exams
TestOut Pro Certified: Microsoft Excel® Advanced Practice Exams
-
232
A.3.1 Certification Practice Exam - Form A
-
233
A.3.2 Certification Practice Exam - Form B
Glossary
