Show findcourses.co.uk as: Mobile

Excel for Accounting Advanced

Activia Training
Course summary
1 day
249 GBP excl. VAT
English
Open / Scheduled
Next available date: 05/09/2019 09:15 - Reading
Course Dates
Leeds
05/09/2019 09:15  (English)
249 GBP
17/10/2019 09:15  (English)
249 GBP
Reading
05/09/2019 09:15  (English)
249 GBP
17/10/2019 09:15  (English)
249 GBP
London
11/09/2019 09:15  (English)
249 GBP
02/10/2019 09:15  (English)
249 GBP
Course description

Course description

Our Excel for Accounting Advanced course will push your Microsoft Excel skills to a new level.

This intensive, hands-on one-day training course is the ideal follow-on from our Excel for Accounting: Introduction course.

It takes you to the highest level of using Excel in an accounts function in the shortest time because it focuses on only those subjects and tools you need in this environment.

Training Course Content

Logical and Error Functions
  • Array Formulas
  • IS Functions
  • IFERROR/IFNA
  • AND/NOT/OR Functions
WhatIf Analysis & Financial Modelling
  • Creating a Forecast Sheet
  • Using Solver
  • Scenarios
  • Data Tables
  • Goal Seek
Specialist Financial Functions
  • General: SLOPE, AVERAGE, EFFECT
  • Depreciation: SLN, DB
  • Rate of Return: IRR
  • Loan repayments: NPER, RATE, PMT, IPMT, PPMT
  • Future Value: FV
  • Present Value of an Investment: PV, NPV and XNPV
Using Pivot Tables
  • Using Timelines in Pivots
  • Slicers
  • Using the Classic PivotTable Layout
  • Formatting a PivotTable
  • Displaying Data in PivotTables
  • Getting Started With PivotTables
More About Charts
  • Making Custom Charts
  • Advanced Chart Formatting
  • Working With Chart Axes and Data Series
  • Using Error Bars
  • Creating Trendlines
  • Creating 3D Charts
  • Changing the Source Data
  • Changing the Type of Chart
Introduction to Macros
  • Visual Basic and Macros
  • Copying and Deleting Macros
  • Recording and Playing Macros
Advanced LOOKUP Functions
  • Using the INDIRECT Function
  • Using INDEX and MATCH with Array Formulas
  • Combining INDEX and MATCH
  • Using MATCH
  • Using INDEX
Advanced PivotTable Tools
  • Creating Custom PivotTable Styles
  • Showing PivotTables in Other Formats
  • Calculated Fields in PivotTables
  • Importing PivotTable Tools

Get Inspired! Watch the Video

About provider

Activia Training

Activia Training

When you organise your training, you need a partner who is able to deliver the skills improvements you need, and Activia have grown into a major UK provider on the strength of excellence in key areas. Whether it's competitive prices,...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Excel for Accounting Advanced.

  Contact the provider

  Get more information

  Register your interest

Contact info

Activia Training

Berkshire
Regus House, 268 Bath Road
SL1 4DX Slough

 Show phone number
www.activia.co.uk


Reviews

Simon
(4)
Well run course with good training resources
Request Information

Find out more about this Excel for Accounting Advanced course - simply fill out your details:

Reviews
Excel for Accounting Advanced
Course rating
(4.0)
Based on 1 reviews
U.K. L&D Report: 2019 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Be Inspired - watch the videos