(703) 288-9767    NTC Store
NTConnections Blog

NTConnections has been serving the Reston area since 2003, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Making Your Excel Use Easier

Tip of the Week: Making Your Excel Use Easier

When it comes to making a spreadsheet, Microsoft Excel is the go-to program for many users. However, many of these users spend much more time creating and formatting these spreadsheets than they have to. For today’s tip, we’ll outline some experience-improving shortcuts that can improve how you use Excel.

Auto Sum Shortcut
You can use Excel as a quick-adding calculator. This can be made even easier with a quick shortcut. Once you’ve highlighted all the cells you’re trying to total up, pressing Alt and = will give you the final result.

Multiple Cells with the Same Text
We’ve all been there--arduously pasting the same text into cell after cell. Fortunately, there’s a shortcut that will let you do the same thing. Again, after highlighting all the cells that need the same text, you simply type the desired input, but press Ctrl and Enter rather than just hitting the Enter button on its own.

Speedy Data Sorting
Sometimes, we need to order the data in a spreadsheet by a particular variable. The Microsoft Auto Filter is a handy way to do so. Once your data is in the spreadsheet, you can select the columns you want to Auto Filter by clicking the top rows. Once that’s attended to, click Data. You will then see the option for Filter and then Auto Filter. This adds drop-down option menus to the top rows of each column, allowing you to sort them based on that column’s data, alphabetizing or grouping the data by its value.

What are your favorite Excel shortcuts? Let us know in the comments, and be sure to come back to the NTConnections blog for more handy tips and trick!



No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Sunday, 21 January 2018

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Security Tip of the Week Technology Cloud Privacy Best Practices Hackers Business Computing Productivity Microsoft Backup Malware Hosted Solutions Internet Mobile Devices Google Efficiency VoIP Business IT Support Miscellaneous IT Services Managed Service Provider Email Server Disaster Recovery Business Continuity Workplace Tips Network Innovation Data Windows Upgrade Software Hardware Business Management Communication Computer Save Money Network Security Saving Money Mobile Device Management Smartphones Android Microsoft Office communications Managed IT Services Virtualization Smartphone Browser Holiday User Tips Windows 10 WiFi Outsourced IT Small Business BYOD Social Media Operating System Mobile Computing Data Backup Computers Hacking Chrome Application Apple Proactive IT Remote Monitoring Avoiding Downtime IT Solutions Cybercrime Alert Automation Information Technology Managed IT Services Passwords Office Marketing Ransomware Budget Collaboration Social Engineering The Internet of Things Big Data Employer-Employee Relationship Quick Tips spam Gadgets Going Green Remote Computing Recovery Health Mobility Bring Your Own Device VPN Telephone Systems Data Recovery iPhone How To Save Time Firewall Managed IT Cloud Computing Two-factor Authentication Bandwidth Compliance Wireless Technology User Error Cybersecurity App Vendor Management BDR Phone System Private Cloud Antivirus Money Content Filtering Vulnerability Downtime Mouse History Tablet Analytics Router Redundancy Value Office 365 Memory IT Support Retail Search Internet of Things Artificial Intelligence Networking Windows 10 Office Tips Lithium-ion battery Risk Management Gmail PowerPoint Website Excel Phishing Flexibility SaaS Identity Theft Data Security Current Events Safety Administration Government Maintenance Credit Cards Entertainment Meetings Running Cable HaaS Unified Threat Management Fax Server Skype Law Enforcement Black Market Mobile Office Data Management Solid State Drive Customer Relationship Management Intranet Data Storage Internet Exlporer Best Available People Workers Word Data storage Business Intelligence Programming Biometrics Business Owner Network Congestion Trending OneNote Apps IT Consultant Hard Drives IT Management Humor Work/Life Balance Facebook Saving Time Statistics Document Management DDoS Online Currency Physical Security Unsupported Software Robot Outlook Public Cloud Environment Printer Google Drive Remote Work Charger Software Tips Virtual Desktop IT service Human Resources Unified Communications Telephony Touchpad Relocation Hybrid Cloud Virtual Reality Print Server Google Docs Computer Care Windows Media Player Uninterrupted Power Supply Training Domains Theft Start Menu HIPAA Audit IaaS Bloatware Spam Blocking Voice over Internet Protocol HBO Cleaning Net Neutrality Hiring/Firing Customer Service Computer Repair Cortana Mobile WIndows 7 Keyboard Screen Mirroring Entrepreneur Multi-Factor Security Fraud Frequently Asked Questions Tech Support Hacker Google Apps Professional Services Managing Stress Cast Cost Management Computer Fan Lifestyle Amazon Tip of the week Virus Shadow IT Applications Touchscreen LinkedIn Wireless Files Science Infrastructure Tools Productivity Streaming Media Password Debate Instant Messaging FENG Data Protection Amazon Web Services Windows Server 2008 Computer Accessories Wi-Fi Shortcut SharePoint Colocation Windows 8 Password Manager Encryption Comparison Bluetooth Online Shopping Windows 7 Cameras Sports Video Surveillance eWaste Computing Infrastructure Tablets Botnet Consultant Monitor Hosted Solution Data Warehousing Notifications Education Specifications USB Evernote Regulations Printer Server YouTube Wearable Technology End of Support Travel Reputation Worker Commute Mobile Device Piracy Social Millennials Wireless Charging Servers NarrowBand Internet exploMicrosoft User Customers Workforce IT Plan Best Practice Company Culture Licensing Social Networking Root Cause Analysis Windows 8.1 Update Samsung Fiber-Optic Flash Chromecast Twitter Advertising Analyitcs Software as a Service Patch Management Data loss Telecommuting Crowdfunding Cables Sync Laptop Settings Scam Distributed Denial of Service Update Scalability Politics Transportation How to webinar Benefits PDF Users Loyalty Conferencing Smart Technology Windows 10s Battery Experience Two Factor Authentication Assessment Music Television Troubleshooting Electronic Medical Records Techology Public Computer Business Mangement Employer Employee Relationship Legal Data Breach Automobile Recycling Emails Books CrashOverride IBM Webinar Emergency Worker Supercomputer Content IT solutions Rootkit Video Games Knowledge Audiobook Netflix