4IT Blog

4IT has been serving the Miami area since 2003, 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 4IT’s blog!

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Sunday, 19 November 2017
If you'd like to register, please fill in the username, password and name fields.

Mobile? Grab this Article!

Qr Code

Tag Cloud

security Tip of the Week Technology Cloud Privacy Best Practices Microsoft software Internet Business Computing Backup Hackers Productivity Hosted Solutions Business Management Managed Service Provider Google Malware IT Services Business Efficiency Windows IT Support Disaster Recovery Innovation Hardware Business Continuity Workplace Tips VoIP Saving Money Computer User Tips Upgrade Miscellaneous Virtualization Windows 10 Mobile Device Management Mobile Devices Data Server Network Security Mobile Computing Alert Email Communication Network Save Money Microsoft Office Smartphone Small Business communications Quick Tips Going Green Mobile Office Information Technology Social Media Smartphones BYOD Apps Health Android Office Browser Gadgets Operating System Chrome Managed IT Services Outsourced IT Application Ransomware Disaster Mobility Tablet WiFi Holiday Productivity Firewall Avoiding Downtime Managed IT Spam BDR Risk Management Search Best Practice Data Management Cybercrime The Internet of Things Passwords Remote Computing Telephone Systems Cybersecurity Unified Threat Management IT Solutions Automation Saving Time Hacking History Remote Monitoring VPN Apple Facebook Employer-Employee Relationship Vendor Management Budget Hard Drives Proactive IT Data Recovery Office Tips User Error iPhone Customer Relationship Management Money Collaboration Data Backup Phishing Password Wireless Technology Hosted Solution Computers Big Data Law Enforcement Marketing Recovery Phone System Content Filtering Analytics Encryption Office 365 Router Gmail Humor Vulnerability Administration Government Wearable Technology Lithium-ion battery Antivirus Maintenance PowerPoint Shortcut Virus Social Current Events Telephony Printer Bring Your Own Device Work/Life Balance USB Point of Sale IT COnsultant Computer Repair Politics App Personal Information SaaS Cost Management Audit Intranet HaaS Bandwidth Wireless Printer Server Unsupported Software Business Intelligence Laptop Google Drive Users Cloud Computing OneNote Save Time Windows 8 Education Social Engineering Trending Data Security Net Neutrality Data Protection Private Cloud Tech Support Outlook Mouse Emergency IT Support Compliance Artificial Intelligence Workplace Applications Windows 10 Streaming Media Two-factor Authentication hacker Uninterrupted Power Supply Managing Stress Excel online currency Transportation Robot Computer Care Battery Data Storage Travel Social Networking Automobile End of Support Customer Service Efficency Update Biometrics Retail Virtual Reality Internet Exlporer Meetings Internet of Things Identity Theft Display Solid State Drive Instant Messaging Emails Flexibility Sports HIPAA Augmented Reality Entertainment Network Congestion Paperless Office Benefits Computer Accessories DDoS Samsung Wi-Fi Fax Server Help Desk Distributed Denial of Service Administrator Training Patch Management Nokia Colocation Consultant Google Maps WIndows 7 Storage The Blindside Of Commerce Inbound Marketing eWaste Access Company Culture Regulation Regulations Black Market Touchscreen Software as a Service IT Security Value Twitter Cleaning Sync Cameras Experience iOS Surge Protector Data Loss User Science Keyboard Managed IT Service Avoid Downtime Television Virtual Desktop Adobe 3D Printing Presentation Managed IT Services Music Computer Fan Bluetooth Google Docs Best Available Hiring/Firing IT Technicians Data storage Hard Drive Licensing Books Dark Web SharePoint Microsoft Excel ISP Smart Technology Screen Mirroring Video Games Images Document Management Uograde Data Breach Blogging Advertising Teamwork File Sharing Programming Cast Busines Continuity Legal Touchpad Networking Mobile Device Near Field Communication Windows 10s Managed Security Nanotechnology Website systems Scam Human Resources Tablets IT consulting Hard Disk Drive OneDrive Root Cause Analysis Running Cable hack Employer Employee Relationship HBO Amazon Wiring Information Co-managed IT Operating Sysytem NFL Reliable Computing Worker Commute best practices Cortana CrashOverride PDF Bloatware IT Management Scalability Debate Files data breach Lifestyle Word Legislation Safety Settings Ebay Text Messaging WIndows Server 2008 Computing How To Chromecast risk management Branding Upgrades Windows Ink Comparison Specifications Tutorial IT service Shadow IT Relocation Domains Webinar Gift Giving Microblogging Youtube Buisness Mobile IT solutions Sales Professional Services Managed Service Provder Webinar Taxes Supercomputer Electronic Medical Records IT Budget Reputation