Data Analysis
Advanced Excel
"In this course you will learn:
- What is lookup and reference functions?
- What is power functions and how to use it?
- The difference between IF and IFS function and how to apply it.
- How to mix formulas?
- How to link between different Excel sheets?
- How to create, design and edit pivot tables?
- How to create and design graphs and charts
- What is text functions.
- How to use macro tool?"
This course for a person who has a basics of how to use an Excel, it's functions and wants to get deeper in it by learning an advanced tools and formulas in Excel.
Course content
14 Lectures
1 hour 16 minutes
Introduction
-
Intro
1 minute 9 seconds
Excel in Advance
-
Excel Secrets
10 minutes 51 seconds -
Lookup and Reference Functions
9 minutes 29 seconds -
"Power" Functions
3 minutes 37 seconds -
"IF" and Related Functions - Part1
4 minutes 51 seconds -
"IF" and Related Functions - Part 2
4 minutes 26 seconds -
"Text" Functions
7 minutes 51 seconds -
Mixing Formulas
7 minutes 9 seconds -
Drop Down List
6 minutes 55 seconds -
Linking Different Excel Sheets
3 minutes 6 seconds -
Pivot Tables
6 minutes 22 seconds -
How to Use Charts and Graphs
4 minutes 39 seconds -
The Magic of Macro Tool
5 minutes 29 seconds -
Conclusion
34 seconds
Meet your instructor
Subscriptions
Start watching our recorded courses in different fields with our great experts
1 Month Subscription
USD
15
Benefits
- Full access to all courses
- Full access to material of courses
- Engage with course instructors
- Get certificate of completion
1 Year
USD
70
Benefits
- Full access to all courses
- Full access to material of courses
- Engage with course instructors
- Get certificate of completion
3-Months group subscription
USD
40
Benefits
- All one month subscription perks
- Access for three months
- Access for 3 users