37 Sections
168 Lessons
16 Weeks
Expand all sections
Collapse all sections
Course 1 : Preparing Business-Ready Data using Excel
0
Key Business Questions
3
2.1
How do I clean and unify inconsistent data from multiple sources?
2.2
How do I automate reports and dashboards for recurring business needs?
2.3
Can I use Excel to model business scenarios and make data-backed decisions?
Advanced Excel for Data Structuring
Master core Excel functions used in business analysis:
3
3.1
Logical functions: IF, IFS, AND, OR
3.2
Lookup functions: VLOOKUP, INDEX, MATCH, XLOOKUP
3.3
Text & Date handling: TEXTJOIN, LEFT/RIGHT, DATEDIF
Summarizing & Visualizing Business Metrics
3
4.1
Create dynamic summaries using PivotTables & Pivot Charts
4.2
Apply business logic through Conditional Formatting and Data Validation
4.3
Build an interactive performance dashboard
Modelling Scenarios & Workflow Automation
3
5.1
Use What-If Analysis (Goal Seek, Data Tables, Scenario Manager) for forecasting
5.2
Optimize resource allocation using Solver Add-in
5.3
Automate data workflows using Power Query in Excel
Projects
6
6.1
Data Cleaning & Preparation in Excel
6.2
Sales Analysis Dashboard
6.3
Advanced Data Filtering
6.4
Bank Marketing Campaign Report
6.5
Human Resource Dashboard
6.6
Project Management Analysis
Course 2 : Building Accurate Financial Records using Tally Prime
0
Key Business Questions
3
8.1
How do I record and manage daily transactions accurately in Tally?
8.2
How do I generate real-time Profit & Loss and Balance Sheet reports?
8.3
How do I reconcile bank statements and detect accounting errors?
Basic & Service Accounting
8
9.1
Fundamental of Accounts Rules of Accounts
9.2
Creating/Altering/Deleting Company in Tally Prime
9.3
Group & Ledger Creation in Tally Prime
9.4
Journal Entries in in Tally Prime
9.5
Day Book & Cash/Bank Book
9.6
Trading & P&L Account
9.7
Trial Balance, Balance Sheet & Reports.
9.8
Managing Accounts of Sole Proprietorship & Consultancy Firm
Trading Accounting & Reports
7
10.1
GST in Tally Accounting.
10.2
Inventory Management.
10.3
Purchase & sale Vouchers.
10.4
Creating Stock Group Stock Items, & units.
10.5
Maintaining Stock & Depreciation.
10.6
Inventory Reports.
10.7
Managing Account of Partnership Firm
GST Basics
12
11.1
CGST, SGST, IGST & UTGST.
11.2
Link between the three taxes.
11.3
Composition scheme. HSN code.
11.4
What is input tax credit (ITC).
11.5
Electronic ledgers.
11.6
How to avail the ITC.
11.7
Different types of GST invoices.
11.8
Payment of taxes and taking refunds
11.9
E-way bill.
11.10
Generation of e-way bill.
11.11
Provisions of reverse charge.
11.12
Cases where reverse charge is applicable.
Industrial & Factory Accounting
11
12.1
Purchase & Sales order.
12.2
Managing Account of Different
12.3
Cost Centers & Cost Categories
12.4
Creating Custom Vouchers.
12.5
Godown & Currency Creation.
12.6
Bills of Material (BOM).
12.7
Inter-Godwin Transfer.
12.8
Creating & Maintain Price-List.
12.9
Interest Calculation.
12.10
Maintaining Payroll.
12.11
Security Control.
Advanced Features
17
13.1
Budgeting systems & scenarios.
13.2
Variance Analysis.
13.3
Costing Systems & Cost Classification.
13.4
Ratio Analysis.
13.5
Cash Flow & Fund Flow Statement.
13.6
Ordering Levels of Stock.
13.7
Analyzing and Managing Inventory.
13.8
System Administration and Other Utilities.
13.9
Management Control Systems.
13.10
Multi Rate Tax Invoices in Tally Prime
13.11
Input Service Distributor (ISD)
13.12
Economic Zone (SEZ)
13.13
Job Work entries
13.14
Purchase & Sales under Special
13.15
Composition Scheme Dealer
13.16
Point of Sales
13.17
Payroll Voucher Entry
Industrial Projects
0
Consultancy Firm Project
4
15.1
Recording Transactions for 12 months
15.2
Working with adjustment and Provisional entries
15.3
preparing the Financial Statements
15.4
Rectifying the trail balance for the year.
Advocacy Firm Project
4
16.1
Setting Up the Company and their Clients
16.2
Passing the necessary Journal Entries
16.3
Rectifying the Statements & solving the errors
16.4
Preparing the reports
Computer Trading Project
6
17.1
Setting up the Company
17.2
Setting up the inventories
17.3
Making the price lists for different Consumers
17.4
Working with Discounts & Free Sales Offer
17.5
Billing With GST
17.6
Finalizing the reports
Hardware Parts Trading Project
4
18.1
Setting up the Company & Clients
18.2
Setting up the Inventories
18.3
Preparing GST Returns in tally
18.4
Finalizing the reports
Manufacturing Company Project 1
5
19.1
Managing with Cost Centers & employees
19.2
Working with Purchase & Sale orders, Receipt & delivery Notes for the company.
19.3
Setting up Godowns
19.4
Passing up Manufacturing Entries
19.5
Preparing the Financial Reports
Manufacturing Company Project 2
4
20.1
Working with Job Work in & out entries.
20.2
Working with Payroll
20.3
Working with Point of sales
20.4
working with SEZ entries.
Course 3 : Automating Smart Business Accounting using Zoho Books
0
Key Business Questions
3
22.1
How do I manage online invoicing and automate payment reminders?
22.2
How do I track expenses and monitor business cash flow in real time?
22.3
How do I reconcile bank feeds automatically in Zoho Books?
Introduction to Zoho Books
3
23.1
What is Zoho Books & its uses in business
23.2
Features and benefits of Zoho Books
23.3
Cloud Accounting overview
Company Setup & Configuration
5
24.1
Adding business/company details
24.2
Creating Zoho Books account
24.3
Setting up GST details (India-based)
24.4
Chart of Accounts overview
24.5
Financial year & accounting preferences setup
Master Creation (Core Setup)
5
25.1
Creating Customers & Vendors
25.2
Products & Services setup
25.3
Unit of measurement & pricing
25.4
Tax setup (GST slabs)
25.5
Bank and cash account setup
Sales Module (Receivables)
6
26.1
Creating Estimates / Quotations
26.2
Sales Orders
26.3
Invoices creation & customization
26.4
Credit Notes
26.5
Customer payments and receipt entry
26.6
Recurring invoices
Purchase Module (Payables)
6
27.1
Vendor Bills entry
27.2
Purchase Orders
27.3
Expenses entry
27.4
Vendor payments
27.5
Debit Notes
27.6
Recurring bills
Banking & Reconciliation
4
28.1
Bank account linking (overview)
28.2
Manual bank entry & import statement
28.3
Bank reconciliation process
28.4
Bank rules and automation
GST & Taxation in Zoho Books
4
29.1
GST setup and tax configuration
29.2
GST applied on sales and purchase
29.3
GST reports
29.4
HSN/SAC codes usage
Inventory & Stock Management
4
30.1
Stock tracking features
30.2
Inventory valuation method
30.3
Stock adjustments
30.4
Low stock alerts
Reports & Financial Statements
7
31.1
Profit & Loss statement
31.2
Balance Sheet
31.3
Cash Flow Statement
31.4
Trial Balance
31.5
Receivables & Payables reports
31.6
Sales and Purchase reports
31.7
GST and tax summary reports
Course 4 : Business Intelligence using Power BI
0
Key Business Questions
3
33.1
How can I create a real-time dashboard that tracks sales performance?
33.2
How do I build a scalable reporting system for business leaders?
33.3
How do I apply business rules to create dynamic KPIs?
Introduction to Power BI & Power Query
3
34.1
Power BI Ecosystem (Desktop, Service, Mobile)
34.2
Connect to Excel, CSV, and SQL Server data
34.3
Clean, merge, and structure data using Power Query Editor
Visualization & Report Design
3
35.1
Choosing the right visuals for your data
35.2
Formatting, themes, and report layout
35.3
Interactivity: Slicers, filters, bookmarks, and drill-through.
Working with DAX Functions
3
36.1
Calculated Columns vs. Measures
36.2
DAX Functions: SUM, AVERAGE, COUNT, DISTINCTCOUNT
36.3
Date, Time & Text based DAX Functions
Projects
6
37.1
Telecom Industry Churn Analysis
37.2
OLA Cabs Analysis Report
37.3
BLINKIT Analysis Report
37.4
Bike Buyer Report in Power BI
37.5
Company Cost Calculation
37.6
Employee HR Dashboard
Professional Business Finance & Accounting
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Your Website
Modal title
Main Content
Your Website
