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.

 

Comments

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

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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

Blog Archive

February
March
April
May
June
July
August
September
October
November
December