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