Shoping cart:
Cheap Software
Search by Letter:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z All programs New Mac

Excel For Accountants 2017

Buy!Download Size: 431.21 MB

Video: AVC 1280x720
Audio: AAC 44KHz 2ch
Duration: 3 Hours
Lec: 29
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
What you will need:

A computer, laptop, or tablet
Microsoft Excel
Basic accounting knowledge
Hunger to learn

Excel For Accountants 2017

Buy!Download Size: 431.21 MB

Customers who bought this program also bought:

Beauty Retouch Panel 3.0 and Pixel Juggler 2 for Photoshop for Win and Mac $10 BUY!
Intergraph CAESAR II 2018 version x32 x64 $30 BUY!
Intergraph PV Elite 2018 version 20.00.00 x32 x64 $25 BUY!
Fundamentals of Solar Energy for Electrical Engineering $10 BUY!
Calculation and Computation in the Pre-electronic Era The Mechanical and Electrical Ages $15 BUY!
Excel 2016 Beginning to Intermediate Complete Course $10 BUY!
Excel Tracking Data Easily and Efficiently $10 BUY!
Adobe CC 2018 Collection 19.04.18 $260 BUY!
SolidWorks 2018 SP3.0 Full Premium Multilanguage Integrated x64 (1 dvd) $110 BUY!
Microsoft Excel for Beginners Master the Basics $10 BUY!

Software Store Deal of the Day



Unclude: Adobe Acrobat 9.0 Pro Extended (1 dvd), Adobe Photoshop CS5 Extended 12.0 (1 dvd), Autodesk Autocad LT 2011 (1 dvd), Corel WinDVD Pro 2010 Multilingual, CorelDRAW Graphics Suite X5, DVD Cloner VII 7.10.992, TechSmith Camtasia Studio 7.0.0

Real PriceSaving Deal of the Day View it »
$2960 94.6%229$BUY!
We recommend
© 2010-2017. All rights reserved.