Excel data analysis bootcamp

Excel data analysis bootcamp, available at $39.99, has an average rating of 4.27, with 27 lectures, based on 123 reviews, and has 7720 subscribers.

You will learn about 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 This course is ideal for individuals who are Those who wants to learn excel or Those who wants to master excel or Those who wants to learn data analysis using excel It is particularly useful for Those who wants to learn excel or Those who wants to master excel or Those who wants to learn data analysis using excel.

Enroll now: Excel data analysis bootcamp

Summary

Title: Excel data analysis bootcamp

Price: $39.99

Average Rating: 4.27

Number of Lectures: 27

Number of Published Lectures: 27

Number of Curriculum Items: 27

Number of Published Curriculum Objects: 27

Original Price: $99.99

Quality Status: approved

Status: Live

What You Will 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 Should Attend

Those who wants to learn excel
Those who wants to master excel
Those who wants to learn data analysis using excel

Target Audiences

Those who wants to learn excel
Those who wants to master excel
Those who wants to learn data analysis using excel

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 whateach formula does, I teach through hands-on, contextual examples designed to showcase whythese formulas are awesome and howthey 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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Day 1

Lecture 1: Custom sort order

Lecture 2: Sort by color

Lecture 3: Reverse list

Lecture 4: Sort in ascending and descending order

Chapter 3: Day 2

Lecture 1: Number and text filter

Lecture 2: Date filters

Lecture 3: Remove duplicates

Lecture 4: Unique values

Lecture 5: Filter function

Chapter 4: Day 3

Lecture 1: Column chart

Lecture 2: Line chart

Lecture 3: Pie chart

Lecture 4: Bar chart

Lecture 5: Area chart

Lecture 6: Scatter plot

Lecture 7: Gantt chart

Chapter 5: Day 4

Lecture 1: Structured references

Lecture 2: Table design

Lecture 3: Adding analysis toolpak

Chapter 6: Day 5

Lecture 1: Histogram

Lecture 2: Descriptive statistics

Lecture 3: Anova

Lecture 4: F test

Lecture 5: Moving average

Lecture 6: Exponential smoothing

Lecture 7: Correlation

Instructors

Neuralclass Academy
Learn from the experts in the field!

Rating Distribution

1 stars: 6 votes
2 stars: 5 votes
3 stars: 29 votes
4 stars: 37 votes
5 stars: 46 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu