Module One - Introduction

Module Two - Basic Terminology (Part 1)

• Balance Sheet
• Assets
• Liabilities
• Equity
• Income Statement
• Revenue
• Cost of Goods Sold
• Expenses
• Accounting Period

Module Three - Basic Terminology (Part 2)

• Accounts Receivable
• Accounts Payable
• Depreciation
• General Ledger
• Interest
• Inventory
• Journals
• Payroll
• Trail Balance

Module Four - Accounting Methods

• Cash Method
• Accrual Method
• Differences between Cash and Accrual

Module Five - Keeping Track of you Business

• Accounts Payable
• Account Receivable
• The Journal
• The General Ledger
• Cash Management

Module Six - Understanding the Balance Sheet

• The Accounting Equation
• Double-Entry Accounting
• Types of Assets
• Types of Liabilities
• Equity

Module Seven - Other Financial Statements

• Income Statement
• Cash Flow Statement
• Capital Statement
• Budget vs Actual

Module Eight - Payroll Accounting / Terminology

• Gross Wages
• Net Wages
• Employee Tax Withholding's
• Employer Tax Expenses
• Salary Deferrals
• Employee Payroll
• Employee Benefits
• Tracking Accrued Leave
• Government Payroll Returns / Reports

Module Nine - End of Period Procedures

• Depreciating your Assets
• Reconciling Cash
• Reconciling Investments
• Working with the Trial Balance
• Bad Debt
• Posting Adjustments and Corrections

Module Ten - Financial Planning, Budgeting and Control

• Reasons for Budgeting
• Creating a Budget
• Comparing Budget to Actual Expenses

Module Eleven - Auditing

• What is an Audit?
• When and Why would you Audit?
• Internal
• External

Module Twelve - Wrapping Up

Module One - Getting Started

Module Two - Glossary

• What is Finance?
• Commonly used Terms
• Key Players
• Important Financial Organisations
• Understanding GAAP

Module Three - Understanding Financial Statements

• Balance Sheets
• Income Statements (AKA Profit and Loss Statements)
• Statement of Retained Earnings
• Statement of Cash Flow
• Annual Reports

Module Four - Analysing Financial Statements (Part 1)

• Income Ratios
• Profitability Ratios
• Liquidity Ratios
• Working Capital Ratios
• Bankruptcy Ratios

Module Five - Analysing Financial Statements (Part 2)

• Long - Term Analysis Ratios
• Coverage Ratios
• Leverage Ratios
• Calculating Return on Investment (ROI)

Module Six - Understanding Budgets

• Common types of budgets
• What information do I need?
• Who should be involved?
• What should a budget look like?

Module Seven - Budgeting Made Easy

• Factoring in historical data
• Gathering related information
• Adjusting for special circumstances
• Putting it all together
• Computer based methods

Module Eight - Advanced Forecasting Technigues

• Using the average
• Regression Analysis
• Extrapolation
• Formal Financial Models

Module Nine - Managing the Budget

• How to tell if you're on track
• Should your budget be updated
• Keeping a diary of lessons learned
• When to panic

Module Ten - Making Smart Purchasing Decisions

• 10 questions you must ask
• Determining the Payback period
• Deciding whether to lease or buy
• Thinking outside the box

Module Eleven - A Glimpse into the Legal World

• A brief history
• The Sarbanes-Oxley Act
• CEO / CFO Certification
• 8th Company Law Directive

Module Twelve - Wrapping Up

PART ONE – THE BUILDING BLOCKS

Section One: Getting Started

• a quick refresher on basic writing concepts (such as spelling, grammar, and punctuation) – the things that we often miss especially when completing work under pressure; and
• an overview of some the typical business documents – letters, reports, proposals – that you may have to deal with, with tips on structure, style etc. 

Section Two: Spelling and Grammar

• Spelling
• Grammar

Section Three: Language and tone

• Clarity
• Conciseness
• Formality
• Focus
• Tone

Section Four: Sentences and Paragraphs

• Parts of a Sentence
• Sentence Length
• Punctuation
• Paragraphs

Section Five: Organization and Structure

• Organisation Approach

Section Six: Tools and Techniques

• The Reader
• The Requirement
• Write faster – effective writing
• Templates
• Proofreading
• Review/Peer Review
• The Appearance - Printing and Publishing

PART TWO – THE DOCUMENTS

Section Seven: Meeting Agendas

• The Basic Structure

Section Eight: E-mails

• Addressing your mails
• Brevity
• Formality
• Attachments
• Forwarding/replying

Section Nine: Business Letters

• The Basic Structure
• Writing the Letter

Section Ten: Proposals

• The Basic Outline
• Key information
• Sequence
• Choosing a Format
• Proposal Structure and Content
• Executive Summaries

Section Eleven: Reports

• Report Structure and format

Section Twelve: Requests for Proposal

• Requests for Proposals

Section Thirteen: Business Cases

