MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 107 lectures (7h 38m) | Size: 3.2 GB
Format, Analyze, Manipulate Data & Build Interactive Dashboards in Excel
What you’ll learn:
Data Analysis & Manipulation
Formula & Functions
Pivot Tables & Charts
…and a lot more
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.
Who this course is for
Anyone who wants to learn Excel from the beginning to becoming highly proficient.
Looking into a career in any data related field – Data Scientist, Data Analyst, Business Analyst, Database Administration, BI Analyst, Artificial Intelligence e.t.c.