shutterstock 99713225 TEST SIZE V8 051016

 

 "Only the Client can define Quality."

Have IT Questions?
Call us now (888) 894-6411

TWINTEL Solutions 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
Thursday, December 13 2018
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Mobile? Grab this Article!

QR-Code

Our 10 Benefits

Our 10 Benefits Whitepaper

This whitepaper will evaluate the differences between traditional technical support practices and modern managed IT practices and the pros and cons of both in regards to small and medium-sized businesses.

Download Now!   Need A Consultation?

Tag Cloud

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