Blog

Microsoft Excel Tips and Tricks

Expert Microsoft Excel Tips and Training

Microsoft Excel is the standard software for managing and organizing data and spreadsheets.

This software is widely used by businesses across various industries on a daily basis. Whether you need to compare monthly sales revenue or document weekly traffic for a website, you’ve probably used Micorsoft Excel at some point on the job.

But while you may have some experience with the program, you probably have only scratched the surface of all of its features. Here are some ways any user can get more out of Microsoft Excel.

Create Menu Shortcuts to Save Time

Excel is a very versatile program, allowing users to display information in various ways. Users can also check, edit, and copy information as needed. The large amount of features Excel has makes it useful in various situations, but most businesses will use it for the same purposes on a regular basis.

Creating menu shortcuts allows users to quickly access important commands. This makes it easy to streamline daily operations, achieve consistency in data logging, and stay organized. To view the shortcut menu, simply press Shift+F10 on a PC and Fn+Shift+F10 on Mac.

Add a Diagonal Line to a Cell

Most people use Excel to store information in a concise and easy-to-read manner. Even regular users of this software may think that horizontal and vertical lines are all that is used to divide data. However, diagonal lines can be added in the border category of the formatting menu. Dividing cells can be useful for starting tables and displaying different types of data.

To add a diagonal line to cells, just select the cell and right click to open the format cells menu. Then select the diagonal line option on the border menu.

Quick Drag of Columns or Rows

The amount of data an Excel sheet holds can vary, but no one likes the thought of having to move individual cells. Luckily, users can drag rows and columns quickly by clicking on the border. Data can also be copied and pasted from rows and columns with ease, ensuring fast changes can be made without sacrificing accuracy.

Delete All Blank Cells

Excel is known for its ability to organize data into visually-appealing formats. In some cases, this doesn’t mean adding things to the sheet – it can mean taking them away. Deleting blank cells can make it easier to see the actual data in an Excel file. We can use the filtering command to select all blank cells and delete them simultaneously.

Simply select the area with blank cells, then click on Find and Select in the editing toolbar. Next, scroll down to “Go to Special” and fill the check box labeled “Blank.” Now that you only have blank cells selected, go to the delete button on the editing toolbar.

Input Restrictions Improve Any Sheet

When it comes to maintaining data, sometimes a given range is applicable in a certain cell. For example, a cell dedicated to the birth-month of all employees in a company would use whole numbers between one and twelve. Under data validation settings, we are able to set the minimum and maximum values allowable, as well as whether the values should be whole numbers.

On the data tab, select Data Validation. Then in the settings menu you can select your desired input restrictions to whole numbers (or whatever restrictions your document requires.)

Turn Columns into Rows Collectively

Sometimes we find that data can be displayed more efficiently if the sheet is switched around. Doing this manually can be time consuming and lead to errors. Users can turn columns into rows using the transpose function. It’s easy and quicker than most expect so don’t settle for a spreadsheet that isn’t optimally formatted!

For a quick how to switch the columns and rows, click here.

Streamlining Case of Text

Text may need to be formatted differently in different rows and columns. Case text can be set in each cell based on whether the text should be all capitals or lowercase, or whether the first letter should be capitalized. In many cases, data from outside sources may be in all caps and you may need it transposed into first letter only – especially if you are using the data to create shipping labels or using in a Word document.

To fix case of text of a whole row or column at once, use the following formula to create new columns or rows. In the first cell of the new row or column use =PROPER(Cell Number) You can use PROPER for proper capitalization, UPPER for uppercase and LOWER for lowercase. For more info on how to use this feature, click here.

Save Time with Microsoft Office Training

Excel is the type of software which can be useful in any professional setting. When it comes to keeping data organized in an easy-to-read format, Excel has plenty to offer businesses of all sizes. There are plenty of advanced functions users can master in Excel. The best way to do this is with Microsoft training from a quality provider.

At Centriq, we offer training in all of the software and hardware necessary to keep your business running in the digital age.View all available Excel 2013/2016 Classes HERE.

To learn more about training to help you master this software, contact Centriq today or take a look at our class schedule here.

