Towards an understanding of excel functional skills needed for a career in public accounting: Perceptions from public accountants and accounting students

Public accounting firms (e.g., Grant Thornton, 2012) are stressing an interest in recruiting accounting students with a proficiency in Excel. The purpose of this study is to investigate which Excel functions are perceived to be important and useful for new hires to understand prior to starting a job in public accounting. We collect survey data from four large public accounting firms as well as undergraduate and graduate accounting students (i.e., potential new hires) to gauge perceptions of Excel importance, knowledge, and usage in public accounting. We find that employees at the firms believe the most important Excel functions are: basic formula, filter and sort data, vertical (horizontal) lookup, formatting of documents, and If/Then statements. In a comparison of new hires at public accounting firms with accounting students, results suggest that accounting students underestimate the importance and usage of some of these Excel functions. In addition, results suggest that new hires’ perceived knowledge on how to use specific Excel functions in their accounting job is statistically different than students’ perceived knowledge on how to use some of the same Excel functions. Our research contributes to educational accounting literature by documenting which Excel functions employers in public accounting want new hires to know prior to starting a job in public accounting. Also, this research informs accounting educators that students’ perceptions are not the same as public accounting employers’ expectations with respect to analytical skills using Excel technology.     

The written communication skills that matter most for accountants

Given the importance of effective written communication skills to the discipline of accounting, faculty must emphasize these skills in their classroom in order to adequately prepare students for successful careers in the field. Since 2000, only two studies in the accounting literature have examined which written communication skills are needed by entry-level accountants and consensus is that spelling, grammar, punctuation, and clarity are of utmost importance. We surveyed accounting practitioners and faculty to determine what exactly, within those categories, is most bothersome. For example, within clarity, is it wordy sentences, passive voice, or shifts in tense? By documenting the most bothersome errors, our findings can help accounting educators to focus their limited time on the appropriate skill emphasis.     

A study of the perception of public accounting skills held by UK students with accounting and non-accounting carrer aspirations

This paper examines perceptions of the skills that are important for success in public accounting. The total sample consists of 203 respondents who have operationalized carrer interest by either applying to accounting firms (n = 107) or to other large companies for non-accounting positions (n = 96). Data was gathered using an attitudinal questionnaire administered to the two groups. ttests, ANOVA and multivariate analysis were used to analyse the results. Factor analysis was used to generate inputs for discriminant analysis. The finding indicate that bot groups have similar perceptions of the importance of analytical ability and deductive reasoning. However, respondents interested in entering the accounting profession attach greater importance to the possession of good interpersonal skills, empathy, sensitivity, innovation and creativity. Accounting applicants describe accounting as incorporating a wider skill repertoire than those with non-accounting aspirants. The implications of these differing views for carrer choice and accounting education are explored.     

Developing critical thinking: An examination of contemporary practices in accounting

Employers and professional bodies call for higher education accounting courses to emphasise the importance of critical thinking skills. This study provides an in-depth assessment of how critical thinking is currently taught and assessed across an entire accounting degree. Our study contributes to our understanding of how teaching and assessment can support students in developing their critical thinking. Using a case study approach, we identify resource restraints and disruptions to traditional forms of engagement as key challenges to developing critical thinking skills in accounting education. We conclude with suggestions for teaching practice, such as formative scaffolds and teacher-led discussions.     

Priorities for the development of vocational skills in management accountants: A European perspective

In recent years there have been many calls for a re-orientation of accounting education in order to include the development of competencies such as communication, group working, and problem solving skills. However, concern has been expressed that the proposed changes are possibly biased towards the interests of public accounting employers. This paper presents and compares the opinions of the employers of management accountants in Spain and the UK, and then by using a weighted importance indicator determines vocational skills development priorities. The factors that the Spanish and UK employers identified as major constraints to the development of vocational skills are also compared.     

Positioning of emotional intelligence skills within the overall skillset of practice-based accountants: employer and graduate requirements

