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
Thursday, December 13 2018

Captcha Image

Tag Cloud

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

Mobile? Grab this Article!

QR-Code dieser Seite

Recent Comments

Phillip Bond A Checklist of 40 Microsoft Software Titles Reaching End of Life/Extended Support in July 2016
11 December 2018
A checklist of the components is done for the widening of the elements. The scope of the check list ...
Erickson Ferry Tip of the Week: Useful Shortcuts for Google
30 November 2018
Your blog was too good. I was exceptionally satisfied to discover this site. I needed to thank you f...
Alex Ling Would Your Users be Tricked by Social Engineering?
27 November 2018
I came to know about the user that was tricked by the users in this community this was all on social...
Daniel Mcmahon Ancient Greek Computer in Serious Need of Firmware Update
23 November 2018
Computers which are imported from the Greek now want to update the all software that is firmware tra...
Cameran Moon Download the Wrong App and Have More Than Pokémon Fever Infect Your Device
22 November 2018
Infra core was the heart of IT they told us that if we download a wrong application it will infect o...