4IT Blog

4IT has been serving the Miami area since 2003, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Better Ways To Use Microsoft Excel

Tip of the Week: Better Ways To Use Microsoft Excel

There is no denying that, of all the application suites in the world, Microsoft Office is the most famous and most popular. Regardless of their size, businesses rely on these programs in order to function--so much so, that a working knowledge of Microsoft Office is often a prerequisite for employment. However, despite so many people using these programs on such a regular basis, few understand their full capabilities. Take, for example, Excel, Microsoft’s spreadsheet program.

There are plenty of formulas that you can use to enhance your use of your spreadsheet. For starters, let’s review where these formulas should go, and how they should be formatted.

Using Formulas
Microsoft has made using formulas in Excel relatively painless. The process that follows identifies the individual pieces of an Excel formula and how a user can create essentially any formula they need.

Formula Bar in Excel

  1. First, to notify Excel that you will be inputting a formula, the first character that you type into the formula bar should be an equals sign (=).
  2. Then you need to identify the proper action command that will inform the rest of your formula. The formula tab can be referenced to find the correct action command.
  3. Once you’ve done so, identify the letter and number for each cell the action command should apply to inside the parenthesis.
  4. Finally, press the Enter key. If your formula is correct, your data will automatically calculate and populate in the spreadsheet.

Of course, knowing how to use formulas only comes into play when you have formulas to use.
Let’s go over some useful formulas to have up your sleeve as you use Excel.

Total to Find a Sum
=sum(cell1:cell2)
This action will add up all the cells in a given series. Including a colon in the equation tells Excel to include all the cells between the two in its calculation.

=sum(a1:a12)
If you select two cells in the same column, Excel will automatically include any cells between them. As a result, this equation would give the total of all numbers in rows 1 through 12 of column A.

Count Characters in a Cell
=len(cell)
Entering a specific cell into this formula will give you the total number of all letters, numbers, and other characters that are entered into the cell in question. This comes in handy when trying to complete a task with strict character limits, like creating content for Twitter. You can use this formula to ensure that your posts don’t exceed the 140 character limit Twitter enforces.

Calculating Percentages
=(cell1/cell2)
This function gives you a quick percentage calculation based on your selected cells.

  1. FindingExcelPercentage1
  2. FindingExcelPercentage2
  3. FindingExcelPercentage3

Excel also offers a few other useful utilities to make using it easier.

Freeze Panes
Freezing panes keep columns or headers from moving offscreen as you scroll through your spreadsheet, which comes in handy when working with a larger document.

Freeze Pane

Remove Duplicates
If you have a row, column, or even a cell that redundantly repeats (and therefore adds confusion to your spreadsheet) this feature makes it easy to eliminate the extra copies. This could be useful when trying to merge mailing lists that have contacts that overlap.

Remove Duplicates

Excel is designed to enable the work that can be done in a spreadsheet to be as comprehensive as possible, with shortcuts and functions to help conserve time and your team’s energy. This has just been a brief sample of how Excel can help make your business more efficient. For more tips and tricks, keep checking back to 4IT’s blog!

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Monday, 22 January 2018
If you'd like to register, please fill in the username, password and name fields.

Mobile? Grab this Article!

Qr Code

Tag Cloud

