Register Online - Add to Cart

Credits

Only registered attendee will receive continuing education credit.
Product ID: 406405
 

Filtering Techniques for Excel Data

Live Webinar
October 14, 2019
1:00 pm ET (12 pm CT, 11 am MT, 10 am PT)
1 hour 30 minutes
Live Webinar$199Register Now
Can't Attend?   Audio & Reference Manual$199Add to Cart

Save time and create accurate spreadsheets by learning how to link your worksheets and workbooks to each other.

In today’s business world, there is tons of data. Your Excel® spreadsheets are becoming more and more complex. You seem to updating the same numbers in different sheets. You also have to import data from other sources, and then reimport the data when it changes. This process is taking too much time and it leads to many mistakes. This topic will show you how to link your worksheets and workbooks to each other, and how to link Excel® to webpages and other data sources as well. When you use the techniques, you will save a lot of time and have more accurate spreadsheets. When you link things together properly, you will only have to update the data once, and then the changes will cascade thru to your other sheets and workbooks.

Learning Objectives

• You will be able to define links between one Excel® sheet and another.

• You will be able to identify situations where data can and should be linked together.

• You will be able to recognize linked data and how to refresh it.

• You will be able to review broken links and fix them, when possible.

Registration

Live Webinar$199Register Now
Can't Attend?   Audio & Reference Manual$199Add to Cart