Excel for Accounting | Udemy

Excel for Accounting | Udemy
English | Size: 1.76 GB
Genre: eLearning

What you’ll learn
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

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.

Who this course is for:
Anyone who wants to master excel for a career in accounting
Small business owners who want to manage their own books
Anyone who wants to manipulate data to make their life easier
Anyone who wants to automate processes for their financials



If any links die or problem unrar, send request to

About WoW Team

I'm WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I'll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.

Speak Your Mind

This site uses Akismet to reduce spam. Learn how your comment data is processed.