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.     

Desired attributes of public accounting firms in the job selection process: an empirical examination of accounting graduates' perceptions

The purpose of this study is to identify attributes of public accounting firms that accounting graduates find most desirable in their job selection decisions, and the impacts of individual differences on these perceptions. Factor analysis performed on the responses of 167 final-year accounting students in Hong Kong to a 30-item questionnaire identified seven factors. The results indicate that accounting graduates considered help in finishing their professional accounting examinations and good staff relationships as the most important criteria in their choice of employers. In addition, female accounting graduates were more concerned about the possibility of being required to travel or be transferred, but were less concerned about the reputation and profile (such as the client base and the size) of the firms than their male counterparts. Accounting graduates with a higher grade point average (GPA) were less concerned about the working environment, but more concerned about a firms' reputation and profile than those with a lower GPA. The implications of these results are discussed.     

Empirical evidence on factors significant for employment in government accounting

The primary objective of this study is to investigate the perceptions of government agencies regarding the importance of selected job characteristics in entry-level accountants. We collected our data with a survey instrument which contained detailed questions on appearance, education, extracurricular activities, performance, and personality. Our sample consisted of federal agencies with a known proclivity to hire accounting graduates. In addition, for comparative purposes we also sampled the 11 largest U.S. public accounting firms. We mailed the instrument to both the treatment and the control group of firms. Our results indicated that a number of achievement, personality, and social factors were particularly important to each employer group. Interoccupational comparisons revealed minimal overlap in the factors of particular significance to both federal agency and public accounting firm recruiters. These findings suggest that different knowledge, skills, and personality traits might be crucial to students seeking employment with federal agencies as opposed to large public accounting firms.     

Perceptions of master of accountancy graduates concerning their job search and employment experiences with public accounting firms

The public accounting profession has been calling for a 150-hour education requirement for new entrants to the profession for over two decades. The rationale for increasing the entry-level education requirement is that since the business world is more dynamic and complex than ever before, new professionals need broader knowledge and skills to be able to cope. Graduates of master of accountancy (MSA) programs would appear to be the type of students that public accounting firms are seeking since they often have intellectual breadth gained through undergraduate degrees in areas other than accountancy, current technical competence in accountancy, and frequently have work experience. This paper reports the results of a study undertaken to determine the perceptions of MSA graduates concerning: (1) how recruiters from public accounting firms viewed their non-accounting academic backgrounds and work experience; (2) how well prepared they were for their first jobs in public accounting as compared to traditional undergraduate accounting majors; and (3) any bias they experienced during the hiring process. The results of this study indicate that although a majority of the respondents who desired careers in public accounting were able to secure jobs in the field, they believed it was harder for them to get jobs in public accounting than their peers with just undergraduate degrees. The majority did not feel that public accounting firms viewed their non-accounting academic backgrounds and work experience favorably. Although more than half believed that they were paid more than their peers who held only undergraduate degrees, less than half felt that they were given more responsibility. The results also indicate that older MSA graduates believed that they were subject to age bias during the interview process.     

Employers’ Perceptions of Information Technology Competency Requirements for Management Accounting Graduates

Abstract

Management accountants work in a computerized workplace with information technology (IT) for producing financial ledgers and for reporting. Thus, the role of the management accountant has shifted from capturing and recording transactions to analyzing business issues. The research question is: what IT knowledge and skills do employers require of management accounting graduates? An exploratory field research approach was used; chief financial officers and their subordinates at some of New Zealand's largest firms were consulted. These respondents were consistent in their requirements. They emphasized intermediate proficiency with some Microsoft tools (Excel, Word, PowerPoint, and Outlook) and sufficient familiarity with the structure and navigation of an enterprise resource planning system to process transactions such as accounts receivable. Of those requirements, Excel for analysis was the most important. Our contributions update and augment the literature by clarifying the perceptions of employers regarding the IT competencies required of management accounting graduates.     

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.     

Racial biases in recruitment by accounting firms: The case of international Chinese applicants in Australia

