Get $1 credit for every $25 spent!

The Microsoft Excel for Accounting Expert Bundle

Ending In:
Add to Cart - $29
Add to Cart ($29)
$1,200
97% off
wishlist
Courses
6
Lessons
93

What's Included

Product Details

Access
Lifetime
Content
8.0 hours
Lessons
23

Excel Accounting 1: Transactions for Common Data Input Forms

Build an Accounting System Using Excel & Enter Common Transactions from a CPA

By Robert Steele | in Online Courses

In this course, you will build an accounting system starting with a blank Excel worksheet, creating a general journal, a general ledger, a trial balance, sub-ledgers, and financial statements. For each new step in the process, you will have access to a downloadable Excel Workbook, containing at least two tabs, one with the answer, the new steps having been completed, the other starting out where the prior presentation left off.

Accountants are generally more valuable when they understand both the accounting theory, the impact on financial statements of each transaction, as well as how an accounting database program like QuickBooks works, including the data input forms used to enter normal financial transactions.

4.6/5 average rating: ★ ★ ★ ★

  • Access 23 lectures & 8 hours of content 24/7
  • Create an accounting system using Excel, starting from a blank worksheet
  • Navigate & format Excel worksheets
  • Create a general journal, general ledger, trial balance & subsidiary ledgers
  • Create financial statements, including a balance sheet & income statement
  • Enter transactions related to the vendor/customer/employee cycles, including the impact on subsidiary ledgers & financial statements
NOTE: Software NOT included
Robert Steele | CPA, CGMA, M.S. Tax, CPI
4.4/5 Instructor Rating: ★ ★ ★ ★

Robert Steele has experience working as a practicing Certified Public Accountant (CPA), an accounting and business instructor, and a curriculum developer. He has enjoyed putting together quality tools to improve learning and has been teaching, making instructional resources, and building curricula since 2009. Through working with students from many different schools, Mr. Steele has learned best practices for helping people understand accounting fast. Learning new skills and finding the best way to share knowledge with people who can benefit from it is a passion of his.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel, Google Sheets, or other spreadsheet program

Course Outline

  • Your First Program
  • Create Excel Worksheet
    • 1025 Create Accounting Worksheet Part 1 - 19:13
    • 1028 Create Accounting Worksheet Part 2 - 11:04
    • 1031 Create Accounting Worksheet Part 3 - 13:20
    • 1034 Create Accounting Worksheet Part 4 - 7:50
    • 1037 Create Accounting Worksheet Part 5 - 17:14
    • 1040 Create Accounting Worksheet Part 6 - 15:58
    • 1043 Create Accounting Worksheet Part 7 - 8:28
    • 1046 Create Accounting Worksheet Part 8 - 15:58
    • 1049 Create Accounting Worksheet Part 9 - 27:54
    • 1052 Create Accounting Worksheet Part 10 - 18:39
    • 1055 Create Accounting Worksheet Part 11 - 19:31
  • Vendor Cycle, Purchases Cycle, or Accounts Payable Cycle Transactions
    • 1180 Bill Form - 27:09
    • 1200 Pay Bills Form Check - 21:38
    • 1260 Check Form - 22:14
    • 1280 Void Check Prior Period Adjustment - 25:57
  • Customer Cycle, Sales Cycle, or Accounts Receivable Cycle Transactions
    • 1340 Invoice Form - 28:09
    • 1360 Receive Payment Form - 27:59
    • 1380 Deposit Form - 33:18
    • 1400 Sales Receipts Form - 26:30
    • 1420 Credit Memo Refund Form & Bad Debt Expense Service Item - 29:55
    • 1488 Credit Memo with Inventory - 33:13
  • Employee Cycle- Payroll Cycle Transactions
    • 1520 Pay Employees Form - 18:24
    • 1522 Pay Employees Form Part 2 - 26:18

View Full Curriculum


Access
Lifetime
Content
2.0 hours
Lessons
10

