Velocity Technology Partners Blog

Velocity Technology Partners has been serving the Bogart area 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.



No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Tuesday, 20 March 2018

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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