This paper presents evidence of employer and graduate attitudes on the skill set requirements for professional accountants, and whether university accounting programs develop these skills, and in particular emotional intelligence (EI) skills. We use priority indices and strategic mapping to evaluate the positioning of 31 skills. This analysis suggests that university accounting programs could consider increasing the emphasis placed on particular EI and non-emotional intelligence (non-EI) skills while other skills could be de-emphasised. While non-EI skills were ranked higher than EI skills, some non-EI skills are considered well developed in graduates and others are viewed as important but not well developed. While employers expect correspondence between the skills seen as important in the workplace and their expected development in university, there was also reverse correspondence in that employers do not expect universities to develop skills considered less important in the workplace.     

Excel in the accounting curriculum: perceptions from accounting professors

Public accounting firms emphasize the importance of accounting graduates being proficient in Excel. Since many accounting graduates often aspire to work in public accounting, a question arises as to whether there should be an emphasis on Excel in accounting education. The purpose of this paper is to specifically look at this issue by examining accounting faculty's perceptions of Excel in public accounting and accounting education. We survey 245 faculty members at over 100 accounting programs. We find that a majority of faculty incorporate Excel in their accounting classes consistent with their perception of Excel importance. However, we find that students are not fully proficient in Excel based on faculty's perceptions. This study contributes to the accounting education literature by identifying possible disconnections between Excel skills faculty include in the accounting curriculum and specific Excel skills faculty believe new hires (i.e. recent accounting graduates) most often use in public accounting.     

Assessing the use of computer-based assessment-feedback in teaching digital accountants

Both assessment and feedback have a vital impact on students’ learning. Using computer-based assessment (CBA) with constructive and prompt computer-based feedback (CBF) reduces the attainment gap of the new generation of digital students. Action research methodology was employed to explore students’ view of utilising CBA and/or CBF in teaching and learning practice. A survey was administered to 537 undergraduate students in the Management School of a British university to collect data about their perceptions of using CBA and CBF to assess their progress. Findings from students’ survey show that students are generally appreciated the use of and benefits of CBA and/or CBF in teaching accounting modules. Findings also reveal that many participants valued working online compared to paper-and-pencil assessment and they also appreciated the timely and constructive feedback-feedforward they received. Information technology (IT), therefore, can provide an innovative type of assessment and feedback that students’ desire in an effective manner.     

An investigation into the development of non-technical skills by undergraduate accounting programmes

Non-technical skills are essential for today’s professional accountant who operates in a dynamic socio-technical environment. Accounting degrees have continued to be criticised for failing to develop these skills to the required level. In the Scottish location of this study, employers have responded by seeking out graduates from non-accounting degrees who they perceive have better developed these skills. The research aims to further the debate on non-technical skill development of accounting graduates, interpreted through a lens of institutional theory. Data was collected via a questionnaire to Big 4 ICAS trainees and subsequent interviews with Scottish academics. Pressure, driven normatively by accreditation, for high-levels of technical content was found to result in accountancy degree providers requiring to make prioritisation decisions regarding the development of non-technical skills. Accountancy degree providers appeared to prioritise interpersonal and communication skills at the detriment of intellectual skills. Un-actioned, this could threaten the institutional legitimacy of accountancy degrees.     

Management accounting information and the needs of managers: Perceptions of managers and accountants compared

The study builds on prior research on information user perceptions and the roles of management accountants. Perceptions of management accountants and managers in the same organisations regarding information supplied by the management accounting function were compared and differences highlighted. Perceptions of managers were also sought regarding desired changes in the information supplied and desired future roles of management accountants.Consistent with prior literature in MIS and accounting, the findings showed evidence of preparer–user perception gaps. Major contributors to those perception gaps were identified as an imbalance between technical and organisational validity, functional differentiation and an inherent tension between the simultaneous requirements of independence and involvement. Managers' views of desired future roles for management accountants provided consistent indicators as to how those gaps can be narrowed. The study also exposes inaccuracies in management accountants' perceptions and sets out implications for the design and reporting of future research.     