Excel Accounting 2: Worksheet, Opening Balances & Subledger

Set Up an Accounting System in Excel & Add Beginning Balances

By Robert Steele | in Online Courses

Create an accounting system starting from a blank Excel worksheet and add begging balances to your accounts. In this course, you will learn how to navigate Microsoft Excel as well as how to create a well-designed accounting worksheet, complete with a general journal, trial balance, general ledger, and subsidiary ledgers for accounts receivable, accounts payable, and inventory.

4.4/5 average rating: ★ ★ ★ ★

  • Access 10 lectures & 2 hours of content 24/7
  • Create an accounting system in Excel
  • Enter beginning account balances into a new accounting system
  • Navigate Microsoft Excel
  • Enter beginning balances for inventory & create an accompanying subsidiary ledger
  • Enter beginning balances for accounts receivable & create an accompanying subsidiary ledger
  • Enter beginning balances for accounts payable & create an accompanying subsidiary ledger
NOTE: Software NOT included
Robert Steele | CPA, CGMA, M.S. Tax, CPI
4.4/5 Instructor Rating: ★ ★ ★ ★

Robert Steele has experience working as a practicing Certified Public Accountant (CPA), an accounting and business instructor, and a curriculum developer. He has enjoyed putting together quality tools to improve learning and has been teaching, making instructional resources, and building curricula since 2009. Through working with students from many different schools, Mr. Steele has learned best practices for helping people understand accounting fast. Learning new skills and finding the best way to share knowledge with people who can benefit from it is a passion of his.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel, Google Sheets, or other spreadsheet program

Course Outline

  • Create Worksheet for New Company Accounting Transactions
    • 6010 Set Up Excel Worksheet - 10:15
    • 6012 Set Up Excel Worksheet #2 - 15:17
    • 6014 Set Up Excel Worksheet #3 - 10:15
    • 6016 Set Up Excel Worksheet #4 - 12:57
  • Adding Inventory Items & Related Inventory Account Balances
    • 6300 Inventory & Inventory Subsidiary Ledger - 25:17
  • Add Customers, Add Vendors & Accounts Receivable & Accounts Payables Balances
    • 6340 Accounts Receivable & Subsidiary Ledger - 12:11
    • 6360 Accounts Payable & Subsidiary Ledger - 9:02
    • 6362 Financial Statements - 19:06
  • Add Opening Account Balances
    • 6380 Add New Accounts & Opening Balances - 20:42
    • 6383 Adjust Beginning Balances in Worksheet for Current Period Data Input - 10:28

View Full Curriculum


Access
Lifetime
Content
5.0 hours
Lessons
16

Excel Accounting 3: Enter First Month of Transactions

Enter Transactions & Know Their Impact on General Ledger, Subsidiary Ledgers, Trial Balance, and Financial Statements

By Robert Steele | in Online Courses

This course will teach you how to navigate Microsoft Excel as well as how to use a well-designed accounting worksheet, complete with a general journal, trial balance, general ledger, subsidiary ledgers for accounts receivable, accounts payable, & inventory, financial statements and much more.

Excel is a very good tool to learn accounting because it is much more transparent than a database program, like accounting software, QuickBooks being a common example of accounting software. For most new steps in the process, you will have access to a downloadable Excel Workbook, containing at least two tabs, one with the answer, the new steps being completed, and the other starting out where the prior presentation left off.

4.4/5 average rating: ★ ★ ★ ★

  • Access 16 lectures & 5 hours of content 24/7
  • Record financial transactions into an accounting system using an Excel worksheet
  • Record the impact of each financial transaction on the general ledger, subsidiary ledgers, trial balance & financial statements
  • Enter transactions related to the selling of inventory
  • Learn how & why to use the undeposited funds accounts often seen in accounting software like QuickBooks
  • Create month end financial statements
NOTE: Software NOT included
Robert Steele | CPA, CGMA, M.S. Tax, CPI
4.4/5 Instructor Rating: ★ ★ ★ ★

