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

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
Customers who bought this program also bought:
  • Microsoft Excel for Beginners Master the Basics €10
  • Excel 2016 Beginning to Intermediate Complete Course €10
  • 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
  • Intergraph CAESAR II 2018 version x32 x64 €30
  • Excel Tracking Data Easily and Efficiently €10
  • Adobe CC 2018 Collection 19.04.18 €260
  • SolidWorks 2018 SP3.0 Full Premium Multilanguage Integrated x64 (1 dvd) €110
  • Beauty Retouch Panel 3.0 and Pixel Juggler 2 for Photoshop for Win and Mac €10

  • Home| All Programs| Today added Progs| Download Status| Customers opinion| Helpdesk| Shopping cart      
    Copyright 2006-2019 ©   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

    AutoCAD 2019 x64 (1 dvd) €90


    SolidWorks 2018 SP2 x64 (1 dvd) €110

    FileMaker Pro 16 Advanced x64 €60

    Pinnacle Studio Ultimate 21 €25

    CorelDRAW Graphics Suite 2017 €65