Data Analysis for Accountants: Getting Started

by Paula Guilfoyle

As a finance professional you use Excel to analyse data, but how often do you overlook Excel's useful features? This course looks at basic and advanced features of Excel's PivotTable tool as well as PowerPivot and Data Analysis Expressions (DAX).

price £75+vat
cpd hours 4 CPD hours
access 120 days' access

This course will enable you to

  • Create tables, filter, sort and extract data for efficient data analysis
  • Set up a pivot table and apply summaries and calculations
  • Create and modify a pivot chart and use the GETPIVOTDATA function
  • Analyse data across multiple tables or data sets from different data sources using Data Analysis Expressions (DAX)

About the course

As a finance professional you will use Excel to analyse data, but how often do you overlook Excel's useful features? You may be familiar with creating tables, and filtering and sorting your data, but what more could you be doing to get more insight from your data?

This course looks at both basic and advanced features of Excel's PivotTable tool, which can be used to rearrange and summarise huge data sets without the need for complex formulas. You will also explore PowerPivot, one of Excel's most popular Power Tools. Equipped with its own language, Power Pivot enables you to analyse data across multiple tables or data sets, from different data sources.

Look inside

imac
slide-1
slide-2
slide-3
slide-4
slide-5
slide-1-thumbnail
slide-2-thumbnail
slide-3-thumbnail
slide-4-thumbnail
slide-5-thumbnail

Contents

  • Table, Filter, and Sort Features
    • Using tables
    • Setting up a table in Excel
    • Tables: an example
    • How to filter data
    • Filtering data
    • Sorting data and applying conditional formatting
    • Sorting it out
    • The benefits of using tables
    • Extracting data based on a single criterion
    • Extracting data based on multiple criteria
    • Extracting using multiple criteria
  • PivotTables: the basics
    • Introducing PivotTables
    • Understanding PivotTables
    • How to create a PivotTable
    • Setting up a PivotTable
    • Options for summarising values in a PivotTable
    • Adding calculations to a PivotTable
    • Different calculations in PivotTable value fields
    • Grouping data in a PivotTable
    • Grouping and ungrouping data
    • Applying a filter to a PivotTable
    • Using filters and report filter pages
  • Advanced PivotTables
    • Introducing advanced PivotTables
    • Adding a calculated field to a PivotTable
    • Creating a calculated field
    • Inserting a calculated item
    • Formatting a PivotTable
    • Number formatting in PivotTables
    • The GETPIVOTDATA function
    • Adding slicers and timelines to a PivotTable
    • Slicers and timelines
    • Understanding report layouts
    • Creating a PivotChart
    • Using PivotCharts
  • Power Pivot
    • Introducing Power Pivot
    • Understanding Power Pivot
    • Power Pivot orientation
    • Creating a linked table
    • Inserting PivotTables
    • Linking data tables
    • Relationships between tables
    • Setting up relationships
    • Setting up a table in Power Pivot
    • Adding calculations
    • Explaining DAX

How it works

Author

Paula Guilfoyle

Paula practiced in Industry for over 15 years, working with both small and large private companies, before moving on to teach Excel and Power BI to accountants and professionals.

Reviews

Recommended

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Pick n Mix

All you need for this year's CPD.

Licence

All you need for this year and more.

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours4 unitshourshours21 units20 hours21 hours800+ unitshourshours800+ unitshourshours
Access period120 days120 days12 months12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team’s needs
Learn moreLearn moreLearn more
Recommended

Why not upgrade?

Find the best way to complete your CPD

Licence

All you need for this year and more.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12 months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Access to this course
Total CPD unitshourshours4 unitshourshours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs

Why not upgrade?

Find the best way to complete your CPD

Pick n Mix

All you need for this year's CPD.

Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Licence

Recommended

All you need for this year and more.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12 months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Course

Need just a few unitshourshours?

Access to this course
Total CPD unitshourshours4 unitshourshours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs

Pick n Mix

All you need for this year's CPD.

Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

You might also like

Take a look at some of our bestselling courses