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
Tuesday, February 19 2019

Captcha Image

Tag Cloud

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

Mobile? Grab this Article!

QR-Code dieser Seite

Recent Comments

JordaBale Tip of the Week: 10 Technology Practices To Improve Business As Usual
11 February 2019
Just to make your business more progressive you have to follow some techniques and tips. In this reg...
Gabrielle Kolios Microsoft Moves to Get a Piece of the Technology as a Service Market Share
08 February 2019
The company of the Microsoft has been really now understood the technology which have to be supposed...
AngusCousens Tip of the Week: How To Enable Flash In Google Chrome
06 February 2019
Google is another popular makeup brand. Ladies can get products for eye makeup also. They can use ht...
Cannedguds These 3 Industries are Being Fundamentally Changed by Smart Technology
29 January 2019
While I support the idea of automated or driverless cars in theory, at the moment they just simply m...
Joan Cameron Tip of the Week: 4 Tools that Provide Your Employees With Greater Flexibility
21 January 2019
These are very helpful tools with we can get rid from lots of unwanted efforts of work. Best essay w...