Analysing Data in Excel

0
Language

Level

Beginner

Certificate

Paid

Access

Paid

Last updated on June 12, 2024 8:08 pm

Discover all the fundamental data skills, tools and functions in order to make you a pro at using Microsoft Excel.

Add your review

Who is the course for?

The primary audience for this course are the vast majority of knowledge workers who use Excel every week but could easily do so more effectively, faster and with more confidence.

This includes professional knowledge workers, university students and recent graduates, in-career professionals who want to upskill, and those returning to work.

What topics will you cover?

The course covers the fundamental skills, tools and functions to be competent at analysing data in Excel. Including:

Excel functions

Excel formulae

PivotTables, conditional formatting, timelines, and slicers

PivotCharts

Spreadsheet management/efficiency

Excel shortcuts/commands

Thinking like a data analyst

What will you achieve?

By the end of the course, you‘ll be able to…

Produce a range of spreadsheets, including a cleaned data set, PivotTables, PivotCharts

Apply Excel formulae – such as concatenate, trim, and proper – to data sets to clean and analyse data

Calculate mathematical functions including averages, counts and sums

Identify which Excel functions and formulae are appropriate to perform mathematical functions, clean and interpret data, and answer business questions

Improve decision making, thinking efficiency and problem solving in Excel

Apply numerical and visual formatting, including conditional formatting, slicers and timelines, to spreadsheets to produce clean and comprehensible workbooks

User Reviews

0.0 out of 5
0
0
0
0
0
Write a review

There are no reviews yet.

Be the first to review “Analysing Data in Excel”

×

    Your Email (required)

    Report this page
    Analysing Data in Excel
    Analysing Data in Excel
    LiveTalent.org
    Logo
    Skip to content