Please ensure Javascript is enabled for purposes of website accessibility
Tax Preparation 2022-2023 Part 1 - Introduction And Excel Tax Formula Worksheet Creation

Learn the fundamentals of income tax preparation using an Excel tax formula method, no tax software necessary! Read more.

No ratings yet
Course Skill Level
Beginner
Time Estimate
5h 52m

Robert (Bob) Steele CPA, CGMA, M.S. Tax, CPI

Access all courses in our library for only $9/month with All Access Pass

Get Started with All Access PassBuy Only This Course

About This Course

Who this course is for:

  • Tax preparers
  • Bookkeepers
  • Accountants

What you’ll learn: 

  • Fundamentals of and tools used in income tax preparation

Requirements: 

  • No prior knowledge is required to take this course

This course will cover the fundamentals of income tax preparation. We will discuss the reasons for learning tax preparation, the methods for learning tax preparation, and the tools.

The course will compare different tax types and explain tax terminology, including what a progressive tax is and the differences between a marginal tax rate and an average tax rate.

Learners will approach tax preparation using three central angles: tax forms, a tax formula, and tax software.

You do not need tax software to take the course, as we will primarily use an Excel tax formula worksheet, but practicing with tax software is a powerful tool for learning.

We will talk about what is new for the tax year 2022.

We will create a tax worksheet using Excel, although you may also use Google Sheets. We will use the Excel tax formula worksheet to work on problems.

Explore an arsenal of finance and accounting courses from my instructor profile here in Skill Success.

Our Promise to You

By the end of this course, you will have learned tax preparation.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today!

Course Curriculum

Section 1 - Introduction
Resources – Tax Preparation 2022-2023 Part 1 00:00:00
1010.01 Why And How To Learn Tax Law 00:00:00
1020.03 Methods And Tools For Learning Tax Law 00:00:00
1030.04 Tax Software Options 00:00:00
1040.05 Free Tax Tools 00:00:00
1050.06 Tax Types Or Categories 00:00:00
1070 Marginal And Average Tax Rates 00:00:00
1080 Marginal And Average Tax Rates Example 00:00:00
1090 Income Tax Formula 00:00:00
1100 Income Tax Formula Example 00:00:00
1110 Tax Law And Tax Authority 00:00:00
1120 Circular 230 Regulations Governing Practice Before IRS 00:00:00
1130 Affordable Care Act – What You Need To Know 00:00:00
Section 2 - What's New And Filing Requirements
1135 What’s New 00:00:00
1145 Do You Have To File 00:00:00
1155 When And Where 00:00:00
Section 3 - Excel Worksheet - Tax Formula
1500 Create A Tax Formulate Worksheet Using Excel Part 1 00:00:00
1505 Create A Tax Formulate Worksheet Using Excel Part 2 00:00:00
1510 Create A Tax Formulate Worksheet Using Excel Part 3 00:00:00
1515 Create A Tax Formulate Worksheet Using Excel Part 4 00:00:00

About This Course

Who this course is for:

  • Tax preparers
  • Bookkeepers
  • Accountants

What you’ll learn: 

  • Fundamentals of and tools used in income tax preparation

Requirements: 

  • No prior knowledge is required to take this course

This course will cover the fundamentals of income tax preparation. We will discuss the reasons for learning tax preparation, the methods for learning tax preparation, and the tools.

The course will compare different tax types and explain tax terminology, including what a progressive tax is and the differences between a marginal tax rate and an average tax rate.

Learners will approach tax preparation using three central angles: tax forms, a tax formula, and tax software.

You do not need tax software to take the course, as we will primarily use an Excel tax formula worksheet, but practicing with tax software is a powerful tool for learning.

We will talk about what is new for the tax year 2022.

We will create a tax worksheet using Excel, although you may also use Google Sheets. We will use the Excel tax formula worksheet to work on problems.

Explore an arsenal of finance and accounting courses from my instructor profile here in Skill Success.

Our Promise to You

By the end of this course, you will have learned tax preparation.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today!

Course Curriculum

Section 1 - Introduction
Resources – Tax Preparation 2022-2023 Part 1 00:00:00
1010.01 Why And How To Learn Tax Law 00:00:00
1020.03 Methods And Tools For Learning Tax Law 00:00:00
1030.04 Tax Software Options 00:00:00
1040.05 Free Tax Tools 00:00:00
1050.06 Tax Types Or Categories 00:00:00
1070 Marginal And Average Tax Rates 00:00:00
1080 Marginal And Average Tax Rates Example 00:00:00
1090 Income Tax Formula 00:00:00
1100 Income Tax Formula Example 00:00:00
1110 Tax Law And Tax Authority 00:00:00
1120 Circular 230 Regulations Governing Practice Before IRS 00:00:00
1130 Affordable Care Act – What You Need To Know 00:00:00
Section 2 - What's New And Filing Requirements
1135 What’s New 00:00:00
1145 Do You Have To File 00:00:00
1155 When And Where 00:00:00
Section 3 - Excel Worksheet - Tax Formula
1500 Create A Tax Formulate Worksheet Using Excel Part 1 00:00:00
1505 Create A Tax Formulate Worksheet Using Excel Part 2 00:00:00
1510 Create A Tax Formulate Worksheet Using Excel Part 3 00:00:00
1515 Create A Tax Formulate Worksheet Using Excel Part 4 00:00:00

Are you interested in higher education?