The 2022 Complete Tax Preparation Bundle

11 Courses & 59 Hours
$29.99$2,189.00
You save 98% -

What's Included

Money in Excel: Income Tax Sch. C & Personal Financials
  • Certification included
  • Experience level required: All levels
  • Access 12 lectures & 2 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

12 Lessons (2h)

  • Your First Program
  • Introduction
    1050 What It Can Do For Us20:24
  • Create Excel Worksheet and Link to Financial Institution
    1100 Money In Excel Create Worksheet18:41
    1110 Money In Excel Connect Financial Institution10:55
  • Sort Transactions Data & Add Categories
    1115 Categories & Subcategories Income Items22:14
    1120 Categories & Subcategories Expense Items18:33
    1125 Accounts Numbers To Sort Data8:54
  • Income Statement Creation
    1130 Create Income Statement Options10:20
    1135 Create Income Statement Using Tables16:39
    1140 Create Income Statement Using Pivot Tables10:30
  • Balance Sheet or Net Worth, Budget, & Recurring Transactions
    1145 Net Work Template13:09
    1150 Budget Template11:31
    1155 Recurring Expenses Template8:10

Money in Excel: Income Tax Sch. C & Personal Financials

RS
Robert Steele

Robert (Bob) 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 curriculum since 2009. Mr. Steele has also authored five books that can be found on Amazon or in audiobook format on Audible. He has developed bestselling courses in accounting topics including financial accounting and QuickBooks accounting software.

Description

Money in Excel is an Excel template provided by Microsoft that has bank connectivity similar to many accounting software applications such a QuickBooks, bank connectivity allowing for the download of financial data directly from the financial institutions. This course will cover how to access the Money in Excel template and connect it to financial institutions, downloading financial data. The course will also cover other functions provided by Money in Excel including budgeting options and recurring transactions.

4.8/5 average rating: ★ ★ ★ ★

  • Access 12 lectures & 2 hours of content 24/7
  • Know what Money in Excel can be useful for
  • Set up the Money in Excel template
  • Connect Money in Excel to financial institutions
  • Add account or categories & subcategories to data
  • Sort business & personal data
  • Create an income statement that may be useful for taxes
  • Create a balance sheet or statement of net position
  • Use the Money in Excel budgeting template
"It's helped me when it comes to using money excel and generating income statement, linking bank statement use to generate report need in the business." – Angelica V.

Specs

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: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Microsoft Office would be preferable

Terms

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