Robert Steele has experience working as a practicing Certified Public Accountant (CPA), an accounting and business instructor, and a curriculum developer. He has enjoyed putting together quality tools to improve learning and has been teaching, making instructional resources, and building curricula since 2009. Through working with students from many different schools, Mr. Steele has learned best practices for helping people understand accounting fast. Learning new skills and finding the best way to share knowledge with people who can benefit from it is a passion of his.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel, Google Sheets, or other spreadsheet program

Course Outline

  • Month 1- Record Owner Investment, Purchase of Fixed Assets & Inventory
    • 7020 Record Deposits from Owner and Loan - 11:20
    • 7040 Purchase of Furniture & Investment Transactions - 16:28
  • Month 1- Enter Transactions for Purchase of Inventory
    • 7080 Cash Payment for Inventory Linked to Purchase Order P.O. - 23:04
  • Month 1- Enter Transactions for Sale of Inventory and Deposits
    • 7100 Invoice Selling Inventory - 31:47
    • 7120 Receive Payment From Previous Invoice - 20:43
    • 7140 Sales Receipt Payment Received at Point of Sale - 24:13
    • 7160 Deposits From Undeposited Funds - 11:34
  • Month 1- Enter Transaction for Sale of Inventory, Receive Payment & Bill
    • 7180 Invoice Created From Check Created From Purchase Order - 29:06
    • 7200 Receive Payment & Make Deposit - 17:28
    • 7220 Write Checks for Expenses & Prepaid Assets - 23:34
    • 7240 Bill Pay - 9:07
  • Month 1- Transactions for Payroll & Create Sales Receipt
    • 7280 Pay Employees - 17:33
    • 7281 Pay Employees Part 2 - 23:06
    • 7300 Enter Billable Time & Add to Invoice - 13:47
    • 7301 Enter Billable Expenses to Invoice - 21:07
  • Month 1- Create Financial Statements
    • 7320 Month One Financial Statements - 22:10

View Full Curriculum


Access
Lifetime
Content
6.0 hours
Lessons
23

Excel Accounting 4: Enter Data & Track Current Month and YTD

Enter Data into an Accounting System Using Excel, Generating Reports for Multiple Months

By Robert Steele | in Online Courses

This course will enter a month's worth of data input into an accounting system using Excel, which has already been set up and includes one month of data input. Learners will learn how to navigate Microsoft Excel and use a well-designed accounting worksheet, complete with a general journal, trial balance, general ledger, subsidiary ledgers for accounts receivable, accounts payable, & inventory, financial statements, and much more.

4.6/5 average rating: ★ ★ ★ ★

  • Access 23 lectures & 6 hours of content 24/7
  • Enter transactions into an accounting system using Excel
  • Create reports for the current month & for the year to date
  • Enter transactions into a general journal
  • Post transactions to a general ledger
  • Create a trial balance for the current month & the year to date
  • Create subsidiary ledgers for accounts receivable, accounts payable & inventory
  • Create financial statements for one month & for the year to date
NOTE: Software NOT included
Robert Steele | CPA, CGMA, M.S. Tax, CPI
4.4/5 Instructor Rating: ★ ★ ★ ★

Robert Steele has experience working as a practicing Certified Public Accountant (CPA), an accounting and business instructor, and a curriculum developer. He has enjoyed putting together quality tools to improve learning and has been teaching, making instructional resources, and building curricula since 2009. Through working with students from many different schools, Mr. Steele has learned best practices for helping people understand accounting fast. Learning new skills and finding the best way to share knowledge with people who can benefit from it is a passion of his.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel, Google Sheets, or other spreadsheet program

