Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
If you walk through the finance or accounting department at any major corporate office, you will see computer screens filled with Excel spreadsheets financial results , graphs, budgets,forecast, and plans used to make big business decisions.
Most users know that Excel can add, subtract, multiply, and divide, but it can do much more with advanced IF functions when coupled with VLOOKUP, INDEX-MATCH-MATCH, and pivot tables.
So this course is exactly covering all the business needs which is helpful to find a good career as Excel Expert.
In this course students will learn from scratch the work layout of the excel then gradually move forward to Advance Excel functions which are used to manipulate any kinds of numerical and other data. An accounting application will be created from scratch i.e chart of accounts to financial statements. All the report like trial balance , income statement and balance sheet will be created dynamical from general journal entries. Real business transactions will be also tested to guaranteed our application. This course will also cover payroll and payslips which is the need of any scale of business.
A working knowledge of Excel is vital for most office based professionals today, and stronger Excel skills can open the door to promotion and leadership opportunities. Excel is a powerful tool. It takes a savvy computer user to take advantage of everything Excel has to offer to provide the best results for their company.
In short if the students do the work side by side after completing this course they can called as Excel expert , Accountant and Excel base applications developer and seller.
All the working files and complete application is also attached with this course in working files section.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Course Importance and Introduction|
Why I am teaching this course ?Preview
Get familiar with Excel
|Section 2: Start Advance Excel Learning|
Simple Calculations (Sum Avgs)
Top excel functions lesson I
Top excel functions lesson IIPreview
Top excel functions lesson III
|Section 3: Creating Accounting Application|
Chart of Accounts design
Chart of Accounts list the accounts
Creating voucher templates using mergefunctions
Creating voucher types list
General Journal design
General journal validation listsPreview
General Journal conditional checks
Trial Balance Design
Conditional sum functions to integrate Trial Balance
Profit and Loss statement design
Profit and Loss statement integration
Creating Balance Sheet
Balance Sheet Farmating and Retriving values
Testing the Application with Real transactions Example
Tracking Balances and applying conditional formattings
Creating Dashboard Returns and Financial ratios calculations
|Section 4: Privacy and Protection|
Setting privacy,Creating users and work protection
|Section 5: Payroll|
Creating Payroll using different Excel functions
Dynamic Payslip for each employee with excel functions
Calculation of Over Time for Employees
|Section 6: Working Files|
I am software engineer. My core profession is Software development and Web designing. I love teaching Info Tech courses and involved in teaching since 2009 and have more 2000 students around the globe.
I know : How to program on console & GUI and create a perfect Data base driven system.
My toolkit is contain of C # , C++, JAVA , PHP , MYSQL , SQL ,ORACLE , HTML, CSS, Ms Excel Advance and others. In IDE I used NET-BEANS, ECLIPSE, VISUAL STUDIO, NOTEPAD++, DEV-C++ XAMP and other compilers.