Brief Introduction
Learn to use Excel to run your own books and organize your data in a professional wayDescription
Updated excel for accounting course with new and improved audio plus new lectures!
Why this course is for you
You want to increase your Excel skills to become more efficient at work, school, or any personal project. You want to learn powerful Excel functions that will allow you to automate much of your work and make your life easier. You want to learn how to setup and format different accounting tables and use advance functions to organize your data.
We will start with basic functions and go on to more advance functions throughout the course. The functions and setups you will learn will prepare you for any accounting project.
What you will learn:
- The basics of excel: how to input numbers, how to input formulas, and the different functions of Excel
- How to debit and credit journal entries in excel
- Posting to the general ledger
- Functions that will help you analyze your data at a deeper
- Formats that will make your spreadsheets look clean
- Vlookup, hlookup, index & match functions
- Sumifs & countifs functions
- How to build dynamic queries
- How to create integrated financial statements (Balance Sheet, Income Statement, Statement of Cash Flows)
- How to create debt schedules and pp&e schedules
- Forecasting revenues
- How to create pivot tables
- Flash fill functions
- How to create professional data tables
What you will need:
- A computer, laptop, or tablet
- Microsoft Excel
- Basic accounting knowledge
- Hunger to learn
30-day money back guarantee
In the rare case that you feel the course was not helpful or isn't for you I will refund your money up to 30 days. You have nothing to lose and everything to gain.
Requirements
- Requirements
- Basic accounting knowledge
- Basic Excel knowledge
- Ability to download Excel
- Eagerness to learn
Knowledge
- How to enter numbers and formulas in Excel
- Posting journal entries
- Posting to the general ledger
- Clean formatting
- Build financial statements
- Vlookup & hlookup
- Index & match
- Pivot tables
- Create graphs
- Basic functions (sum, average, min, max)
- Advanced functions (IF, sumifs, countifs, vlookup)
- Data analysis
- Balance sheet
- Income Statement
- Statement of cash flows
ThinkTank Careers
4 Raiting
The Complete Business Plan Course (Includes 50 Templates)
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Everything You Need to Make a Great Business Plan by an Award Winning Business School Prof, VC & Successful Entrepreneur ...
Certified Public Accountant Tax Preparation Tutorial
- 4.1
-
![]()
![]()
![]()
![]()
![]()
A tutorial on how to do Basic Tax Preparation Work Paper organization is a first step to preparing quality tax and accounting and this course teaches the process....
Receivables & The Allowance vs The Direct Write Off Methods
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Accounts receivable valuation, allowance method, direct write off method, valuation of notes receivable, internist calc We will cover detailed methods for calculating simple interest....
Bayesian Statistics: From Concept to Data Analysis
- 4.6
-
![]()
![]()
![]()
![]()
![]()
This course introduces the Bayesian approach to statistics, starting with the concept of probability and moving to the analysis of data....
