Excel for Beginners, A new Add-on for professionals by CA Learning

 

word press slider1.jpg

Microsoft Excel has been a very widely applied spreadsheet software, especially since version 5 in 1993 and due to this popularity; it replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel is a part of Microsoft Office. VisiCalc was the first electronic spreadsheet in the world, which had even helped launch the Apple II as one of the earliest personal computers in business use. With IBM’s entry into the market, VisiCalc was slow to respond as it (IBM) had acquired Lotus 1-2-3 from Lotus Software, which presently is itself a discontinued spreadsheet program. It was the IBM PC’s first killer application, which was hugely popular in the 1980s and contributed significantly to the success of the IBM PC.

 Microsoft Excel is an electronic spreadsheet, which operates on data entered in cells of a table arranged in numbered rows ranging from 1 to 10,48,576 (10,48,576 rows) & lettered columns ranging from A to XFD (16,384 columns). Cells in Excel may contain numeric or text data, or the results of formulas that automatically calculates and displays a value based on the contents of their respective cells. It is an interactive application for entry, arrangement, formatting, study and storage of data in a tabular form, the results of which may be viewed in the form Charts or Sparklines. It not just operates on computers (Windows, macOS) but also on smart phones (Android and iOS) as well; however, in this particular module on “Microsoft Excel for Beginners” we will be dealing with MS Excel (MS Office 2010) running on Windows 7 OS & above. Features of Microsoft Excel developed by Microsoft –

  • Calculation: it has an array of inbuilt functions to solve mathematical, statistical, engineering, financial problems
  • Graphing tools: it can display data entered in the cells of the workbook as Charts varying from column charts to scatter charts or even convert that data into Sparklines with their respective formatting options available
  • Pivot Tables: it allows splitting of data according to the result desired by the user
  • Macro: it allows the user to record steps to a particular problem, which he/she has to apply to similar sets of data repeatedly, by running that respective macro to either the same or any other workbook

 

Excel for Beginners has been prepared with the objective of getting an insight into the basics of Excel. Specially designed for beginners who want to – understand the concepts of Excel, how to perform tasks, shortcuts to perform those tasks, understanding the different methods and to inculcate the easiest one to become a smart and efficient professional. This module is for students who may be

  • in the 10th standard
  • a 10+2 Student
  • a 10+2+3 Student
  • a Student who wishes to utilise his/her summer/winter vacation in learning this Hands on Training (HOT) Course on Excel for Beginners
  • a Chartered Accountancy Student who wishes to brush-up his/her ITT skills in Excel
  • may be an employee even who is an expert in his respective field but wants to perform his Tasks on Excel with ease, accuracy and efficiency

Demo Videos:

As briefed above, the prerequisites of this module are MS Excel (MS Office 2010) Software installed on pre-installed Windows 7 OS & above. This has been prepared based on sequential lectures including case studies for a better overview and conceptual clarity to the student. This module begins with a very brief introduction of MS Excel & its history, the n number of uses with the diversity of users of Excel. Afterward, it makes the Student comfortable with the user interface (UI) of the Excel Spreadsheet; how it looks and what are the different tabs, graphical icons, row bars, column bars, etc. & their implications. Thereafter, case studies have been explained in detail initially with the actual method of performing that task, the different methods to perform those tasks and finally the way it is supposed to be done and all of them with the use of shortcuts. Reiteration of Shortcuts in all the case studies enables the Student to inculcate the habit of using these shortcuts with the use of the easiest method for performing the tasks with speed, accuracy, efficiency, effectiveness and ease at the end of the user. Hope you have an enjoyable journey throughout the course.

If you have any type of query related to excel then You can fill this form. Our Excel Experts will contact you soon.

Thank you for giving your valuable time to this blog

 

Chaitanya Arora

MS Office Expert

CA Learning Faculty

Advertisements

Opportunities for Young Chartered Accountants in Civil Services

Presentation1.jpg

