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