Advanced Excel & Accounting Side by Side
3.6 (4 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.
430 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Advanced Excel & Accounting Side by Side to your Wishlist.

Add to Wishlist

Advanced Excel & Accounting Side by Side

Learn Advance MS Excel and practical work on creating an accounting application.
3.6 (4 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.
430 students enrolled
Last updated 5/2016
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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) .
View Curriculum
  • 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

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.


Who is the target audience?
  • New users, beginners, intermediates and advanced Excel users
  • Skilled office workers who want to advance their career
Students Who Viewed This Course Also Viewed
Curriculum For This Course
27 Lectures
Course Importance and Introduction
2 Lectures 09:26

Get familiar with Excel
Start Advance Excel Learning
4 Lectures 20:19
Simple Calculations (Sum Avgs)

Top excel functions lesson I

Top excel functions lesson III
Creating Accounting Application
16 Lectures 02:03:27
Chart of Accounts design

Chart of Accounts list the accounts

Creating voucher templates using mergefunctions

Creating voucher types list

General Journal design

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
Privacy and Protection
1 Lecture 04:48
Setting privacy,Creating users and work protection
3 Lectures 20:11
Creating Payroll using different Excel functions

Dynamic Payslip for each employee with excel functions

Calculation of Over Time for Employees
Working Files
1 Lecture 00:17
Working Files
About the Instructor
Muhammad Sajid Mughal
3.0 Average rating
25 Reviews
1,875 Students
2 Courses
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.