Learn the fundamentals of income tax preparation using an Excel tax formula method, no tax software necessary! Read more.
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 CourseAbout 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 |