Filtering Techniques for Excel Data

Duration: 90 Minutes
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 re import the data when it changes. This process is taking too much time and it leads to many mistakes.
Filtering Techniques for Excel Data
Instructor: Tom Fragale
Product ID: 509671
Objectives of the Presentation
  • 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
Why Should you Attend
This topic will show you how to link your worksheets and workbooks to each other, and how to link Excel® to web pages 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. Linking and consolidating data in Excel workbooks is an important skill for those who use Excel on a regular basis. Linking data can be used to prevent holding many copies of the same data.

Areas Covered
  • Integrating Data on Web Pages Into Your Workbooks and Creating Automatic Links
  • Learning How to Repair Broken Workbook Links
  • Controlling Whether or Not Linked Workbooks Update Automatically as Well as Suppressing Unwanted Prompts
  • Linking to Other Data Sources Such as Access®, SQL Server, and Text Files
  • Having the Links to Other Data Sources Update the Information Automatically
  • Linking Formulas Between Worksheets and Workbooks
  • Using the Data Consolidate Function to Add Sheets Together and Link
  • Eliminating the Risk of Workbook Links by Using Microsoft® Query® to Get Data From One Workbook into Another
  • Managing Prompts That Appear When You Open a Workbook That Contains Links
  • Learning How to Arrange Two Worksheets From Within the Same Workbook On-Screen
  • Linking Charts to Data in Other Sheets
Who will Benefit
This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, bookkeepers and accountants.
  • Business Owners
  • CEO's / CFO's / CTO's
  • Managers of all levels
  • Team Leaders
  • Supervisors
  • Administrative Specialists
  • Anybody with large amounts of data
  • Anybody who uses Microsoft Access/Excel on a regular basis, and wants to be more efficient and productive
  • Accountants
  • CPAs
  • Controllers
  • Financial Consultants
  • IT Professionals
  • Auditors
  • Human Resource Personnel
  • Bookkeepers
  • Marketers
$249
Recorded Session for one participant
Get life time access with download option!
Book this course
Pay Now
  $329.00 Training CD
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
  $379.00 Training USB Flash Drive
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
For multiple location please contact our customer care team +1-510-857-5896.
How it works
Live Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • The webinar joining link, username and password for joining the webinar will be updated on your OCP Account 24 hours prior to the webinar
  • Presentation handouts in Downloadable PDF format will be updated on your OCP Account 24 hours prior to the live session
  • Login to the audio conference on the scheduled date and time
  • Get answers to your queries through interactive Q&A sessions via chat at the end of the session
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account 24 hours after the completion of the session
  • Please let us know your thoughts and views at the end of the webinar, your valuable feedback will help us improve
Recorded Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • Upon purchase of the recorded session a link will be updated on your OCP Account within 24 hours
  • Please click on the link to access the Recorded Session
  • Presentation handouts in downloadable PDF format will be updated on your OCP Account within 24 hours of the purchase of the product
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account after 48 hours of the product Purchase
  • Please share your valuable Feedback at the end of the session
Instructor Profile:
Tom Fragale is a computer professional with over 30 years experience. He has trained over 30,000 business people with online webinars, public seminars and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks and SharePoint. His passion is training people and helping them get most out of their computers. He has written and published a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.
View More