Excel data analysis bootcamp

Focused View

Neuralclass Academy

56:17

154 View

1. Introduction

1. Introduction.mp4

02:24

2. Day 1

1.1 sort-function.xlsx

1. Custom sort order.mp4

02:08

2.1 sort-by-color.xlsx

2. Sort by color.mp4

02:29

3.1 reverse-list.xlsx

3. Reverse list.mp4

01:45

4. Sort in ascending and descending order.mp4

02:14

3. Day 2

1.1 number-text-filters.xlsx

1. Number and text filter.mp4

02:17

2.1 date-filters.xlsx

2. Date filters.mp4

02:34

3.1 remove-duplicates.xlsx

3. Remove duplicates.mp4

02:51

4.1 unique-values.xlsx

4. Unique values.mp4

01:54

5.1 filter-function.xlsx

5. Filter function.mp4

03:38

4. Day 3

1.1 column-chart.xlsx

1. Column chart.mp4

02:22

2.1 line-chart.xlsx

2. Line chart.mp4

02:13

3.1 pie-chart.xlsx

3. Pie chart.mp4

01:56

4.1 bar-chart.xlsx

4. Bar chart.mp4

01:47

5.1 area-chart.xlsx

5. Area chart.mp4

01:43

6.1 scatter-plot.xlsx

6. Scatter plot.mp4

02:02

7.1 gantt-chart.xlsx

7. Gantt chart.mp4

01:41

5. Day 4

1.1 structured-references.xlsx

1. Structured references.mp4

01:54

2.1 table-styles.xlsx

2. Table design.mp4

01:04

3. Adding analysis toolpak.mp4

01:28

6. Day 5

1.1 histogram.xlsx

1. Histogram.mp4

01:59

2.1 descriptive-statistics.xlsx

2. Descriptive statistics.mp4

02:33

3.1 anova.xlsx

3. Anova.mp4

02:01

4.1 f-test.xlsx

4. F test.mp4

01:38

5.1 moving-average.xlsx

5. Moving average.mp4

02:00

6.1 exponential-smoothing.xlsx

6. Exponential smoothing.mp4

02:06

7.1 correlation.xlsx

7. Correlation.mp4

01:36

Description

Microsoft Excel Course.Learn microsoft 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
Master Microsoft Excel from Beginner to Advanced
Build a solid understanding on the Basics of Microsoft Excel
Become expert in excel

Who is this for?

Those who wants to learn excel

Those who wants to master excel

Those who wants to learn data analysis using 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:
Those who wants to learn excel
Those who wants to master excel
Those who wants to learn data analysis using excel

User Reviews

Rating

average 0

Total votes0

Focused display

Our team has an experience of 15+ years.Hi there,By 2024, there will be more than 1 million unfilled computing jobs and the skills gap is a global problem. This was our starting point.At Neuralclass, we are the tech experts who have been in the sector for years and years. We are deeply rooted in the tech world. We know the tech industry. And we know the tech industry's biggest problem is the “tech skills gap” and here is our solution.Neuralclass will be the bridge between the tech industry and people who-are planning a new career-are thinking career transformation-want career shift or reinvention,-have the desire to learn new hobbies at their own paceBecause we know we can help this generation gain the skill to fill these jobs and enjoy happier, more fulfilling careers. And this is what motivates us every day.We specialize in critical areas like cybersecurity, coding, IT, game development, app monetization, and mobile. Thanks to our practical alignment we are able to constantly translate industry insights into the most in-demand and up-to-date courses,Neuralclass will provide you the information and support you need to move through your journey with confidence and ease.Our courses are for everyone. Whether you are someone who has never programmed before, or an existing programmer seeking to learn another language, or even someone looking to switch careers we are here.Neuralclass is here to transforms passionate, enthusiastic people to reach their dream job positions.If you need help or if you have any questions, please do not hesitate to contact our team.By choosing Neuralclass , you make sure you will learn from proven experts, who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time.

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.