Learn Advanced Excel & Responsive Accounting Application

Learn Advance MS Excel and practical work on creating an accounting application.
4.8 (8 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.
410 students enrolled
$19
$20
5% 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

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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.

GOOD LUCK

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) .

What 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.

Curriculum

Section 1: Course Importance and Introduction
Why I am teaching this course ?
Preview
02:11
Get familiar with Excel
07:15
Section 2: Start Advance Excel Learning
Simple Calculations (Sum Avgs)
05:54
Top excel functions lesson I
04:43
Top excel functions lesson II
Preview
04:51
Top excel functions lesson III
04:51
Section 3: Creating Accounting Application
Chart of Accounts design
05:30
Chart of Accounts list the accounts
07:43
Creating voucher templates using mergefunctions
07:40
Creating voucher types list
07:23
General Journal design
07:57
General journal validation lists
Preview
08:20
General Journal conditional checks
09:42
Trial Balance Design
06:09
Conditional sum functions to integrate Trial Balance
11:03
Profit and Loss statement design
09:13
Profit and Loss statement integration
08:08
Creating Balance Sheet
08:08
Balance Sheet Farmating and Retriving values
08:42
Testing the Application with Real transactions Example
07:30
Tracking Balances and applying conditional formattings
04:46
Creating Dashboard Returns and Financial ratios calculations
05:33
Section 4: Privacy and Protection
Setting privacy,Creating users and work protection
04:48
Section 5: Payroll
Creating Payroll using different Excel functions
04:00
Dynamic Payslip for each employee with excel functions
05:44
Calculation of Over Time for Employees
10:27
Section 6: Working Files
Working Files
00:17

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