Excel for Accounting
Original price was: $99.99.$17.99Current price is: $17.99.
What you will be taught
-
How to enter numbers and formulation in Excel
-
Posting journal entries
-
Posting to the final ledger
-
Clean formatting
-
Build monetary statements
-
Vlookup & hlookup
-
Index & match
-
Pivot tables
-
Create graphs
-
Basic features (sum, common, min, max)
-
Advanced features (IF, sumifs, countifs, vlookup)
-
Data evaluation
-
Balance sheet
-
Income Statement
-
Statement of money flows
Show extraShow much less
Updated excel for accounting course with new and improved audio plus new lectures!
Why this course is for you
You wish to improve your Excel abilities to develop into extra environment friendly at work, college, or any private mission. You wish to be taught highly effective Excel features that can help you automate a lot of your work and make your life simpler. You wish to learn to setup and format totally different accounting tables and use advance features to prepare your knowledge.
We will begin with fundamental features and go on to extra advance features all through the course. The features and setups you’ll be taught will put together you for any accounting mission.
What you’ll be taught:
- The fundamentals of excel: find out how to enter numbers, find out how to enter formulation, and the totally different features of Excel
- How to debit and credit score journal entries in excel
- Posting to the final ledger
- Functions that can aid you analyze your knowledge at a deeper
- Formats that can make your spreadsheets look clear
- Vlookup, hlookup, index & match features
- Sumifs & countifs features
- How to construct dynamic queries
- How to create built-in monetary 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 features
- How to create skilled knowledge tables
What you have to:
- A pc, laptop computer, or pill
- Microsoft Excel
- Basic accounting data
- Hunger to be taught
30-day a reimbursement assure
In the uncommon case that you just really feel the course was not useful or is not for you I’ll refund your cash as much as 30 days. You don’t have anything to lose and every little thing to achieve.
Who this course is for:
- Anyone who needs to grasp excel for a profession in accounting
- Small enterprise homeowners who wish to handle their very own books
- Anyone who needs to control knowledge to make their life simpler
- Anyone who needs to automate processes for their financials
10 reviews for Excel for Accounting
Add a review
Original price was: $99.99.$17.99Current price is: $17.99.
Michelle Patton –
I wouldn’t say it was “awful”, but he’s not always easy to understand. The black ribbon bar however is truly awful!
Agatha Fernander –
Presenter was excellent. Learnt to use Sumif, Countif. The course outline was want I was looking for. Will use what I have learnt at my workplace
Eugenia Blow –
I need some type of paperwork or atleast the formulas written down so I can see what I’m suppose to do.
Kathy Cooper –
I thought it would be a little more advanced that it was..But a good refresher on basic accounting functions.
L Moore –
The first 5 sections on VLOOKUP, INDEX/MATCH, and PIVOT TABLES were very detailed and worth far more than the price paid if user will pause and practice all the tools he is demonstrating. The last part on journal entries and the general ledger was not using any useful automated aspects of EXCEL at all but merely showing a manual posting process that was neither efficient nor even accurate for the tax aspects of the entries.
Bintou Viviane Diabate –
Yes this class was a great refresher for me. The step by step was perfect and easy to follow .
Aimee E Ketola –
The presenter’s voice sounds a little bored and has a slight southern accent maybe, which is a little distracting. But so far I am learning new things and am looking forward to dive deeper.
Randeep R Walia –
Yes, Keep up the good work!
Irina Sirbu –
So far it’s very clear.
Sm Sameer Nafi –
CLEAR EXPLANATION ABOUT THE FORMULA