Skip to navigation Skip to main content
Wrong menu selected
ADD ANYTHING HERE OR JUST REMOVE IT…
Wrong menu selected
Bharati law House
Select category
  • Select category
  • Bare Acts
  • E-Products
    • E-TDS
    • Law
    • Tax
  • Entrance Exams
    • AIBE
    • CLAT
    • Judicial Service
    • LLM
    • UGC NET JRF SLET
  • IIBF
    • Banking
    • CAIIB
    • JAIIB
  • Legal
    • Administrative Law
    • Adverse Possession
    • Advocates Act
    • Alternative Dispute Resolution System
    • Animal law
    • Arbitration and Conciliation
    • Arms and Explosives
    • Artificial Intelligence
    • Aviation Law
    • Bail
    • Banking Law
    • Bharatiya Nagarik Suraksha Sanhita
    • Bharatiya Nyaya Sanhita
    • Bharatiya Sakshya Adhiniyam
    • Charitable and Religious Trusts
    • Citations
    • Citizenship
    • Civil Procedure
    • Commercial Courts Act
    • Competition Act
    • Constitution
    • Consumer Protection Act
    • Contempt of Courts
    • Contract
    • Conveyancing
    • Corporate Governance
    • Corporate Law
    • Corruption
    • Court Fees & Suit Valuation
    • Criminal Investigation
    • Criminal law
    • Criminal Minor Acts
    • Criminal Trial
    • Cross Examination
    • Cyber Crime
    • Damages
    • Data Protection
    • Digital Personal Data Protection
    • Dishonour of Cheques
    • Divorce Act
    • Domestic Violence
    • Dowry Prohibition Act
    • Drugs and Cosmetics
    • Easements Act
    • Economics
    • Election Laws
    • Electricity
    • English-I
    • Environmental Law
    • EPF
    • Essential Commodities
    • Explosives Act
    • Family Court's Act
    • Food Safety
    • Foreigners Act
    • Forest Act
    • Gender Justice
    • General Clauses
    • General Law
    • Guardians and Wards
    • Health Law
    • Hindu Law
    • Human Rights
    • Indian Succession Act
    • Information Technology
    • Injunction
    • Insurance
    • International law
    • IPR
    • Jurisprudence
    • Juvenile Justice
    • Labour Laws
    • Land Laws
    • Law & Poverty
    • Law of Carriage
    • Legal Dictionary
    • Legal Method
    • Legal Metrology
    • Legal Referencer
    • Legal Research
    • Legal Services Authorities
    • Limitation
    • Mahomedan Law
    • Marriage and Divorce
    • Media Law
    • Mediation Act
    • Medical Jurisprudence
    • Military Law
    • Mines & Minerals
    • Misc
    • Moot Court
    • Motor Vehicle
    • NDPS
    • Negotiable Instruments Act
    • Notaries
    • Partition Act
    • Partnership
    • Passports Act
    • POCSO
    • Political Science
    • Power of Attorney
    • PRB
    • Private International Law
    • Probation of Offenders
    • Real Estate
    • Registration Act
    • Right to Education
    • Right to Information law
    • Sale of Goods Act
    • SARFAESI
    • SC & ST
    • Securities Law
    • Service Laws
    • Sexual Harassment
    • Society
    • Sociology
    • Specific Relief
    • Sports
    • Stamp Act
    • State Laws
    • Statues
    • Taxation Law
    • Tort
    • Trade Law
    • Transfer of property
    • UGC-NET/JRF (Law)
    • Waqf
    • White Collar Crimes
    • Wills
    • Women Laws
    • Writs
  • Legal Classics
  • NISM
  • Professional Books
    • Accounting
    • Bank Audit
    • Company law
    • Corporate Laws
    • Customs
    • Direct Tax
    • FEMA
    • GAAR
    • GST
    • HUF
    • Income Tax
    • IND AS
    • Insolvency
    • Insurance
    • International Taxation
    • LLP
    • Mergers
    • Minimum Alternative Tax (MAT)
    • Money Laundering
    • MSME
    • NBFC
    • NFRA
    • RERA
    • SEBI
    • Securitisation
    • Tax Audit
    • TDS
    • Telecommunications
    • Transfer Pricing
    • Trusts
    • Valuation
  • Professional Exams
    • CA Final
      • Advanced Auditing and Professional Ethics
      • Advanced Financial Management
      • Corporate and Economic Laws
      • Direct Tax Laws & International Taxation
      • Financial Reporting
      • Indirect Tax Laws
      • Strategic Cost Management and Performance Evaluation
    • CA Foundation
      • Business Economics And Business & Commercial Knowledge
      • Business Laws And Business Correspondence
      • Business Mathematics, Logical Reasoning And Statistics
      • Principles And Practice Of Accounting
    • CA Intermediate
      • Accounts
      • Advanced Accounting
      • Auditing and Assurance
      • Corporate And Other Laws
      • Cost and Management Accounting
      • Enterprise Information Systems & Strategic Management
      • Financial Management & Economics for Finance
      • Taxation
    • CMA Final
      • Corporate & Economic Laws
      • Corporate Financial Reporting
      • Cost & Management Audit
      • Direct Tax Laws and International Taxation
      • Indirect Tax Laws
      • Strategic Cost Management
      • Strategic Financial Management
      • Strategic Performance Management and Business Valuation
    • CMA Foundation
      • Business Economics
      • Business Law
      • Business Mathematics and Statistics
      • Financial and Cost Accounting
    • CMA Inter
      • Business Laws & Ethics
      • Corporate Accounting
      • Cost Accounting
      • Direct Taxation
      • Financial Accounting
      • Indirect Taxation
      • Management Accounting
      • Operations Management & Strategic Management
    • CS Executive
      • Company Law
      • Corporate & Management Accounting
      • CS Executive Entrance
      • Economic, Business and Commercial Laws
      • Financial and Strategic Management
      • Jurisprudence, Interpretation & General Laws
      • Securities Laws & Capital Markets
      • Setting up of Business Entities and Closure
      • Tax Laws
    • CS Foundation
      • Business Economics
      • Business Environment and Entrepreneurship
      • Business Management Ethics and Communication
      • Fundamental of Accounting and Auditing
    • CS Professional
      • Advanced Tax Laws
      • Compliance Management, Audit & Due Diligence
      • Corporate Restructuring, Valuation, and Insolvency
      • Drafting, Appearances and Pleadings
      • Strategic Management & Corporate Finance
  • Under Graduate
    • B.Com
