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.     

Story spaces: a methodological contribution

This paper draws attention to methodological opportunities evident in diverse approaches to story. Empirical work from Organisational Behaviour is placed alongside empirical work in Science Technology Studies and a case made for diversity and detail in deploying story in studies of work, technology and employment.     

Who Loses HOPE? Attrition from Georgia's College Scholarship Program

Georgia's lottery-funded HOPE Scholarship program provides free tuition to in-state students who can maintain a B average at state universities. However, roughly half of HOPE Scholars lose their support after their freshman year. This study employs student-level administrative data to identify the observed characteristics that systematically relate to scholarship attrition. Conditional on measures of student ability, there are not statistically significant differences between white, black, and Hispanic students. However, there are dramatic differences across academic disciplines. Students majoring in science, engineering, and computing are 21 to 51 percent more likely to lose their HOPE Scholarships than students in other disciplines.     

The Impact of Medical Education Reform on the Racial Health Status Gap, 1920–1930: A Difference-in-Differences Analysis

The racial impact of a quantity–quality tradeoff in physician supply (implemented through medical education reform) made during an era of racial segregation is assessed. The reform produced differential impacts across race and region. The health status of northern blacks improved the most; that of southern blacks the least. Accordingly, the health status gap between northern whites and blacks diminished, but the gap between southern blacks and every other demographic group increased. The path of northern blacks suggests that access to and high quality of health care are both necessary to close the racial gap in health status that persists today.     

Community in a recreational setting

Abstract

The loss of community and of traditional communal ties characteristic of modern industrial society has caused many people to search for alternative sources of social identification and solidarity. Recreational sites may afford some people opportunities for constructing communities on the basis of common interests. As part of an ongoing investigation, data have been gathered over several years to discover whether elements of community can be found in a marina's social system; evidence is being sought through examination of patterns of social interaction, the system of social ranking, and ties of affection that characterize the marina's social network. Data reveal a social organization at the marina comprising subgroups with complex interaction patterns, affective ties, and communal solidarity. It appears, therefore, that at this recreational site the structure and dynamics of an alternative form of community have been constructed by boaters.     

Redirecting direct selling: High-touch embraces high-tech

Direct selling, defined as a sales channel without a fixed retail location, was built on the premise of leveraging an individual's social networks. This industry is being redirected by embracing social media; here, the challenge lies in providing the benefits of face-to-face selling, augmented by social media. An examination of the Direct Selling News ‘Global 100 Top Direct Sellers’ found that Facebook, YouTube, and Twitter represent the most widely employed social networks in the industry. While 76% of direct sellers utilize social media for promotional purposes, 55% use it for recruiting new distributors and 42% use it for reactive purposes. Consumers are the most popular target for social media, followed by distributors and communities. Social media has evolved as a driver of strategy, and will become even more important in the future. Improved customer relationships are developing by listening and reacting to concerns. The transparency created by social media is enhancing trust and ethical organizational cultures. Finally, consumer brand communities are emerging that increase brand value.     

Market-oriented sustainability: a conceptual framework and propositions

Utilizing Resource-Advantage Theory as the underlying theoretical foundation and drawing on literature from a variety of disciplines, we develop a market-oriented sustainability framework. By incorporating sustainability into market orientation, the goal of strategic alignment of sustainability with marketing strategies is achieved to create a competitive advantage. Three constructs identified in the model are DNA, stakeholder involvement, and performance management. These three constructs are the drivers of sustainability. DNA is used as an extended metaphor to clarify and illustrate the workings of an organization and how sustainability may be implemented. This construct includes core ideology, dynamic capabilities, and societal engagement. The firm’s DNA is communicated to both internal and external stakeholders, and stakeholders’ concerns should be an influence on strategic marketing planning. Performance management is the third major construct in the model and includes corporate social performance and corporate financial performance metrics. Within the model explication, we offer propositions to support market-oriented sustainability research and provide directions for sustainability theory, research, and practice.     

The Emergence of Second‐Tier Auditors in the US: Evidence from Investor Perceptions of Financial Reporting Credibility

We examine changes in the association between auditor type (Big 4, Second‐Tier, and Other non‐Big 4) and perceived financial reporting credibility in the wake of events (e.g., Andersen's failure, the implementation of SOX, creation of the PCAOB, etc.) which led to significant growth in Second‐Tier client portfolios and increased scrutiny of Second‐Tier audit practices. Our results reveal that financial reporting credibility of Second‐Tier clients was lower than that of Big 4 clients and was indistinguishable from that of Other non‐Big 4 clients pre‐Andersen. However, post‐Andersen, we find that financial reporting credibility of Second‐Tier clients is higher than that of Other non‐Big 4 clients and is indistinguishable from that of Big 4 clients. We expect that our results will be of interest to regulators, both in the United States and in the European Union, who have expressed concerns about the current state of competition in the audit market, management and boards of directors that are contemplating switching to a Second‐Tier audit firm, and academics investigating quality differences among audit firm types.     

On the competition enhancing effects of exclusive dealing contracts

Antitrust scholars have argued that exclusive contracts have anticompetitive, or at best neutral effects, if no efficiencies are generated. In contrast, this paper shows that exclusive contracts can have procompetitive effects, provided buyers are imperfect downstream competitors and contract breach is feasible. In that case, an efficient entrant is not necessarily foreclosed through exclusive contracts but induces buyers to breach. Because breaching buyers have to pay expectation damages to the incumbent, the downstream profits they obtain when breaching must be large enough. Therefore, the entrant needs to set a lower wholesale price than absent exclusive contracts, leading to lower final consumer prices and higher welfare.