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