Login / Register
0
0 items ₹0.00
Menu
Bharati law House
0 items
Browse Categories
  • Bare Acts
  • Entrance Exams
    • AIBE
    • CLAT
    • Judicial Service
    • LLM
    • UGC NET JRF SLET
  • IIBF
    • Banking
    • CAIIB
    • JAIIB
  • Civil Laws
    • Arbitration and Conciliation
    • Civil Procedure
    • Contract
    • Family Law
      • Divorce Act
      • Hindu Law
      • Indian Succession Act
      • Mahomedan Law
      • Marriage and Divorce
    • Limitation
    • Specific Relief
    • Tort
      • Motor Vehicle
      • Consumer Protection Act
    • Transfer of property
  • Criminal law
    • Bail
    • Bharatiya Nyaya Sanhita
    • Bharatiya Nagarik Suraksha Sanhita
    • Bharatiya Sakshya Adhiniyam
    • Criminal Investigation
    • Criminal Trial
    • Juvenile Justice
    • NDPS
    • POCSO
    • Sexual Harassment
  • Corporate & Business Law
    • Banking Law
    • Company law
    • Competition Act
    • Intellectual Property Rights (IPR)
    • Insolvency
    • Insurance
    • Labour Laws
    • SEBI
  • Taxation & Fiscal Laws
    • Customs
    • Direct Tax
    • GST
    • Income Tax
    • International Taxation
    • Transfer Pricing
  • Constitutional & Administrative
    • Administrative Law
    • Constitution
    • Environmental Law
    • Human Rights
    • Service Laws
    • Writs
  • CA / CS / CMA / Others
    • CA Foundation
      • Business Economics And Business & Commercial Knowledge
      • Business Laws And Business Correspondence
      • Business Mathematics, Logical Reasoning And Statistics
      • Principles And Practice Of Accounting
    • CA Intermediate
      • Accounts
      • Advanced Accounting
      • Auditing and Assurance
      • Corporate And Other Laws
      • Cost and Management Accounting
      • Enterprise Information Systems & Strategic Management
      • Financial Management & Economics for Finance
      • Taxation
    • CA Final
      • Advanced Auditing and Professional Ethics
      • Advanced Financial Management
      • Corporate and Economic Laws
      • Direct Tax Laws & International Taxation
      • Financial Reporting
      • Indirect Tax Laws
      • Strategic Cost Management and Performance Evaluation
    • CMA Foundation
      • Business Economics
      • Business Law
      • Business Mathematics and Statistics
      • Financial and Cost Accounting
    • CMA Intermediate
      • Business Laws & Ethics
      • Corporate Accounting
      • Cost Accounting
      • Direct Taxation
      • Financial Accounting
      • Indirect Taxation
      • Management Accounting
      • Operations Management & Strategic Management
    • CMA Final
      • Corporate & Economic Laws
      • Corporate Financial Reporting
      • Cost & Management Audit
      • Direct Tax Laws and International Taxation
      • Indirect Tax Laws
      • Strategic Cost Management
      • Strategic Financial Management
      • Strategic Performance Management and Business Valuation
    • CS Foundation
      • Business Economics
      • Business Environment and Entrepreneurship
      • Business Management Ethics and Communication
      • Fundamental of Accounting and Auditing
    • CS Executive
      • Company Law
      • Corporate & Management Accounting
      • Economic, Business and Commercial Laws
      • Financial and Strategic Management
      • Jurisprudence, Interpretation & General Laws
      • Securities Laws & Capital Markets
      • Setting up of Business Entities and Closure
      • Tax Laws
    • CS Professional
      • Advanced Tax Laws
      • Compliance Management, Audit & Due Diligence
      • Corporate Restructuring, Valuation, and Insolvency
      • Drafting, Appearances and Pleadings
      • Strategic Management & Corporate Finance
    • Under Graduate
  • NISM
  • Legal Classics
  • Home
  • Shop
  • E-Products
  • Pages
    • Invitation To Authors
    • Privacy Policy
    • Return Policy
    • Terms & Conditions
