Infracore LLC Blog

Tip of the Week: Excel Features for the Power User

Tip of the Week: Excel Features for the Power User

As useful as a spreadsheet can be to convey information, they can be a little drab and disengaging if the full capabilities of Microsoft Excel aren’t understood and leveraged. For today’s tip, we’ll go over a few little-known and underutilized features that can help you create spreadsheets with both more style, and more utility.

Visible Zeros
There is a fair chance that, at some point, you will need to input data into Excel that begins with zeroes, whether you’re documenting serial numbers or what have you. The trouble is, Excel has a habit of hiding these zeros, so 0056907 would display as 56907. This unfortunately renders the data inaccurate. However, an easy fix to this is to just add a quotation mark in front of the number. This prevents the zeros from being omitted, so instead of resulting in 56907, you would keep your original “0056907.

Adding a Drop-Down List
Adding a drop-down list to a spreadsheet is a simple, yet effective way to limit the input a particular cell will accept. The first thing you have to do is select the cell that needs to have drop-down capabilities, and then click Validate in the Data tab in the header menu. On the Settings page of the window that pops up, there will be a menu labelled Allow. From that menu, select List and highlight the cells that make up the options you want in your drop-down, and finally, click OK.

Accessing Tools on the Developer Tab
Depending on your needs, you may require some more advanced capabilities in your spreadsheet, like creating option buttons, creating macros, and other features. These can all be found in the Developer tab, which is hidden by default. In order to access it, you will first have to access the Excel menu at the top of your screen and select Preferences. Once you’re provided with the Preferences menu, select Ribbon & Toolbar. You will then see a list of the various options that you can add or remove from your Tabs. Selecting Developer will give you access to the tools that tab contains.

Shading Every Other Row
If spreadsheets have any faults, the eye can easily wander when one is looking at them. Adding shading to the formatting, more specifically, to break up individual rows can be very helpful to someone trying to read the information the spreadsheet has to share. To do this, you will need to highlight the area where you want to display the effect or use the Select All shortcut (Ctrl + A) to apply the effect to the entire sheet. In the Home tab, click into Conditional Formatting and select New Rule from the drop-down menu. You will then have a Style drop-down menu to select from, from which you should pick Classic, after which you should select Use a formula to determine which cells to format. Enter the formula =MOD(ROW(),2) and pick your desired color, and your spreadsheet should be striped quite nicely.

Do you know any other tricks to improve the use of Microsoft Excel? Share them in the comments!

5 Useful Cloud Apps for Small Businesses
The 3 F’s of a VoIP Solution
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Saturday, October 20 2018

Captcha Image

Tag Cloud

Tip of the Week Security Technology Privacy Best Practices Cloud Business computing Network Security Hackers Google Malware Microsoft Software Internet Data Innovation Backup Smartphones Hardware Tech Term Windows 10 Browser Hosted Solutions Email Mobile Devices VoIP Computer Android Business Continuity Business User Tips Alert Workplace Tips Data Backup IT Services Small Business Managed IT Services Office Communications Computers Disaster Recovery Business Management Ransomware Miscellaneous Outsourced IT Cloud Computing Smartphone Productivity Cybercrime Efficiency Law Enforcement Artificial Intelligence Data Recovery Communication Password Applications Money Facebook Virtualization Passwords Windows 10 Windows Social Media How To Telephone Systems Network Chrome Collaboration Cybersecurity Router Internet of Things Managed IT Services Productivity Health Work/Life Balance Social Engineering Gadgets Server App Saving Money Quick Tips Upgrade Office 365 Vulnerability Information Data Protection Spam Bring Your Own Device Apps Save Money Two-factor Authentication Private Cloud Mobile Device Management HaaS Holiday Office Tips Connectivity Keyboard IT Support Phishing Google Drive Automation Word Microsoft Office IT Support Data Security Scam Data Breach Hacking Wi-Fi Windows 7 Paperless Office Electronic Medical Records Content Management PDF Samsung Settings Bandwidth Data Management Training BYOD Managed Service Entertainment Data Storage Business Intelligence Virtual Assistant Mobile Device Blockchain Managed Service Provider USB Value Firewall Networking OneNote Update Government Marketing Identity Theft Redundancy Infrastructure IT Management Encryption Battery Telephone System Employer-Employee Relationship Avoiding Downtime Sports Spam Blocking Public Cloud Charger Patch Management IT Plan VPN Remote Computing Operating System Fraud Cleaning Flexibility End of Support Worker Unsupported Software BDR History Remote Monitoring Comparison Big Data Managed IT Website Legal CES Computer Care Mobility Automobile Google Apps Employer Employee Relationship Cast Specifications Books Assessment Amazon Web Services Nanotechnology Safe Mode IT Consultant Botnet Voice over Internet Protocol Best Practice iPhone Wireless Internet Warranty Wearable Technology Outlook HVAC Benefits Skype Recovery Recycling Advertising Wiring Emails Remote Work Practices Solid State Drive Flash Techology Workers Users Addiction Relocation User Error Computer Accessories Information Technology Digital Signature Machine Learning Television Online Shopping Smart Tech Leadership Meetings Travel Content Wire Printer Frequently Asked Questions Hosted Computing Monitor Enterprise Content Management Start Menu eWaste Unified Threat Management Vendor Management Search Public Computer Audit Virtual Reality Cache MSP Bluetooth Millennials Instant Messaging YouTube Emergency Evernote Save Time Multi-Factor Security Video Games HIPAA Audiobook Mouse Troubleshooting Loyalty Excel Credit Cards How to Inventory Password Management Smart Technology Current Events Tools Criminal Mobile Computing IT solutions Physical Security Computer Fan Sync Password Manager Worker Commute Humor Internet Exlporer File Sharing Workforce Wireless Charging Education Devices Files Data loss Trending Human Resources Smart Office SaaS Tip of the week Black Market Access Control Data storage NIST Two Factor Authentication Knowledge Downtime Google Docs Hybrid Cloud Camera Experience The Internet of Things Business Mangement Augmented Reality Risk Management webinar Accountants Windows 10s Windows Server 2008 Cortana Computing Infrastructure Thought Leadership Hiring/Firing Screen Mirroring Scalability Staff Document Management Amazon Authentication Cryptocurrency Network Congestion Root Cause Analysis Apple Music HBO Servers Transportation Safety FENG Telephony Gmail Internet exploMicrosoft Remote Worker Politics Rootkit Conferencing Software Tips Wireless Telecommuting Twitter Thank You Congratulations Webinar CrashOverride WiFi Company Culture Compliance Administrator Managing Stress Regulation Printers

Mobile? Grab this Article!

QR-Code dieser Seite

Recent Comments

JeffreyKGuertin Tech Term: Modems and Routers Defined
18 October 2018
Thank you so much for defining here the modems and routers to give us better information about this....
Shay Stuart How the Convenience of The Internet of Things Can Come Back to Bite Us
17 October 2018
This is a very important share that delivers facts about the utilization of internet tools in differ...
Isla Tait It Pays to Outsource Your IT
15 October 2018
New IT project that show us a new outcome that has been to prepare this setup that was god to know o...
ClarenceEHaynes 11 Ways to Enhance Android Security
15 October 2018
I really impressed from your working, after reading this 11 ways to enhance android security and dis...
technicalsupport VoIP Delivers Benefits That a Traditional Phone System Can’t
13 October 2018
http://Www.Office.Com/Setup | Microsoft http://Office.Com/Setup :- Office setup suite is an importan...