Jan

17

2018

Excel For Accountants 2017

Laser 17 Jan 2018 00:21 LEARNING » e-learning - Tutorial

Excel For Accountants 2017
Excel For Accountants 2017
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3 Hours | Lec: 29 | 537 MB
Genre: eLearning | Language: English

Learn to use Excel to run your own books and organize your data in a professional way

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.

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
uploadgig



nitroflare


rapidgator


turbobit

High Speed Download

Add Comment

  • People and smileys emojis
    Animals and nature emojis
    Food and drinks emojis
    Activities emojis
    Travelling and places emojis
    Objects emojis
    Symbols emojis
    Flags emojis