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!

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Friday, June 22 2018

Captcha Image

Tag Cloud

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

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 ...