Spreadsheet users often lack advanced design capabilities

Stoller, Jacob
October 2010
CMA Management;Oct2010, Vol. 84 Issue 6, p33
Trade Publication
The article focuses on the aspects of creating spreadsheets. It states that the spreadsheet can be a significant tool, however, many join the profession with inadequate skills. According to Janet Pierce, Fellow Chartered Management Accountant (FCMA), vice president, professional programs, students might graduate and knows how to use Excel, but they cannot design rich spreadsheets to answer issues.


Related Articles

  • Creating an Auditions Spreadsheet. WHITE, AMANDA // Classical Singer;Sep2013, Vol. 26 Issue 7, p20 

    The article offers tips for singers on how to properly use spreadsheets in tracking their auditions through Microsoft Office Excel. It notes the advantage of creating an audition record to help singers remind of the people whom they need to follow up. It also advises singers to include important...

  • Excel tips and tricks. Lont, David // Chartered Accountants Journal;Aug2005, Vol. 84 Issue 7, p78 

    Discusses the approach in manipulating data using the Excel spreadsheet. Tips in forming columns using the reverse process; Approach in determining the length of a name to be entered in a string; Process in correcting fields with incorrect capitalization or too many spaces.

  • Sort your worksheet tabs automatically -- even dates! Hiltz, Kara // Inside Microsoft Excel;Jun2010, Vol. 17 Issue 6, p1 

    The article offers information on how to sort worksheet data in several ways. It notes that in Excel worksheets, data should be manually clicked and dragged to get them in order. It suggests to use macros which allow to sort both text-based and date-based worksheet tabs in ascending or...

  • Refer to documents on the spot by embedding them in your spreadsheet. Thomas, T. L.; Hiltz, Kara // Inside Microsoft Excel;Jun2010, Vol. 17 Issue 6, p6 

    The article offers information on how to embed a word document in an Excel spreadsheet. It provides steps on how to do the process either from scratch or documents that are already existing. It also discusses the two ways on how to edit an embedded word document like editing the document's...

  • MACROS OF THE MONTH.  // Australian PC User;Dec2007, Vol. 19 Issue 12, p94 

    This article explains the use of the PasswordChar property of a text box in hiding information entered into a text box in Word. One can set the PasswordChar property of the text box to an asterisk, so when one type something into the box, it is hidden from view by a series of asterisks. The...

  • Excel formatting tricks. Bradley, Helen // Australian PC User;Apr2006, Vol. 18 Issue 4, p98 

    The article offers techniques for formatting Microsoft Excel worksheets. It provides tips on changing the font style and size. Heading can be moved to the center of the worksheet by clicking the Merge and Center button. It presents process of merging cells. INSET: MACROS OF THE MONTH.

  • 1-2-3 for Windows.  // Accountancy;Jul1993, Vol. 112 Issue 1199, p66 

    Reviews the spreadsheet data management software Lotus 1-2-3 Release 4 for Windows.

  • Bridging the Gap between Spreadsheet Use and Control: An Instructional Case. Loraas, Tina M.; Mueller, Jennifer M. // Journal of Information Systems;Spring2008, Vol. 22 Issue 1, p161 

    End user applications (such as spreadsheets) have been cited as a previously ignored yet potentially significant risk to financial reporting in the wake of The Sarbanes-Oxley Act (PricewaterhouseCoopers [PwC] 2004; Ernst&Young [E&Y] 2004). We developed a realistic spreadsheet model in order to...

  • Two ways to calculate expiration dates when the EDATE function won't work on your terms. Duncan, Julie // Inside Microsoft Excel;Sep2009, Vol. 16 Issue 9, p10 

    The article offers two ways to calculate expiration dates in Microsoft Excel especially when EDATE do not work. EDATE can return to date on the same day of the month, however, it is only wired to count in one-month increments. It stresses the need to install the analysis toolpak to use EDATE by...


Read the Article


Sorry, but this item is not currently available from your library.

Try another library?
Sign out of this library

Other Topics