Courses for Excel in Accounts from Activia

Microsoft Excel for Accounting: Introduction

A 1-Day Training Course

Course Content

A Specialist Introduction to Excel for Accounting

Here in one place is a great new course, specifically designed to introduce delegates to using Excel for accounting jobs. That includes people producing any kind of financial analysis or charting, as well as accounting professionals.

In 8 highly focused modules, it takes you from the basics of Functions and Formulas, through Charts and Formatting, to LOOKUP functions.

And we look at presenting your results with charts and formatting, as well as the nuts and bolts of analysing financial data.

Course Aims

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.

Who Should Attend

This course has been designed for anyone who uses Excel to record, analyse and present financial data, whether in an accounting department or a more general office environment.

Delegates do not need to be accountants but they must understand the basics of using Excel in a Microsoft Windows environment.  A good level of numeracy is assumed.

Course Outline
This course is a 1-day training course structured into 8 modules.
Module 1
Working with Functions and Formulas
Topics covered
  • Formulas v Functions
  • Formulas with Absolute References
  • Using SUM across Multiple Ranges
  • Using SUMIF & AVERAGEIF
  • Using the IF Function and Nested IF
  • Creating Named Cells and Ranges
  • Text Functions in Excel
  • Module 2
    Outlining, Grouping and Sub Totals
    Topics covered
  • Outlining & Grouping Data
  • Using the Sub Total Tool
  • Using Sub Totals for Financial Data
  • Module 3
    Protecting Your Spreadsheet
    Topics covered
  • Protecting the Workbook File
  • Applying Worksheet Protection
  • Applying Workbook Protection
  • Password Protecting Specific Ranges
  • Sharing Workbooks
  • Encrypting Excel Files
  • Module 4
    Presenting Data with Charts
    Topics covered
  • Creating Charts
  • Selecting Chart Data
  • Working With Chart Options
  • Formatting Charts
  • Adding Chart Elements
  • Enhancing a Chart With Drawing Tools
  • Enhancing a Chart With Titles & Tables
  • Module 5
    Formatting Financial Data
    Topics covered
  • Number Formatting
  • Currency/Accounting Formats
  • Custom Formatting
  • Conditional Formatting
  • Top/Bottom Rules
  • Modifying Rules
  • Using Formulas in Conditional Formatting
  • Module 6
    Data Tools: Managing Your Data
    Topics covered
  • Text to Columns
  • Flash Fill
  • Removing Duplicates
  • Data Validation
  • Consolidating Data across Sheets
  • Consolidating Data by Position
  • Consolidating Data by Reference
  • Consolidating Data by Category
  • Consolidating Data with Summary Sheets
  • Module 7
    Formula Auditing
    Topics covered
  • Trace Dependant & Precedent Data
  • Error Checking Formulas
  • Evaluating Formulas
  • Tracking Formulas
  • Keeping Watch on Formula Values
  • Auditing via Trace Lines
  • Module 8
    LOOKUP Functions
    Topics covered
  • VLOOKUP
  • HLOOKUP
  • LOOKUP



  • Activia Training :   Training courses for business at twelve locations UK wide
    www.activia.co.uk