The Civil Services originated in India after the expansion of the East India Company’s operations in India. The objective was to provide a strong administrative structure, further the practices followed by citizens were very different; the role of the collector was to collect land revenue and slowly as the Raj expanded and the functions of East India Company expanded, they kept on adding the roles of the collector.

Thereafter the Country sought of these services to be applied pan India and to add a large no of functions the government exercised more than just generating revenues like the administration, safety to be ensured, enforcement of law and order, etc.

As a Civil Servant, you have an opportunity to serve a no. of times more than the rest who think why we cannot change the decisions of the government. Hence, these services give you an opportunity. You learn about the government, how it works, understand the policy, look at the grievances and pains and do something for their upliftment.

You also learn about Government Accounts and procedure of expenditure of the government; what all revenues are raised by the government are to be deposited in the respective funds. Only a Body can be utilize those fund, which will be passed/authorized by the Parliament. Accounts to certain Principals to be spent on authorized grounds in the interest of public. The CAG checks and prepares the report. How Railways are operated and how the accounts for railways are managed. How Civil wing for defense services are managed. Indian police service are working all across the country to ensure normal peace and to ensure public order is maintained. The officers of Income Tax or Customs in collection of taxes. When you are a member of these services you can do all these kind of assessments. There are certain services which handles the relations with different countries of sensitive nature including countries like Pakistan and other neighbors and which help us in bringing more foreign direct investment leading India to grow at a better rate.

 

The Civil Examination is a three-stage examination; first is the Preliminary, second is the Mains and the third is the Interview. Union Public Service Commission (UPSC) conducts the exam. Any graduate above the age of 21 can appear for the exam. Around 3.5 – 4 lakh students appear for the Preliminary, out of them 3 – 4 % students i.e. 10 – 12 K appear for the Mains out of them 2,500 – 3,000 students appear for the Interview and out of these 2,500 – 3,000 students the last merit list of about 1,000 students is prepared. There are 20 – 25 services. All India services include services like IAS and IPS. Group A services include IRS, Indian Accounts, Postal Services, Railway Services and there are some Group B services as well. The duration of the entire stages of the exam is one year. The preliminary is in June, the Mains in October and Interviews in April/May. If a candidate is preparing for the Civil Services Exam, he should start 10 – 12 months prior to the Preliminary Exam. There are four attempts for the General Category; for Reserved Category there are more no. of attempts. There has been a relaxation in the age limit from 30 to 32 for General Category and up to 35 for Reserved Category. In Preliminary exam CSAT, there is one General Studies paper and one Aptitude paper, which is common for all aspirants. Once you clear the preliminary, there are four papers in Mains, which are again uniform across the board. Then you have to select one optional paper out of two; for Chartered Accountants, it can be Commercial Accounts. Apart from that, you need to qualify two language papers; for normal students, the language papers are English and Hindi and for the rest English is compulsory and except Hindi, you can choose any other language. Then there is one Essay paper, General Studies and one optional paper. The Interview is for about 275 marks. After this, the final merit list is prepared. The top preferences in the exam are the IAS and the IPS. This is the usual trend adopted by the aspirants. The interviews are conducted in the main building of UPSC of the respective state.

It has been seen that the students consider this examination as a very tough examination. Out of these 3 – 4 lakh students, only 80 K to 1 lakh students are serious and will be appearing in the exam. Out of these 1-lakh students, 10 to 15 K students pass the exam that makes around 10 to 15% success rate in the Preliminary, which is much better than the CA Final result. Statistically, it is not that tough. As far as the course curriculum is concerned CA’s are expert in Finance and Accounts they have an idea about the economic scenario of the Country. In the Preliminary, you have an Aptitude paper, which is Data Interpretation and Logical Reasoning, which is quite easy for a CA, so one of the paper is taken care of in the initial stage. In GS you have 4 papers out of which one is Economics, one deals with the Quality Governance and the Legal Structure that governs the Country. As CA’s, we read a lot of law and we have an aptitude to read the law so that paper is also taken care of. So you have an initial advantage in two papers. One paper has to be selected out of two; we have Commerce and Accountancy so that paper is also manageable. As a CA, we score the max. as we have a grip over this exam.

