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.

  • 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...

  • 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...

  • Save re-typing time: Rearrange your names with a formula instead. Duncan, Julie // Inside Microsoft Excel;Jun2010, Vol. 17 Issue 6, p4 

    The article offers information on how to transpose and separate first and last names without having to retype them by using formulas in Excel worksheet. It presents instructions on how to do the process and suggests to avoid an error in deleting the original data. It also shows the steps on how...

  • 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...

  • Don't count out conditional formatting just because you're using a PivotTable. Kuhn, Frank; Soos, Kara // Inside Microsoft Office (15506622);Dec2012, Vol. 19 Issue 12, p9 

    The article offers information on the use of conditional formatting in PivotTables of Microsoft Excel. Topics discussed include the creation of PivotTable from the data, the application of non-contingent conditional formatting, copying the conditional formatting to other data cells, and applying...

  • 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...


Read the Article


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

Try another library?
Sign out of this library

Other Topics