| Track | Microsoft Office |
| Title | Document Access Databases and Excel Workbooks |
| Abstract | What do you do when someone else's database or workbook lands on your desk? How can you quickly figure out what is there? How do you share what you have built with others in a way they can understand? This session introduces you to free tools for documenting Access databases and Excel workbooks. ***** Do YOU have analysis tools that the public can freely download? If so, please sign up to help present the session -- your expertise is welcome! To all participants: bring your workbooks and databases on a USB stick -- will use audience files to demonstrate the tools :) Bring your laptop if you have one -- we will pass around a stick with all the tools. |
|
| Track | Microsoft Office |
| Title | Drawing and Animating with PowerPoint |
| Abstract | See how easy it is to create eye-catching graphics and animations with PowerPoint! Paste graphics into and launch presentations from your other applications such as Excel and Word. |
|
| Track | Microsoft Office |
| Title | Excel Formulas, Functions and Common Equations |
| Abstract | Do you have any idea how many built-in functions Excel has? It can make your head spin! Luckily, there is a good way to browse through them and find the ones you are interested in using. Learn essential functions and how to create your own user-defined functions (UDFs). ~~ Explore basic numeric functions for summing, averaging, and rounding -- then step into the vast field of specialized functions such as amortizing payments, 360 calculations, ceilings, and cosines. Get comfortable combining and parsing text. Pull information out of dates like month and year, do date math. ~ Get a list of common equations. Learn great tips from experts. Become a formula whiz! |
|
| Track | Microsoft Office |
| Title | Learn VBA for Microsoft Office |
| Abstract | How do you get started writing VBA code for Office applications? Right here! Download free chapters and get links to free resources to help you in your journey to become a great developer. ~~ Examine code to create a header with variable information such as page number and date in Word and Excel -- how is the code different? how is it the same? where does code go? Learn VBA to find a record on an Access form and more. No previous programming experience needed -- only an interest to know! |
|
| Track | Microsoft Office |
| Title | Word Style Sheets |
| Abstract | In Word, you add a table of contents, headers, and footers ... do you know how EASY it is to have text (and graphics!) from your document automatically picked up? ... even when changes are made? Using Style Sheets adds consistency to the look and flow of your document, and gives you a way to tag text for use in other places -- including conversion to a database. ~ What are paragraph and character styles? How do you copy formatting? Where is formatting information stored? How can you keep track of your sections? How do you make a Table of Contents in 5 seconds? How can section, title, and subject automatically show up in all the headers as they change from page to page? ~ For true efficiency in Word, understanding style sheets is essential. ** Bring your documents! Maybe yours will be one that gets a style sheet set up during the session :) |