Home > BrittBrief > Microsoft Excel - How to Automate Procedures with Templates in Excel
Microsoft Excel - How to Automate Procedures with Templates in Excel 
 
5/5/2010 
ALP Recording 

Click on the image above to watch the webcast replay now.

 Class Description

Join us today as we tackle these two challenges:

  • How to Consolidate Data Across Worksheets, and
  •  How to Dynamically Link Excel to Word

 In this class you'll learn:

  • A consolidation technique that allows you to automatically add or remove subsidiary worksheets without breaking your formula.
  • The trick to applying formatting across multiple sheets with one stroke.
  • The correct syntax for summing across workbooks.
  • How to add sizzle to your Word documents by dynamically linking Excel tables and charts.

 Class Handout

 Other Materials of Interest
Microsoft Excel - How to use Date Math and Functions to Solve Practical Business Problems in Excel
In this month’s Microsoft Excel webcast class, you’ll learn "How to Use Date Math and Functions to Solve Practical Business Problems in Excel."
Microsoft Excel - How To Automate Spreadsheets with Conditional Expressions and Lookup Tables in Excel
The IF function is one many people shy away from, but this is one function that will truly make every Excel user's life much easier. Excel's VLookup is a handy tool that helps you compare data in two spreadsheets
Microsoft Excel - What's New & Different in Excel 2007
Whether you already have Excel 2007, or plan to upgrade, this webcast class will provide valuable tips and tricks you can use immediately.
Microsoft Excel - How to Create and Use Pivot Tables - Part II
Excel's Pivot Tables enable you to slice, dice and present data from a variety of perspectives.
Microsoft Excel -How to Create and Use Pivot Tables - Part I
Microsoft Excel Pivot tables are a tremendous tool for ad-hoc analysis and reporting of data from almost any source. Excel's Pivot Tables enable you to slice, dice and present data from a variety of perspectives.
Microsoft Excel - Sorting, Querying, and Subtotaling an Excel Database
nage data in Excel? If you aren't using the "Database" feature in Excel, you could be missing out on a tool to finally give you mastery over lists of data.
Microsoft Excel - How to Optimize your Data Management with Excel's Database Feature
Do you manage data in Excel? If you aren't using the "Database" feature in Excel, you could be missing out on a tool to finally give you mastery over lists of data. Join the inaugural class of the Excel Advanced Learning Program from Brittenford Systems, and learn the secret!
Microsoft Excel - How to Automate Procedures with Templates in Excel
Join us today as we tackle these two challenges: How to Consolidate Data Across Worksheets, and How to Dynamically Link Excel to Word
Microsoft Excel - How to Automate Repetitive Procedures with Templates in Excel
Here's what we will cover: Spreadsheet Error Messages and how to solve these issues when they occur Excels' Formula Auditing Feature for monitoring and debugging your math
12359 Sunrise Valley Dr, Suite 130, Reston, VA 20191
©2009 Brittenford Systems, Inc.