ع
Search for courses, vacancies, internships
Search for anything: courses, vacancies, internships...
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?"
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 • 01h 16m
  • Lecture 1: Intro
    01:09 min
  • Lecture 2: Excel Secrets
    10:51 min
  • Lecture 3: Lookup and Reference Functions
    09:29 min
  • Lecture 4: "Power" Functions
    03:37 min
  • Lecture 5: "IF" and Related Functions - Part1
    04:51 min
  • Lecture 6: "IF" and Related Functions - Part 2
    04:26 min
  • Lecture 7: "Text" Functions
    07:51 min
  • Lecture 8: Mixing Formulas
    07:09 min
  • Lecture 9: Drop Down List
    06:55 min
  • Lecture 10: Linking Different Excel Sheets
    03:06 min
  • Lecture 11: Pivot Tables
    06:22 min
  • Lecture 12: How to Use Charts and Graphs
    04:39 min
  • Lecture 13: The Magic of Macro Tool
    05:29 min
  • Lecture 14: Conclusion
    00:34 sec

Meet your instructor

Mostafa Hassan

Visit Linkedin

Recorded Courses Subscription

Start watching our recorded courses in different fields with our great experts

1 Month
USD 15
  • Full access to all courses
  • Full access to material of courses
  • Engage with course instructors
  • Get certificate of completion
Subscribe Now
3 Months
USD 40
  • Full access to all courses
  • Full access to material of courses
  • Engage with course instructors
  • Get certificate of completion
Subscribe Now
1 Year
USD 70
  • Full access to all courses
  • Full access to material of courses
  • Engage with course instructors
  • Get certificate of completion
Subscribe Now

Have Question? Get in touch!

We are happy to answer your question regarding our services and programs that we provide.

Contact us