This paper documents the difficulties in finding accounting work faced by international Chinese accounting graduates in Australia in the two years after graduation. We argue that Chinese accounting graduates remain a marginalised group within today's Australian society. The interview results support this assertion, with even high-achieving Chinese graduates finding it difficult to obtain work with mainstream accounting firms and corporations. The main reasons appear to be their lack of Australian working experience, lack of knowledge of Australian culture, and lack of “Australian English”. Australian accounting firms, due to a revealed preference to hire white Australian graduates, appear to be missing out on a vast reservoir of Chinese talent. Chinese accounting graduates speak two or three languages and have established business networks in China or at the very least insider knowledge of how that country's business culture operates. Whilst their sub-cultural capital may be lower on average than white graduates on some conventional measures, it is higher in those areas of bilingual capability and cross-cultural knowledge which are becoming of increasing importance to Australian business.     

Computer education: A survey of accounting graduates

In recent years, increased attention has been directed towards the integration of computers into accounting education. A questionnaire was distributed to accounting graduates in order to determine their opinions about the adequacy of computer education and the importance of computer skills to the professional accountant. Graduates, stratified by year of graduation, were selected from a diverse group of universities.Overall, the respondents rated their own preparation low. They felt best prepared in programming skills but least prepared in networking and computer communication skills. In terms of importance, software proficiency was rated highest, with programming skills lowest. With a few exceptions, the analysis of the responses by demographic variables yielded results consistent with the overall analysis. The respondents with less work experience rated their preparation higher than those with more experience, but those with more work experience rated the importance of all computer skills higher.     

COMMUNICATION SKILLS OF ACCOUNTANTS IN AUSTRALIA

This paper reports a study that adapted an American communications skills inventory to determine the extent to which new graduates in the accounting profession are perceived to have adequate communications skills. Senior practitioners' and educators' perceptions were surveyed to reach conclusions regarding the future directions of communications in accounting education in Australia.     

Student career aspirations and perceptions: The case of Israeli accounting students

The study investigates changes in Israeli accounting students' career aspirations during their course of studies, and the relationship between these and their perceptions of professional accountancy firms. We employed a cross-sectional analysis of students across consecutive educational levels from the first year to the end of their formal education. We assumed that revealed differences between the accounting student cohorts, in terms of their perceptions of professional accountancy firms and their career aspirations, could be interpreted as reflecting changes over time in students' attitudes. Results from the sample show that accounting student' aspirations to pursue a career with a professional accountancy firm decline significantly between the first and postgraduate years, while their desire to work in the business sector increases. The results show the same trend with regard to the student's positive perceptions of the above firms as future workplaces. Non-parametric tests demonstrate significant relationships between students' career aspirations and their perceptions of professional accountancy firms. We suggest that the change in students' perceptions and aspirations is a symptom of something similar to a ‘reality shock’, and that it results from the students' exposure to the accounting profession. Professional accountancy firms need to implement innovative policies to meet the challenge.     

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.     

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.     

Critical thinking in the public accounting profession: aptitudes and attitudes

The public accounting profession has called for enhanced critical thinking skills in accounting graduates. However, critical thinking is a term which does not enjoy a universally-accepted definition. This study attempts to identify the critical thinking competencies essential to success in public accounting, and articulates those competencies to facilitate future research aimed at curricular change to meet the needs of the profession. The findings reveal that the profession uses the term critical thinking to refer to a broad set of competencies which includes both cognitive and non-cognitive attributes, attitudes, and behaviors. These competencies are presented as an operational definition of critical thinking useful to accounting education researchers.     

Does the Holland model of occupational choice (HMOC) perpetuate the Beancounter-Bookkeeper (BB) stereotype of accountants?

This article investigates the Holland model of occupational choice's (HMOC) development, influence, and validity in relation to its classification of bookkeepers, accountants, and business professionals. Study 1 reanalyzes published data and provides evidence that the Beancounter-Bookkeeper (BB) stereotype, which is promoted in the HMOC, is partially predictive of the personality characteristics of individuals who choose to enter professional accountancy. Study 2 investigates the influence of HMOC training, and exposure to accounting education, on perceptions of the personality type needed for accounting work; results indicate that: (1) HMOC training is associated with perceptions that accounting work requires a BB personality, and (2) the importance of investigative skills to accounting work increase with accounting education. Following this, we review evidence that suggests low validity in the HMOC's claims of greater job success and satisfaction among BB accountants. Finally, we consider three possible processes that may explain Holland and colleagues’ conjoining of accountants with bookkeepers. Together, the analysis promotes skepticism regarding whether the HMOC's claim that professional accounting success demands a passive, compliant, subservient, i.e., BB, personality supports the public interest obligations of professional accountants.     

