NEW for 2008-2009!!!!
Special Afternoon Microsoft Office breakout sessions.

HFMA will be offering special afternoon breakout sessions geared towards improving your Microsoft skills beyond what you’ve picked up on your own.  Three sessions will be offered:  Excel: Beyond the Basics, Excel: Analytical Redesign and Power Point/Word: Made Easy & Useful.  We will give you practical examples with step-by-step instructions to allow you to feel confident in replicating the skills learned to your boss and co-workers.  These essential skills will provide the basis for learning more advanced skills at our April 2009 Decision Support Seminar. 

Excel: Beyond the Basics will cover a range of introductory skills that you may have missed in your training or self-learning.  We’ll cover basics like text manipulation (functions like LEFT, MID, LEN, etc.), linking spreadsheets, print formats (header/footers, print dates, file names ,etc.), rounding vs. “Precision as displayed,” autofill lists, absolute vs. relative reference and (in case you didn’t know it already) the “F4” key.

For example, have your ever completed a spreadsheet, checked all of the formulas, and then found that the totals don’t “foot” because of rounding in the “cents,” which you didn’t display on the worksheet?  You can fix this using the “precision as displayed” option, but you need to be aware of other effects and traps of using this option in a spreadsheet.  Learn these at this seminar.

Excel: Analytical Redesign will allow the more experienced user to understand the general techniques involved in using Excel as an analytical tool.  You will be able utilize your raw data and have Excel do the summarization and analysis for you.  Your successful use of lists and tables, along with Excel’s summarization functions, will allow you to extract data and summarize results with easy and efficiency.

You will be able to successfully use:  lists & tables, named ranges, pivot tables, data connections from Access or other databases, counting & summing functions (SUMIF, DCOUNT, VLOOKUP) and little-known but useful functions (SUMPRODUCT, RANDBETWEEN, etc.).

Power Point/Word: Made Easy & Useful will teach the professional to easily transform hours of analyses into Board quality presentations or Word documents without the hassle of recreating everything you just did in Excel.  We will demonstrate how the combination of Excel, Word and Outlook can save time in sending multiple recipients only data pertaining to them.  You will leave with a whole new appreciation for the power of Word and PowerPoint by mastering the following: mail merge with embedded lists, use of file properties, linking words & text into a Word narrative document from an Excel file, pasting tables with links and pasting graphs.

If you have specific questions please feel free to email Jon Pearce or Ann Saputelli to see if we could add some of your questions to this or future sessions.

Not just for the old time Office 2003 users - we will also cover some helpful features in Office 2007 that may persuade you to cough up the cash and buy the update!