Data Analysis Course

Advanced Excel

Course Duration: 01h 16m

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
Advanced Excel

Course Curriculum

Get introduced to the content of the course.

Know the usages of F9, how to insert columns and rows, how to copy and paste content and the usages of CTRL E.

Know about the V Lookup, H Lookup and Index function in excel and how to apply them in Excel.

Know about SUM IF, SUIFS and SUM products functions and how to apply them on Excel.

Know about IF/OR and IF/AND functions and how to apply them in excel.

Know about IF/OR and IF/AND functions and how to apply them in excel.

Know the text functions in excel like upper, low, proper, substitute, mid, left and right and how to apply them on excel.

Know about how to mix between formulas in excel.

Know about the basic drop down list and how to apply the drop down list function in excel.

Learn how to link between two sheet, how to replace and change the source of the sheet.

Know how to create pivot table, how to change its design and how to add a new field in it.

Know how to create chart, how to create 2 columns for the charts and how to design the chart.

Know about the magic macro tool on excel and how to use it.

Recap to the content of the course.

Related Vacancies

Data Analysis
INSITE OOH
Data Analyst
  • Experience Level: +1 Years
  • Job Type: Full Time
  • Location: Cairo
  • Deadline: 2022-08-08
Data Analysis
Nawy
Senior Data Analyst
  • Experience Level: +3 Years
  • Job Type: Full Time
  • Location: Cairo
  • Deadline: 2022-06-01
Data Analysis
Halan
Data Engineer
  • Experience Level: +1 Years
  • Job Type: Full Time
  • Location: Cairo
  • Deadline: 2022-06-01

Have Question ? Get in touch!

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

Contact us