


Beginner: learn from the absolute basic even if you have never used MS-EXCEL ever
Intermediate: Learn how to perform day to functions with great efficiency
Advanced: Learn the advance functions and features and let your creativity guide you
AI: Now incorporating AI usage to speed up your work and make sure you stay ahead of the curve
Flexible Learning Pace:
Lifetime access allowing you to study at your own pace, without the pressure of deadlines. This flexibility is especially beneficial for individuals with busy schedules. You can revisit complex topics as often as needed to fully understand the material.
Continuous Access to Updated Content:
This course offers lifetime access and includes updates to the content. As new information becomes available or the subject matter evolves, the course material will be updated, ensuring that learners have access to the most current knowledge and practices.
Full access: All the material used in the videos is also provided to students for practice, so they can practice while watching.
Pre Built Templates: Full access to various pre built EXCEL Templates to enhance productivity.
Private Community: Get all your questions answered daily so you are never second guessing or wasting time!
Pre Built Templates: Get over 800 templates for your use to boost your office productivity, from Budgeting spreadsheets to monthly planners, only if you buy now!


You want to learn how to get proficient in Microsoft Excel 365
You have zero knowledge and you want to start from the absolute basic
You want to understand the practical application of MS-Excel 365
You want to increase your efficiency and effectiveness and save time while using MS- Excel 365
You have basic level knowledge but you want to understand how to use excel to excel at your office or for save time working on spreadsheets for your own business
You want to understand how to start using AI to incorporate into your daily work routine working with EXCEL spreadsheet
The absolute beginner
People with intermediate level of knowledge
Someone who wants to understand charts as visual representation enhances understanding for users
Business owners who yet cannot afford someone to manage their business information
Students who need to work on research projects.
Anyone who wants to speed up their work by leveraging AI
And so much more!
Your aren't willing to take instructions and prefer to figure things out on your own with trial and error.
You do not have the need for maintaining and organizing information as some one else does everything for you




Lorem ipsum dolor sit amet, consectetur adipisicing elit. Autem dolore, alias, numquam enim ab voluptate id quam harum ducimus cupiditate similique quisquam et deserunt, recusandae.

In this section we will learn how to set up account and how to buy the online version and avail any discount available at the moment

We will learn how to carry out basic account settings. How to set up QBO for maximum efficiency

This is where we will go through the basics of QBO, we learn more about the dash Board of QBO, where each item is and how to navigate to each section quickly and even customize it

The basis of all accountancy is Chart of accounts. This is perhaps the most integral part of QBO. We will learn how to set up Chart of accounts.

We will learn how to set up accounts receivables, how to navigate and see and pull reports on our customers and check the ageing.

Similarly just like receivables we need to keep track of our liabilities, to whom we owe how much and by when. Failure to pay on time can create major bottle neck issues which we want to avoid.

Considered to be the hardest part is making the journal entries and we will learn within the confines of accounting principals how to pass journal entries.

One of the most important functions of accounting is being able to reconcile bank transactions. In audit if bank is reconciled it is assumed your 90% of book keeping is accurate. That explains the importance of Bank reconciliation.

Finally, its not complete unless we go through full cycle of Book keeping in QBO.

There will be a lot more in it, we will keep on improving the whole thing lifetime!

The course will introduce the use of spreadsheets outside of software use and how use of spreadsheets complements use of accounting software

We start by understanding how to best use excel for passing journal entries and taking it to preparation of ledger and eventually Trial Balance

This is where we want to prepare financial statements using spreadsheets

Despite having software to this for us, sometimes we need to use spreadsheets to prepare a more customizable Aging Analysis of our receivables

Perhaps the jewel of this course is our bank reconciliation training. Its long but very useful. Software can only go so far, bank reconciliation is a tricky business and this will help you cut down your time 10X

Similar to Bank recollimation, if you can reconcile bank account, you can reconcile any company account. It could be intercompany accounts or inventory accounts, it could be anything you want

A very important function, if you are an individual entrepreneur, this is for you, where you have to juggle many bank accounts . If you are an employee in a medium size company or you manage treasury function in a large MNC, you will thank me for this later!

learn about various financial functions and how to use them in efficient manner. Which financial function goes where and how to best use it

Learn about project profitability methods, knowing whether an investment is worth while in future or not

Companies make profit in financial terms but are still running low on cash. Knowing if a company is cash positive or is running low on cash is very important for financial integrity of the organization

There would always be more! we would keep on adding new tools and techniques and you will see you will keep on learning newer things!

The course is created in Excel 2024 (365) but works in Excel 2019, 2016, 2013, 2010, and 2007
