Programming in Microsoft Excel

Jan 092016

Microsoft Excel provides programing features. Programming in Excel can be created and executed from two different scenarios- either separately or in combination with both of them. They  are:

1. Excel Macros

2. VBA for Excel

A 'macro' in general, in the terminology of Computing Science may be defined as a series of keystrokes or instructions stored to a particular name (key). Such key strokes or instructions can be played back by invoking the name (key) to which the macro has been stored.In the context of Microsoft Excel, it refers to the keystrokes and instructions as are applicable to the MS Excel application.

The term "VBA for Excel" is also known as "Visual Basic for Applications"  for MS Excel. Programming feature provided by VBA for Excel enhances utility of the Excel and can help you to develop excellent Application that involves computations and calculations and presentations which do not warrant MS Access or any other dedicated data base utility. Besides, it also reduces dependence on hard core computer programmers or software specialists by a Finance or Accounting or any other process based professional.

In this presentation, we will be explaining fundamentals and concepts relating to macros and VBA for Excel and also will be taking you through the nuances of developing excel based programmes.

 

Recording of Excel Macros

undefined

 As in the above screen, choose 'developer' menu and then select the 'record macro' option available at the top left; First item in third column from the left, below the menu bar. Now "Record Macro" box appears. In the macro name rectangle, you give the macro a name. Let us give the name "macnamenadd" in which we are going to save key strokes relating to your name and address. In the next small box, you write an alphabet, (it is optional) with which you are going to associate the macro. Let us type 'a' in the box. The next drop down box contains three entries, namely 'This Workbook', 'Personal Workbook' and 'New Workbook'. First option lets you access the macro only in the workbook where you create it; second one enables you to access the macro in every workbook you work with in your computer. New Workbook option enables you to save the macro in a new workbook. In the description box, we can enter, detail about this macro. Now, the above excel sheet appears as below.

 undefined

Now, when you click 'ok', the macro is ready to record your operations. Every key you enter is recorded. You can see 'Stop Recording' button at the top and the bottom, meaning that your operations are about to be recorded in the macro. Before you choose to enter the details of your name and address, just click on 'Use Relative References' option at the top, below 'Stop Recording' option. You type your name and address details in the excel sheet and click on 'stop recording' menu item. Now a macro by name 'macnamenadd' has been recorded.

Playing the macro 'macnamenadd'

Now, you can run the macro in two ways. Go to macros section under 'developer' menu and choose 'macros'. You can see your macro's name appearing in the macro box that comes. Now you click on the macro name  and 'run', your name and adderss will appear where ever you cell pointer is. If you are in 'A5', it appears there. Choose any other place, and run the macro, the details appear there. You can alternatively run the macro by pressing 'ctrl + b'. 

Changing Scenario of Financial Reporting by Companies

Dec 012015

The matter and the manner in which the companies across the globe are going to report in their Annual Reports or perhaps more frequently is expected to see a sea change in the context of Integrated Reporting and Sustainability Accounting Standards gaining wider mandate, significance and recognition.

Today, the Sustainability Accounting Standards Board (SASB) has issued an implementation guidance that will help US Companies in integrating SASB Standards into their existing 10-K or 20-F disclosure processes. 

The SASB Implementation Guide for Companies helps issuers achieve three objectives:

  • Identify the industry-specific sustainability topics most likely to be material to an investor

 

  • Understand the current state of disclosure and performance on those topics

 

  • Enhance existing reporting processes to more effectively disclose material information on sustainability topics

SASB Standards provide companies with standardized sustainability metrics designed to communicate performance on sustainability topics. When making disclosure on sustainability topics, companies can use SASB Standards to help ensure that disclosure is standardized, decision-useful, relevant, comparable, and complete.


SASB Standards are intended to provide the basis for “suitable criteria,” defined by AT 101.23 -. 321 as having the following attributes:

  1. Objectivity—Criteria should be free from bias.
  2. Measurability—Criteria should permit reasonably consistent measurements, qualitative or quantitative, of subject matter.
  3. Completeness—Criteria should be sufficiently complete so that those relevant factors that would alter a conclusion about subject matter are not omitted.
  4. Relevance—Criteria should be relevant to the subject matter.