Academicians' and practitioners' views on the content and importance of the advanced financial accounting course

This study reports the results of a survey of accounting academicians and accounting practitioners in public and private accounting. The purpose of the study was to examine the content and importance of the advanced financial accounting course. The results indicate that most schools require the course for accounting majors and the topics most often covered are consolidations and business combinations, partnership accounting, governmental/nonprofit accounting, and foreign currency accounting. Regarding the respondents' perceptions of what should be covered in this course, academicians indicated that significantly more time should be devoted to consolidations and business combinations while accounting practitioners indicated that a broader range of topics should be covered in the course. Also, academicians are more in agreement with the statement that the advanced financial accounting course is a good indicator of students' analytical skills. The results of this study should be of interest to accounting departments that are reviewing their curricula and individuals teaching advanced financial accounting.     

Accounting education,firm training and information technology: a research note

Rapid developments in information technology (IT) have posed many challenges to the accounting profession. In this study we examined what has been done in US colleges by polling auditors' perceptions to investigate whether US accounting firms provide their auditors with more information on current IT topics than colleges do. Also educators in the USA are surveyed to find out what they are planning to do in college courses to ensure that accounting graduates acquire necessary IT knowledge/skills. The results indicate that the entry-level auditors have had significantly more exposure to IT topics while in college than the senior auditors had, which suggests that educators have modified their curricula by incorporating more IT topics into accounting programmes. According to the findings, educators recognize the importance of IT topics, but only a few IT topics can/will be covered in accounting curricula. Implications, limitations, and future research directions of this study are also discussed.     

Social mobility via elite placements: working class graduates in elite accounting and banking firms

ABSTRACT

Little research attention has been paid to the effect of yearlong placements in elite accounting firms and investment banks on the social mobility of working class graduates. Using the framework of Bourdieu, this paper examines the link between placements and employment destinations of eight cohorts of accounting and finance graduates from a non-elite British university. We find that elite professions are most likely to recruit graduates who have already gained the ‘right’ professional habitus through the successful completion of yearlong placements in the same elite firms in that particular field and/or with better degree averages. Social mobility of working class graduates taking an elite placement is evident after controlling for gender, age, ethnicity and degree average. The findings indicate that working class graduates need to consciously and continuously modify their class specific dispositions so that they can fully engage with higher education and elite placement experiences to achieve social mobility.     

Ethics education in accounting: An investigation of the importance of ethics as a factor in the recruiting decisions of public accounting firms

In recent years, significant attention has been directed to the role of ethics in the business environment and to the ethical development of business students. This study explores the importance of ethical behavior as a factor in the recruiting decisions of public accounting firms. Factors related to the ethical behavior of entry-level employees were compared with other personal characteristics that are traditionally viewed as important to public accounting firms (e.g., personality, appearance, academic performance, etc.). Recruiters from both Big-Six and non-Big-Six firms indicated strong views on the importance of the students' ethical propensities. In fact, ethics received the highest rating by the public accounting firms regardless of their size. The results of this study provide strong evidence for accounting educators to continue to stress to their students the importance of ethical behavior and to continue their efforts to more fully integrate ethics education into the accounting curriculum.     

Scholarly accomplishments in promotion and tenure decisions of accounting faculty

Deans and accounting department heads are surveyed to measure the relative importance assigned to various scholarly accomplishments in promotion and tenure decisions of accounting faculty at AACSB-accredited institutions. We also investigate whether these importance ratings vary across colleges of business and their departments of accounting in accordance with their educational missions, as determined by an institution's classification under the Carnegie Foundation system. The results demonstrate that accomplishments involving publication, external recognition, and funding count most in tenure and promotion decisions. Academic publications and awards are rated the highest at all institutional types. And, of the 39 scholarly accomplishments examined, fewer than half were assigned an average importance of four or higher on a 7-point scale. Further, the importance assigned to certain scholarly accomplishments by deans and accounting heads varies with the educational missions of their institutions. At doctoral-granting, high research support institutions, deans and heads employ a different definition of scholarship than do their colleagues at Comprehensive institutions. Academic publication activities and external recognition tend to dominate tenure and promotion decisions at doctoral-granting, high research support institutions. Comprehensive deans and heads place significantly more importance on scholarly accomplishments associated with practitioner publications, pedagogical publications, national and regional academic meetings, and instruction.