The fear factor is GS. NCERT is easy to read and initially gets you to the GS portion to have an overall background. Should update yourself with the Current Events happening around by in-depth reading of the newspapers like the Hindu and the Indian Express.

As a Civil Servant, you are dealing with the lives of the citizens of India and for that, you need to understand the history of the County and finally what is happening in their daily lives. Should also read an economic survey of India, it also explains a large no. of government schemes and what are its logical aspects. A basic idea of economy. You have to plan out a large amount of syllabus.

There are two structures State and Central. We start as a trainee in the state. There is a 3 month course from Lal Bhadur Shantri Academy. There is another capsule after 2 months of ground surfing around the country to understand its geography, the way people live, the culture they practice. Then you are staying for about a year in a district. On your come back to the academy, you share your experience and then you placed to the area as a Sub Magistrate. He (Sub Magistrate) has a small part under his jurisdiction, is supposed to co-ordinate, and ensure law & order. This is how he actually starts. For a year or two he works as a Sub-Divisional Magistrate called the Sub-Collector and he graduates to becoming a CEO of a Zilla Parishad or is some states its also called as the Chief Government Officer. Once he has handled the Revenue & Land Reforms and Law & Order is handled to the final aspect of development that includes laying down of roads, canals, providing houses to the poor, scholarships to students, women support old age support and then finally you become a Collector and handle the aspects of administration.  From Under Secretary, you become Secretary. You can take implementation decisions. You become a Principal Secretary assisting the concerned Minister. You are actually coordinating like a Magistrate after 9 years of service. After completing 14 years of service you become a Director. Finally after 17 years, you are empaneled to take decisions like what will be the policy. Basically you are molding the country’s policy. After that you can become additional secretary.

The IPS officers start as Sub Divisional Police Officer. After 1 – 2 years, you graduate as SP of different Departments. After 4 – 6 years, you graduate to become DIG then IG (Secretary IAS) then they graduate to become ATG. After ATG there are DGP’s amongst them in to handle the police infrastructure. DGP police. This is the general setup of IPS.

CA Coaching is not compulsory but helps for giving the exams. There are no exemptions in these papers as in the case of CA exams. There is low remuneration in the start; there a few benefits available like a house (Government Quarter), HRA, DA. Still at the end doing something positive for the country for which, a civil servant works where a new CA can contribute, as these services are the Backbone of administration of the Country would lead to a sense of satisfaction, which an enlightened citizen of the country would definitely dream of.

OPPORTUNITIES FOR CA IN THE ORDER OF ICAI FINAL SYLABUS

CA Leaning Solution

Highlights of this Article :

  • Discussed practical application in life of the subject studied in CA Final
  • Paper by paper analysis
  • Information  collected  from the industries expert.

PART 1 : GROUP 1

Financial Reporting

  • Application of IND-AS in the various industries w.e.f. 1/4/2017 : Central Government has made in stages the implementation of IND-AS mandatory.

It will be made applicable to large companies first.

  • Valuation of business and intangibles for the business acquisition: Business acquisition strategy can work properly for growth only when it is properly structured. Goodwill, patent, copyright and other intangible may be valued by a registered business valuer. Such valuation process needs to be properly implemented by a Chartered Accountant.
  • Internal Financial Control (IFC) mechanism : Internal control has become a serious professional task in a multi country and multicultural business environment. It requires following the standard codified international guidelines on a consistent basis.
  • International Financial Reporting Standard(IFRS) compliances from international perspective : IFRS is a common global platform which requires

All countries to follow common accounting practices. India is also working on the convergence model by changing to IND- AS first. The developed countries and few least developing countries have already implemented IFRS. IFRS will make the flow of capital across world easy because the reporting practice will be common and easy to understand just like Microsoft which universally same.

