Tutorialspoint

Microsoft Excel for Data Analyst

Microsoft Excel for Data Analyst

Course Description

Excel is by far the world’s most popular spreadsheet program and is useful for everything from maintaining simple household budgets to building sophisticated financial models or designing complex dashboards. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel’s data analysis features to the maximum, rather than focusing on individual Excel functions and features.

Through this course, you will learn Advanced Data Sorting and Filtering techniques and how to use Lookup & reverse Lookup techniques – easy demo of VLOOKUP, HLOOKUP, INDEX and MATCH.

  • Advanced Data Sorting
  • Advanced Filtering
  • Conditional Formatting
  • Cell Referencing in Excel
  • Text Formulas
  • Removing Duplicates
  • Generate Pivot tables from datasets
  • VLOOKUP, HLOOKUP, INDEX & MATCH
  • Advanced functions- Transpose, Fibonacci, Skip blanks
  • What-if analysis

Goals

  • Advanced-Data Sorting
  • Advanced Filtering
  • Conditional Formatting
  • Cell Referencing in Excel
  • Text Formulas
  • Removing Duplicates
  • Generate Pivot tables from datasets
  • VLOOKUP, HLOOKUP, INDEX & MATCH
  • Advanced functions- Transpose, Fibonacci, Skip blanks

Prerequisites

  • Basic computer knowledge
  • Familiarity with the Microsoft Office work environment
Show More

Curriculum

  • Introduction to Advanced Data Sorting
    06:55
    Preview
  • How to use Data and Sort
    06:30
    Preview
  • Advanced Data Filtering
    10:55
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
Microsoft Excel for Data Analyst
This Course Includes
  • 1.5 hours
  • 14 Lectures
  • Completion Certificate Sample Certificate
  • Lifetime Access Yes
  • Language English
  • 30-Days Money Back Guarantee

Sample Certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registered users and counting who have advanced their careers with us.

X

Sample Certificate