Learn Advanced Excel & Responsive Accounting Application

Learn Advance MS Excel and practical work on creating an accounting application.
4.5 (9 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
420 students enrolled
25% off
Take This Course
  • Lectures 27
  • Length 3 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


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.

About This Course

Published 4/2016 English

Course Description

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.


What are the requirements?

  • Excel 2007, 2010 & 2013. This course was recorded using Excel 2007 but all the concepts taught are compatible with Excel 2013 and 2010.
  • Microsoft & Apple compatible
  • Capability to follow the step-by-step instructions of this training

What am I going to get from this course?

  • Learn advance excel concepts like lookup, conditional formatting, data validations, graphical representation, linking different sheets , controlling structures, creating users , protecting your work.
  • Creating a responsive accounting application for any business types in excel. ( General Journal , Trial Balance, Profit & Loss, Balance Sheet , Chart of Accounts, dashboards) .

Who is the target audience?

  • New users, beginners, intermediates and advanced Excel users
  • Skilled office workers who want to advance their career

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Course Importance and Introduction
Why I am teaching this course ?
Get familiar with Excel
Section 2: Start Advance Excel Learning
Simple Calculations (Sum Avgs)
Top excel functions lesson I
Top excel functions lesson II
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 lists
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
Working Files

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Muhammad Sajid Mughal, Web & Desktop Applications Developer and Udemy Instructor

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.

Ready to start learning?
Take This Course