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