Connect with us

Hi, what are you looking for?

The American GeniusThe American Genius

Tech News

Magically change Excel spreadsheets to visually pleasing flowcharts

(Tech News) Navigating data in spreadsheets can be difficult. Use Slate to turn facts and figures into easy-to-navigate flowcharts.

slate

Excel sucks – make it better

Navigating data in an Excel spreadsheet can be frustrating, especially if you are trying to follow someone else’s spreadsheet. Excel is great for organizing facts and figures, but it does little in the way of explaining someone’s thought process, which is often critical to understanding the data presented. What if you could see someone’s thought process, as well as a visual representation of how facts and figures are related?

Slate is an add-in for Microsoft Excel (2007, 2010, and 2013) that allows you to turn your spreadsheets into a visual flowchart. Simply select a cell and see its in flowchart style. You can expand each level in the visualization to follow the trail of calculations. This is especially helpful when you need to review someone else’s spreadsheet, as it can be difficult to follow someone else’s thought process; with Slate you can document and explain your logic, so when someone else views it your thought process is clear.

bar
It can also help to simplify the error check process in your spreadsheets without feeling overwhelmed by the data. When Slate pulls information to turn it into a graphic, it grabs your spreadsheet’s headers and allows you to quickly zoom through your it by clicking the icon and expanding or collapsing the branches formed by Slate. When you are done reviewing in Slate, you can return to your Excel sheet with one click, by clicking on any cell’s collapsed link.  This allows you to check a great deal of data, quickly and efficiently.

See mistakes, get through this process more quickly

Using Slate allows you to quickly see mistakes, poorly related information, and issues that could be difficult to explain to a client.

It allows you to optimize your spreadsheet without sifting through each cell looking for potential problems. It also gives you the opportunity to explain anything that may be difficult for someone not directly related to the project to understand. Excel helps you organize facts and figures, but Slate takes them a step further connecting the data visually and making it more digestible, in my opinion.

Advertisement. Scroll to continue reading.

Jennifer Walpole is a Senior Staff Writer at The American Genius and holds a Master's degree in English from the University of Oklahoma. She is a science fiction fanatic and enjoys writing way more than she should. She dreams of being a screenwriter and seeing her work on the big screen in Hollywood one day.

Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Advertisement

The
American Genius
news neatly in your inbox

Subscribe to our mailing list for news sent straight to your email inbox.

Advertisement

KEEP READING!

Opinion Editorials

It is easy to lose sight of everything on your to do list which makes hiring a personal assistant seem super attractive. But do...

Video

This week on AG Live, we talk about the endless Twitter drama (and what establishment media has missed), the Apple lawsuit, AI art, and...

Opinion Editorials

People at the top of their game work less, but with more focus - replicate their good habits to get ahead. Work smarter, not...

Opinion Editorials

Productivity is king in the office, but sometimes distractions and other issues slow you down. So what can you do to limit these factors?

The American Genius is a strong news voice in the entrepreneur and tech world, offering meaningful, concise insight into emerging technologies, the digital economy, best practices, and a shifting business culture. We refuse to publish fluff, and our readers rely on us for inspiring action. Copyright © 2005-2022, The American Genius, LLC.