Udemy

Excel data analysis bootcamp

Microsoft Excel Course.Learn microsoft Excel
Free tutorial
Rating: 3.9 out of 5 (114 ratings)
7,636 students
56min of on-demand video
English
English [Auto]

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

Requirements

  • No prior knowledge is 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 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

Instructor

Learn from the experts in the field!
Neuralclass Academy
  • 4.0 Instructor Rating
  • 792 Reviews
  • 58,339 Students
  • 15 Courses

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 pace

Because 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 AI,data science,cybersecurity, coding, IT, game development, full stack developement, 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.

Top companies trust Udemy

Get your team access to Udemy's top 26,000+ courses