Excel for data analyst

Focused View

Neuralclass Inc

56:17

172 View

1 - Introduction

1 - Introduction.mp4

02:24

2 - Day 1

2 - Custom sort order.mp4

02:08

2 - sort-by-color.xlsx

3 - Sort by color.mp4

02:29

3 - sort-by-color.xlsx

4 - Reverse list.mp4

01:45

4 - reverse-list.xlsx

5 - Sort in ascending and descending order.mp4

02:14

5 - sort-function.xlsx

3 - Day 2

6 - Number and text filter.mp4

02:17

6 - number-text-filters.xlsx

7 - Date filters.mp4

02:34

7 - date-filters.xlsx

8 - Remove duplicates.mp4

02:51

8 - remove-duplicates.xlsx

9 - Unique values.mp4

01:54

9 - unique-values.xlsx

10 - Filter function.mp4

03:38

10 - filter-function.xlsx

4 - Day 3

11 - Column chart.mp4

02:22

11 - column-chart.xlsx

12 - Line chart.mp4

02:13

12 - line-chart.xlsx

13 - Pie chart.mp4

01:56

13 - pie-chart.xlsx

14 - Bar chart.mp4

01:47

14 - bar-chart.xlsx

15 - Area chart.mp4

01:43

15 - area-chart.xlsx

16 - Scatter plot.mp4

02:02

16 - scatter-plot.xlsx

17 - Gantt chart.mp4

01:41

17 - gantt-chart.xlsx

5 - Day 4

18 - Structured references.mp4

01:54

18 - structured-references.xlsx

19 - Table design.mp4

01:04

19 - table-styles.xlsx

20 - Adding analysis toolpak.mp4

01:28

6 - Day 5

21 - Histogram.mp4

01:59

21 - histogram.xlsx

22 - Descriptive statistics.mp4

02:33

22 - descriptive-statistics.xlsx

23 - Anova.mp4

02:01

23 - anova.xlsx

24 - F test.mp4

01:38

24 - f-test.xlsx

25 - Moving average.mp4

02:00

25 - moving-average.xlsx

26 - Exponential smoothing.mp4

02:06

26 - exponential-smoothing.xlsx

27 - Correlation.mp4

01:36

27 - correlation.xlsx

Description

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

Who is this for?

Beginner who wants to learn data analysis in excel

Those who wants to master excel

Those who wants to learn excel

More details

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 data
Create your own formula-based Excel formatting rules
Join datasets from multiple sources with XLOOKUP, INDEX & MATCH functions
Manipulate dates, times, text, and arrays
Automate 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 charts
Learn how to manipulate and analyse data

At 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 spreadsheets
Managing large sets of data
Mastering 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 PivotTables
Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot
Audit Excel Worksheet formulas to ensure clean formulas
Automate your day to day Excel tasks by mastering the power of Macros and VBA
How to do data analysis
How to plot beautiful charts
Who this course is for:
Beginner who wants to learn data analysis in excel
Those who wants to master excel
Those who wants to learn excel

User Reviews

Rating

average 0

Total votes0

Focused display

Our team has an experience of 15+ years.We are a group of data scientists who have experience in working various industry sectors like oil and gas,finance etc.We are also currently rated expert and master tier in kaggle which is the largest place for data science competitions.Our goal is to provide everyone quality courses which would help them in their career alot.We have a strong track record in implementing machine learning, data visualization, spatial data analysis, deep learning and natural language processing tasks using both R and Python.We specialise in a variety of topics ranging from data science,deep learning (Tensorflow, Keras) to machine learning to spatial data analysis, data visualizations, natural language processing,computer vision,reinforcement learning,startups,financial analysis among others.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.