Advertising
Advertising

10 Common Spreadsheet Mistakes You’re Probably Making

10 Common Spreadsheet Mistakes You’re Probably Making

Spreadsheets are a stable in the business world. If you work anywhere in money, finances, business, or anything similar to those then you likely use a spreadsheet. They’re even used in the military to keep track of supplies. With so many people in so many industries using spreadsheets, you would imagine that people make a lot of errors. Correct! Here are ten common spreadsheet mistakes that you’ve probably made before.

common spreadsheet mistakes

    1. Mistakes in spreadsheet logic

    Spreadsheets are notoriously strict with things like order of operations. If you don’t type your equations and formulas in properly, you will get the wrong math which can wreck an entire spreadsheet. Thankfully there is something you can do about that and it’s simply a matter of using more parenthesis. Put parts of your equations in them in order to get the desired effect.

    common spreadsheet mistakes

      2. Misuse of built-in functions

      A single wrong letter in a function can change its entire meaning. For instance, AVERAGE will ignore all text and false entries. AVERAGEA converts all text and false entries to zero. That one letter can totally change the outlook and values in your spreadsheet. Companies have misused functions and had wrong values in their spreadsheets for years and it caused damage of millions of dollars. If you’re using a function, then double check to make sure you’re using the right ones.

      Advertising

      common spreadsheet mistakes

        3. Not copying all the cells you need

        When you work with spreadsheets, there can be a lot of copying and pasting. It’s a very common problem that people don’t select all the cells they need to copy and paste into the next workbook. If you don’t, you’ll have missing information. That can cause a lot of problems if it isn’t caught. Since spreadsheets can get ridiculously big, this is actually harder than it sounds. If you have 15 years of financial history and you only copy ten years of it, you may not catch that right away.

        common spreadsheet mistakes

          4. Keep your data entry and formula cells separate

          Formula cells and data entry cells should never be anywhere near each other. The reason for this is relatively simple. If you put values in the formula cells that are supposed to be in the data entry cells and vice versa, then you can seriously mess up your books. When you keep them separate, you run little risk of mixing the two up and that keeps your books and your bosses happy.

          Advertising

          common spreadsheet mistakes

            5. Save only when you need to

            This one seems odd but it’s true. You should only save when you need to. This bit of advice flies right in the face of the oft-told advice to save frequently. Here’s why you should only save when necessary. Assuming you hadn’t made a mistake up to the point when you opened a saved spreadsheet, you went through the project with a spreadsheet without a mistake. If you make a mistake and save it for a bunch of times, then your mistake gets saved and you won’t be able to recover your flawless copy later. Thus you should only save when you know what you just did was correct.

            common spreadsheet mistakes

              6. Create new spreadsheets if you want to experiment

              If you want to play around with your spreadsheets, you should make a copy and alter that instead. You should never tinker with your main spreadsheets because you could lose your original copy in the event that you accidentally saved. To avoid what could be a cataclysmic mistake, do yourself a favor and keep copies.

              common spreadsheet mistakes

                7. Give new cells a range name

                Range names can help you keep things organized. You can sort by range name and it helps you find information more quickly. It only makes sense that if you create new cells that you should give them a range name. Not giving new cells a range name can limit how they’re sorted and searched which can make them hard to find. You’d be surprised how many people add new cells to a huge spreadsheet and don’t give them range names. It makes things cluttered and more difficult to work with.

                Advertising

                common spreadsheet mistakes

                  8. Delete range names when you delete all of its cells

                  You should also delete range names when you delete all of its cells and it’s for exactly the same reasons as number seven. When you make major changes to your spreadsheet, you need to update everything around the change in order to ensure proper documentation. Not doing so can cause others to re-enter information that was supposed to be deleted and can also hinder things like searching and sorting.

                  common spreadsheet mistakes

                    9. Check your math

                    This seems like an obvious mistake but it’s absolutely essential. A company named Fidelity once had their books messed up by $2.6 billion over a silly minus sign. You can imagine what effect this had with investors and with the company’s higher ups. One tired night and you tap the minus sign on accident and you can make your company look like it has gained $1.3 billion more than it actually earned. Make sure you check even the most basic arithmetic you perform.

                    Advertising

                    common spreadsheet mistakes

                      10. Have someone double check your work

                      Most of the largest mistakes made in the world of spreadsheets came from people not double checking their work. This mistake is then transferred up the chain of command without anyone else seriously checking everyone else’s work, and it can result in horrible problems. If you work with spreadsheets, then you should find someone to check yours every now and again to make sure the numbers add up. If you’re in charge of people who work on spreadsheets, then you should double check their work more often. An article from 2013 posits that 88% of spreadsheets have an error in them. That’s not a promising number.

                      At the end of the day it comes down to just paying attention. When your eyes stare at tiny numbers in tiny blocks all day long, they’re bound to start missing things. Make sure you take a step away from the computer every now and then and give your eyes and your brain a break. Spreadsheets are great but they’re also very tedious and it’s very easy to make a mistake if you’re not paying attention.

                      Featured photo credit: Sunoray via sunoray.com

                      More by this author

                      10 Benefits of Sleeping Naked You Probably Didn’t Know 12 Inspirational Speeches That Teach You the Most Valuable Life Lessons 15 Most Effective Cool Down Exercises For Every Workout 10 Things Guys Love That You Didn’t Expect 20 Google Search Tips to Use Google More Efficiently

                      Trending in Technology

                      1 Best 5 Language Learning Apps to Easily Master a New Language 2 18 Best Time Management Apps and Tools (2019 Updated) 3 20 Best Productivity Apps for Mac You Should Have in 2019 4 40 Top Productivity Apps for iPhone (2019 Updated) 5 How to Improve Your Computer Skills to Get Ahead in Your Career

                      Read Next

                      Advertising
                      Advertising
                      Advertising

                      Published on January 18, 2019

                      Best 5 Language Learning Apps to Easily Master a New Language

                      Best 5 Language Learning Apps to Easily Master a New Language

                      Learning a new language is no easy feat. While a language instructor is irreplaceable, language learning apps have come to revolutionize a lot of things and it has made language learning much easier. Compared to language learning websites, apps offer a more interactive experience to learn a new language.

                      The following language learning apps are the top recommended apps for your language learning needs:

                      1. Duolingo

                        Duolingo is a very successful app that merged gamification and language learning. According to Expanded Ramblings, the app now counts with 300 million users.

                        Duolingo offers a unique concept, an easy-to-use app and is a great app to accompany your language acquisition journey. The courses are created by native speakers, so this is not data or algorithm-based.

                        The app is free and has the upgrade options with Duolingo Plus for $9.99, which are add free lessons. The mobile app offers 25 languages and is popular for English-speaking learners learning other languages.

                        Advertising

                        Download the app

                        2. HelloTalk

                          HelloTalk aims to facilitate speaking practice and eliminate the stresses of a real-time and life conversation. The app allows users to connect to native speakers and has a WhatsApp like chat that imitates its interface.

                          There is a perk to this app. The same native speakers available also want to make an even exchange and learn your target language, so engagement is the name of the game.

                          What’s more, the app has integrated translation function that bypasses the difficulties of sending a message with a missing word and instead fills in the gap.

                          Download the app

                          Advertising

                          3. Mindsnacks

                            Remember that Duolingo has integrated gamification in language learning? Well, Mindsnacks takes the concept to another level. There is an extensive list of languages available within the app comes with eight to nine games designed to learn grammar, vocabulary listening.

                            You will also be able to visualize your progress since the app integrates monitoring capabilities. The layout and interface is nothing short of enjoyable, cheerful and charming.

                            Download the app

                            4. Busuu

                              Bussu is a social language learning app. It is available on the web, Android, and iOS. It currently supports 12 languages and is free.

                              Advertising

                              The functionality allows users to learn words, simple dialogues and questions related to the conversations. In addition, the dialogues are recorded by native speakers, which brings you close to the language learning experience.

                              When you upgrade, you unlock important features including course materials. The subscription is $17 a month.

                              Download the app

                              5. Babbel

                                Babbel is a subscription-based service founded in 2008. According to LinguaLift, it is a paid cousing of Duolingo. The free version comes with 40 classes, and does not require you to invest any money.

                                Each of the classes starts with with a sequential teaching of vocabulary with the help of pictures. The courses are tailor made and adapted to the students’ level, allowing the learning to be adjusted accordingly.

                                Advertising

                                If you started learning a language and stopped, Babbel will help you pick up where you started.

                                Download the app

                                Takeaways

                                All the apps recommended are tailored for different needs, whether you’re beginning to learn a language or trying to pick back up one. All of them are designed by real-life native speakers and so provide you with a more concrete learning experience.

                                Since these apps are designed to adapt to different kinds of learning styles, do check out which one is the most suitable for you.

                                Featured photo credit: Yura Fresh via unsplash.com

                                Read Next