Skip to content
Category
Business & Entrepreneurship
Cloud Computing & DevOps
Cybersecurity
Data Science & AI
Design & Creative
Digital Marketing
Finance & Accounting
Management & Leadership
Personal Development & Productivity
Programming & Software Development
Home
About Us
Courses
Blog
Contact Us
0
Currently Empty:
$
0
.00
Continue shopping
Start
Home
About Us
Courses
Blog
Contact Us
Excel for Data Analysis
Curriculum
4 Sections
15 Lessons
4 Hours
Expand all sections
Collapse all sections
Excel Analyst Foundations
4
1.1
Structuring Data for Analysis
23 Minutes
1.2
Tables and Named Ranges
23 Minutes
1.3
Sorting, Filtering and Conditional Formatting
18 Minutes
1.4
Essential Shortcuts
27 Minutes
Formulas That Matter
4
2.1
Logical Functions: IF and Friends
16 Minutes
2.2
Lookups: XLOOKUP and INDEX/MATCH
11 Minutes
2.3
Text and Date Functions
8 Minutes
2.4
SUMIFS and COUNTIFS
18 Minutes
Analysis Power Tools
4
3.1
PivotTables Deep Dive
19 Minutes
3.2
PivotCharts and Slicers
17 Minutes
3.3
What-If Analysis
17 Minutes
3.4
Power Query in Excel
9 Minutes
Reporting
3
4.1
Charts That Communicate
25 Minutes
4.2
Building a Mini Dashboard
25 Minutes
4.3
Course Project: Sales Analysis Workbook
13 Minutes
This content is protected, please
login
and
enroll
in the course to view this content!
Sign in
Sign up
Sign in
Don’t have an account?
Sign up
Remember me
Lost your password?
Sign up
Already have an account?
Sign in
Modal title
Main Content
