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 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

“LAN Infotech has been an exceptional resource for our organization. They provide consistent knowledgeable network engineers, round the clock monitoring and are invaluable in our IT infrastructure decision-making process. Their level of customer service has been top-notch and exceeds our expectations – we look forward to a continued partnership with LAN Infotech.”

—Janice M. Pennington
Vice-President of Finance & Administration
National Multiple Sclerosis
Society South Florida Chapter
read more»

Featured IT Services Fort Lauderdale Articles

LAN Infotech Recognized as Leading Microsoft Marketing Partner Worldwide

The team of IT specialists from LAN Infotech are thrilled to announce that they have been recognized on Fifty-Five and Five’s Inbound Marketing Excellence Report as one of the top 250 Microsoft mark

Read more

Featured IT Services

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