Companies Home Search Profile

Power of MS Excel - Data Manipulation and Analysis

Focused View

eBodhisathva Solutions

1:41:50

52 View
  • 1. LOOKUP().mp4
    12:11
  • 2. HLOOKUP().mp4
    06:15
  • 3. VLOOKUP().mp4
    09:07
  • 4. XLOOKUP().mp4
    07:41
  • 5. MATCH Function.mp4
    05:32
  • 1. Demo- LOOKUP().mp4
    09:50
  • 1. Vlookup-1- Search with relative and absolute cell reference.mp4
    12:25
  • 2. Vlookup-1-Search by two parameters (two way search).mp4
    10:47
  • 1. Demo1- Find a value in ROW in column of a Lookup value.mp4
    04:36
  • 2. Demo2 - Approximate Match.mp4
    03:29
  • 3. Demo3 - Find values from Arrays.mp4
    03:25
  • 4. Demo4 - Some common errors.mp4
    02:46
  • 5. Demo5 - Using Farmula Bar and function HLOOKUP.mp4
    03:28
  • 6. Demo6 - Combination of functions to find specific result.mp4
    10:18
  • 1. Bonus Lecture.html
  • Description


    MS EXCEL 2021

    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

    Who is this for?


  • All are welcome
  • What You Need to Know?


  • Basic Conversance of MS EXCEL
  • More details


    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

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    eBodhisathva Solutions
    eBodhisathva Solutions
    Instructor's Courses
    Ours is a partnership firm started in 2005, with offices in Bangalore and Hyderabad, India and San jose, USA. We worked as partners to EXAMPRO, HONGKONG for about 6 years before transforming to Independent Providers. eBodhisathva believes in offering the best value to the customer by minimizing all other overheads which are  duly passed to customer in the form of price. In other words we believe that the price is the value customer experiences and NOT the costs of administrative and other overheads. We believe that our customer is aware that any fancy spending by the firm is in reality absorbed from the customer without adding value to the customer.The fact that major share of our investment goes to the value providers who are creators of the valuable intellectual content for the customers, indicates how determined the firm is for ensuring the best value to customers.Any spend that does not add value to customer is cost for the firm and for the customer.We have a team that has good industrial and academic background with certifications such as APICS CPIM,CIERP,CISA,CBCP,CQA and PMP. In addition some of the team members were authors of many thought provoking literature in the area such as  DesignThinking, ERP Implementation, Business Ethics in IT, Center of Excellence and Value Added Tax .Our key advisors are Raja Ivaturi and Venkat Manthripragada. Both have vast experience of more than 30 year in multiple domains of Banking, Financials, Manufacturing, Utilities, Public Sector, Automobiles and Telecom. Their combined experience include international roles leading business units of continents such as Africa, Middle-East, APAC and Europe.
    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.
    • language english
    • Training sessions 14
    • duration 1:41:50
    • Release Date 2023/11/21