Excel for accountants

Current Status

Not Enrolled

Price

20000

Get Started

This course is currently closed

Course

Materials

Glossary_Excel_for_Accountants

Course Content

Expand All

Introduction

Excel for accountants Sample Lesson

1. Major Tasks in the Accounting Industry

Accounting Tasks and Career Roles

Basics of accounting industry

Cash flow budgeting in Excel 1 Quiz

Expand

Lesson Content

What is P&L

P&L in Excel

2. QuickBooks, Excel, and Small Business Record-Keeping

Small business accounting overview

Transactions in QuickBooks and Excel

Quarterly profit and loss tracking in Excel

QuickBooks and ledger records

Taxes and Excel record-keeping

Tracking business performance in Excel

Pivot tables for accountants

Import data from Excel to QuickBooks

3. The General Ledger, Excel, and Corporate Record-Keeping

General ledger overview

Recording transactions in a GL

GL strings

Corporate financial statements in Excel

Financial statement links in Excel

Key corporate accounting ratios

International accounting standards vs. the US

1 of 2

By Prof. Adebayo | October 20, 2019 | |