Generic skills in accounting: perspectives of Chinese postgraduate students

This study examines Chinese accounting students’ perceptions of skills required for a professional accounting position in Australia and of the emphasis placed on skills during their postgraduate Master of Professional Accounting (MPA) course. The study is motivated by concerns about international students’ inadequate generic skills and their difficulty in securing professional employment. We find that Chinese students perceive ‘communication skills’ to be the most important for their professional employment in Australia, but at the same time they tend to overemphasise technical skills and underemphasise other desirable generic skills.     

Professional accountants and the development of a management accounting service for the small firm: barriers and possibilities

This paper reports the results of a qualitative study examining the potential for the provision of a management accounting service for smaller companies by accountants in professional practice. The study aimed to determine the management information needs of owner-managers, the type and frequency of information preferred and the capacity of professional accountants to contribute to these needs. The owner-managers of 15 smaller companies were asked to participate in semi-strucutured interviews during which their use of computers to provide management accounts, their relationship with their accountant and their financial skills were discussed. The respondents were presented with a range of management information including statutory final accounts, interim accounts, cash statements, ratios and graphical comparisons of monthly turnover figures in order to assess their financial information skills and needs. The study found that companies used computers for the preparation of management accounting information, but usually not to their full potential. The financial awareness of owner-managers varied considerably. There was a favourable response to the presentation of ratios and graphs, however, it was felt that an explanation or interpretation of financial information by their accountant would be a useful addition to improve their understanding and therefore aid their business. The study concludes that there appears to be significant potential for accountants to expand the management accounting services they provide to smaller companies, especially where information is presented as ratios or graphs and accompanied with an appropriate narrative interpretation. This would also increase the financial skills of their clients and result in an increased demand for management accounting services.     

Developing Accounting Students' Listening Skills: Barriers,Opportunities and an Integrated Stakeholder Approach

Accountants and employers of accounting graduates consider listening to be among the most important communication skills that graduates possess. However, accounting education practices that develop students' listening skills are uncommon. Further, in the case of listening development, the current approach of prescribing that educators do more to rectify students' skill deficiencies overlooks barriers that prevent greater incorporation of listening instruction in the accounting curriculum. An alternative integrated stakeholder approach to develop students' listening skills is proposed. Informed by a broad range of education literature, the approach identifies cross-disciplinary listening development best practice and barriers to the widespread implementation of such practices in the typical accounting programme, before determining and assigning interrelated listening development roles to key stakeholders who will benefit from improved student listening. While student listening development is feasible under the proposed approach, shared contributions by accounting students, the profession and educators are needed to achieve enhanced skills outcomes.     

Perceptions of the benefits of the A3 planner in facilitating project-based learning in accounting education

This paper evaluates ways of instilling project management skills into accounting-based learning by the use of an iterative A3 planner to plan, monitor and review assignment progress. The application of an A3 planner to facilitate a project-based learning (PBL) group assignment in undergraduate accounting education has been critically evaluated in terms of both the student and tutor experience. The study uses a mix of qualitative and quantitative data. Quantitative data assisting exploration of perceptions were collected through 100 undergraduate students. A series of focus group discussions were carried out to investigate students’ engagement and tutors’ teaching experiences regarding the adoption of the A3 planner. The results suggest that the A3 planner promotes active planning and effective management of a PBL group assignment. It makes students’ thought processes more visible thereby facilitating and enhancing the tutoring/mentoring process. Moreover a more interactive and transparent approach by doing assignment via the use of an iterative A3 planner has ensured more feedback points and action based efficiency in the doing approach for learners.     

A Business Communication Module for an MBA Managerial Accounting Course: A Teaching Note

Abstract

