Microstoft Excel or just Excel, If you are in need to learn excel for your job for school or simply to be able to create your own management apps you are at the right place. In this course you will learn how to use excel from A to Z. You will understand all the basics of this app and you will be able to create advanced things by the end of the course.

Description

• Everybody who want to learn how excel work

Course content

• Introduction
  • Introduction
• Starting out
  • The basics of excel
  • Relative vs absolute cell reference
  • DIfference between a function and a formula
  • Basic excel formulas
  • Work 1
• Functions
  • Introduction to excel functions
  • IF function
  • VLOOKUP function
  • Work 2
• Charts and data
  • Visually representing data
  • Creating charts and using charts
  • import data from the web
  • work 3
• Pivot tables
  • Introduction to pivot tables
• Project 1 Creating a gradebook
  • Step 1 creating the architecture of the app
  • Step 2 entering the functions
  • Step 3 manipulating the data and tests
• Final Words
  • Final words