merger merger

Welcome to your new course portal!

On October 15th, hotcourses.com moved to findcourses.co.uk - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show findcourses.co.uk as: Mobile

Excel for Accounting Fast Track

Activia Training
Course summary
1 day
249 GBP excl. VAT
English
Open / Scheduled
Next available date: 13/11/2019 09:15 - Leeds
Course Dates
Leeds
13/11/2019 09:15  (English)
249 GBP
08/01/2020 09:15  (English)
249 GBP
Slough
22/11/2019 09:15  (English)
249 GBP
London
11/12/2019 09:15  (English)
249 GBP
15/01/2020 09:15  (English)
249 GBP

Course description

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

This intensive, hands-on one-day training course is the ideal way to learn how to use Excel for accounting applications in the shortest possible time.

It covers formatting and managing data, auditing formulas and moves on to modelling and specialist accounting functions, as well as covering the essential tools of LOOKUPS and Pivot Tables.

Training Course Content

Formatting Financial Data
  • Using Formulas in Conditional Formatting
  • Modifying Rules
  • Top/Bottom Rules
  • Conditional Formatting
  • Custom Formatting
  • Currency/Accounting Formats
  • Number Formatting
Data Tools: Managing Your Data
  • Consolidating Data with Summary Sheets
  • Consolidating Data by Category
  • Consolidating Data by Reference
  • Consolidating Data by Position
  • Consolidating Data across Sheets
  • Data Validation
  • Removing Duplicates
  • Flash Fill
  • Text to Columns
Formula Auditing
  • Auditing via Trace Lines
  • Keeping Watch on Formula Values
  • Tracking Formulas
  • Evaluating Formulas
  • Error Checking Formulas
  • Trace Dependant & Precedent Data
LOOKUP Functions
  • LOOKUP
  • HLOOKUP
  • VLOOKUP
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
  • FORECAST Function
Using Pivot Tables
  • Using Timelines in Pivots
  • Slicers
  • Using the Classic PivotTable Layout
  • Formatting a PivotTable
  • Displaying Data in PivotTables
  • Getting Started With PivotTables

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 Fast Track.

  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


Request Information

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

Reviews

There are no reviews available yet.

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