{"id":5059,"date":"2012-11-26T14:36:42","date_gmt":"2012-11-26T20:36:42","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/blog\/?p=5059"},"modified":"2022-07-22T10:15:29","modified_gmt":"2022-07-22T15:15:29","slug":"spreadsheet-misuse-why-it-happens-and-how-to-stop-it","status":"publish","type":"post","link":"https:\/\/www.mrc-productivity.com\/blog\/2012\/11\/spreadsheet-misuse-why-it-happens-and-how-to-stop-it\/","title":{"rendered":"Spreadsheet misuse: Why it happens and how to stop it"},"content":{"rendered":"

\"SaveDo you know why end users still use spreadsheet programs (like Excel) so frequently, despite all of the security concerns? The answer is simple: Spreadsheets are easy.<\/p>\n

Sure, maybe they\u2019ve sat through training classes on how to use your enterprise software. Maybe they already learned about the dangers of spreadsheet misuse<\/span><\/a>. Maybe you\u2019ve even given them a safer alternative to spreadsheets. But, here\u2019s the problem: If the process isn\u2019t as easy (or easier) than Excel, they probably won\u2019t use it.<\/p>\n

The solution: Give users simple, secure web applications that replace the most common Excel uses. In what ways is Excel most commonly used? When you boil it down, end users typically use Excel in three ways:<\/p>\n

    \n
  1. They enter data<\/li>\n
  2. They manipulate (edit, sort, and filter) data<\/li>\n
  3. They analyze data<\/li>\n<\/ol>\n

    If you want to eliminate spreadsheet misuse, give users a better, safer way to accomplish the three tasks listed above. The best way to accomplish this: Give them web applications! Don\u2019t know where to start? Here are some great web applications that replace the most common uses of Excel.<\/a><\/p>\n

    Applications that let users enter data into a database<\/h3>\n

    1. <\/strong>Database Rapid Entry Application<\/span><\/a>: This application lets users add new records to your database using a familiar, spreadsheet-like interface. As you can see in the demo, the Ajax autocomplete feature makes data entry a breeze.<\/p>\n

    Applications that let users manipulate data in a database<\/h3>\n

    1. <\/strong>Database CRUD Application<\/span><\/a>: For those unaware, CRUD is an acronym for \u201cCreate, Read, Update, Delete.\u201d A Database CRUD application lets users create new, or modify existing records in your database.<\/p>\n

    2. <\/strong>Database Update Application<\/span><\/a>: While similar to the CRUD application, the Database Update application lets users edit multiple records at one time.<\/p>\n

    Applications that let users analyze data in a database<\/h3>\n

    1. <\/strong>Interactive Report<\/span><\/a>: This application lets users view their data in any way imaginable. It lets them sort, drill down, and filter their data, and even provides interactive graphs.<\/p>\n

    2. <\/strong>Web Pivot Table<\/span><\/a>: If you want to move users away from Excel, you must provide them with a pivot table alternative. This pivot table application pulls data in real-time from your database, while giving users the same features found in a spreadsheet-based pivot table.<\/p>\n

    Wrap up<\/h3>\n

    Excel misuse creates all sorts of problems for businesses. However, if you want to move your end users away from Excel, simplicity is key. Give them a simple way to accomplish their goals using secure web applications. The web applications listed above give you a good place to start.<\/p>\n

    It\u2019s the best of both worlds: Your users are happy, and your data is secure!<\/p>\n","protected":false},"excerpt":{"rendered":"

    Do you know why end users still use spreadsheet programs (like Excel) so frequently, despite all of the security concerns? The answer is simple: Spreadsheets are easy. Sure, maybe they\u2019ve sat through training classes on how to use your enterprise software. Maybe they already learned about the dangers of spreadsheet misuse. Maybe you\u2019ve even given …<\/p>\n

    Spreadsheet misuse: Why it happens and how to stop it<\/span> Read More »<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","slim_seo":{"title":"Spreadsheet misuse: Why it happens and how to stop it - mrc's Cup of Joe Blog","description":"Do you know why end users still use spreadsheet programs (like Excel) so frequently, despite all of the security concerns? The answer is simple: Spreadsheets ar"},"footnotes":""},"categories":[5],"tags":[44],"class_list":["post-5059","post","type-post","status-publish","format-standard","hentry","category-save-money","tag-spreadsheets"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/5059","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/comments?post=5059"}],"version-history":[{"count":8,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/5059\/revisions"}],"predecessor-version":[{"id":13347,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/posts\/5059\/revisions\/13347"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/media?parent=5059"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/categories?post=5059"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/blog\/wp-json\/wp\/v2\/tags?post=5059"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}