Start Date
End Date
Day/Eve
Break Weeks
Track
Jan 23, 2023
Jul 27, 2023
Eve
4/3/23-4/7/23
5/22/23-5/26/23
7/3/23-7/7/23
CSSP-V
Jan 30, 2023
May 5, 2023
Day
3/6/23-3/10/23
4/10/23-4/14/23
CSSP-V
Feb 6, 2023
May 19, 2023
Day
3/27/23-3/31/23
FSCP-V
Mar 20, 2023
Jun 23, 2023
Day
4/24/23-4/28/23
5/22/23-5/26/23
CSSP-V
Apr 10, 2023
Jul 28, 2023
Day
5/29/23-6/2/23
7/3/23-7/7/23
FSCP-V
Apr 24, 2023
Oct 19, 2023
Eve
7/3/23-7/7/23
8/21/23-8/25/23
CSSP-V
May 15, 2023
Dec 14, 2023
Eve
7/3/23-7/7/23
9/4/23-9/8/23
11/20/23-11/24/23
FSCP-V
Jun 5, 2023
Sep 8, 2023
Day
7/3/23-7/7/23
8/7/23-8/11/23
CSSP-V
Jun 19, 2023
Oct 6, 2023
Day
7/3/23-7/7/23
9/4/23-9/8/23
FSCP-V
Jul 24, 2023
Jan 25, 2024
Eve
10/2/23-10/6/23
11/20/23-11/24/23
12/25/23-12/29/23
CSSP-V
Aug 14, 2023
Nov 17, 2023
Day
9/5/23-9/8/23
10/16/23-10/2/23
CSSP-V
Aug 28, 2023
Dec 15, 2023
Day
9/4/23-9/8/23
11/20/23-11/24/23
FSCP-V
Oct 30, 2023
Feb 2, 2024
Day
11/20/23-11/24/23
12/25/23-12/29/23
CSSP-V
Oct 30, 2023
May 2, 2024
Eve
11/20/23-11/23/23
3/4/23-3/7/23
CSSP-V
Nov 6, 2023
Mar 1, 2024
Day
11/20/23-11/24/23
12/25/23-12/29/23
1/29/24-2/2/24
FSCP-V
If you don't see the Cohort Start date you are looking for don't forget to check out our campus calendars.
CSSP-I: Cloud & Security Specialist Program (In-Person Modality)
CSSP-V: Cloud & Security Specialist Program (Live Virtual Modality)
FSCP-I: Full Stack Coding Program (In-Person Modality)
FSCP-V: Full Stack Coding Program (Live Virtual Modality)
Please note that Centriq will be closed on the following observed holidays: New Year’s Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, the day following Thanksgiving Day, and Christmas Day.
Start Date
End Date
Day/Eve
Break Weeks
Track
Feb 29, 2024
Mar 24, 2024
Day
3/25/24-3/29/24
4/22/24-4/26/24
CSSP-I
May 13, 2024
Aug 16, 2024
Day
5/27/24-5/31/24
7/1/24-7/5/24
CSSP-I
Aug 19, 2024
Nov 22, 2024
Day
9/2/24-9/6/24
10/21/24-10/25/24
CSSP-I
Dec 2, 2024
Mar 14, 2025
Day
12/23/24-12/27/24
12/30/24-1/3/25
2/10/25-2/14/25
CSSP-I
If you don't see the Cohort Start date you are looking for don't forget to check out our online instructor-led calendar.
CSSP-I: Cloud & Security Specialist Program (In-Person Modality)
CSSP-V: Cloud & Security Specialist Program (Live Virtual Modality)
FSCP-I: Full Stack Coding Program (In-Person Modality)
FSCP-V: Full Stack Coding Program (Live Virtual Modality)
Please note that Centriq will be closed on the following observed holidays: New Year’s Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, the day following Thanksgiving Day, and Christmas Day.
Start Date
End Date
Day/Eve
Break Weeks
Track
Jan 15, 2024
Apr 19, 2024
Day
2/19/24-2/23/24
3/18/24-3/22/24
CSSP-I
Feb 26, 2024
May 24, 2024
Day
4/1/24-4/5/24
CSSP-I
Apr 08, 2024
Jul 12, 2024
Day
5/27/24-5/31/24
7/1/24-7/5/24
CSSP-I
May 20, 2024
Aug 23, 2024
Day
5/27/24-5/31/24
7/1/24-7/5/24
CSSP-I
Jun 24, 2024
Sep 27, 2024
Day
7/1/24-7/5/24
9/2/24-9/6/24
CSSP-I
Jul 29, 2024
Feb 6, 2025
Eve
9/2/24-9/5/24
11/25/24-11/28/24
12/23/24-12/27/24
12/30/24-1/3/25
CSSP-I
Aug 5, 2024
Nov 8, 2024
Day
9/2/24-9/6/24
10/7/24-10/11/24
CSSP-I
Sep 9, 2024
Dec 13, 2024
Day
10/14/24-10/18/24
11/25/24-11/29/24
CSSP-I
Oct 21, 2024
Jan 31, 2025
Day
11/25/24-11/29/24
12/23/24-12/27/24
12/30/24-1/3/25
CSSP-I
Dec 2, 2024
Mar 14, 2025
Day
12/23/24-12/27/24
12/30/24-1/3/25
2/10/25-2/14/25
CSSP-I
If you don't see the Cohort Start date you are looking for don't forget to check out our online instructor-led calendar.
CSSP-I: Cloud & Security Specialist Program (In-Person Modality)
CSSP-V: Cloud & Security Specialist Program (Live Virtual Modality)
FSCP-I: Full Stack Coding Program (In-Person Modality)
FSCP-V: Full Stack Coding Program (Live Virtual Modality)
Please note that Centriq will be closed on the following observed holidays: New Year’s Day, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, the day following Thanksgiving Day, and Christmas Day.