Wrong menu selected
Hot
Taxmann's Spreadsheet Skills for Finance Professionals by Pitabas Mohanty - 2nd Edition August 2020
Click to enlarge
Home / Professional Books / Accounting / Taxmann’s Spreadsheet Skills for Finance Professionals by Pitabas Mohanty – 2nd Edition August 2020
TNL's A Compendium of GST Laws in West Bengal by K.K.Mundra - 1st Edition 2020
TNL's A Compendium of GST Laws in West Bengal by K.K.Mundra - 1st Edition 2020 ₹2,200.00
Back to products
Taxmann's Unnat Bank Prabandhan - Hindi by Indian Institute of Banking & Finance (IIBF), Edition August 2020
Taxmann's Unnat Bank Prabandhan - Hindi by Indian Institute of Banking & Finance (IIBF), Edition August 2020 ₹900.00

Taxmann’s Spreadsheet Skills for Finance Professionals by Pitabas Mohanty – 2nd Edition August 2020

₹575.00

Taxmann’s Spreadsheet Skills for Finance Professionals by Pitabas Mohanty – 2nd Edition August 2020.

10 in stock

Compare
SKU: Taxmann's Spreadsheet Skills for Finance Professionals by Pitabas Mohanty - 2nd Edition August 2020 Categories: Professional Books, Accounting Tag: Account
Share:
  • Description
  • Additional information
  • Reviews (0)
  • Shipping & Delivery
Description

