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
Friday, 23 February 2018

Captcha Image

Tag Cloud

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

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