Excel For Data Analyst

Learn how to analyse and manipulate data using excel

What you'll learn

Create dynamic reports by mastering one of the most popular tools, PivotTables

Maintain large sets of Excel data in a list or table

Learn the most common Excel functions used in the Office

Build a solid understanding on the Basics of Microsoft Excel

Become expert in excel data analysis

Requirements

No experience required

Description

This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways for analysis of data I will teach you how to THINK like Excel.This course is hands on tutorial where sample excel sheets are provided for practice.Easily build dynamic tools & Excel dashboards to filter, display and analyze your dataCreate your own formula-based Excel formatting rulesJoin datasets from multiple sources with XLOOKUP, INDEX & MATCH functionsManipulate dates, times, text, and arraysAutomate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!)Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)Plotting chartsLearn how to manipulate and analyse dataAt completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:Creating effective spreadsheetsManaging large sets of dataMastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more…)Create dynamic report with Excel PivotTablesUnlock the power and versatility of Microsoft Excel's Add-In, PowerPivotAudit Excel Worksheet formulas to ensure clean formulasAutomate your day to day Excel tasks by mastering the power of Macros and VBAHow to do data analysis How to plot beautiful charts

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Day 1

Lecture 2 Custom sort order

Lecture 3 Sort by color

Lecture 4 Reverse list

Lecture 5 Sort in ascending and descending order

Section 3: Day 2

Lecture 6 Number and text filter

Lecture 7 Date filters

Lecture 8 Remove duplicates

Lecture 9 Unique values

Lecture 10 Filter function

Section 4: Day 3

Lecture 11 Column chart

Lecture 12 Line chart

Lecture 13 Pie chart

Lecture 14 Bar chart

Lecture 15 Area chart

Lecture 16 Scatter plot

Lecture 17 Gantt chart

Section 5: Day 4

Lecture 18 Structured references

Lecture 19 Table design

Lecture 20 Adding analysis toolpak

Section 6: Day 5

Lecture 21 Histogram

Lecture 22 Descriptive statistics

Lecture 23 Anova

Lecture 24 F test

Lecture 25 Moving average

Lecture 26 Exponential smoothing

Lecture 27 Correlation

Beginner who wants to learn data analysis in excel,Those who wants to master excel,Those who wants to learn excel