Contemporary Financial Accounting and Reporting for Management- by Nalayiram Subramanian, M.Com., FCA, CISA (USA), Chartered Accountant

Apr 192014

Click here for more details

The book provides a holistic approach towards the subject, covering Conceptual, Managerial, Regulatory, Analytical, and Information Technological aspects of Financial Accounting and Reporting for Management from a practical perspective. It includes a discussion on the latest regulatory requirements of financial reporting in India by appropriately including the provisions of the Companies Act 2013.
The author discusses various intriguing and practical aspects of financial accounting and reporting for management. He presents justifiable discussion on application of Financial Reporting Standards, namely IFRS, IND AS and AS (including a comparative study), process involved in preparation of financial statements, audits and significance of audit on quality of financial statements, preparation of projected financial statements, analysis of financial statements based on Published Annual Reports of Companies. He discusses about how a company may 'window dress', besides travelling across reported ‘accounting scandals’.
A contemporary accountant/CFO/Financial Analyst cannot be effective and efficient without application of spreadsheet software. Hence the author demonstrates application of Microsoft Excel and Macros (including VBA Macros for Excel) in day today financial accounting routines as well as in preparation of projected financial statements and Financial Modeling.
The book titled as 'Contemporary Financial Accounting and Reporting for Management' is authored by Mr. Nalayiram Subramanian, a practising Chartered Accountant with more than two decades of experience in Corporate Accounting and Finance, Information Systems, Audits, Corporate Laws, Business Valuation, Project Finance. He has been teaching accounting and finance subjects for MBA Students in top Business Schools including NITIE, Mumbai, India. He also conducts Professional Development, Management Development and Faculty Development Programmes in areas of IFRS, Financial Modeling, Business Valuation and Advanced Excel.
Target Audience
This book is ideal for B School Students of Accounting & Finance, Financial Analysts, Bankers, Accounting and Finance Executives, Finance Managers, Company Directors, Faculty and Students of Commerce, Accounting and Finance pursuing graduate and post graduate programmes. The book is useful for Chartered Accountants, Cost Accountants, Management Accountants, Company Secretaries and Investment Analysts from many aspects, including application of Excel with respect to Financial Accounting, Financial Modelling and Financial Analysis.
Price: For sale within India : INR Rs. 895.
For sale outside India : USD 30 (shipping extra at actuals)

ISBN: 978 - 81 - 927713 - 0- 4

For orders, Contact : Mrs. Ponnammal Nalayiram, Director, SN Corporate Management Consultants P Ltd., G2, Sun Rays Apartments, 25, Jayalakshmipuram 2nd Street, Nungambakkam, Chennai – 600 034, India. Tel: +91 81 22 62 4000 / +91 44 28260330
Email: publications@fintegratedsolutions.com website: www.fintegratedsolutions.com

 

 
   

 

 

Benefits of e-learning

Apr 112014

One of the impacts of the credit crunch has been a fresh look at the potential of e-learning. We decided to take a look at some of the research and examine the benefits of e-learning, including evidence of:

Lower costs
Faster delivery
More effective learning
Lower environmental impact
We provide some key data for your e-learning business case.

Lower cost?
There appears to be little argument that e-learning can be more cost effective to deliver than classroom based training, especially for larger organizations. There are a great many case studies including:

Dow Chemical who reduced average spending of $95 per learner / per course on classroom training, to only $11 per learner / per course with electronic delivery, giving rise to an annual saving of $34 million (Shepherd, 2002).

Ernst & Young who cut training costs 35 percent while improving consistency and scalability. They condensed about 2,900 hours of classroom training into 700 hours of web-based learning, 200 hours of distance learning and 500 hours of classroom instruction, a cut of 52 percent. (Hall, 2000).

source: www.kineo.com/resources/new-to-elearning/the-benefits-of-elearning