This Teaching Note describes a two-hour-and-40-minute Business Communication module developed and used by the author over the past six years in an MBA Managerial Accounting course at a university in the USA. The module has two modest but important goals: to sensitize graduate accounting students to the importance of communication skills for professional success; and to provide students with a set of writing-improvement resources. The students' component of the module consists of a set of five readings and two learning resources. For teachers, a comprehensive set of PowerPoint slides is available from the author. The module is flexible in two respects: it can be used in graduate-level accounting courses other than Managerial Accounting; and a reduced version of in-class presentation time is possible by using only a sub-set of the PowerPoint slides, based on teacher preferences. Student responses to the module have been consistently positive and have supported continued use of the module into the future.     

Management accounting curricula: striking a balance between the views of educators and practitioners

Management accounting education has been subject of considerable debate since the 1970s, particularly in terms of what topics should be taught. The research reported here set out to ascertain the management accounting topics/techniques and the skills/characteristics that are considered important for a graduate who intends to pursue careers in management accounting. Based on a survey conducted on educators and practitioners, the results indicate that educators viewed behavioural implications, activity-based costing (ABC), performance evaluation and product costing as the top four important topics. In contrast, practitioners' top four important topics were cash flow management, operational budgeting, variance analysis and performance evaluation. Overall, traditional techniques, as compared to contemporary techniques, tend to be more widely used by firms. As regards skills and characteristics, practitioners and educators placed high importance on thinking, problem solving, listening and quantitative skills.     

Accounting graduates' perceptions of skills emphasis in undergraduate courses: an investigation from two Victorian universities

This study investigated the emphasis placed on technical and generic skills developed during undergraduate accounting courses from the graduate perspective. It is motivated by two issues. First, calls by the accounting profession and international education committees regarding the professional adequacy of graduates. Second, the challenge facing educators and professional bodies to design accounting courses that address a diverse range of needs from students, the educational philosophy of the institution, and the changing dynamics of global business. Data obtained from 310 graduates from two Victorian universities provided insights into the types of skills development considered necessary for a successful accounting career.     

Impact of group exams in a graduate intermediate accounting class

Cooperative learning techniques have been found to be quite successful in a variety of learning environments. However, in university-level accounting courses, investigations of the efficacy of cooperative learning pedagogical methods have produced mixed results at best. To continue the search for a cooperative learning method that is effective in accounting education, this study examines the use of group exams in a graduate intermediate accounting class. We provide evidence of a number of positive effects. Average scores on group exams were consistently higher than average scores on exams taken in individual format. Students adapted to the new assessment format rapidly and effectively. Further, students found the experience positive and believed they had improved important skills such as communication, time management, and teamwork. While some evidence of a free-rider effect and negative behavior associated with it was found in the beginning, this behavior was apparently temporary.     

Thinking practice: Iteration,peer review,and policy analysis in a governmental accounting class

All accounting graduates need strong critical thinking skills to succeed. However, possessing these critical thinking skills upon graduation is particularly crucial for new accountants working in the field of governmental accounting. As public servants at the local, state, and federal levels, they may face both short-term budget constraints and long-term sustainability concerns that cannot be solved with technical skills alone. Due to the proliferation of standards and technical practices across the accounting profession, governmental accounting educators may find it difficult to incorporate critical thinking instruction into their courses. In response to these concerns, this paper presents a project developed for inclusion in a governmental and nonprofit accounting course. Over the course of one semester, students choose a governmental policy topic of interest, conduct background research, evaluate the costs and benefits associated with a policy issue, and prepare recommendations in a written format addressed to the appropriate legislative committee. The project also incorporates review and iterative components that allow students to revise their written work based on feedback from the instructor and classmates. We report results of pre- and post-surveys that suggest that the project offers promise as a vehicle for promoting critical thinking skills among governmental accounting students.     

Perceptions of journal quality and research paradigm: results of a web-based survey of British accounting academics

This paper reports the results of a web-based perception study of the ranking of peer reviewed accounting journals by UK academics. The design of the survey instrument allows an interactive selection of journals to be scored. The web-based format is unique in that it also includes a step in which respondents classify the journals according to methodological perspective (paradigm). This is depicted graphically in the paper in a bubble diagram that shows the “positioning” of journals according to perceptions of both paradigm and quality.