Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power of MS Excel - Data Manipulation and Analysis
Rating: 3.6 out of 5(5 ratings)
71 students

Power of MS Excel - Data Manipulation and Analysis

MS EXCEL 2021
Created byEBodhisathva Solutions
Last updated 1/2026
English
English [Auto],

What you'll learn

  • Learn MS Excel in context of Data review, manipulation and Analysis
  • Excel Function for Data Cleaning of Incoming data
  • Excel functions for reviewing the Large data (Reference functions)
  • Excel functions to analyze (Pivot, What if analysis etc)
  • Demos

Course content

6 sections • 15 lectures • 1h 44m total length

  • LOOKUP()12:11

    Explore the lookup function in Excel, using vector or array form to match a lookup value in a lookup vector and return a result vector, noting sorting and limitations.

  • HLOOKUP()6:15

    Explore how the hlookup function searches the top row of a table, returns a value from a specified row, and handles exact or approximate matches along with sorting and wildcards.

  • VLOOKUP()9:07
  • XLOOKUP()7:41

    Learn to clean, organize, and analyze large Excel data using xlookup, a flexible lookup that returns a matching value from the result range, regardless of position.

  • MATCH Function5:32

Requirements

  • Basic Conversance of MS EXCEL

Description

This course is to explain usage of EXCEL function in relevance to Data review, analysis and manipulation.

In your business you use MS EXCEL to capture, review, manipulate and analyze the data.

The data comes to you through manual entries to excel, import from external sources from flat files, web content or other sources.

Your first job will be to cleanup the entire input data and ensure the data are healthy enough to review or analysze.

When the data are huge, it will be a challenge for referring to the data of your interest. Hence you will leverage excel functions for lookup and references to locate and retrieve the right information in short time, to analyze or use in your manipulations. The manipulations can be applying farmulas on retrieved data from a logic. Or you derive some inferences from the retrieved data.

Once the data are properly structured, you can start analysing the data. In a large number of rows and columns you may need only a few pieces of information for your analysis. You will hence leverage other functions such as PIVOTS, What if utilities etc.

Finally you will leverage the reporting features of excel and present the outcome of your analysis in impressive forms.

This course deals with all excel functions useful for above activities.

Who this course is for:

  • All are welcome

Report abuse