Velocity Technology Partners Blog

Velocity Technology Partners has been serving Athens, Gainesville and North Georgia since 2005, 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 Velocity Technology Partners’s blog!

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Wednesday, July 18 2018

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Tech Support Hackers Data Loss Proactive IT Small Business App Specifications SaaS Productivity intranet Cast Data Theft IT Management Google Assistant Social Media The Internet of Things Artificial Intelligence Streaming Media Virus Internet of Things Wireless Internet Mobile Security Charger Cloud Computing Data Management Compliance Identities Retail Business Printing Smart Tech Cost Management FAQ Android Data Backup Congratulations Device Security Computers Data Privacy Office 365 Holiday Business Continuity Mobile Devices BYOD Microsoft Cortana Hybrid Cloud Computer Forensics User Error Data Bring Your Own Device Ciminal Wi-Fi Best Practice Flexibility Marketing Unified Communications Workers Mobile Device Management Telephone Systems Software Legislation Wireless Charging Antivirus App store iPhone Communications Unsupported Software Applications Mobility Analysis Managed IT services Language Content Filter Browser Emergency Comparison Managed IT Lifestyle PowerPoint IT support Cybersecurity Law Enforcement OneNote Business Computing Telephone Internet Edge Gamification Gmail Commerce Data Security Apple Tip of the Week Network Google eWaste Email Application Vulnerability Windows Ink IoT Server Maintenance Evernote Sales Money Google Docs Hosted Solution Legal Government Spam Fraud VPN IT Services Softphones Licensing Disaster Recovery Networking Identity Managed Service Provider Blockchain Smartphones Operating System Technology Virtualization Tech Term Windows 10 Spyware History Microsoft Word Risk Management Innovation Backup HBO Personal Information Financial Conferencing Company Culture BDR Smartphone User Tips Memory Chrome Ransomware WIndows Server 2008 Excel Security Identity Theft Thank You Passwords Value Apps IT budget Managing Stress Windows Management Computer Data Protection Automation Monitoring Websites Social Engineering Vendor Management Adobe Tablets IT Solutions Outlook Computing Credit Cards Managed IT Services Network Security Two-factor Authentication Sports Gadgets Work/Life Balance VoIp Data Storage Safety Travel Communication Project Management Saving Money Big Data Screen Mirroring Shortcut Hardware Google Maps Outsourced IT Phishing Sync Update Devices Privacy Redundancy Wireless Technology Storage Patch Management Proactive WiFi MSP Employer-Employee Relationship Data Breach Politics Remote Monitoring Efficiency Hosted Solutions Google Drive Router Collaboration Microsoft Excel Remote Computing Cleaning Education Students File Sharing Alert Best Practices Updates Word Chromebook Connectivity WannaCry Content Filtering IT Support Cybercrime Business Management Data Recovery Encryption Twitter NFL Malware Financial Technology Software as a Service Microsoft Office Audit Gifts Cloud Hard Drive