Data Analysis In Excel

Course

Online

£ 39 VAT inc.

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Class hours

    3h

  • Duration

    Flexible

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

In a world where we are constantly bombarded with information, making sense of it all can sometimes be difficult and time-consuming. This is particularly true of Excel. Analysing large amounts of data and presenting information that makes sense to your audience is an essential skill for many people.

In this short, ten module course we aim to teach you the basic skills you need to analyse data effectively and efficiently. From Pivot Tables and Conditional Formatting to Lookup Formulas and beyond, ‘Excel Data Analysis’ will set you up with a great foundation upon which to build further skills.
We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit.

We also know how difficult it is to find quality instruction that is:

Easy to follow
Gets you the results you want
Teaches you advanced methods that you can quickly put into practice

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course

Clean up data ready for analysis
Create PivotTables and PivotCharts
Lookup information using VLOOKUP, HLOOKUP and INDEX-MATCH
Make decisions using IF Statements
Highlight information using Conditional Formatting and Rules
Build a basic Interactive Dashboard

CPD UK

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 5 years

Subjects

  • Excel
  • Data analysis
  • Basic Skills
  • MS Excel
  • Excel Introduction
  • Excel Interface
  • Saving Files
  • Enter Data
  • Efficiency
  • Editing
  • Sorting and Filtering

Course programme

Syllabus:

Section 1: Basic Skills
  • Unit 1.1 - Excel Introduction
  • Unit 1.2 - The Excel Interface
  • Unit 1.3 - Accessing and Saving Files
  • Unit 1.4 - Read and Enter Data
Section 2: Efficiency of Use
  • Unit 2.1 - Keyboard Shortcuts
  • Unit 2.2 - Editing
Section 3: Data Analysis
  • Unit 3.1 - Basic Arithmetic
  • Unit 3.2 - Sorting and Filtering
Section 4: Presentation
  • Unit 4.1 - Setup and Printing

Data Analysis In Excel

£ 39 VAT inc.