Show as: Mobile

Excel for Accounting Introduction

Activia Training
Course summary
1 day
249 GBP excl. VAT
Open / Scheduled
Next available date: 22/07/2019 09:15 - Reading
Course Dates
22/07/2019 09:15  (English)
249 GBP
04/09/2019 09:15  (English)
249 GBP
30/07/2019 09:15  (English)
249 GBP
11/09/2019 09:15  (English)
249 GBP
31/07/2019 09:15  (English)
249 GBP
19/08/2019 09:15  (English)
249 GBP

Course description

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

This intensive, hands-on one-day training course is the ideal introduction to using Excel for accounting applications in the office.

It teaches the basics of what's needed to record, work with and display all types of financial data, without the time-wasting distraction of more general Excel courses which cover subjects that aren't directly relevant to an accounting function.

Training Course Content

Working with Functions and Formulas
  • Text Functions in Excel
  • Creating Named Cells and Ranges
  • Using the IF Function and Nested IF
  • Using SUM across Multiple Ranges
  • Formulas with Absolute References
  • Formulas v Functions
Outlining, Grouping and Sub Totals
  • Using Sub Totals for Financial Data
  • Using the Sub Total Tool
  • Outlining & Grouping Data
Protecting Your Spreadsheet
  • Encrypting Excel Files
  • Sharing Workbooks
  • Password Protecting Specific Ranges
  • Applying Workbook Protection
  • Applying Worksheet Protection
  • Protecting the Workbook File
Presenting Data with Charts
  • Enhancing a Chart With Titles & Tables
  • Enhancing a Chart With Drawing Tools
  • Adding Chart Elements
  • Formatting Charts
  • Working With Chart Options
  • Selecting Chart Data
  • Creating Charts
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

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 Introduction.

  Contact the provider

  Get more information

  Register your interest

Contact info

Activia Training

Regus House, 268 Bath Road
SL1 4DX Slough

 Show phone number

Request Information

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


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's second annual U.K. L&D Report!


Learn more

Be Inspired - watch the videos