ct logo wslogan

i-medIT Blog

At i-medIT, we provide a comprehensive range of computer and technology solutions to small business owners and Ambulatory Health Care entities. We specialize in helping companies focus on their business by leveraging IT to serve their goals and objectives rather than being a distraction.
Customers come to us for managed services, healthcare IT, project management, IT consulting, HIPAA Compliance, PCI Compliance, server virtualization, and data backup. These core services help our customers run their own companies and take their business goals to the next level.

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 i-medIT blog for more handy tips and trick!

 

Comments

No comments made yet. Be the first to submit a comment

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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