Most popular
Free
Build Automated Sales Dashboard with Excel
What you'll learn
Understand the importance of sales dashboards in decision-making and performance monitoring.
Learn how to import, clean, and organize sales data for analysis in Excel.
Gain proficiency in using advanced Excel functions and formulas for data manipulation and calculation.
Develop the skills to design visually appealing and informative charts, graphs, and pivot tables to present sales data effectively.
Be able to create dynamic dashboards that automatically update with new sales data and enable user interaction.
Identify and incorporate relevant KPIs to track sales performance and measure success.
Learn techniques for trend analysis and forecasting using Excel's analytical tools.
Acquire the knowledge to automate data updates, refresh dashboards, and generate reports.
Understand how to deploy and share sales dashboards with stakeholders using Excel's sharing and collaboration features.
Featured
Accounting for Accounting Professionals & Freelance Bookkeepers
What you'll learn
Accounting Golden rules
Double entry bookkeeping system (Debit and Credit)
Ledgers or Chart of Accounts
Bill, Invoice, Accounts Payable and Accounts Receivable
Financial reports (P/L accounts and Balance sheet)
Assets, Depreciation and LiabilityÂ
Common accounting terminologies
Business position analysis by using Ratio AnalysisÂ
Daily cash register and bank register
Accounting, Inventory and Payroll vouchers
Simple overhead calculation
Simple selling price calculation
Cost of sale/Cost of goods sold
Inventory valuation methodsÂ
Trial balance, cash flow statement, receive & paymentsÂ
Cost center and cost units
Graphical presentation of accounting data/reports
-25%
Tally Prime Advance Inventory Management
What you'll learn
Item Creation and modification.
# Understanding Product Line
# Create, Alter a Stock group, Stock Unit (Unit of Measure)
# Create, Alter a Godown
# Create, Alter a Stock item
# Create, Alter a Stock categories
# Creating Alternative Unit of measure
# Maintaining Batch number, MFG and expire Date
# Maintaining Inventory Valuation Method
Sales, Purchase Transaction Projection
# Inventory Vouchers posting
# Purchase & sales Invoice posting with practical example
# Voucher for Consumption of Materials and Inter Godown Transfer.
# Accounting & Inventory Integration
# Sales as per Multiple Price Level/Price list
# Vouchers postings for Accounts and Inventory departments
# Delivery Note voucher
# Delivery Note voucher integration with Sales voucher
# Receipt Note voucher
# Receipt Note voucher integration with Purchase voucher
Sales Return, Purchase Return Transaction Projection
# Vouchers postings for Accounts and Inventory Departments
# Purchase & sales Return posting with practical example
# Voucher for Consumption of Materials and Inter Godown Transfer.
# Accounting & Inventory Integration
# Rejection In voucher
# Rejection In voucher integration with Credit Note voucher
# Rejection Out voucher
# Rejection Out voucher integration with Debit Note voucher
Sales and Purchase Order Management:
# Sales order management
# Purchase order management
# Creating Sales Voucher form Sales order
# Creating Purchase Voucher from Purchase order
# Managing difference between Order Quantity, Purchase Quantity and Actual Received Quantity.
Manufacturing Voucher:
# Creating Manufacturing Voucher
# Creating Bill of Materials (Recipe) for Finished Goods
# Transferring Raw materials to Manufacturing Godown
# Maintaining Work in Progress
# Creating Manufacturing Vouchers for different level of Production.
# Calculation of Scrap/ By product
# Adding Manufacturing Overhead to Production cost
Other Inventory Vouchers:
# Physical Stock count/ Inventory adjustment.
# Inventory Transfer - Stock Journal
# Inventory adjustment - Stock Journal
# Inventory consumption - Stock Journal
Project wise Profit and Loss Statement:
# Creating Project
# Creating Godown for Project
# Customizing cost center/ Voucher for Project report
# Voucher posting for Project P/L accounts.
# Inventory Management for Project
# Cost of Goods sold for Project
How to Get/Print/Analyze reports:
# Stock Summary
# Stock Quarry
# Stock Item Analysis
# Stock categories, stock group & stock transfer Analysis
# Outstanding Order report.
# Pending Bills Report
# Pending Material Balance report.
# Project reports.
# Customer wise Sales and Stock Movement report
Corporate Tax Calculation
What you'll learn
Corporate Tax Rate at a glance
Minimum Tax on business income
Income considered as business income
General allowable deduction in case of business income
Special allowable deduction in case of business income
The deduction is not allowable in certain cases
Tax planning in case of corporate tax return
Documents required to submit a corporate tax return
Corporate Tax Return Preparation
Featured
Finance for Non-Finance Managers
What you'll learn
By the end of this course, participants will:
Gain a comprehensive understanding of fundamental financial concepts and terminology.
Be able to interpret financial statements and assess the financial health of their organization.
Acquire skills to prepare budgets, forecast financial outcomes, and manage financial resources effectively.
Develop the ability to evaluate investment opportunities and make informed capital budgeting decisions.
Enhance their capacity to identify, assess, and manage financial risks.
Learn to integrate financial considerations into strategic decision-making processes.
Utilize key financial metrics to monitor performance and drive improvements.
Demonstrate awareness of ethical and legal considerations in financial management.
Trending
Featured
Accounting for Accounting Professionals & Freelance Bookkeepers
What you'll learn
Accounting Golden rules
Double entry bookkeeping system (Debit and Credit)
Ledgers or Chart of Accounts
Bill, Invoice, Accounts Payable and Accounts Receivable
Financial reports (P/L accounts and Balance sheet)
Assets, Depreciation and LiabilityÂ
Common accounting terminologies
Business position analysis by using Ratio AnalysisÂ
Daily cash register and bank register
Accounting, Inventory and Payroll vouchers
Simple overhead calculation
Simple selling price calculation
Cost of sale/Cost of goods sold
Inventory valuation methodsÂ
Trial balance, cash flow statement, receive & paymentsÂ
Cost center and cost units
Graphical presentation of accounting data/reports
-25%
Tally Prime Advance Inventory Management
What you'll learn
Item Creation and modification.
# Understanding Product Line
# Create, Alter a Stock group, Stock Unit (Unit of Measure)
# Create, Alter a Godown
# Create, Alter a Stock item
# Create, Alter a Stock categories
# Creating Alternative Unit of measure
# Maintaining Batch number, MFG and expire Date
# Maintaining Inventory Valuation Method
Sales, Purchase Transaction Projection
# Inventory Vouchers posting
# Purchase & sales Invoice posting with practical example
# Voucher for Consumption of Materials and Inter Godown Transfer.
# Accounting & Inventory Integration
# Sales as per Multiple Price Level/Price list
# Vouchers postings for Accounts and Inventory departments
# Delivery Note voucher
# Delivery Note voucher integration with Sales voucher
# Receipt Note voucher
# Receipt Note voucher integration with Purchase voucher
Sales Return, Purchase Return Transaction Projection
# Vouchers postings for Accounts and Inventory Departments
# Purchase & sales Return posting with practical example
# Voucher for Consumption of Materials and Inter Godown Transfer.
# Accounting & Inventory Integration
# Rejection In voucher
# Rejection In voucher integration with Credit Note voucher
# Rejection Out voucher
# Rejection Out voucher integration with Debit Note voucher
Sales and Purchase Order Management:
# Sales order management
# Purchase order management
# Creating Sales Voucher form Sales order
# Creating Purchase Voucher from Purchase order
# Managing difference between Order Quantity, Purchase Quantity and Actual Received Quantity.
Manufacturing Voucher:
# Creating Manufacturing Voucher
# Creating Bill of Materials (Recipe) for Finished Goods
# Transferring Raw materials to Manufacturing Godown
# Maintaining Work in Progress
# Creating Manufacturing Vouchers for different level of Production.
# Calculation of Scrap/ By product
# Adding Manufacturing Overhead to Production cost
Other Inventory Vouchers:
# Physical Stock count/ Inventory adjustment.
# Inventory Transfer - Stock Journal
# Inventory adjustment - Stock Journal
# Inventory consumption - Stock Journal
Project wise Profit and Loss Statement:
# Creating Project
# Creating Godown for Project
# Customizing cost center/ Voucher for Project report
# Voucher posting for Project P/L accounts.
# Inventory Management for Project
# Cost of Goods sold for Project
How to Get/Print/Analyze reports:
# Stock Summary
# Stock Quarry
# Stock Item Analysis
# Stock categories, stock group & stock transfer Analysis
# Outstanding Order report.
# Pending Bills Report
# Pending Material Balance report.
# Project reports.
# Customer wise Sales and Stock Movement report
Free
Build Automated Sales Dashboard with Excel
What you'll learn
Understand the importance of sales dashboards in decision-making and performance monitoring.
Learn how to import, clean, and organize sales data for analysis in Excel.
Gain proficiency in using advanced Excel functions and formulas for data manipulation and calculation.
Develop the skills to design visually appealing and informative charts, graphs, and pivot tables to present sales data effectively.
Be able to create dynamic dashboards that automatically update with new sales data and enable user interaction.
Identify and incorporate relevant KPIs to track sales performance and measure success.
Learn techniques for trend analysis and forecasting using Excel's analytical tools.
Acquire the knowledge to automate data updates, refresh dashboards, and generate reports.
Understand how to deploy and share sales dashboards with stakeholders using Excel's sharing and collaboration features.
Featured
Finance for Non-Finance Managers
What you'll learn
By the end of this course, participants will:
Gain a comprehensive understanding of fundamental financial concepts and terminology.
Be able to interpret financial statements and assess the financial health of their organization.
Acquire skills to prepare budgets, forecast financial outcomes, and manage financial resources effectively.
Develop the ability to evaluate investment opportunities and make informed capital budgeting decisions.
Enhance their capacity to identify, assess, and manage financial risks.
Learn to integrate financial considerations into strategic decision-making processes.
Utilize key financial metrics to monitor performance and drive improvements.
Demonstrate awareness of ethical and legal considerations in financial management.
Corporate Tax Calculation
What you'll learn
Corporate Tax Rate at a glance
Minimum Tax on business income
Income considered as business income
General allowable deduction in case of business income
Special allowable deduction in case of business income
The deduction is not allowable in certain cases
Tax planning in case of corporate tax return
Documents required to submit a corporate tax return
Corporate Tax Return Preparation
Featured Courses
Featured
Accounting for Accounting Professionals & Freelance Bookkeepers
Course Description “Accounting for Accounting Professionals & Freelance Bookkeepers” Objectives …
Accounting for Accounting Professionals & Freelance Bookkeepers
What you'll learn
Accounting Golden rules
Double entry bookkeeping system (Debit and Credit)
Ledgers or Chart of Accounts
Bill, Invoice, Accounts Payable and Accounts Receivable
Financial reports (P/L accounts and Balance sheet)
Assets, Depreciation and LiabilityÂ
Common accounting terminologies
Business position analysis by using Ratio AnalysisÂ
Daily cash register and bank register
Accounting, Inventory and Payroll vouchers
Simple overhead calculation
Simple selling price calculation
Cost of sale/Cost of goods sold
Inventory valuation methodsÂ
Trial balance, cash flow statement, receive & paymentsÂ
Cost center and cost units
Graphical presentation of accounting data/reports
Featured
Finance for Non-Finance Managers
Finance is a language spoken by every successful organization, and …
Finance for Non-Finance Managers
What you'll learn
By the end of this course, participants will:
Gain a comprehensive understanding of fundamental financial concepts and terminology.
Be able to interpret financial statements and assess the financial health of their organization.
Acquire skills to prepare budgets, forecast financial outcomes, and manage financial resources effectively.
Develop the ability to evaluate investment opportunities and make informed capital budgeting decisions.
Enhance their capacity to identify, assess, and manage financial risks.
Learn to integrate financial considerations into strategic decision-making processes.
Utilize key financial metrics to monitor performance and drive improvements.
Demonstrate awareness of ethical and legal considerations in financial management.
Popular Topics
Popular Instructors
All Accounts and Audit Courses
Featured
Accounting for Accounting Professionals & Freelance Bookkeepers
Course Description “Accounting for Accounting Professionals & Freelance Bookkeepers” Objectives …
What you'll learn
Accounting Golden rules
Double entry bookkeeping system (Debit and Credit)
Ledgers or Chart of Accounts
Bill, Invoice, Accounts Payable and Accounts Receivable
Financial reports (P/L accounts and Balance sheet)
Assets, Depreciation and LiabilityÂ
Common accounting terminologies
Business position analysis by using Ratio AnalysisÂ
Daily cash register and bank register
Accounting, Inventory and Payroll vouchers
Simple overhead calculation
Simple selling price calculation
Cost of sale/Cost of goods sold
Inventory valuation methodsÂ
Trial balance, cash flow statement, receive & paymentsÂ
Cost center and cost units
Graphical presentation of accounting data/reports
-25%
Tally Prime Advance Inventory Management
Tally Prime Advance Inventory Management Inventory Module (Three Classes; 6 …
What you'll learn
Item Creation and modification.
# Understanding Product Line
# Create, Alter a Stock group, Stock Unit (Unit of Measure)
# Create, Alter a Godown
# Create, Alter a Stock item
# Create, Alter a Stock categories
# Creating Alternative Unit of measure
# Maintaining Batch number, MFG and expire Date
# Maintaining Inventory Valuation Method
Sales, Purchase Transaction Projection
# Inventory Vouchers posting
# Purchase & sales Invoice posting with practical example
# Voucher for Consumption of Materials and Inter Godown Transfer.
# Accounting & Inventory Integration
# Sales as per Multiple Price Level/Price list
# Vouchers postings for Accounts and Inventory departments
# Delivery Note voucher
# Delivery Note voucher integration with Sales voucher
# Receipt Note voucher
# Receipt Note voucher integration with Purchase voucher
Sales Return, Purchase Return Transaction Projection
# Vouchers postings for Accounts and Inventory Departments
# Purchase & sales Return posting with practical example
# Voucher for Consumption of Materials and Inter Godown Transfer.
# Accounting & Inventory Integration
# Rejection In voucher
# Rejection In voucher integration with Credit Note voucher
# Rejection Out voucher
# Rejection Out voucher integration with Debit Note voucher
Sales and Purchase Order Management:
# Sales order management
# Purchase order management
# Creating Sales Voucher form Sales order
# Creating Purchase Voucher from Purchase order
# Managing difference between Order Quantity, Purchase Quantity and Actual Received Quantity.
Manufacturing Voucher:
# Creating Manufacturing Voucher
# Creating Bill of Materials (Recipe) for Finished Goods
# Transferring Raw materials to Manufacturing Godown
# Maintaining Work in Progress
# Creating Manufacturing Vouchers for different level of Production.
# Calculation of Scrap/ By product
# Adding Manufacturing Overhead to Production cost
Other Inventory Vouchers:
# Physical Stock count/ Inventory adjustment.
# Inventory Transfer - Stock Journal
# Inventory adjustment - Stock Journal
# Inventory consumption - Stock Journal
Project wise Profit and Loss Statement:
# Creating Project
# Creating Godown for Project
# Customizing cost center/ Voucher for Project report
# Voucher posting for Project P/L accounts.
# Inventory Management for Project
# Cost of Goods sold for Project
How to Get/Print/Analyze reports:
# Stock Summary
# Stock Quarry
# Stock Item Analysis
# Stock categories, stock group & stock transfer Analysis
# Outstanding Order report.
# Pending Bills Report
# Pending Material Balance report.
# Project reports.
# Customer wise Sales and Stock Movement report
Featured
Finance for Non-Finance Managers
Finance is a language spoken by every successful organization, and …
What you'll learn
By the end of this course, participants will:
Gain a comprehensive understanding of fundamental financial concepts and terminology.
Be able to interpret financial statements and assess the financial health of their organization.
Acquire skills to prepare budgets, forecast financial outcomes, and manage financial resources effectively.
Develop the ability to evaluate investment opportunities and make informed capital budgeting decisions.
Enhance their capacity to identify, assess, and manage financial risks.
Learn to integrate financial considerations into strategic decision-making processes.
Utilize key financial metrics to monitor performance and drive improvements.
Demonstrate awareness of ethical and legal considerations in financial management.
Corporate Tax Calculation
Corporate Tax Rate at a glance Minimum Tax on business …
What you'll learn
Corporate Tax Rate at a glance
Minimum Tax on business income
Income considered as business income
General allowable deduction in case of business income
Special allowable deduction in case of business income
The deduction is not allowable in certain cases
Tax planning in case of corporate tax return
Documents required to submit a corporate tax return
Corporate Tax Return Preparation
Free
Build Automated Sales Dashboard with Excel
In today’s data-driven business environment, the ability to effectively analyze …
What you'll learn
Understand the importance of sales dashboards in decision-making and performance monitoring.
Learn how to import, clean, and organize sales data for analysis in Excel.
Gain proficiency in using advanced Excel functions and formulas for data manipulation and calculation.
Develop the skills to design visually appealing and informative charts, graphs, and pivot tables to present sales data effectively.
Be able to create dynamic dashboards that automatically update with new sales data and enable user interaction.
Identify and incorporate relevant KPIs to track sales performance and measure success.
Learn techniques for trend analysis and forecasting using Excel's analytical tools.
Acquire the knowledge to automate data updates, refresh dashboards, and generate reports.
Understand how to deploy and share sales dashboards with stakeholders using Excel's sharing and collaboration features.
