20 Sage Courses, Quickbooks, Excel, Accounting and Bookkeeping Package

Dive into learning with this bumper package of 20 Sage courses, as well as courses in QuickBooks, Excel, Accounting and Bookkeeping – it has everything you could possibly need to help you to develop your accounting, bookkeeping and office skills. It’s a complete toolkit for expanding your accountancy skills and an ideal purchase if you are looking to set up your own small business or get ahead of the competition in the jobs market.

From the Basics to the Advanced

This huge course package helps you to understand the core concepts of Sage and other pieces of essential accounting software by starting from the very beginning. It doesn’t throw you straight in at the deep end, but rather eases you in gently with a variety of Sage courses that will take you through the basic set ups to the more complex security configurations and reporting systems. This comprehensive resource includes a set of units consisting of Accounting Basics, QuickBooks, QuickBooks Point of Sale, Sage (Basic to Advanced) and an introduction to Excel. Over the course of the study – all conducted online – you will build on your confidence and competence within these areas so that, by the end of it, you’ll not only be stiff competition for any future job prospects but you’ll also be ready to go if you’re starting out on your own!

A Package that Covers All Bases

You can rest assured that, if you need to further your knowledge of Sage, QuickBooks and Excel, this all-inclusive bundle can help you to take your skillset to the next level – and beyond! The course leaves no stone unturned; whether you’re after the bare essentials to get you started or something a little more advanced so that you have all of the bases covered, by the time you reach completion of the course, you’ll have a clear and thorough understanding of these fundamental accounting programmes.

Key Learning Points

This course is a well-rounded package that can help you to build your knowledge of accounting and bookkeeping, whether you’re wishing to progress in your current job role, are on the lookout for a better opportunity or even if you’re considering setting up your own business venture.

• Help your small business flourish with the power of QuickBooks. Learn how to keep track of invoices and receipts, and keep track of paperwork so that when future audits arise, you won’t have to worry about hastily crunching the numbers.
• Learn how to analyse your business’ financial position, and keep track of your company information throughout the daily operation of it.
• Learn how to monitor stock levels, while keeping an eye on top-selling merchandise, as well as analysing customer stats and demographics so that you can target your customers with POS.
• Focus your time and motivation on ensuring your customers are happy, by allowing the QuickBooks Point of Sale software to track inventory, sales and customer information so that you don’t have to waste valuable time doing it manually. This software will also integrate with QuickBooks easily, so you don’t have to worry about double entry accounting.
• Become a master at Sage – essential accounting software – with 20 courses from basic to advanced level, including Sage 50.
• Broaden your bookkeeping skills, from configuration of accounts and invoicing, to setting up stock systems and managing profits and losses.
• Master the Excel software and learn how to utilise all of its useful features, including spreadsheets, charts, reports and macros. Learn how to manipulate formulas so that you can complete your own calculations to help streamline the spreadsheets that you create.

Advantages of this course

• Increase your marketability by broadening your skillset and improving your chance of a job offer or promotion.
• Business owners can save money with the know-how to do their own accounts.
• Sage 50 is one of the most desired accounting certifications; add it to your CV with this in-depth course package.
• Diverse study materials to complement any learning profile, including presentations, quizzes, exam simulators, educational games and flash cards.
• Instructor-led training videos; learn from some of the industry’s finest and be confident in the calibre of their teaching. Fast forward, rewind and pause to suit your own learning requirements.
• Practice exams available, so that you can make sure you’re ready for the real thing.

Drive yourself, and your business, forward and invest in this bumper accounting and bookkeeping package today!

• Units of study

Accounting Basics

• Intro
• Business Entities
• Beginning Your Business
• Financial Basics Part 1
• Financial Basics Part 2
• Employee Payroll
• Getting Your Business Out There
• SEO
• Other Topics
• Closing

Quickbooks

• Introduction to Quickbooks
• Setting up Quickbooks
• Tools
• Preferences
• Email Preferences
• Users and Security
• Estimates
• Sales and Orders
• Account Receivable
• Batch Invoicing
• Customer Deposits
• Bounced Checks
• Vehicle Mileage
• Class Tracking Transactions
• Receiving Payments
• Making Deposits
• Credit Cards
• Bank Accounts
• Payroll Preferences
• Employee Setup
• Processing Payroll
• Payroll Tax Forms
• Job Costing with Payroll
• Payroll Setup Advance
• Workers Compensation
• Special Transactions
• Memorized Transactions
• Other Account Types
• Quickbooks Reporting
• Advance Reporting
• Budgets and Forecast
• Writing Letters in MicroSoft Word
• Converting, Importing and Exporting
• Quickbooks backup Data Integrity
• Multi-Currencies
• Advance Features
• Update or Upgrade
• Summary of Quickbooks

Quickbooks Point of Sale (POS)

• Introduction to Point of Sale
• Creating and Setting Up Point of Sale
• Determine Your Point of Sale Additions
• Navigating and Customizing the Homepage
• Company Preferences
• Setting Up Quickbooks Connection
• Setting Up Sales Tax
• Workstation Preferences
• Additional Features
• Employee Security
• Customers
• Reward Programs
• Vendors
• Setting up Inventory
• Adding Styles Assemblies and Groups
• Working with Inventory
• Sales
• Working with Price Level and Discounts
• Collecting Sales Tax
• Adding Shipping Info
• Tracking Sales and Commission
• Taking Payments and Giving Change
• Recording Tips
• Handling Tricky Sales and Returns
• Working with Sales and Work Orders
• Purchasing Merchandise
• Receiving Purchase Orders
• Managing Inventory
• Reporting Point of Sales
• Quickbooks Financial
• Multi-Store
• Protecting Your Data
• Adding 3rd Party Apps
• Summary of Point of Sale

