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

                      Joseph Hindy

                      A writer, editor, and YouTuber who likes to share about technology and lifestyle tips.

                      12 Inspirational Speeches That Teach You the Most Valuable Life Lessons 10 Benefits of Sleeping Naked You Probably Didn’t Know 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 10 Best Monitors for Your PC Under $100 2 10 Best Spy Apps for iPhone in 2020 3 How To Choose The Best iPad Screen Protector (With 10 Recommendations) 4 10 Best Headsets for Video Chats and Conference Calls 5 10 Best Mechanical Keyboards to Type Faster

                      Read Next

                      Advertising
                      Advertising
                      Advertising

                      Published on September 17, 2020

                      10 Best Monitors for Your PC Under $100

                      10 Best Monitors for Your PC Under $100

                      Are you looking for the best monitor under $100?

                      Whether you want it for your home office, editing photography, or gaming, you don’t need to spend big bucks on a display screen because a low budget one will certainly do the trick.[1]

                      We can almost hear you having second thoughts about the picture quality, but you don’t have to worry at all.[2]

                      Our list of the best monitors under $100 will be more than enough to cover you. Just go through it now, and you’ll find yourself a bargain.

                      Why You Should Trust Us

                      Our list incorporates some of the best low-budget monitors available in the market. Their efficiency and distinctive traits enable them to stand out from others.[3] The hand-picked ones below are incredibly slick and have a high refresh rate, fast response time, high resolution, and built-in speakers.

                      1. Acer Ultra Thin Frame Monitor

                        Our first affordable computer screen is Acer’s 21.5-inch ultra-thin frame monitor. It has a refresh rate of 75Hz using an HDMI port and offers a full HD widescreen display.

                        Its brightness can be maxed out at 250 nits. It has a slight tilt angle ranging from -5 to 15, as well as Radeon free sync technology.

                        Advertising

                        Buy this computer monitor.

                        2. Sceptre Ultra-Thin Display

                          Sceptre is another company that provides excellent displays for your CPU. The screen size is a little smaller at 20 inches, but it’s made up for the slightly lower price than Acer. It also comes with two HDMI ports and built-in speakers and is wall mount ready.

                          Buy this computer monitor.

                          3. ViewSonic LED Monitor

                          best monitor

                            If you want the best monitor to set up in your office or around the house, ViewSonic’s LED screen is another good option to buy. The resolution is full HD and has a broader tilt ranging from -5 to 23 degrees.

                            On top of that, the product comes with a 3-year warranty. Included in the bundle are a VGA cable, monitor, power cable, and audio cable.

                            Buy this computer monitor.

                            Advertising

                            4. ViewSonic Gaming Screen

                              While we just covered a ViewSonic monitor, this one is specifically built for gaming in mind.

                              Overall, this computer screen provides the same specs as the previously mentioned item. The key differences are that this one is slightly longer, comes with pre-set customizable visual modes, and offers a maxed out contrast, delivering a dynamic contrast ratio for sharp and crisp images. It also comes with a DVI cable.

                              Buy this computer monitor.

                              5. Asus Back Lit Monitor

                              best monitor

                                If you don’t mind spending a little more money, you can get an Asus Back Lit Monitor for your PC. A lot of the focus is on image quality, particularly having a strong contrast ratio and smart video technology for straight viewing. That feature also helps in reducing blue light since you’ll have more flexibility with the colors and brightness.

                                Buy this computer monitor.

                                6. Asus Back Lit Display

                                Advertising

                                  Another alternative to the previous Asus monitor is this one. It has a smaller contrast ratio, though it still delivers a smooth video display. You also have aspect controls, so you can adjust its display.

                                  Buy this computer monitor.

                                  7. Dell Ultrasharp Panel Monitor

                                  best monitor

                                    If you’re looking for the basic features, look no further than Dell. There’s nothing particularly fancy about this panel screen, but it does the job well for any computer.

                                    Its response time is 8ms, which is typical for a monitor. It can come in either silver or black.

                                    Buy this computer monitor.

                                    8. ViewSonic Frameless Monitor

                                      If you liked ViewSonic’s LED monitor but wanted a little more features, we suggest looking at their frameless display. While it boasts similar specs as the brand’s other monitors, it offers color correction and dual built-in speakers, making it ideal for office and home use. It’s also 22 inches long.

                                      Advertising

                                      Buy this computer monitor.

                                      9. Dell Mountable LED-Lit Monitor

                                        For a dependable display with a good frame rate, Dell has a mountable, LED-lit monitor in the market. It measures 18.5 inches, has an adjustable arm, and has been through rigorous testing for long-lasting reliability. You can’t go wrong with this best monitor either.

                                        Buy this computer monitor.

                                        10. Sceptre Monitor

                                          The final screen to cover comes from Sceptre. Compared to the ultra-thin version mentioned above, this one is available in 22 inches. Beyond that, it’s your standard display that provides decent tilting at -5 to 15 degrees, wall-mounted capabilities, 5ms response time, and built-in speakers.

                                          Buy this computer monitor.

                                          Final Thoughts

                                          Finding one of the best monitors around can be tricky. If you’re looking for an affordable one that can last for years, consider picking a computer screen from this list.

                                          Featured photo credit: Sebastian Bednarek via unsplash.com

                                          Reference

                                          Read Next