Taxmann’s Spreadsheet Skills for Finance Professionals by Pitabas Mohanty – 2nd Edition August 2020.

Taxmann’s Spreadsheet Skills for Finance Professionals by Pitabas Mohanty – 2nd Edition August 2020.

Description

This book is a comprehensive & authentic book on ‘Spreadsheet skills for finance professionals’. The Present Publication is the 2nd Edition with the following noteworthy features:

  • Specific focus on application of MS Excel in corporate finance
  • Enhances the readers skills to build powerful financial models
  • Discusses techniques of good/bad practices to be followed/avoided & VBA macros to build financial models
  • Usage of multiple examples to under the use of functions in excel to build financial models using formulas
  • Discusses newer applications such as the following:

o   Google Sheets

o   Office 365

  • Coverage:

o   Functions used in Financial Models

o   Keyboard Shortcuts in Spreadsheets

o   Writing Correct Formulas in Excel

o   Using Controls in Excel

o   Creating Useful Charts in Finance

o   Understanding Macros

o   Formatting Numbers

o   Sensitivity Analysis in Excel

o   Miscellaneous Topics

  • Newer features such as dynamic array (that applies to many existing features in Excel) & XLOOKUP have also been discussed

Details

  • Paperback : 388 Pages
  • Publisher : Taxmann
  • Author : Pitabas Mohanty
  • Edition : 2nd Edition August 2020
  • Language : English
  • ISBN-10 : 9789390128228
  • ISBN-13 : 9789390128228
Additional information
PublisherTaxmann
LanguageEnglish
AuthorPitabas Mohanty
Reviews (0)

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Shipping & Delivery

Related products

Commercial's Understanding of Provisions of Deemed Income by Ram Dutt Sharma, 1st Edition 2026
-25% Hot
Compare

Commercial’s Understanding of Provisions of Deemed Income by Ram Dutt Sharma

Professional Books, Income Tax, Direct Tax
₹1,395.00 Original price was: ₹1,395.00.₹1,046.00Current price is: ₹1,046.00.

Master the complex legal fictions that turn undisclosed financial transactions into massive tax liabilities. Commercial's Understanding of Provisions of Deemed Income (1st Edition, 2026) is a highly focused reference manual authored by former Income Tax Officer Ram Dutt Sharma.

  • ✔ The Finance Act 2026 Updates: Fully aligned with the Income Tax Act 2025, detailing the latest statutory treatments of income deemed to accrue or arise in India.

  • ✔ Unexplained Wealth: Deep, operational analysis of deemed income arising from unexplained cash, investments, expenditure, and assets (Sections 68, 69, 69A-D).

  • ✔ Insider Strategy: Written by a 35-year veteran of the Income Tax Department, providing unparalleled clarity for defending against scrutiny assessments and reassessments.

Add to cart
Quick view
Volume 1 of Bharat's Commentary on Income Tax by Dr. Ashok Saraf, 1st Edition 2026
-25% Hot
Compare

Commentary on Income Tax (Set of 2 Vols) | Ashok Saraf 2026

Professional Books, Income Tax
₹5,995.00 Original price was: ₹5,995.00.₹4,496.00Current price is: ₹4,496.00.

Navigate the sweeping changes of India's new direct tax regime with Bharat's Commentary on Income Tax (Set of 2 Volumes). Authored by Senior Advocate Dr. Ashok Saraf and CA Dr. Ayush Saraf, this 1st Edition (2026) provides an authoritative, section-by-section analysis of the newly enacted Income-tax Act 2025.

  • ✔ Complete Statutory Transition: Exhaustive commentary on the new Income-tax Act 2025, amended by the Finance Act 2026.

  • ✔ Corporate & Business Focus: Deep-dive analysis into the computation of business profits, depreciation, and capital gains.

  • ✔ Expert Authorship: Blends decades of constitutional litigation experience with modern corporate accounting (Ind AS) expertise.

Add to cart
Quick view
Cover of Foreign Trade Policy and Handbook of Procedures 2023 2 Volumes by S.C. Jain, 2nd Edition 2025
-25% Hot
Compare