20 Courses in Sage Basic to Advanced Levels (1-3) Introduction to Sage

• Course Overview
• New Features
• Quick Tab Menu Overview
• Business Status
• Customer and Sales
• Vendors and Purchases
• Inventory and Services
• Employees and Payroll
• Banking
• System
• Quick Tab Menu Review
• Sage 50 Menu Overview
• Review

Understanding Sage Functions

• Sage 50 Available Products
• Accounts Payable Features
• Vendors and Purchases
• Accounts Payable Review
• Accounts Receivable Overview
• Customer and Sales Menu
• Customers
• Jobs
• Sales Taxes
• Quotes and Proposals
• Sales Orders
• Invoices
• Finance Charges
• Receive Money
• Bank Accounts
• Printing Statements
• Credits and Returns
• Accounts Receivable Reports
• Review

Inventory & Purchase order Basics

• Inventory and Services Overview
• Inventory Items
• Company Services
• Assemblies and Prices
• Purchase Orders
• Receiving Inventory, Shipping and Tracking
• Inventory Count and Adjustments
• Inventory Reports
• Review

Sage Payroll

• Employees and Payroll Overview
• Employees and Users
• 1099s
• Payroll Setup
• Time and Expense Tickets
• Direct Deposit and Printing Payroll Checks
• Forms and Void Checks
• Review

Banking & Accounts

• Banking Features Overview
• Write Checks
• Account Register
• Analysis Tools
• Chart of Accounts
• Receive Money and Bank Deposits
• Enter Bills, Pay Bills and Electronic Bill Pay
• Reconcile Accounts
• General Journal Entries
• Void Checks and Reports
• Review

Back Up & Restore Data

• Automatic Backup
• Back Up data
• Back Up data
• Automatic Backup
• Restore Data
• Data Maintenance
• System Checks
• Company Maintenance
• Data Integrity
• Review

Attaching Documents

• Attaching Documents
• Attaching and Managing Documents
• Review

Management Systems

• Analysis Managers
• Cash Flow Manager
• Collection Manager
• Payment Manager
• Financial Manager
• Review

Creating, Maintaining & Managing Jobs

• Maintaining Jobs
• Creating Jobs
• Managing Jobs
• Review

Creating, Maintaining & Managing Budgets

• Maintain Budgets
• Creating and Managing Budgets
• Review

Creating, Maintaining & Managing Accounts

• Maintain Chart of Accounts
• Creating Accounts
• Accounts List
• Review

Creating, Maintaining & Managing Customers

• Maintain Customers and Prospects
• Adding Customers and Prospects
• Account Aging
• Finance Charges
• Payment Methods
• Managing a Customer Account
• Review

Customer Setup, Balances, Statements and Invoicing

• Customer Setup Guide
• Customer Setup
• Customer Beginning Balance
• Customer Account Defaults
• Sales Tax
• Statement and Invoice Defaults
• Review

Basic to Advanced Job Management

• Jobs Setup Guide
• Jobs Setup
• Jobs Change Order
• Jobs Ledger
• Job Profitability Report
• Jobs Beginning Balances
• Jobs Defaults
• Review

Vendor Setup and Balances

• Vendors Setup Guide
• Vendor Setup
• Vendor Beginning Balances
• Vendor Defaults
• Review

Inventory Set Up & Management

• Inventory and Service Items Setup
• Adding and Managing Inventory and Service Items
• Quantities on Hand
• Inventory and Service Items Default Setup
• Review

Security Set Up & Management

• Security Setup Guide
• Setup Up Security
• Set Up Users
• User Security Setup
• User List Rights and Permissions
• Setup Guide Next Steps
• Review

Sage 50 ACT Creation, Maintenance & Management

• Sage 50 ACT
• Sage ACT Link
• ACT Accounting Link Setup
• Creating and Editing Contact Links
• Contact Link Updates Options
• Review

Understanding Tasks, Bills, Shipping, Charges & Other Functions

• Tasks Menu
• Quotes, Sales Orders and Proposals
• Sales Invoicing and Time Expenses
• Shipments
• Receipts
• Finance Charges
• Select For Deposit
• Credit Memos
• Select For Purchase Orders
• Bills and Payments
• Bills and Payments
• Account Register
• Time and Expense
• Select for Payroll Entry
• General Journal Entry
• Assemblies
• Account Reconciliation and Void Checks
• Write Letters and Action Items
• System Tasks
• Review

Reports & Forms

• Reports and Forms
• Form Types and Sample Forms
• Reports
• Services
• Program Review

MS Excel 2010 Introduction In this course, you will learn to create tables in the Microsoft Excel program, to enter data in them, to format the data and edit the table format. You will provide calculations through simple functions and formulas and will familiarize yourself with the basics of chart creation and formatting.

List of Lessons:

• Introduction to Excel
• Data entry and editing
• Worksheet navigation and basic settings
• Cell range selection
• Manipulation with cell ranges
• Cell inserting and deleting
• Text and cell formatting
• Number, Date and Time format
• Formatting via style gallery
• Working with files and windows
• Printing smaller tables
• The AutoSum button and formula copying
• Custom formula creation
• Work with functions
• Chart creation
• Chart formatting
• Proofing
• Basic Excel settings
• Getting help