Strategic Financial Management 

  • Strategies for derivative and hedging : The stock brokers create business strategies for derivative and hedging. These are used for creating growth around stocks and commodities. Profit can be booked in the future based on the hedging strategies defined by the investment experts.
  • Capital budgeting proposals for the big infrastructure and power projects :

Big projects need capital planning on a longer horizon. This requires a decision on the capital expenditure and revenue expenditure with a focus on the breakeven, internal rate of return and corresponding payback period.

  • Wealth management planning for High Net worth Individual (HNI) : HNI is a person who requires a guidance on fund and asset management. Different banks and consultants are working to give solution so that optimum utilization is achieved for HNI funds and assets by diversifying the risks.
  • Analysis of Share market operation: Share market goes through bull and bust in a business cycle. Cyclical movement allows a business to work upon the future direction in the interest of shareholder and debenture holders. Analysis of these parameter allows the individuals and businesses to understand and improve the investing direction of investors on a short term and long term horizon.

 

Advanced Auditing & Professional Ethics

  • Internal audit of the various industries : CAs are known for their internal auditing capability which requires certain basic common requirements universally. These are known as the Standard of Auditing  called as SA.

But in case of the different industries say mining or aviation we may find that

the capabilities and standard requirement will vary according to the requirements of the industry.

  • Internal control design for the different companies: CAs are better known as an internal control design experts for the various businesses and industries. Automated Internal control questionnaire help an expert to find the suitable solution towards the client’s requirements on a long term basis.
  • Forensic Audit : Businesses are susceptible to the frauds which can be countered through the application of the Forensic Audit.
  • CAG Audit and Bank Audit : Central government allows a regular conduct of statutory audits of the central government institutions annually by a CA firm. Likewise, banks are also asked to get their accounts audited annually.

Company and Allied Law  

  • MCA Compliances Filing : Ministry of Company Affairs has created as per Company Act 2013,the various compliances filing at the various periodic interval of time. MCA has made it’s compliance filing mandatory to certain type of companies.
  • Company Law Case studies and it’s judicial solution before Company Law Board : This is again a sunrise area where due to the change of Company law Act from 1956 to 2013 has lots of new opportunities to the professional at the practice level and at the corporate level has come. New Act, circulars, explanations allow the companies to reorient properly.
  • Foreign Exchange Management Act (FEMA ACT) related compliance : Foreign exchange movement for the products and services by way of export and import is essentially required by India which is regulated by FEMA. FEMA limits for the foreigner, person of Indian origin, NRI and resident are different. Proper compliance through RBI mechanism is required through FEMA Act.
  • SEBI related compliance : Stock exchange Board of India related compliances as required by the SEBI Act is an alluring working area for the professionals which require deep knowledge in to the Act and circulars.

FIVE SKILLS A PROFESSIONAL MUST ACQUIRE

five skills -01

Every professional needs to under do skill upgrade on a continuous basis in a changing world. It requires quality learning and practical application.

Firstly, a professional must have knowledge update and hence he must read the latest development in the professional world. He must also attend the training by the experts including webcast on the regular basis.

Secondly, he must have an excellent communication abilities which includes both written and communication skills in a given skill area. This means he must have also have a commanding ability on the technology side of the communication as well. He must be able to seriously understand the requirement of the consumer or management. He must be able to deliver the business requirements also.

Thirdly, a professional must have leadership ability to improve the skills of the junior staff. He must drive the vision of the business and its stakeholders. He must develop a business strategy which is suitable in both short and long range of the business. He must operationalize the business objectives on a long term rolling basis plan.

Fourthly, interpersonal behavioural skill development is a hall mark of the business development and consumer satisfaction. It requires good communication, reciprocity and positive working attitude which fuels the business growth. Also there is always a scope of skill enhancement in human behaviour arena.

Fifthly, networking with the professionals with in the same skill set is highly desirable when globe is such a small place to function. Networking gives more business potential and growth opportunity and therefore a professional must be always be in a networking mode.

to know more – http://calearning.in