Course Information
Course Overview
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.
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.
Course Content
- 10 section(s)
- 108 lecture(s)
- Section 1 Enter & Find
- Section 2 Format Text
- Section 3 Layout
- Section 4 Data Validation
- Section 5 Customize
- Section 6 Excel Formula
- Section 7 Common Functions
- Section 8 Logical Functions
- Section 9 Text/String Functions
- Section 10 Reference Functions
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
Skills covered in this course
Reviews
-
CChris Ijogbe
Excellent Excel breakdown.
-
MMaaz Shariff
Yes
-
BBabatunde Oladimeji Ajewol
Excellent
-
EErnest NGIPE
I LOVE EVERYTHING I'M SEEING SO FAR