• Business Cases

Section Fourteen: General Documentation

• General Documentation

Section Fifteen: Wrapping Up

Module One: Getting Started
By the end of this course, you should be able to:

• Open and close spreadsheets
• Understand the Office 365 web interface, including the home page, the team site, and the shared documents list
• Understand the Excel 365 browser interface
• Upload a spreadsheet to the Shared Documents library
• Differentiate between worksheets, workbooks, rows, columns, and cells
• Download and reload workbooks
• Use the Find Command
• Save a Copy
• Open in Editing View
• Open the spreadsheet in the Excel desktop application for more advanced features
• Understand saving and collaborating
• Create a new file
• Enter labels and values
• Edit data
• Use the Wrap Command
• Use cut, copy, and paste
• Use Undo and redo
• Add rows and columns
• Delete cells
• Understand shortcuts
• Build, copy and edit formulas
• Use absolute referencing appropriately
• Understand the difference between Formulas and Functions
• Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
• Understand Autocomplete
• Sort and filter data
• Collaborate with others on a spreadsheet
• Refresh and recalculate data
• Format text and numbers
• Use alignment options
• Apply borders and fill color
• Insert and work with Tables
• Insert and work with Charts
• Insert links

Module Two: Welcome to Office 365 Web Apps

• The Home Page
• The Team Site
• Shared Documents
• Uploading a Spreadsheet

Module Three: Worksheets and Workbooks

• Opening a Spreadsheet
• Overview of the Reading View
• Understanding Worksheets vs. Workbooks
• Downloading and Reloading
• Closing Spreadsheets

Module Four: Working with Excel Files

• Using the Find Command
• Saving a Copy
• Editing in Browser
• The Excel Web App Interface
• Opening in Excel

Module Five: Editing in the Browser (one)

• About Saving and Save As
• A New File and AutoSaving
• Entering Data
• Editing Data
• Using the Wrap Command

Module Six: Editing in the Browser (two)

• Cut, Copy, and Paste
• Using Undo and Redo
• Adding Rows and Columns
• Deleting Cells
• Using Timesaving Shortcuts

Module Seven: Building Formulas

• The Math Basics of Excel
• Building a Formula
• Editing a Formula
• Copying a Formula
• Relative vs. Absolute References

Module Eight: Understanding Functions

• Formulas vs. Functions
• Using the SUM Function
• Using Other Basic Excel Functions
• Using AutoComplete

Module Nine: Working with Data

• Sorting Data
• Filtering Data
• About Collaborating
• About Refreshing External Data

Module Ten: Formatting Your Data

• Changing the Appearance of Text
• Changing the Appearance of Numbers
• Setting Alignment Options
• Adding Borders
• Adding Fill Color

Module Eleven: The Insert Tools

• Inserting Tables
• Inserting Charts
• Working with Charts
• Inserting Links

Module Twelve: Wrapping Up

Module One: Getting Started

By the end of this course, you will be able to:

• Organize a binder
• Develop procedures
• Prepare checklists
• Understand succession planning
• Collect the correct tools

Module Two: Why Your Office Needs Adminstrative Procedures

• Business Continuity
• Succession Planning
• Internal and External Audit Requirements
• Recovery Planning

Module Three: Gathering the Right Tools

• Binder
• Section Divider
• Sheet Protectors
• Cover to Cover Binders

Module Four: Identiyfing Procedures to Include

• Tracking Tasks for Some Days
• Reach Out to Other Employees for Feedback/Ideas
• Write Down Daily Tasks
• Keep Track Using a Spreadsheet

Module Five: Top Five Procedures to Record

• Use a Template to Stay Consistent from Track to Track
• Be as Detailed as Possible
• Use Bullet Points Instead of Paragraphs
• Ask Someone to Execute the Procedure

Module Six: What to Include in Your Binder (I)

• Phone Etiquette
• Business Writing
• Effective Time Management
• Creating Meeting Arrangements

Module Seven: What to Include in Your Binder (II)

• Policy on Absences
• Breaks
• Salaries
• Benefits

Module Eight: Organizing Your Binder

• Create a Table of Contents
• List Each Section (e.g. Accounting)
• List Procedures in that Section
• Keep Binder Updated with any New Changes

Module Nine: What Not to Include in the Procedure Guide

• Passwords
• Identify Other Confidential Information Via Your Employer
• Store Information in a Separate Folder Outside of the Guide
• Find a Secure Location to Store

Module Ten: Share Office Procedure Guide

• Give Guide to Boss/Executive to Review
• Inform Office Personnel of Procedure Guide
• Place Guide in a Visible Area
• Allow Office Personnel to Express Improvements/Updates if Needed

Module Eleven: Successfully Executing the Guide

• Create a One Hour Meeting/Seminar for Employees
• Stay Consistent with Procedures
• Make Employees Aware of any Updated Changes
• Keep Open to Improvements

Module Twelve: Wrapping Up