The Premium Microsoft Excel & Data Certification Bundle

5 Reviews
707 Enrolled
24 Courses & 90 Hours
$69.99$2,376.00
You save 97% -

What's Included

MS Excel/Excel 2020: The Complete Introduction to Excel
  • Certification included
  • Experience level required: Beginner
  • Access 19 lectures & 3 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

19 Lessons (3h)

  • Your First Program
  • Introduction
    Intro9:30
  • Starting out
    The Basics of Excel15:38
    Relative Vs Absolute cell References9:38
    Difference Between a Function and a Formula2:44
    Basic Excel Formulas4:50
    Project 17:49
  • Functions
    Introduction to Excel Functions9:08
    IF Function10:10
    VLOOKUP Function10:39
    Project 210:06
  • Charts and Data
    Visually representing Data10:01
    Creating and Using Charts9:02
    Importing Data From the Web13:57
    Project 313:10
  • Introduction to Pivot Tables
    Introduction to Pivot Tables16:44
  • Final Project Creating a Gradebook
    Step 1 Creating the Architecture of the APP10:39
    Step 2 Writing the Functions11:12
    Step 3 Manipulating the Data and Tests10:04
  • Final Words
    Final Words2:10

MS Excel/Excel 2020: The Complete Introduction to Excel

YM
Yassin Marco

Yassin Marco

4.1/5 Instructor Rating: ★ ★ ★ ★

Yassin has a BS in international management and multiple certifications in management and IT. He works on a daily basis with various Microsoft apps and is a specialist in excel as well as in various other fields such as online business creation and promotion, marketing, and many more. Also, he has a passion for finances and has helped many people in taking their first steps in the trading and investing world, from basic financial coaching to advanced Stock/Forex data analysis.

He has developed a passion for coaching and educating and has helped more than 380,000+ students on multiple online platforms. Teaching in English and French, he has been able to reach across to people spanning from over 198 countries.

Description

The course is created around a very simple concept. To learn you need to practice as much as you can. This is why from the moment that you will enter the course and start your Excel journey you will have a lot of examples and cases. Not only this will help you become a better user of Microsoft Excel but it will also give you the confidence to start using the app by yourself to be able to create way more advanced applications that will be able to perform different tasks.

4.1/5 average rating: ★ ★ ★ ★

  • Access 19 lectures & 3 hours of content 24/7
  • Learn the basics of Excel
  • Understand the difference between a function & a formula
  • Create charts from your data
  • Create pivot tables
Note: Software NOT included

Specs

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Microsoft Excel

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.