Excel for Accounting 2017
4.8 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
436 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel for Accounting 2017 to your Wishlist.

Add to Wishlist

Excel for Accounting 2017

Learn to use Excel to run your own books and organize your data in a professional way
New
4.8 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
436 students enrolled
Created by ThinkTank Careers
Last updated 9/2017
English
Current price: $25 Original price: $100 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • Basic accounting knowledge
  • Basic Excel knowledge
  • Ability to download Excel
  • Eagerness to learn
Description

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:

  1. The basics of excel: how to input numbers, how to input formulas, and the different functions of Excel
  2. How to debit and credit journal entries in excel
  3. Posting to the general ledger
  4. Functions that will help you analyze your data at a deeper
  5. Formats that will make your spreadsheets look clean
  6. Vlookup, hlookup, index & match functions
  7. Sumifs & countifs functions
  8. How to build dynamic queries
  9. How to create integrated financial statements (Balance Sheet, Income Statement, Statement of Cash Flows)
  10. How to create debt schedules and pp&e schedules
  11. Forecasting revenues
  12. How to create pivot tables 
  13. Flash fill functions
  14. How to create professional data tables

What you will need:

  1. A computer, laptop, or tablet
  2. Microsoft Excel
  3. Basic accounting knowledge
  4. 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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
32 Lectures
03:04:01
+
Basic Functions
6 Lectures 33:52

Number Formatting
03:50

Rounding
05:54

IF Statement
04:40

IF Statement Cont..
06:50

Sumif & Countif
06:29
+
Advance Functions
5 Lectures 35:11
Multiple Range Sumifs
06:02

Vlookup & Hlookup
11:40

Vlookup Approximate
07:33

Index & Match
04:44

Vlookup & Sumifs
05:12
+
Pivot Tables
3 Lectures 23:11
Pivot Table
08:57

Pivot Table 2
07:41

Pivot Table 3
06:33
+
Tables & Graphs
4 Lectures 20:57
Flash Fill Data
05:05

Column and Bar Graphs
06:25

Line Graphs
04:36

Scatterplot Graphs
04:51
+
Building Financial Statements
8 Lectures 44:51
Balance Sheet Summary
04:24

Income Statement Summary
03:21

Cash Flow Statement Summary
02:47

Income Statement
06:58

Balance Sheet
08:17

Cash Flow Statement
05:08

Debt Schedule
08:56

PP&E Schedule
05:00
+
Accounting Ledgers
2 Lectures 20:59
Journal Entries
08:01

General Ledger
12:58
+
Conclusion
1 Lecture 00:55
Conclusion
00:55
About the Instructor
ThinkTank Careers
4.3 Average rating
40 Reviews
5,051 Students
5 Courses
ThinkTank Careers

ThinkTank Careers is a team of professional businessmen and women who have come together to educate individuals in our respective professions.  All of our teachers are college graduates with years of work experience in our fields. Our careers range from finance to management to bloggers. We are diverse group of individuals who hope to educate as many students as possible.