Centriq Training Print Logo

Tuesday

February 7 09:42 AM


Blog Banner Graphic

Blog

Expert Microsoft Excel Tips and Training

Expert Microsoft Excel Tips and Training

April 3, 2017 in Corporate IT Training, Microsoft / by Centriq 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 8, 2023
Aug 11, 2023
Day
5/29/23-6/2/23
7/3/23-7/7/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 19, 2023
Oct 6, 2023
Day
7/3/23-7/7/23
9/4/23-9/8/23
FSCP-V
Jun 26, 2023
Sep 29, 2023
Day
7/3/23-7/7/23
8/7/23-8/11/23
CSSP-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
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 13, 2023
Mar 19, 2023
Day
3/20/23-3/24/23
4/17/23-4/21/23
CSSP-I
Apr 17, 2023
Jul 21, 2023
Day
5/22/23-5/26/23
7/3/23-7/7/23
CSSP-I
Jun 5, 2023
Sep 8, 2023
Day
7/3/23-7/7/23
8/7/23-8/11/23
CSSP-I
Jul 31, 2023
Nov 3, 2023
Day
9/4/23-9/8/23
10/2/23-10/6/23
CSSP-I
Sep 25, 2023
Dec 22, 2023
Day
11/20/23-11/24/23
CSSP-I
Nov 27, 2023
Mar 1, 2024
Day
12/25/23-12/29/23
1/29/24-2/2/24
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 16, 2023
Apr 21, 2023
Day
2/2023-2/24/23
3/20/23-3/24/23
CSSP-I
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-I
Feb 27, 2023
Jun 2, 2023
Day
4/3/23-4/7/23
5/1/23-5/5/23
CSSP-I
Apr 10, 2023
Jul 14, 2023
Day
5/15/23-5/19/23
7/3/23-7/7/23
CSSP-I
May 22, 2023
Aug 18, 2023
Day
7/3/23-7/7/23
CSSP-I
Jun 26, 2023
Sep 29, 2023
Day
7/3/23-7/7/23
8/7/23-8/11/23
CSSP-I
Aug 7, 2023
Nov 10, 2023
Day
9/4/23-9/8/23
10/9/23-10/13/23
CSSP-I
Sep 11, 2023
Dec 15, 2023
Day
10/16/23-10/20/23
11/20/23-11/24/23
CSSP-I
Oct 23, 2023
Jan 26, 2024
Day
11/20/23-11/24/23
12/25/23-12/29/23
CSSP-I
Dec 4, 2023
Mar 8, 2024
Day
12/25/23-12/29/23
2/5/24-2/9/24
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.