Foreign Trade Policy & Handbook of Procedures 2023 | S.C. Jain

Professional Books, Customs
₹3,295.00 Original price was: ₹3,295.00.₹2,471.00Current price is: ₹2,471.00.

Navigate India’s complex foreign trade regime with the updated 2nd Edition (2025) of Foreign Trade Policy and Handbook of Procedures 2023 (2 Volumes). Authored by indirect tax experts S.C. Jain, Shweta Jain, and Abhishek Jain, this comprehensive set is the ultimate reference for trade professionals.

  • ✔ Complete Framework: Full text of FTP 2023, Handbook of Procedures, and the FTDR Act 1992.

  • ✔ Practical Insights: Detailed coverage of incentives, exemptions (Advance Authorisation, EPCG), and export promotion schemes.

  • ✔ Fully Updated: Includes the latest DGFT notifications, circulars, and allied laws impacting foreign trade (Customs, GST, FEMA).

Add to cart
Quick view
Lexis Nexis's Key to Insolvency and Bankruptcy Code - Practice and Procedure by Narender Kumar
-15% Hot
Compare

Lexis Nexis’s Key to Insolvency and Bankruptcy Code – Practice and Procedure by Narender Kumar

Professional Books, Insolvency
₹895.00 Original price was: ₹895.00.₹761.00Current price is: ₹761.00.

Lexis Nexis's Key to Insolvency and Bankruptcy Code - Practice and Procedure by Narender Kumar - 2nd Edition 2024.

Add to cart
Quick view
Commercial's Handling of Income Tax Problems by Ram Dutt Sharma
-20% Hot
Compare

Commercial’s Handling of Income Tax Problems by Ram Dutt Sharma

Professional Books, Income Tax, Direct Tax
₹995.00 Original price was: ₹995.00.₹796.00Current price is: ₹796.00.

Commercial's Handling of Income Tax Problems by Ram Dutt Sharma - 1st Edition 2025.

Add to cart
Quick view
Taxmann's Income Tax Act - As Amended by Finance Act 2025
-25% Hot
Compare

Taxmann’s Income Tax Act – As Amended by Finance Act 2025

Professional Books, Income Tax
₹2,895.00 Original price was: ₹2,895.00.₹2,171.00Current price is: ₹2,171.00.

Taxmann's Income Tax Act - As Amended by Finance Act 2025 - 70th Edition 2025. This book seamlessly integrates all amendments from the Finance Act 2025 into a single authoritative text. It offers extensive annotations, cross-references, and legislative history, catering to practitioners, academics, and libraries. Separate divisions also cover the Finance Act 2025, STT, CTT, and the now-ended Equalisation Levy, ensuring a holistic overview of direct tax laws. A user-friendly layout—with marginal notes, footnotes, and a comprehensive subject index—enables efficient navigation. Backed by meticulous editorial accuracy, this volume remains a definitive guide to direct tax legislation.

Add to cart
Quick view
Bharat's FEMA & FCRA by Kamal Garg - 3rd Edition 2024
-25% Hot
Compare

Bharat’s FEMA & FCRA by Kamal Garg – 3rd Edition 2024

Professional Books, FEMA
₹2,695.00 Original price was: ₹2,695.00.₹2,021.00Current price is: ₹2,021.00.

Bharat's FEMA & FCRA by Kamal Garg - 3rd Edition 2024.

Add to cart
Quick view
Bharat's Law & Practice relating to SFIO and Inspection, Investigation & Fraud by D.P. Mittal - 1st Edition February 2020
Hot
Compare

Bharat’s Law & Practice relating to SFIO and Inspection, Investigation & Fraud by D.P. Mittal – 1st Edition February 2020

Professional Books, Corporate Laws
₹595.00

Bharat's Law & Practice relating to SFIO and Inspection, Investigation & Fraud by D.P. Mittal - 1st Edition February 2020.

