reed.co.uk Courses

Header

January sale shop all deals

Microsoft Excel for Data Analyst Online Training


EduCBA

Summary

Price
£99 inc VAT
Study method
Online, self-paced
Duration
2 Hours
Access to content
Lifetime access
Qualification
No formal qualification
Additional info
  • Certificate of completion available and is included in the price

1 student purchased this course

Add to basket or enquire

Overview

Excel for Data Analyst

  • 2+ Hours OF HD VIDEOS
  • Verifiable CERTIFICATION
  • Practical SKILLS DEVELOPMENT
  • Accelerate YOUR CAREER
  • Lifetime Access 24*7 Unlimited Access
  • Access through any device
  • Technical support
  • Mobile App Access

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.

Description

Excel for Data Analyst

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

The training will help you learn about

  • 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

Who is this course for?

  • Market Analysts
  • Research Analysts
  • Data Analysts
  • Business Analysts

Requirements

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

Questions and answers

Currently there are no Q&As for this course.Be the first to ask a question.

Rating and reviews

There haven't been any reviews for this course yet.

Leave a review

Modals

Mobile Navigation