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

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
Wednesday, 21 February 2018

Captcha Image

Mobile? Grab this Article!

QR-Code

Tag Cloud

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

Sign Up for Our Newsletter

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