Add to cart
Quick view
    © 2026 Bharati Law House
    payments
    • Menu
    • Categories
    • Bare Acts
    • Entrance Exams
      • AIBE
      • CLAT
      • Judicial Service
      • LLM
      • UGC NET JRF SLET
    • IIBF
      • Banking
      • CAIIB
      • JAIIB
    • Civil Laws
      • Arbitration and Conciliation
      • Civil Procedure
      • Contract
      • Family Law
        • Divorce Act
        • Hindu Law
        • Indian Succession Act
        • Mahomedan Law
        • Marriage and Divorce
      • Limitation
      • Specific Relief
      • Tort
        • Motor Vehicle
        • Consumer Protection Act
      • Transfer of property
    • Criminal law
      • Bail
      • Bharatiya Nyaya Sanhita
      • Bharatiya Nagarik Suraksha Sanhita
      • Bharatiya Sakshya Adhiniyam
      • Criminal Investigation
      • Criminal Trial
      • Juvenile Justice
      • NDPS
      • POCSO
      • Sexual Harassment
    • Corporate & Business Law
      • Banking Law
      • Company law
      • Competition Act
      • Intellectual Property Rights (IPR)
      • Insolvency
      • Insurance
      • Labour Laws
      • SEBI
    • Taxation & Fiscal Laws
      • Customs
      • Direct Tax
      • GST
      • Income Tax
      • International Taxation
      • Transfer Pricing
    • Constitutional & Administrative
      • Administrative Law
      • Constitution
      • Environmental Law
      • Human Rights
      • Service Laws
      • Writs
    • CA / CS / CMA / Others
      • CA Foundation
        • Business Economics And Business & Commercial Knowledge
        • Business Laws And Business Correspondence
        • Business Mathematics, Logical Reasoning And Statistics
        • Principles And Practice Of Accounting
      • CA Intermediate
        • Accounts
        • Advanced Accounting
        • Auditing and Assurance
        • Corporate And Other Laws
        • Cost and Management Accounting
        • Enterprise Information Systems & Strategic Management
        • Financial Management & Economics for Finance
        • Taxation
      • CA Final
        • Advanced Auditing and Professional Ethics
        • Advanced Financial Management
        • Corporate and Economic Laws
        • Direct Tax Laws & International Taxation
        • Financial Reporting
        • Indirect Tax Laws
        • Strategic Cost Management and Performance Evaluation
      • CMA Foundation
        • Business Economics
        • Business Law
        • Business Mathematics and Statistics
        • Financial and Cost Accounting
      • CMA Intermediate
        • Business Laws & Ethics
        • Corporate Accounting
        • Cost Accounting
        • Direct Taxation
        • Financial Accounting
        • Indirect Taxation
        • Management Accounting
        • Operations Management & Strategic Management
      • CMA Final
        • Corporate & Economic Laws
        • Corporate Financial Reporting
        • Cost & Management Audit
        • Direct Tax Laws and International Taxation
        • Indirect Tax Laws
        • Strategic Cost Management
        • Strategic Financial Management
        • Strategic Performance Management and Business Valuation
      • CS Foundation
        • Business Economics
        • Business Environment and Entrepreneurship
        • Business Management Ethics and Communication
        • Fundamental of Accounting and Auditing
      • CS Executive
        • Company Law
        • Corporate & Management Accounting
        • Economic, Business and Commercial Laws
        • Financial and Strategic Management
        • Jurisprudence, Interpretation & General Laws
        • Securities Laws & Capital Markets
        • Setting up of Business Entities and Closure
        • Tax Laws
      • CS Professional
        • Advanced Tax Laws
        • Compliance Management, Audit & Due Diligence
        • Corporate Restructuring, Valuation, and Insolvency
        • Drafting, Appearances and Pleadings
        • Strategic Management & Corporate Finance
      • Under Graduate
    • NISM
    • Legal Classics
    • Home
    • Shop
    • E-Products
    • Pages
      • Invitation To Authors
      • Privacy Policy
      • Return Policy
      • Terms & Conditions
    Shopping cart
    Close
    Sign in
    Close

    Lost your password?

    Shop
    0 items Cart
    My account