Microsoft Excel – Complete Beginner to Pro Guide

Format, Analyze, Manipulate Data & Build Interactive Dashboards in Excel

Excel is one of the most used data processing and analysis application. This course is designed to take you from knowing absolutely nothing in Excel to becoming highly proficient.

What you’ll learn

  • Microsoft Excel.
  • Formatting Data.
  • Data Analysis & Manipulation.
  • Formula & Functions.
  • Data Validation.
  • Tables.
  • Handling Errors.
  • Pivot Tables & Charts.
  • Macro.
  • Charts.
  • Interactive Dashboards.
  • …and a lot more.

Course Content

  • Enter & Find –> 13 lectures • 55min.
  • Format Text –> 7 lectures • 24min.
  • Layout –> 6 lectures • 14min.
  • Data Validation –> 3 lectures • 11min.
  • Customize –> 3 lectures • 9min.
  • Excel Formula –> 3 lectures • 16min.
  • Common Functions –> 4 lectures • 6min.
  • Logical Functions –> 11 lectures • 32min.
  • Text/String Functions –> 9 lectures • 23min.
  • Reference Functions –> 5 lectures • 27min.

Microsoft Excel - Complete Beginner to Pro Guide

Requirements

  • No course requirement or prerequisites.

Excel is one of the most used data processing and analysis application. This course is designed to take you from knowing absolutely nothing in Excel to becoming highly proficient.

You will learn how to clean and format data using several commands.

There are wide variety of in-built functions in excel. In this course, you will learn how to use Logical Functions, String Functions, Reference Functions, Date Functions, Statistical Functions and Math Functions, to analyze small and large quantities of data. You will also learn how to write basic and complex formulas.

An important part of data analysis is to derive insights from the data. One of the most compelling ways of presenting information from data is through visualization. You will learn how to create different charts which is subsequently used to build interactive and dynamic dashboard.

 

IS THIS YOU?

Looking to work with data personally or professionally?

Starting or transitioning into a career as a Data Scientist, Data Analyst, Business Analyst, Report Analyst, ETL Specialist, BI Consultant, Data Engineer, or any data related field? Then you need to learn Excel.

 

Course Requirement or Prerequisites

This course does not require any prior knowledge or specific academic background. The only requirement is having a laptop or desktop computer. You also need to have Microsoft Excel application installed on your laptop or computer.