Chicago (The Loop)
Chicago (West Loop)
Chicago (Wacker)
Houston (Theater District)
Houston (Scanlan Building)
Dallas (Katy Building)
Charlotte (Uptown)
Jacksonville (Groover-Stewart Building)
Seattle (Pioneer Building)
Alexandria (Old Town)
Indianapolis (Circle Tower)
Pittsburgh (Golden Triangle)
San Diego (Gaslamp)
Denver (16th Street)
Chicago (River North)
Kansas City (Kessler Building)
Richmond (Shockoe Slip)
Nashville (5th Avenue)
Minneapolis (Lasalle Building)
Boulder (15th and Canyon)
Cincinnati (Hooper Building)
Savannah (Johnson Square)
Phoenix (Midtown)
Chicago (Superior)
Minneapolis (TriTech Center)
Madison (The Capitol)
Orlando (Angebilt Building)
Denver (Trinity Place)
Milwaukee (Cathedral Square)
America Chicago
America Adak
America Anchorage
America Anguilla
America Antigua
America Araguaina
America Argentina - Buenos Aires
America Argentina - Catamarca
America Argentina - Cordoba
America Argentina - Jujuy
America Argentina - La Rioja
America Argentina - Mendoza
America Argentina - Rio Gallegos
America Argentina - Salta
America Argentina - San Juan
America Argentina - San Luis
America Argentina - Tucuman
America Argentina - Ushuaia
America Aruba
America Asuncion
America Atikokan
America Bahia
America Bahia Banderas
America Barbados
America Belem
America Belize
America Blanc-Sablon
America Boa Vista
America Bogota
America Boise
America Cambridge Bay
America Campo Grande
America Cancun
America Caracas
America Cayenne
America Cayman
America Chicago
America Chihuahua
America Costa Rica
America Creston
America Cuiaba
America Curacao
America Danmarkshavn
America Dawson
America Dawson Creek
America Denver
America Detroit
America Dominica
America Edmonton
America Eirunepe
America El Salvador
America Fort Nelson
America Fortaleza
America Glace Bay
America Godthab
America Goose Bay
America Grand Turk
America Grenada
America Guadeloupe
America Guatemala
America Guayaquil
America Guyana
America Halifax
America Havana
America Hermosillo
America Indiana - Indianapolis
America Indiana - Knox
America Indiana - Marengo
America Indiana - Petersburg
America Indiana - Tell City
America Indiana - Vevay
America Indiana - Vincennes
America Indiana - Winamac
America Inuvik
America Iqaluit
America Jamaica
America Juneau
America Kentucky - Louisville
America Kentucky - Monticello
America Kralendijk
America La Paz
America Lima
America Los Angeles
America Lower Princes
America Maceio
America Managua
America Manaus
America Marigot
America Martinique
America Matamoros
America Mazatlan
America Menominee
America Merida
America Metlakatla
America Mexico City
America Miquelon
America Moncton
America Monterrey
America Montevideo
America Montserrat
America Nassau
America New York
America Nipigon
America Nome
America Noronha
America North Dakota - Beulah
America North Dakota - Center
America North Dakota - New Salem
America Ojinaga
America Panama
America Pangnirtung
America Paramaribo
America Phoenix
America Port-au-Prince
America Port of Spain
America Porto Velho
America Puerto Rico
America Punta Arenas
America Rainy River
America Rankin Inlet
America Recife
America Regina
America Resolute
America Rio Branco
America Santarem
America Santiago
America Santo Domingo
America Sao Paulo
America Scoresbysund
America Sitka
America St Barthelemy
America St Johns
America St Kitts
America St Lucia
America St Thomas
America St Vincent
America Swift Current
America Tegucigalpa
America Thule
America Thunder Bay
America Tijuana
America Toronto
America Tortola
America Vancouver
America Whitehorse
America Winnipeg
America Yakutat
America Yellowknife
Hawaii-Aleutian Standard Time (HAST)
Hawaii-Aleutian with Daylight Savings Time (HADT)
Alaska Standard Time (AKST)
Alaska with Daylight Savings Time (AKDT)
Pacific Standard Time (PST)
Pacific with Daylight Savings Time (PDT)
Mountain Standard Time (MST)
Mountain with Daylight Savings Time (MDT)
Central Standard Time (CST)
Central with Daylight Savings Time (CDT)
Eastern Standard Time (EST)
Eastern with Daylight Savings Time (EDT)
Atlantic Standard Time (AST)
Atlantic with Daylight Savings Time (ADT)


Excel is one of the jewels in Microsoft’s crown, and one of the most frequently used pieces of software worldwide for many and varied purposes. Very few people have ever attended a structured course on how to use the software to its full potential, and subsequently, the majority of users are missing out on many of the features and benefits provided.

The purpose of this article is not to try and give you an in-depth training course on Excel, but rather to teach you four quick, easy, and productive tips that you can start using immediately. These tips have a very small learning curve, but have the potential to significantly enhance your use of Excel.  


1. Quickly Add More Than One Column Or Row

As your use of Excel becomes more advanced and sophisticated, you will frequently run into the scenario of needing to add extra columns or rows. This is fine when you simply want to add an occasional row or column, but sometimes you might need to add 200 at a time. Trying to achieve this by adding rows individually would be both time consuming and tedious. The good news is that there is a quick and easy solution to this problem. All that you need to do is highlight the number of rows or columns you want to add, right click and select insert, and you will instantly have the additional columns or rows added. This tip has the potential to save you many hours and will quickly become one of your most used shortcuts.


2. Use The Tab And Enter Keys For Quicker Data Entry

When it comes to entering large quantities of data into a spreadsheet, it is essential that you are fully aware of the keyboard shortcuts, to speed up the process. To begin the data entry process, select the cell where you want to type your first piece of data. If you subsequently want to move to the next cell on the right, hit the tab key. When you are ready to drop to the row below, then use the enter key.

The above two points are relatively well known by most Excel users, but many users are unaware that to go in reverse you simply need to use the shift key and the same combination as above. So to move left hit the shift and tab key, and to move up a row it is shift and enter. You will be surprised how quickly this becomes second nature, and this method is much quicker than trying to use the arrow keys. This excellent video will teach you further ways to navigate within Excel.


3. Create A New Shortcut Menu

When you first begin using Excel it comes with a standard set of shortcuts setup, namely save, undo typing and repeat typing. While these shortcuts might be the most frequently used for some people, they may not suit your workflow. The good news is that it is possible to create a shortcut menu that provides the options you require. Let’s say you want to add, cut, and copy as a shortcut. Select File -> Options -> Quick Access Toolbar -> and then add Cut and Copy from the left column to the right. You will then find two new options available in the top menu.


4. Quickly Delete Blank Cells

As you continue to work on Excel, certain pieces of data will no longer be required and you might even delete the data to avoid confusion. Over time this can leave large numbers of blank cells which means extended scrolling, and wasted time. Luckily, there is a quick and easy way to delete all the blank cells. Select the column you want to edit and then select Data -> Filter. Change the option at the bottom from select all to blanks. This will identify all of the blanks; now, go to home and then delete to remove all of the blanks.


All of the above tips and tricks are quick and easy to learn and master, and they will rapidly become second nature. Once you are confident in using them, continue to expand your knowledge with more shortcuts. Having an in-depth working knowledge of Excel is a valuable skill in any workplace.