Eclipse Integrated Systems Blog

Eclipse Integrated Systems has been serving the Bridgewater area since 1994, 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 Eclipse Integrated Systems’s blog!

 

Comments

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

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

Sign up for our Newsletter!

  • Company Name *
  • First Name *
  • Last Name *

      Latest News

      Eclipse Integrated Systems launches new website!

      Eclipse Integrated Systems is proud to announce the launch of our new website at www.eisystems.com. The goal of the new website is to make it easier for our existing clients to submit and manage support requests, and provide more information about our services for prospective clients.

      Read more ...

      Account login