Get Ahead of the Curve with These Basic Tips for Microsoft’s Least Understood Tool

Microsoft Excel is a tool most of us use but few of us truly understand. From client lists to call sheets, purchase orders to audits, almost every business person has some use for the data management tool that is Excel. Here are six basic tips that can help you get around Excel with greater efficiency and power.

Microsoft Excel Support

  1. How to use Keyboard Shortcuts to get around quickly

There are some basic keyboard shortcuts that will help you navigate around Excel sheets with speed and accuracy. Scrolling around with your mouse is fine, but with large sheets it’s easy to overshoot your mark and spend time scrolling back to where you meant to be. This takes up a surprisingly large amount of time, and can be solved with the following keystrokes.  You can use CTRL + ↑ to jump to the top cell, or CTRL + ↓ to drop to the last cell before an empty cell. This allows you to rapidly and succinctly move around large data sets.

  1. How to use Right Click

Many people, primarily Mac users, are unaware of the power of the right click. It can open up a condensed list of context based options for a specific cell. This can save time and effort rooting around through the menus to find a function. If you are a Mac user you can enable right click functionality in the System Preferences.

Support For Microsoft Excel

  1. How to use the Sort function

Sorting is one of the most powerful functions for manipulating and understanding your data.

Microsoft Excel 2013 Consultant

Sorting enables you to rearrange the data by columns, keeping each row paired with each other as you move the information around. This allows you to bring relevant data to light and keep an ongoing workbook ordered and neat.

Use Microsoft Excel Easily

  1. How to use Automatic SUM

You can quickly add the contents of an entire row or column by clicking in the first empty cell in the column and typing ALT + ‘=’ to sum all the numbers in every cell above.

  1. How to Automatically Adjust Width of Columns

Columns are often not wide enough to accommodate all the text within them, and so often that means that you’re painstakingly dragging out each column to fit its contents. Rather than dragging it out, simply double-click on the seam at the column heading. This will automatically adjust the column to perfectly fit the largest cell, displaying all the information clearly.

  1. How to Copy A Pattern

You can easily copy a set pattern of numbers, days, months or years by clicking and dragging.

Using Microsoft Excel Autofill
Hold your mouse over the dark square that appears when you highlight a pair of cells. When your cursor becomes a cross, click and drag down as far as you need the pattern to go. Excel will do the rest, filling in the cells with the pattern you set in the first two cells.

Contact LAN Infotech by phone at (954) 717-1990 or email at sales@laninfotech.com to learn more about how to master Microsoft Excel.

 

Fort Lauderdale Computer Networks
Network Services in Fort Lauderdale
Network Consulting in Fort Lauderdale
Fort Lauderdale Data Backup
Data Security Fort Lauderdale
 
Client Feedback

“Our experience working with LAN Infotech and its engineers has been very rewarding for our firm. We count on Lan Infotech’s team to engineer, maintain, coordinate and monitor our systems.”

—Ricardo Gonzalez-Rosa
IT Director
Katz Barron Squitero Faust
read more»

Featured IT Services Fort Lauderdale Articles

IT Consulting Advice for Fort Lauderdale: Taking Care of Your Employees Is Taking Care of Your Business!

Quid Pro Quo An IT consulting firm in Fort Lauderdale will usually advise that you get what you give. This is the core principle which defines most working relationships. The employer gives the em

Read more

Featured IT Services

IT Services Business Advice: Do You Really Need a Management Consultant in Fort Lauderdale?

Eliminate the Middleman IT services in Fort Lauderdale need not cost an arm and a leg to provide services your own organization could source internally. You want a consultation agency willing to he

Read more

Featured IT Services

Reasons Why IT Support in Fort Lauderdale is Necessary for Business Growth

IT support in Fort Lauderdale is turning out a necessity for most businesses. This can be pointed to the fact that embracing IT services helps to improve business productivity and efficiency. However,

Read more

Featured IT Services