Excel for Accounting

Excel for Accounting, available at $64.99, has an average rating of 4.5, with 32 lectures, based on 389 reviews, and has 1649 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone who wants to master excel for a career in accounting or Small business owners who want to manage their own books or Anyone who wants to manipulate data to make their life easier or Anyone who wants to automate processes for their financials It is particularly useful for Anyone who wants to master excel for a career in accounting or Small business owners who want to manage their own books or Anyone who wants to manipulate data to make their life easier or Anyone who wants to automate processes for their financials.

Enroll now: Excel for Accounting

Summary

Title: Excel for Accounting

Price: $64.99

Average Rating: 4.5

Number of Lectures: 32

Number of Published Lectures: 32

Number of Curriculum Items: 32

Number of Published Curriculum Objects: 32

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Course Overview

Lecture 3: Download Course Worksheets Here

Chapter 2: Basic Functions

Lecture 1: Basic Formulas

Lecture 2: Number Formatting

Lecture 3: Rounding

Lecture 4: IF Statement

Lecture 5: IF Statement Cont..

Lecture 6: Sumif & Countif

Chapter 3: Advance Functions

Lecture 1: Multiple Range Sumifs

Lecture 2: Vlookup & Hlookup

Lecture 3: Vlookup Approximate

Lecture 4: Index & Match

Lecture 5: Vlookup & Sumifs

Chapter 4: Pivot Tables

Lecture 1: Pivot Table

Lecture 2: Pivot Table 2

Lecture 3: Pivot Table 3

Chapter 5: Tables & Graphs

Lecture 1: Flash Fill Data

Lecture 2: Column and Bar Graphs

Lecture 3: Line Graphs

Lecture 4: Scatterplot Graphs

Chapter 6: Building Financial Statements

Lecture 1: Balance Sheet Summary

Lecture 2: Income Statement Summary

Lecture 3: Cash Flow Statement Summary

Lecture 4: Income Statement

Lecture 5: Balance Sheet

Lecture 6: Cash Flow Statement

Lecture 7: Debt Schedule

Lecture 8: PP&E Schedule

Chapter 7: Accounting Ledgers

Lecture 1: Journal Entries

Lecture 2: General Ledger

Chapter 8: Conclusion

Lecture 1: Conclusion

Instructors

ThinkTank Careers
ThinkTank Careers

Rating Distribution

1 stars: 6 votes
2 stars: 12 votes
3 stars: 75 votes
4 stars: 133 votes
5 stars: 163 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu