ع
Search for courses, vacancies, internships
Search for anything: courses, vacancies, internships...
Your Instructor
Mostafa Hassan
Visit Linkedin
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?"
15 Lectures
01h 22m
Advanced
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
Enroll
  • 1
  • Lecture
Intro
Get introduced to the content of the course.

Lecture: 1 | 01:09 min

  • 2
  • Lecture
Excel Secrets
Know the usages of F9 how to insert columns and rows, how to copy and paste content and the usages of CTRL E.

Lecture: 2 | 10:51 min

  • 3
  • Lecture
Lookup and Reference Functions
Know about the V Lookup , H Lookup and Index function in excel and how to apply them in Excel.

Lecture: 3 | 09:29 min

  • 4
  • Lecture
"Power" Functions
Know about SUM IF, SUIFS and SUM products Functions and how to apply them on Excel.

Lecture: 4 | 03:37 min

  • 5
  • Lecture
"IF" and Related Functions - Part1
Know about IF/OR and IF/AND Functions and how to apply them in excel.

Lecture: 5 | 04:51 min

  • 6
  • Lecture
"IF" and Related Functions - Part 2
Know about IF/OR and IF/AND functions and how to apply them in excel.

Lecture: 6 | 04:26 min

  • 7
  • Lecture
"Text" Functions
Know the text functions in excel like upper, low, proper, substitute, mid, left and right and how to apply them on excel.

Lecture: 7 | 07:51 min

  • 8
  • Lecture
Mixing Formulas
Know about how to mix between formulas in excel.

Lecture: 8 | 07:09 min

  • 9
  • Lecture
Drop Down List
Know about the basic drop down list and how to apply the drop down list function in excel.

Lecture: 9 | 06:55 min

  • 10
  • Lecture
Linking Different Excel Sheets
Learn how to link between two sheet, how to replace and change the source of the sheet.

Lecture: 10 | 03:06 min

  • 11
  • Lecture
Pivot Tables
Know how to create pivot table , ho w to change its design and how to add a new field in it.

Lecture: 11 | 06:22 min

  • 12
  • Lecture
How to Use Charts and Graphs
Know how to create chart how to create 2 columns for the charts and how to design the chart.

Lecture: 12 | 04:39 min

  • 13
  • Lecture
The Magic of Macro Tool
Know about the magic macro tool on excel and how to use it.

Lecture: 13 | 05:29 min

  • 14
  • Lecture
Conclusion
Recap to the content of the course.

Lecture: 14 | 00:34 sec

  • 15
  • Lecture
Creative Process (Features)

Know the second step of the creative process which is identifying the message which you want to show to your customers and how to transfer your product features into a real benefit to the consumer.

Lecture: 15 | 06:01 min

Recorded Courses Subscritpion

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

1 Month
Subscription
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
Subscription
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
Subscription
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