Velocity Technology Partners Blog

Velocity Technology Partners has been serving Athens, Gainesville and North Georgia since 2005, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: 3 Better Ways To Use Excel

Tip of the Week: 3 Better Ways To Use Excel

Microsoft Excel is more or less synonymous with spreadsheet creation. However, even power users may not know all the tricks that are hidden in the program that can help them save significant time. For this week’s tip, we’ll go over some Excel shortcuts that you may not have known about.

Adding the Same Text to Multiple Cells
It’s a hassle that every Excel user has faced: the same text needs to be inserted into many cells. Fortunately, there’s a simpler way to go about doing this than one cell at a time. If you highlight the cells that need the text entered before typing the text, and press Ctrl and Enter instead of just Enter, your selected cells will have that text added in.

Auto-Sum Shortcut
Excel can naturally be used as a quick-adding calculator, but a quick shortcut can make that easier. Highlighting the cells, you need to add together before pressing Alt and = will give you final sum.

Data Sorting, Made Easier
In those cases where you need your data to be sorted by a particular variable, Microsoft gives you the means to do so in their Auto Filter. Once your spreadsheet is populated with your data, you can select the columns to be filtered by selecting the top rows. Once you’ve done so, click Data. You will then see options for Filter and subsequently, Auto Filter. This adds a drop-down menu to each column, allowing you to sort the entire spreadsheet by that data in that column.

What are your most-used Excel shortcuts? Tell us in the comments, and check back in to the Velocity Technology Partners blog for more useful tips.

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Wednesday, July 18 2018

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Remote Computing Identity Theft Business Computing Outsourced IT Money Computer Forensics Windows Computers Big Data Specifications Compliance Virus Operating System WannaCry FAQ Software as a Service Content Filtering Data Protection Saving Money Google Work/Life Balance Virtualization Server Updates Comparison Security Shortcut Telephone Systems Tech Term Websites Conferencing Vendor Management Fraud Licensing Antivirus Wireless Charging IT Support Phishing User Error Analysis Encryption Safety VoIp Managed IT Monitoring Maintenance WIndows Server 2008 Sales Connectivity Data Loss Financial Technology Managing Stress Google Docs Excel Microsoft Office The Internet of Things Identity Remote Monitoring Gamification Lifestyle Managed IT services Thank You Google Drive Computing Politics Screen Mirroring Cloud Computing Cost Management Audit BDR Mobility Evernote Data Privacy Social Engineering Hybrid Cloud HBO Legislation Law Enforcement Cast Small Business Retail Office 365 IT budget PowerPoint Device Security Innovation Legal Ciminal Malware Microsoft Word Network Networking Communication Commerce Holiday Microsoft Excel Unified Communications Network Security Education Workers Hackers Applications NFL App store Business Continuity Patch Management SaaS Data Management Browser IT support Data Recovery Spyware Unsupported Software Hosted Solutions Communications Vulnerability Android WiFi Memory Redundancy Proactive IT Privacy Company Culture App Social Media Identities Apple Managed Service Provider Spam Internet of Things Computer Data iPhone Microsoft Financial Storage Proactive Wireless Internet Telephone Alert Chromebook IT Management Artificial Intelligence Gmail Twitter Best Practice Hardware Google Assistant Adobe Software Travel Tech Support Mobile Device Management Wi-Fi Cloud Printing Edge Charger Hard Drive Value Softphones Personal Information Windows Ink Smartphone Marketing Ransomware Word Router Managed IT Services Business Management Data Theft Flexibility Content Filter Tip of the Week IT Services Chrome Sync Mobile Devices VPN Two-factor Authentication Bring Your Own Device Cybersecurity Risk Management User Tips Government Cybercrime Congratulations Business Data Security Management Credit Cards Blockchain Data Backup Employer-Employee Relationship Wireless Technology Technology Hosted Solution intranet Email Data Storage Update Outlook Collaboration OneNote Internet Cleaning Cortana IoT Smartphones IT Solutions Application Language Backup Automation Mobile Security Google Maps Productivity Efficiency Gifts Tablets Windows 10 Emergency Gadgets Best Practices Disaster Recovery History Smart Tech Devices Streaming Media Apps Data Breach Students Sports MSP eWaste Passwords Project Management File Sharing BYOD