Course Outline

  • Month 2-Enter Loan Transaction, Create Amortization Table, & Investment
    • 8005 Format Worksheet for New Month - 17:39
    • 8020 Make Amortization Table - 11:41
    • 8022 Make Loan Payments - 17:24
    • 8040 Short Term Investment Sales & Gains - 11:28
  • Month 2-Enter Sale, Cash Received at Same Time & Bill for Inventory
    • 8120 Sales Receipt & Deposit - 28:28
    • 8122 Record Receipt of Inventory with Bill Linked to P.O. - 10:24
  • Month 2-Invoices for Service Sales & Advanced Customer Deposit
    • 8130 Populate Invoice Using Billable Item That was Created From P.O. - 15:21
    • 8140 Advanced Customer Payment or Unearned Revenue Method 1 - 20:48
    • 8160 Apply Customer Deposit (Credit) to Invoice - 17:19
    • 8200 Advanced Customer Payment or Unearned Revenue Method 2 - 24:22
  • Months 2-Transaction for Billable Time
    • 8320 Bill for Hourly Services of Staff Set up Items & Enter Billable Time - 8:57
    • 8322 Create Invoices Using Billable Time - 22:08
  • Month 2-Rental Income Transaction & Advanced Customer Deposit
    • 8342 Rental Income Customer Deposit - 14:25
    • 8344 Rental Income Estimate & Invoice - 20:28
  • Month 2-Purchase & Finance Equipment
    • 8360 Purchase & Finance Equipment - 10:39
    • 8362 Subaccounts Categories For Fixed Assets - 16:57
  • Month 2-Enter & Pay Month End Bills & Pay Sales Tax
    • 8365 Bills - Enter, Sort, & Pay - 27:00
    • 8370 Pay Sales Tax - 9:20
  • Month 2-Enter Payroll & Pay Payroll Tax for Prior Period
    • 8380 Enter Payroll For Second Month Part 1 - 16:25
    • 8381 Enter Payroll For Second Month Part 2 - 20:28
    • 8385 Pay Payroll Taxes - 15:08
  • Month 2 Financial Statements
    • 8420 Create Reports After Second Month of Data Input YTD - 21:57
    • 8421 Create Reports After Second Month of Data Month of February Only - 19:51

View Full Curriculum


Access
Lifetime
Content
1.0 hours
Lessons
6

Excel Accounting 5: Bank Reconciliations - Month 1 & 2

Put Together a Bank Reconciliation Using Excel

By Robert Steele | in Online Courses

This course will focus on creating bank reconciliations after two months of financial data was entered into an accounting system using Excel. For most new steps in the process, you will have access to a downloadable Excel Workbook containing at least two tabs, one with the answer, the new steps completed, and the other starting where the prior presentation left off.

Because cash is the lifeblood of the business and because every transaction will impact at least two accounts, due to the double entry accounting system, verifying cash transactions also provides a huge internal control over the rest of the accounting system, including the revenue cycle, the expenses cycle, and the employee cycle.

4.5/5 average rating: ★ ★ ★ ★

  • Access 6 lectures & 1 hour of content 24/7
  • Understand why the bank reconciliation process is important
  • Describe the bank reconciliation process
  • Complete a bank reconciliation process after the first month of operations, explaining the problems often faced during the first bank reconciliation
  • Complete a bank reconciliation after the second month of operations, explaining how the outstanding items in the first month will be included
  • Define outstanding checks & how they are shown on the bank reconciliation
  • Define outstanding deposits & how the are shown on the bank reconciliation
NOTE: Software NOT included
Robert Steele | CPA, CGMA, M.S. Tax, CPI
4.4/5 Instructor Rating: ★ ★ ★ ★

Robert Steele has experience working as a practicing Certified Public Accountant (CPA), an accounting and business instructor, and a curriculum developer. He has enjoyed putting together quality tools to improve learning and has been teaching, making instructional resources, and building curricula since 2009. Through working with students from many different schools, Mr. Steele has learned best practices for helping people understand accounting fast. Learning new skills and finding the best way to share knowledge with people who can benefit from it is a passion of his.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel, Google Sheets, or other spreadsheet program

