Excel for Accounting

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3 Hours | Lec: 32 | 556 MB

Genre: eLearning | Language: English

Learn to use Excel to run your own books and organize your data in a professional way

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