Contact us today!
217-428-6449

Network Solutions Unlimited Blog

Network Solutions Unlimited has been serving the Decatur area since 2013, 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

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 Network Solutions Unlimited’s blog!

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Tuesday, 21 November 2017

Captcha Image

Mobile? Grab this Article!

QR-Code

Tag Cloud

Apps Server Hosted Solutions IT Solutions Small Business Regulation IT Services Internet exploMicrosoft Password Content Data Protection Customer Miscellaneous Computer Care VoIP Thank You Tablets Legislation User Error Productivity Screen Mirroring Hosted Solution Microsoft Office Data Security Word IT solutions Worker Commute Data storage BDR Hard Drives Software Safety Android OneNote Colocation Patch Management Risk Management Technology Google Drive Router USB Managed IT Services Spam Blocking Electronic Medical Records Business Computing Books Files Wireless Technology IT Support Legal Microsoft Excel Artificial Intelligence Phishing Software as a Service Data Loss Proactive IT CrashOverride Outlook Quick Tips Public Cloud Value Hybrid Cloud Operating System Business Intelligence Applications Best Practices Hardware Mobile Device Management Education Computer Accessories Encryption Users Google Docs Training Alert Work/Life Balance Managed IT Service Apple Television iOS Lifestyle Computer Fan Augmented Reality Video Games Travel Gadgets Windows Benefits How To Cybercrime Emergency Unsupported Software Audiobook HaaS Government BYOD Commerce Touchpad Charger Audit Public Computer Adobe Security Save Money Chrome Computers Productivity Shortcut Scam Mobile Devices Cortana WannaCry PDF Retail Data Management Windows 10 Comparison Internet of Things App Outsourced IT Saving Money Computer Upgrade Root Cause Analysis Hackers Remote Computing Keyboard iPhone Data Breach Business Bandwidth Shadow IT Mobile Device Avoiding Downtime Physical Security How to Monitors Email Worker Black Market Google Humor Hacking Managed IT Services Windows Ink Marketing Law Enforcement Instant Messaging Scalability History Cybersecurity Privacy Robot Storage Two-factor Authentication Politics VPN User Tips Congratulations Compliance Best Practice Techology Loyalty Sports Cast NFL Advertising Wi-Fi Nanotechnology File Sharing Data Backup HBO Cost Management Upgrades Cloud Wireless Two Factor Authentication Consultant Bring Your Own Device Cleaning Mobility Office 365 Microsoft Smart Technology Data Storage Reputation Touchscreen End of Support Budget Experience Computing Infrastructure Browser Redundancy Dark Web Internet Cache Google Maps Managed Service Provider Health The Internet of Things Automation Hiring/Firing Licensing Specifications Big Data Social Engineering Smartphones Recovery Unified Threat Management Smartphone Cloud Computing Remote Monitoring Information Technology Windows 10 Settings Private Cloud Relocation Downtime Solid State Drive Spam Communications Webinar Administration Application Automobile Excel Battery Document Management Vendor Management Tip of the Week Transportation Phone System Backup Telephone Systems IT Support Business Continuity Office Tips Disaster Recovery Rootkit Holiday Business Management Efficiency Going Green Data Flexibility Sync Employer Employee Relationship Virtual Reality hacker Personal Information Data Recovery Money Windows 10s Content Filtering Facebook Business Owner Entertainment Internet Exlporer Innovation Network Workplace Tips Collaboration Network Security Professional Services Emails Employer-Employee Relationship Managed IT Chromecast Save Time Hard Disk Drive Monitor Sales HIPAA Troubleshooting Ransomware Gmail Office Social Media SaaS Passwords Meetings WiFi Mobile Search WIndows Server 2008 Bluetooth Vulnerability Virtualization IT Management Samsung Firewall Malware Assessment Laptop

Sign Up for Our Newsletter

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