security Tip of the Week Technology Cloud Privacy Best Practices Microsoft software Internet Business Computing Hackers Backup Productivity Hosted Solutions Business Management Managed Service Provider Google Malware IT Services Business Efficiency IT Support Windows Disaster Recovery Innovation Hardware Business Continuity Workplace Tips VoIP Mobile Devices User Tips Computer Saving Money Windows 10 Miscellaneous Virtualization Upgrade Network Security Mobile Device Management Data Server Email Mobile Computing communications Alert Communication Network Save Money Microsoft Office Small Business Social Media Smartphone Quick Tips Information Technology Smartphones BYOD Going Green Mobile Office Health Apps Android Office Managed IT Services Outsourced IT Browser Operating System Gadgets Chrome Application Ransomware Managed IT Tablet Cybersecurity Holiday WiFi Firewall The Internet of Things Avoiding Downtime Mobility Productivity Disaster Data Recovery Data Management Risk Management Search Cybercrime History Data Backup Telephone Systems Remote Computing Unified Threat Management IT Solutions Passwords Spam BDR Best Practice Remote Monitoring VPN Employer-Employee Relationship Facebook Budget Apple Automation Hard Drives Vendor Management Marketing Saving Time Hacking Collaboration Phishing Password iPhone Law Enforcement Customer Relationship Management Hosted Solution Wireless Technology Computers Recovery Phone System Big Data Content Filtering Money Office Tips Proactive IT User Error Humor Social Administration Lithium-ion battery Wearable Technology Work/Life Balance Maintenance PowerPoint Current Events Virus Telephony Office 365 Printer USB Analytics Bring Your Own Device Encryption Gmail Router Government Antivirus Vulnerability Shortcut Computer Repair Data Protection Bandwidth Printer Server Laptop OneNote Social Engineering Education Trending Net Neutrality Users Private Cloud Politics Windows 8 Data Security Personal Information Tech Support Outlook Wireless Unsupported Software SaaS Google Drive Cloud Computing Audit App HaaS Point of Sale Save Time IT COnsultant Cost Management Business Intelligence Intranet Identity Theft Customer Service Solid State Drive Update Sports Biometrics Flexibility Retail Virtual Reality Efficency Redundancy Data Storage Meetings Samsung Social Networking Wi-Fi Instant Messaging Emails Emergency Artificial Intelligence HIPAA Applications Entertainment Display Benefits hacker DDoS Computer Accessories Augmented Reality Transportation Compliance Paperless Office Mouse Robot Computer Care Battery Fax Server Two-factor Authentication Workplace Managing Stress Automobile Network Congestion End of Support Excel Streaming Media IT Support Help Desk Uninterrupted Power Supply Windows 10 online currency Internet Exlporer Travel Internet of Things 3D Printing SharePoint Sync Data Loss iOS Employer Employee Relationship Worker Commute Operating Sysytem Managed IT Service Teamwork Managed IT Services Busines Continuity ISP PDF Adobe Files Google Docs Computer Fan Networking Near Field Communication Scalability Safety Programming Text Messaging Blogging Licensing Chromecast Microsoft Excel Dark Web Human Resources IT consulting How To Hard Drive Screen Mirroring Running Cable Upgrades Website Administrator File Sharing Reliable Computing Training Uograde Colocation Images Cast Consultant Windows 10s Bloatware The Blindside Of OneDrive Amazon Access systems Nanotechnology Company Culture Black Market Co-managed IT Touchscreen Hard Disk Drive IT Security Tablets hack Root Cause Analysis Branding Cleaning Experience HBO Distributed Denial of Service Lifestyle best practices Keyboard Avoid Downtime Ebay NFL Computing Cortana Wiring CrashOverride WIndows 7 Inbound Marketing Music Information IT Management eWaste Storage data breach Regulations Hiring/Firing Word Debate Data storage Legislation Settings Value Books WIndows Server 2008 risk management Cameras Smart Technology Video Games Windows Ink User Document Management Data Breach Advertising Patch Management Science Twitter Virtual Desktop Presentation Legal Google Maps Touchpad Commerce Bluetooth Best Available Mobile Device Managed Security Nokia Regulation IT Technicians Surge Protector Software as a Service Television Scam Conferencing Taxes Microsoft Word Buisness Gifts Supercomputer Electronic Medical Records Device Security Gift Giving IT Budget Webinar Devices Reputation Credit Cards IT solutions Spyware Mobile Youtube Microblogging FAQ Professional Services Sales Charger Managed Service Provder Shadow IT Webinar Relocation Wireless Charging WannaCry IT service Evernote Tutorial Comparison Domains Workers Specifications Updates