Turning Tables

Courtesy of: Darren Rose, Network 1 Senior NOC Engineer

Tables allow you to analyze your data in Excel quickly and easily. To convert your
data into an Excel table, click on any single cell inside the data set and press
“CTRL + T”. A pop-up window will appear and you will be able to choose where you
want to place the table in the spreadsheet. Once you press “OK”, your data will then
be converted into a table.

 

 

 

 

 

 

Now that you have your table set up, newly created drop-down menus will be located
on the headers of the table, as shown on the image below. These will allow you to use
features, such as sorting and filtering, that will help you organize and view your data.

 

Darren Rose: In the role of Senior NOC Engineer, Darren leads the team that is responsible for the management, deployment and troubleshooting of their 1-Services, including everything a business needs to ensure their networks are running smoothly and securely.

Network 1 designs, builds and supports the IT you need to run your business more securely, productively and successfully. Whether you want to outsource all of your IT needs to a reliable, responsive, service-oriented company, or need to supplement the work of your internal IT staff, we will carefully evaluate where you are now, discuss where you want to go and implement and support a plan to get you there with as little interruption as possible.

Leave a Comment





Related Posts