window._mfq = window._mfq || []; (function() { var mf = document.createElement("script"); mf.type = "text/javascript"; mf.async = true; mf.src = "//cdn.mouseflow.com/projects/0148bb62-7ff8-46ae-a466-bf3fd13c7d09.js"; document.getElementsByTagName("head")[0].appendChild(mf); })();
407-478-6600    Get SUPPORT

TaylorWorks 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!

Some Businesses Don’t Need Every Bell and Whistle
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, October 18 2018
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Tag Cloud

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

Mobile? Grab this Article!

QR-Code dieser Seite