Course Outline

  • Month One Bank Reconciliation
    • 9040 Bank Reconciliation Month One Part 1 - 22:45
    • 9041 Bank Reconciliation Month One Part 2 - 17:44
    • 9042 Bank Reconciliation Month One Part 3 - 21:02
  • Month Two Bank Reconciliation
    • 9140 Bank Reconciliation Month Two Part 1 - 17:52
    • 9141 Bank Reconciliation Month Two Part 2 - 17:52
    • 9143 Bank Reconciliation Month Two Part 3 - 17:24

View Full Curriculum


Access
Lifetime
Content
4.0 hours
Lessons
15

Excel Accounting 6: Adjusting Entries & Financial Statements

Enter Adjusting Entries Into an Excel Worksheet

By Robert Steele | in Online Courses

This course will focus on period-end adjusting entries, entries needed to report financial statements accurately on an accrual basis. Learners will know how to navigate Microsoft Excel and use a well-designed accounting worksheet, complete with a general journal, trial balance, general ledger, subsidiary ledgers for accounts receivable, accounts payable, & inventory, financial statements, and much more. For most new steps in our accounting practice problem, you will have access to a downloadable Excel Workbook containing at least two tabs, one with the answer, the new tasks completed, the other starting where the prior presentation left off.

4.6/5 average rating: ★ ★ ★ ★

  • Access 15 lectures & 4 hours of content 24/7
  • Know what adjusting entries are & how they fit into the accounting process
  • Enter adjusting & reversing entries for accrued interest
  • Enter adjusting & reversing entries for accounts receivable or revenue
  • Enter adjusting entries for prepaid insurance
  • Enter adjusting entries for depreciation
  • Enter adjusting & reversing entries for unearned revenue
  • Enter adjusting entry to break out the short-term & long-term portion of loans
  • Create financial statements from an adjusted trial balance
NOTE: Software NOT included
Robert Steele | CPA, CGMA, M.S. Tax, CPI
4.4/5 Instructor Rating: ★ ★ ★ ★

Robert Steele has experience working as a practicing Certified Public Accountant (CPA), an accounting and business instructor, and a curriculum developer. He has enjoyed putting together quality tools to improve learning and has been teaching, making instructional resources, and building curricula since 2009. Through working with students from many different schools, Mr. Steele has learned best practices for helping people understand accounting fast. Learning new skills and finding the best way to share knowledge with people who can benefit from it is a passion of his.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Excel, Google Sheets, or other spreadsheet program

Course Outline

  • Adjusting Entries Introduction
    • 10175 Adjust Worksheet for Adjusting Entries - 17:23
  • Accrued Interest
    • 10180 Adjusting Entry Accrued Interest Part 1 - 15:04
    • 10182 Adjusting Entry Accrued Interest Part 2 - 15:58
    • 10220 Reversing Entry Accrued Interest - 11:27
  • Accounts Receivable or Revenue
    • 10260 Adjusting Entry Accounts Receivable Sales - 20:49
    • 10300 Reversing Entry Accounts Receivable Sales - 14:11
  • Prepaid Insurance
    • 10340 Adjusting Entry Prepaid Insurance - 15:36
  • Depreciation
    • 10380 Adjusting Entry Depreciation - 24:05
  • Unearned Revenue
    • 10400 Adjusting Entry Unearned Revenue Customer Deposit - 16:46
    • 10460 Reversing Entry Unearned Revenue Customer Deposit - 10:59
  • Loans - Short-Term & Long-Term Portion
    • 10465 Loan Payable Short Term and Long-Term Portion - 14:11
    • 10467 Reversing Entry Loan Payable Short Term & Long-Term Portion - 8:23
  • Financial Statements
    • 10480 Financial Statements with Every Account - 18:53
    • 10485 Balance Sheet Condensed Format - 22:12
    • 10490 Income Statement Condensed Format - 27:43

View Full Curriculum



Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.