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?"
Enroll now

Who takes this course

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
Introduction
1 Lectures
  • Lecture 1: Intro
    1 minute 9 seconds
Excel in Advance
Excel Tools and Functions
13 Lectures
  • Lecture 1: Excel Secrets
    10 minutes 51 seconds
  • Lecture 2: Lookup and Reference Functions
    9 minutes 29 seconds
  • Lecture 3: "Power" Functions
    3 minutes 37 seconds
  • Lecture 4: "IF" and Related Functions - Part1
    4 minutes 51 seconds
  • Lecture 5: "IF" and Related Functions - Part 2
    4 minutes 26 seconds
  • Lecture 6: "Text" Functions
    7 minutes 51 seconds
  • Lecture 7: Mixing Formulas
    7 minutes 9 seconds
  • Lecture 8: Drop Down List
    6 minutes 55 seconds
  • Lecture 9: Linking Different Excel Sheets
    3 minutes 6 seconds
  • Lecture 10: Pivot Tables
    6 minutes 22 seconds
  • Lecture 11: How to Use Charts and Graphs
    4 minutes 39 seconds
  • Lecture 12: The Magic of Macro Tool
    5 minutes 29 seconds
  • Lecture 13: Conclusion
    34 seconds

Meet your instructor

Mostafa Hassan

Mostafa Hassan

Market and liquidity risk management assistant manager

Visit Linkedin

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