Home| All Programs| Today added Progs| Download Status| Customers opinion| Helpdesk| Shopping cart

Program Search:

Shopping Cart:




*Note: Minimum order cost: €20
Maximum Total Price: €1500
We Recommend:
Excel For Accountants 2017 €15 buy download




MP4
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

Download File Size:431.21 MB


Excel For Accountants 2017
€15
Customers who bought this program also bought:
  • Intergraph CAESAR II 2018 version 10.00.00.7700 x32 x64 €30
  • Intergraph PV Elite 2018 version 20.00.00 x32 x64 €25
  • Fundamentals of Solar Energy for Electrical Engineering €10
  • Calculation and Computation in the Pre-electronic Era The Mechanical and Electrical Ages €15
  • Excel Tracking Data Easily and Efficiently €10
  • SolidWorks 2018 SP3.0 Full Premium Multilanguage Integrated x64 (1 dvd) €110

  • Home| All Programs| Today added Progs| Download Status| Customers opinion| Helpdesk| Shopping cart      
    Copyright 2006-2010 ©   LPStore   All Rights Reserved





    Adobe Acrobat Pro DC 2017.012.20093 Multilingual €68


    MathWorks MATLAB R2018a x64 (2 dvd) €100


    Adobe Acrobat Pro DC 2017.009.20058 Multilingual for Mac €68






    Adobe CC 2018 Collection x64 €260


    Adobe Photoshop Elements and Premiere Elements 2018 16.0 Multilanguage x64 €35


    Microsoft Windows 10 Pro With Office and More x64 (1 dvd) €150






    Intuit QuickBooks Enterprise Accountant 18.0 R1 €40


    Mindjet MindManager 2018 18.0.284 Multilingual x64 €25


    Chief Architect Premier X9 19.3.1.8 x64 €50