--- title: I Want Highly Informative Excel Spreadsheets description: I Want Highly Informative Excel Spreadsheets image: https://ontimetech.valeonetworks.com/hubfs/Blog%20Images/Imported_Blog_Media/FB_ad_wedwisdom13-1.jpg --- [Skip to the main content.](https://ontimetech.valeonetworks.com/blog/i-want-highly-informative-excel-spreadsheets#main-content) [![OTT powerd by VN big](https://ontimetech.valeonetworks.com/hs-fs/hubfs/OTT%20powerd%20by%20VN%20big.png?width=500&height=175&name=OTT%20powerd%20by%20VN%20big.png "OTT powerd by VN big")](https://ontimetech.valeonetworks.com) [![OTT powerd by VN big](https://ontimetech.valeonetworks.com/hs-fs/hubfs/OTT%20powerd%20by%20VN%20big.png?width=500&height=175&name=OTT%20powerd%20by%20VN%20big.png "OTT powerd by VN big")](https://ontimetech.valeonetworks.com) - [Services](https://ontimetech.valeonetworks.com/our-services/) - [Managed It Services](https://ontimetech.valeonetworks.com/our-services/managed-it/) - [Cybersecurity](https://ontimetech.valeonetworks.com/our-services/cybersecurity/) - [Cloud Solutions](https://ontimetech.valeonetworks.com/our-services/cloud-solutions/) - [Compliance](https://ontimetech.valeonetworks.com/our-services/compliance/) - [Industries](https://ontimetech.valeonetworks.com/industries/) - [Resources](https://ontimetech.valeonetworks.com/resources/) - [Blog](https://ontimetech.valeonetworks.com/blog) - [About](https://ontimetech.valeonetworks.com/about/) - [Client Testimonials](https://ontimetech.valeonetworks.com/testimonials/) [415-294-5250](tel:4152945250) [Client Portal](https://portal.Valeonetworks.com) Toggle Menu Toggle Menu [415-294-5250](tel:4152945250) [Client Portal](https://portal.Valeonetworks.com) - [Services *Toggle Menu*](https://ontimetech.valeonetworks.com/our-services/) - [Managed It Services](https://ontimetech.valeonetworks.com/our-services/managed-it/) - [Cybersecurity](https://ontimetech.valeonetworks.com/our-services/cybersecurity/) - [Cloud Solutions](https://ontimetech.valeonetworks.com/our-services/cloud-solutions/) - [Compliance](https://ontimetech.valeonetworks.com/our-services/compliance/) - [Industries](https://ontimetech.valeonetworks.com/industries/) - [Resources *Toggle Menu*](https://ontimetech.valeonetworks.com/resources/) - [Blog](https://ontimetech.valeonetworks.com/blog) - [About *Toggle Menu*](https://ontimetech.valeonetworks.com/about/) - [Client Testimonials](https://ontimetech.valeonetworks.com/testimonials/) - Example Link - Example Link - Example Link [*Facebook*](https://ontimetech.valeonetworks.com/blog/i-want-highly-informative-excel-spreadsheets#0) [*Instagram*](https://ontimetech.valeonetworks.com/blog/i-want-highly-informative-excel-spreadsheets#0) [*LinkedIn*](https://ontimetech.valeonetworks.com/blog/i-want-highly-informative-excel-spreadsheets#0) [*Twitter*](https://ontimetech.valeonetworks.com/blog/i-want-highly-informative-excel-spreadsheets#0) [*Youtube*](https://ontimetech.valeonetworks.com/blog/i-want-highly-informative-excel-spreadsheets#0) [*Medium*](https://ontimetech.valeonetworks.com/blog/i-want-highly-informative-excel-spreadsheets#0) 2 min read # I Want Highly Informative Excel Spreadsheets [Lance Stone](https://ontimetech.valeonetworks.com/blog/author/ulisticadmin) : May 3, 2017, 11:09:57 AM [Managed IT Services](https://ontimetech.valeonetworks.com/blog/tag/managed-it-services) If you are giving a presentation and part of it involves a shared display or handouts of a spreadsheet what can you do to keep the group awake? Let’s face it, Microsoft Excel is an excellent tool for organizing and manipulating statistical data, but when sharing your spreadsheet with others, your spreadsheet has to be interesting and informative. ![Microsoft Excel Experts](https://ontimetech.valeonetworks.com/hs-fs/hubfs/Blog%20Images/Imported_Blog_Media/FB_ad_wedwisdom13-1.jpg?width=508&height=266&name=FB_ad_wedwisdom13-1.jpg) **How Do I Get More Information into an Excel Spreadsheet?** Before you get more information into your spreadsheet, make sure that a spreadsheet is a right tool for the job. More often than you might think, we use spreadsheets inappropriately. Would an Access database work better? Should you use PowerPoint for your presentation. If you have decided that Excel is the right vehicle for your presentation, include a text document that is a “welcome” or “about” for the Excel document. This keeps you on track and reminds others what the purpose and mechanics of the spreadsheet are. While it’s true that most of the spreadsheets we use in our careers are for our own consumption, it is a good practice to talk about your spreadsheet with others. Find out what features they like and which they don’t favor. If you work collaboratively with others in your organization be generous with credit and be sure to mention their names in the about or welcome document. **PivotTables Help (A lot)** [PivotTables](https://support.office.com/en-us/article/Create-a-PivotTable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576)are important as they take tables of data, often with hundreds if not thousands of rows and help you and others understand the data by summarizing them by the column fields. For a PivotTable to operate correctly it has to be set up in a certain way; each column needs to contain the same kind of data that is in a “raw” state – that is the data has not been processed yet. The following are some advantages associated with using PivotTables in Excel: - Simplicity - Speedily produced - Multiple dimensions – you can sort data by row or by column - Allows for interactive analysis **Appearances Do Matter** Your Excel Presentation can be exciting and visually stimulating. Following are some tips that help you accomplish this. - **Consistency:** Your spreadsheets will be easier for others to understand if you use only one font, bold headings for data groupings and formulae, distinct shade categories of data (for example shade raw data gray and results in green) and analytical comments should be in italics. - **Create a Logical and Natural Flow: **This is done by using the order of Worksheets and the layout of calculations and data to read left to right and top to bottom. An excellent Excel presentation takes the reader through a story – from inputs and assumptions to calculations and finally the results. - ****I Want Highly Informative Excel Spreadsheets**Make Data Relevant:** To be more informative, an Excel spreadsheet presentation needs to have relevant data and analysis stand out. To do this, try to downplay the non-data elements of your tables and graphs. While you might create [axes and gridlines](http://searchengineland.com/10-tips-to-make-your-excel-charts-sexier-135407) the same color, make them paler than the data points. {company} in {city} is your best source for tips, tricks, and hacks as well as news relating to the latest advances in technology. \[Phone} or {email} us today. - [Tweet](https://twitter.com/share) #### ![BusinessOwnerGuidetoM&A-1](https://ontimetech.valeonetworks.com/hs-fs/hubfs/BusinessOwnerGuidetoM%26A-1.png?width=303&height=209&name=BusinessOwnerGuidetoM%26A-1.png) #### Download our eBook*THE ULTIMATE ROADMAP TO CMMC COMPLIANCE* by filling out the form below! [![Challenges and Opportunities in Data Mining in the Insurance Industry](https://ontimetech.valeonetworks.com/hubfs/Blog%20Images/Imported_Blog_Media/ThinkstockPhotos-518778368-1.jpg)](https://ontimetech.valeonetworks.com/blog/challenges-and-opportunities-in-data-mining-in-the-insurance-industry) #### [Challenges and Opportunities in Data Mining in the Insurance Industry](https://ontimetech.valeonetworks.com/blog/challenges-and-opportunities-in-data-mining-in-the-insurance-industry) [Lance Stone](https://ontimetech.valeonetworks.com/blog/author/ulisticadmin) : Nov 23, 2016, 3:36:18 PM Data mining in the insurance industry is extremely important and crucial to the process of information gathering by companies who indemnify those... [Managed IT Services](https://ontimetech.valeonetworks.com/blog/tag/managed-it-services) [Read More](https://ontimetech.valeonetworks.com/blog/challenges-and-opportunities-in-data-mining-in-the-insurance-industry) [![Importance of Managed IT Services in Improving Your Business Operations](https://ontimetech.valeonetworks.com/hubfs/Blog%20Images/Imported_Blog_Media/GettyImages-843016322.jpg)](https://ontimetech.valeonetworks.com/blog/importance-of-managed-it-services-in-improving-your-business-operations) #### [Importance of Managed IT Services in Improving Your Business Operations](https://ontimetech.valeonetworks.com/blog/importance-of-managed-it-services-in-improving-your-business-operations) [Lance Stone](https://ontimetech.valeonetworks.com/blog/author/ulisticadmin) : Mar 5, 2019, 12:59:17 PM The sudden development of IT problems can quickly throw your team’s workday off track. Even simple login issues can prevent you and your employees... [Managed IT Services](https://ontimetech.valeonetworks.com/blog/tag/managed-it-services) [Read More](https://ontimetech.valeonetworks.com/blog/importance-of-managed-it-services-in-improving-your-business-operations) [![The New Smart Watch isn’t a Smart Investment](https://ontimetech.valeonetworks.com/hubfs/Blog%20Images/Imported_Blog_Media/smartwatch.jpg)](https://ontimetech.valeonetworks.com/blog/the-new-smart-watch-isnt-a-smart-investment) #### [The New Smart Watch isn’t a Smart Investment](https://ontimetech.valeonetworks.com/blog/the-new-smart-watch-isnt-a-smart-investment) [Lance Stone](https://ontimetech.valeonetworks.com/blog/author/ulisticadmin) : Dec 19, 2014, 2:41:18 PM Every bit of technology has security threats, including mobile devices. Just because a device is connected by Bluetooth, doesn’t mean it is only... [Managed IT Services](https://ontimetech.valeonetworks.com/blog/tag/managed-it-services) [Read More](https://ontimetech.valeonetworks.com/blog/the-new-smart-watch-isnt-a-smart-investment) ![OTT White logo](https://ontimetech.valeonetworks.com/hs-fs/hubfs/VN%20-%20Division%20Logos/OTT%20Logo/OTT%20White%20logo.png?width=524&height=140&name=OTT%20White%20logo.png)   ##### About About On Time Tech is an IT Support and Computer Services company serving California. We provide services to the areas in and around We know businesses like yours need technology support in order to run highly-effective organizations. Leverage pro-growth technology services for your company now. ##### Explore On Time Time Explore On Time Time - [Our Services](https://ontimetech.valeonetworks.com/our-services/) - [Industries](https://ontimetech.valeonetworks.com/industries/) - [Resources](https://ontimetech.valeonetworks.com/resources/) - [About](https://ontimetech.valeonetworks.com/about/) - [Contact](https://ontimetech.valeonetworks.com/contact/) ##### Contact Contact **San Francisco:** 1717 Fifth Ave San Rafael, CA 94901 [415-294-5250](tel:4152945250) Business Hours: M-F: 8AM-9PM - [Privacy Policy](https://ontimetech.valeonetworks.com/privacy-policy/) © 2026 On Time Tech [*Facebook*](https://www.facebook.com/ontimetechsf/)[*Twitter*](https://twitter.com/on_time_tech?lang=en)[*LinkedIn*](https://www.linkedin.com/company/ontimetech/)[*YouTube*](https://www.youtube.com/channel/UCubqs9PU_WWF-RFhfK9xNpw) [![Alura White logo](https://ontimetech.valeonetworks.com/hs-fs/hubfs/VN%20-%20Division%20Logos/Alura%20White%20logo.png?width=295&height=115&name=Alura%20White%20logo.png)](https://alura.valeonetworks.com/) [![Next.I.T._White-Logo](https://ontimetech.valeonetworks.com/hs-fs/hubfs/Next.I.T._White-Logo.png?width=328&height=136&name=Next.I.T._White-Logo.png)](https://next-it.net/) [![White-OTT-Logo-1-768x253](https://ontimetech.valeonetworks.com/hs-fs/hubfs/White-OTT-Logo-1-768x253.png?width=313&height=103&name=White-OTT-Logo-1-768x253.png)](https://www.ontimetech.com/) [![Valeo-Logo-White (1)](https://ontimetech.valeonetworks.com/hs-fs/hubfs/Valeo-Logo-White%20(1).png?width=288&height=123&name=Valeo-Logo-White%20(1).png)](https://valeonetworks.com/) *Return to Top* ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Lance Stone", "url" : "https://ontimetech.valeonetworks.com/blog/author/ulisticadmin" }, "dateModified" : "2024-01-10T16:29:56.711Z", "datePublished" : "2017-05-03T15:09:57.000Z", "headline" : "I Want Highly Informative Excel Spreadsheets", "image" : [ "https://ontimetech.valeonetworks.com/hubfs/Blog%20Images/Imported_Blog_Media/FB_ad_wedwisdom13-1.jpg" ], "mainEntityOfPage" : { "@id" : "https://ontimetech.valeonetworks.com/blog/i-want-highly-informative-excel-spreadsheets", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://ontimetech.valeonetworks.com/hubfs/OTT%20-%20Color%20Logo.png" }, "name" : "Valeo Networks" } } ```