MERIT Solutions Blog

MERIT Solutions has been serving the Chesapeake area since 1982, 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 MERIT Solutions’s blog!

e-max.it: your social media marketing partner
 

Comments

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

Tag Cloud

Security Tip of the Week Cloud Privacy Technology Business Computing Best Practices Hackers Malware Software Network Security Hosted Solutions Backup Internet google Productivity Computer Microsoft Disaster Recovery Business Continuity Managed IT Services Business IT Support Windows 10 VoIP User Tips Outsourced IT Innovation IT Services Business Management Hardware Mobile Devices communications Managed IT Mobility Email Productivity Smartphone Windows Mobile Device Management Ransomware Efficiency Save Money Cybercrime Saving Money Telephone Systems Server Small Business Law Enforcement Operating System Hosted Solution Quick Tips Android Cybersecurity Data Backup Virtualization Apps Information Technology Chrome Data Recovery Recovery VPN Microsoft Office Passwords browser BYOD Data Password BDR Money Social upgrade Wireless Budget Communication Smartphones Data Management Unsupported Software Cloud Computing Facebook Government Work/Life Balance Google Drive Hacking Avoiding Downtime Health Miscellaneous Managed Service Provider Computers Office 365 Proactive IT Best Practice Politics Social Media USB search Save Time App Risk Management Phishing Managed IT Services Shortcut Automation Wi-Fi Telephony Data Security Firewall Gadgets Application Alert Workplace Tips Current Events Audit Holiday Office tips Applications Private Cloud Personal Information Apple Automobile Streaming Media Commerce Internet of Things WiFi The Internet of Things Saving Time Humor Going Green Disaster Cleaning Windows 10 Bandwidth Office Computer Care Phone System Employer-Employee Relationship Vulnerability Spam Encryption Network Sports Users Identity Theft User Error Data Storage Artificial Intelligence Hacker Solid State Drive Internet Exlporer Flexibility Wireless Technology Gmail Cost Management Update iPhone SaaS IT solutions Mobile Computing Transportation Google Docs Samsung Antivirus DDoS Content Filtering Battery Robot HaaS Data Protection Compliance History Television Social Engineering Remote Computing IT Support End of Support Black Market Laptop Uninterrupted Power Supply Consultant IT Management compaq Windows 10s Smart Technology Nanotechnology Travel Storage Wearable Technology Value Avoid Downtime Shadow IT Touchpad Two-factor Authentication WIndows Server 2008 hp Hard Disk Drive Root Cause Analysis Document Management Reputation Tablets Cortana domain Experience Advertising Patch Management Augmented Reality NFL Data storage Lifestyle Business Intelligence remote Touchscreen Video Games Virtual Reality eWaste Outlook Yahoo Scam Administration Chromecast Word Legislation Running Cable Managed IT Service Server 2008 Music Legal Excel Ali Rowghani iOS Windows Ink Employer Employee Relationship Colocation Trending Hard Drives Comparison Tech Support Analytics Computer Fan Instant Messaging Files Regulation Keyboard Administrator Google Maps Lithium-ion battery Computer Accessories OneNote Worker Commute Specifications Mobile Device Screen Mirroring server installation dvd "cannot install required files" Big Data Data Breach Dark Web Managing Stress Sync stock Access Software as a Service Meetings Relocation Scalability Sales Cast Books Emails tweet Hiring/Firing Education Adobe Data Loss Vendor Management Settings Router How To PDF Retail calculator Marketing Twitter Benefits Licensing control Text Messaging Unified Threat Management HBO Webinar WSJ Mobile Microsoft Excel Training Exchange Entertainment Distributed Denial of Service Upgrades altivista Electronic Medical Records IT solutions Collaboration Point of Sale Professional Services File Sharing Company Culture SBS HIPAA Safety Emergency Worker CrashOverride Thank You Congratulations WannaCry Cache Monitors Remote Monitoring

Mobile? Grab this Article!

QR-Code dieser Seite

Recent Comments

Anna Jackson 5 SEO Tools To Get a Google-Eye View of Your Website
15 September 2017
Hello Randall! I was doing very important work but due to your subject I felt better to stay at you...
David Miller Not all project-management tools are right for all businesses
25 August 2017
All the points depicted by you in this blog is v.apt. I love the title of this blog because it says ...