THE CONFERENCE ON MASTERING THE SECRETS OF MICROSOFT® OFFICE
In this conference you'll learn...
Working with your data using formulas, data analysis and more
Viewing your data using graphs, form and reports
Adding data to your documents and documents to your data
Integrating Office applications
And much more!
The conference is set up in convenient track format—each track containing 5 dynamic sessions. Follow one track from start to finish, or move in and out of sessions as you like. It´s your conference—don´t miss a thing!
CONFERENCE AGENDA
E-mail this Page
TRACK ONE: Data Management With Microsoft® Office
Session 1: 9:30 – 10:30 a.m.
Getting started with data management
For most people, data management is a complex and mysterious process, but Microsoft Office makes even the most difficult aspects of data management quick and easy if you know how to take advantage of the tools found in Excel and Access. This session will show you where to begin when it comes to data management so you don´t start off on the wrong path that only leads to frustration. You´ll learn ... How to select the right application for the right data management job
Techniques for creating the right relational database structure for optimum performance and efficiency
How to format large blocks of cells quickly and efficiently with the power of Format Painter and how to implement conditional formatting in Excel
Quick ways to import data into Access and Excel from a variety of sources
How to use the Linked Table Manager to manage your linked tables in Access
Session 2: 10:45 – 11:45 a.m.
Working with your data—formulas, data analysis and more!
Once you´ve gotten your data into your Microsoft Office application, you have to know how to put it to work, and that´s what this session is all about. You´ll discover how to get the most from your data by understanding how to create and apply formulas in Excel and Access, and you´ll also find out how to take advantage of the add-in data analysis tools that come with Excel. You´ll find out ... What the Excel Solver is and how to use it
A quick technique to create a cell in a worksheet that contains a drop-down item list
How to use an Access query to generate a dynamic Excel worksheet
How to add power to your database applications and spreadsheets with Visual Basic for Applications (VBA)
How you can use Access as a front-end to client/server database systems such as Microsoft SQL Server
Session 3: 1:00 – 2:00 p.m.
Validating and securing your data
Having data in your application is only half the battle. You must make sure your data is valid and secure, and that´s what this session is all about. Your spreadsheets and databases are only as good as the data they contain, and human error in data entry is an extremely common problem. We´ll show you some of the best techniques to help eliminate human error from your data management equation. You´ll learn ... How to use the Data Validation function to help avoid data entry mistakes
How the Formula Auditing tool can help catch errors and avoid data corruption
How to use Information Rights Management (IRM) to protect your Excel files
How to lock values and formulas in your Excel worksheets
How to set user-level security on your Access databases
Session 4: 2:15 – 3:15 p.m.
Viewing your data with graphs, forms and reports
After getting good, valid data into your applications, you´ll want to be able to display your data in easy-to-understand formats, and that´s what you´ll discover in this informative session. You´ll learn various methods for displaying your data in graphs, forms, reports and more! You´ll find out why the Report Wizard in Access doesn´t always give you the results you´re looking for and how to manually generate a report that displays your data in the exact way you want it to. Also in this session ... Quick and easy techniques for generating graphs in Excel
How to use Excel to quickly create professional-looking forms that look like they took hours to create
The "in‘s and out‘s" of Excel pivot table and pivot chart reports
Think you have to use Excel for all your graphs? Think again—you can do it in Access, and we´ll show you how
How to quickly create data entry forms in Access with or without the use of the Form Wizard
How to correctly design your Access queries to get the right data for your reports
Session 5: 3:30 – 4:30 p.m.
Publishing your data on the Web
Microsoft has made it easy to publish your data on the Internet or your local intranet, but you have to know the right techniques to use in order to get the results you want, and that´s just what you´ll learn in this session. We´ll show you how to publish graphs, forms and reports quickly and easily with professional-looking results. It´ll look as though you spent hours creating them! You´ll learn...How to create interactive Web pages from your Excel workbooks
Simple techniques to import and export your data to and from XML files
What it takes to publish a chart to a Web page and make it interactive
How to quickly publish data from Access to the Web
How to use the Data Access Page feature in Access to create a Web page that you can use to view and enter data into your Access database
TRACK TWO: Mastering Documents and Presentations With Microsoft® Office
Session 1: 9:30 – 10:30 a.m.
Creating amazing documents
The secrets to producing those amazing, professional-looking documents every time—with less effort—are revealed in this information-rich session. Not only will you gain a complete understanding of the best techniques to dramatically enhance your Word documents; you´ll also learn how to use Information Rights Management (IRM) to protect your Word documents. Included in this session ... Cool ways to create stunning layouts with italics, boldface, indents, tabs and line spacing
How to create stunning 3-D, animated, shadowed and textured text and graphics—all with Word´s sophisticated drawing and multimedia tools
How to add Internet objects, hyperlinks and even ActiveX® controls to your documents
Shift your creativity into high gear with these 10 desktop publishing tricks
12 easy-to-implement ways to transform your document from drab to dynamic
Session 2: 10:45 – 11:45 a.m.
Adding data to your documents and documents to your data
Integrating your data from Access or Excel into your Word documents allows you to create truly dynamic documents that contain up-to-the-minute information. In this session, you´ll learn how to create those dynamic documents and find out how you can save time and effort by letting Microsoft Office do the work for you. You´ll find out ... How to use dynamic data from Access in Word
Quick techniques for creating and using formulas in Word
Tips for adding automated fields to your Word document
How to embed an Excel worksheet in your document that automatically updates when you modify the worksheet
How to incorporate a Word document into an Access database and use the Link feature to automatically update the database with any changes
Session 3: 1:00 – 2:00 p.m.
Amazing presentation techniques
To succeed in today´s business environment, you´ve got to be good at presenting ideas and concepts—and there´s no better solution to that challenge than PowerPoint®. In this session, you´ll learn how to create the perfect combination of text, graphics and multimedia in a dynamic PowerPoint presentation ... then tackle even more advanced techniques like voice narration, special effects, hyperlinks and more. You´ll learn ... An easy technique to add stunning roll-over effects to your PowerPoint presentations
How to use motion paths in your PowerPoint presentation
The right way to use video in PowerPoint
How to use the Pointer Options to emphasize information in your PowerPoint presentations
How to publish your presentation on the Web
Session 4: 2:15 – 3:15 p.m.
Integrating Office applications
In this informative session, you´ll learn how to take advantage of the incredible integration features Microsoft Office contains. You´ll discover the difference between linking and embedding and find out how to seamlessly move information from one application to another with just a few mouse clicks. Also in this session ... Learn how to dynamically embed an Excel graphic in your PowerPoint files so that your monthly presentations always contain the most up-to-date data
How to import Access snapshot reports into PowerPoint and Word
Mail Merge made easy: How to produce customized letters, mailing labels and volumes of envelopes—no hassle, no sweat
Tips on how to exchange information between Word and PowerPoint to create punchy handouts
How to use Microsoft Producer to publish rich multimedia presentations to the Internet or an intranet
Session 5: 3:30 – 4:30 p.m.
Using the collaborative features of Microsoft Office
One of the best features of the Microsoft Office applications is collaboration. In this session, you´ll learn how to take advantage of the collaboration features built into Word, PowerPoint and Excel. You´ll learn how to easily share your documents with other members of your team whether they´re in the next cubicle or even half way around the world. You´ll discover ... Step-by-step instructions for using the Shared Workspace function in Word
How to track and protect changes in Word documents ... then merge comments and changes from multiple reviewers into one document
How to share an Excel workbook with others in your office
How to use the Online Collaboration tool to set up a meeting to review a document
How to take advantage of the Web Discussions tool to set up discussion threads about a Word, Excel or PowerPoint file
US/Canada:
1-800-867-4340
United Kingdom:
0800 968254
Australia:
1 800 145 233
New Zealand:
0800 447 299
or e-mail us at:
onsite@skillpath.net
1-800-867-4340
United Kingdom:
0800 968254
Australia:
1 800 145 233
New Zealand:
0800 447 299
or e-mail us at:
onsite@skillpath.net
