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

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

    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 x64 €50

    DxO Optics Pro 11.4.0 Build 11979 Elite Multilingual x64 €22

    SketchUp Pro 2018 18.0 x64 €30

    Corel Painter 2018 Multilingual x64 €40