| |
Dawn Bjork Buzbee
The Software Pro®
Microsoft Certified Trainer (MCT)
Certified Microsoft Office 2010 Specialist (MOS 2010) Master Instructor
Certified Microsoft Office 2007 Specialist (MOS 2007) Master Instructor
Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Expert
Certified Women's Business Enterprise (WBE)
(303) 699-6868
Dawn@SoftwarePro.com
|
| | The Software Pro® delivers software and technology speaking and training programs including:  Conference Breakout Sessions- Workshops
- Customized Software Education
- Technology Seminars
- Keynotes
- Beginning to Advanced Microsoft Office Topics
- Follow-Up Coaching and Project Support
- One-to-one training and troubleshooting
- ...and more...including your customized solution!
"Your program on Microsoft Office was one of the best training sessions I have ever attended!"
Carol Selke
Business Support Coordinator, Information Technology
COPIC Insurance Do you want to learn more about the software and technology available on your desktop? Here is a sampling of the topics that are available to your company, association, or organization (additional and customized programming is available too):
 Microsoft Office 2010 is a significant update for Microsoft Office 2003 and 2002 users. Even though the core function of each program remains, the look and feel of Office 2010 is dramatically different. Familiar menus and toolbars are gone, a radical user interface was added, and well-known steps need to be re-learned. Join Dawn Bjork Buzbee, a software speaker, Microsoft Office Certified Trainer (MCT), and certified Microsoft Office Master Instructor, to discover what you need to know to easily make the switch to Office 2010 and to smoothly move between different versions of Microsoft Office. In this session explore:
- 5 key changes to the Microsoft Office 2010 interface
- How to manage new file formats and file compatibility with earlier versions
- Microsoft Office 2010 tips, tricks, and shortcuts
- New and updated features in Outlook 2010, Excel 2010, Word 2010, PowerPoint 2010, Access 2010 (topics custom-tailored to audience)
Recommended Session Length: 1 to 4 hours (may include hands-on learning; customized to audiences and organizations); may also include training on moving to Windows 7. Transition to Microsoft Office 2010 training also presented in webinar format.  Windows 7 is new from the ground up. Whether you’re already using Windows 7 or planning on making the switch, uncover many of the ways Windows 7 is different from earlier versions. In this tips-packed session, you will learn techniques in Microsoft Windows 7 to customize and organize your work, and streamline your business productivity including:
- Explore the new and enhanced features for customizing the Windows 7 desktop
- Make the most of the enhanced Taskbar and new Start menu
- Find out how to work with the updated Windows Explorer to manage files, folders, and new Libraries
- Discover fun and useful tricks with Aero Peek, Snap and Shake
- …and much more!
Who Should Attend: This session is designed for anyone familiar with and comfortable working in Windows XP or Windows Vista who wants to upgrade to the new and improved features of Windows 7. Ideal for desktop/end users as well as IT support and help desk staff. Note: This session does not specifically address new features in Microsoft Office 2010 or Office 2007 although these programs may have been part of an upgrade to Windows 7. Customized speaking or training sessions can include both as requested by client. Recommended Session Length: 1 to 3 hours (may include hands-on learning; can be customized to audiences and organizations).  Do you ever feel overwhelmed by e-mail? Do you ever struggle to get through all of your messages so that you can focus on other priorities? Have you ever missed time-critical e-mail that got lost in the middle of spam and company broadcasts? Learn strategies in Microsoft Outlook that will help you to:
- Organize and prioritize your messages with categories, folders, and rules
- Move through your messages quickly
- Reduce the number of incoming messages
- Spend less time on responses
- Get and keep attention with clear and legible messages
- Improve your company’s e-mail effectiveness
Recommended Session Length: 1 to 4 hours (may include hands-on learning) We live in a digital world, and so, it's not surprising that Portable Document Format files (PDFs) are one of the fastest growing document types today and are now showing up everywhere from web sites to email messages. Unlike a Word or Excel document, sharing a PDF ensures that the format and layout of the file remains intact and secure. Topics may include: - The difference between the Adobe Acrobat Reader and Adobe Acrobat Professional
- New features in Adobe Acrobat X
- How to create PDF documents directly from Adobe Acrobat
- How to create PDF documents from Word or Excel
- How to combine multiple files from different programs
- Changing document views
- Customizing the Acrobat work space
- Navigating PDF documents
- How to insert hyperlinks and bookmarks for simpler navigation through large documents
- When and how to use a portfolio
- Tricks in Microsoft Word for creating better PDF files
- How to add reviewing notes and comments
- How to create Adobe Acrobat forms that can be distributed and completed online
Recommended Session Length: 1 hour to 1 day depending on topics (may include hands-on learning) How many times have you been bored, confused, or frustrated by ineffective, poorly designed PowerPoint presentations? Discover the secrets and best practices for creating and delivering your message with a PowerPoint presentation from a Certified Microsoft PowerPoint Expert and Master Instructor. This session includes: - The 4 key parts to any PowerPoint presentation
- How to connect with your audiences
- When PowerPoint is not the best presentation solution
- Discover the expert tips to build more dynamic and effective text and bullet slides
- Tap into new design and graphic features in PowerPoint 2007 and 2010
- Discover quick ways to become a power user by engaging audiences with multi-media, animation, and hyperlinks
- Explore insider secrets to professionally publish and deliver a PowerPoint presentation
Session Length: 1 hour to 1 day (may include hands-on learning) All Excel with Excel sessions described below are designed for 1 hour to 1.5 hours. Customized training can also be created to combine multiple Excel topics which are most important to you!  Nearly 350 functions are built into Microsoft Excel for simple to complex calculations. Regardless of your work or industry, which of these functions are likely to be most valuable to you to build formulas, analyze data, extract key information, and to more effectively use your Excel worksheets? In this session, focus on many of the frequently used and helpful functions in Microsoft Excel.
- Review of function basics and arguments; SUM, AVERAGE, MAX, MIN
- COUNT and COUNTA
- ROUND
- Creating named ranges
- Data analysis with IF, SUMIF, COUNTIF, and VLOOKUP
- DATE functions
- TEXT functions
 Excel with Excel: Filtering & Sorting Techniques
Excel is a powerful program for managing and analyzing lengthy lists of data. What tips, tricks, and techniques do you need to know to quickly and easily sort and filter a range or table of data? Join this training course to explore the shortcuts and solutions for effectively working with large worksheets of data. - Discover the differences between a data range, data list or table
- Tips for formatting data lists
- Filtering data with AutoFilter
- Sorting data in a worksheet
- Applying conditional formatting for quick analysis
- Using Data Validation to control data entry
- Creating, viewing, and removing Subtotals
- Advanced Filter techniques
Excel with Excel: Linking & Sharing DataSome of the most useful and time-saving features in Excel are the choices to link and share worksheet data. In this course, find out how to easily reference and summarize data from other worksheets, learn how to use Excel data in other programs, look at options to share workbooks and protect data, and how to manage user comments and changes. - Linking within a workbook
- Linking and updating across workbooks
- Using the Consolidate command
- Sharing Excel data with other programs (Word, PowerPoint)
- Applying protection and sharing properties
- Handling comments and revisions
- Creating hyperlinks to other files and resources
Excel with Excel: Getting Started with PivotTablesMany people avoid exploring PivotTables in Excel because they have a reputation for being hard to create and understand. Find out how to quickly and easily create and modify PivotTables and see how they might literally save you hours, or even days, when you need to summarize and evaluate your important worksheet data. - What is a PivotTable?
- Creating a PivotTable
- Formatting and modifying a PivotTable
- Summarizing data
- Exploring PivotTable options
- Sorting and filtering in a PivotTable
- Refreshing data
- Adding a Slicer to filter data
- Creating calculations in a PivotTable
Excel with Excel: Charts & GraphicsNot all of Excel is about crunching numbers. Excel is also an easy yet powerful program for creating charts and graphics. With this training, you'll discover how to use Excel's graphics capabilities to display your data in a chart and learn how to use Excel's other drawing and diagram tools to enhance your worksheets. - Understanding how Excel handles charts
- Creating and customizing a chart
- Modifying chart format and options
- Adding mini charts with Sparklines
- Creating graphics and diagrams with shapes and SmartArt
- Using the easy screen capture tool
Excel with Excel: Getting Started with Macros & AutomationIf you have tasks in Microsoft Excel you perform repeatedly, you don't have to keep doing each step manually. Instead, create macros to automate these actions. In this session, find out how to plan, create, edit, and run macros in an Excel workbook. - Understanding and planning macros
- Creating macros with the recorder
- Working with macro security
- Absolute vs. relative recording
- Easy editing of macros (programming not required)
- Running macros with keyboard shortcuts
- Running macros with a Quick Access Toolbar button
- Running macros with a button
 Are you spending too much time trying to find commands that you need? How can you make Word 2010 or Word 2007 work for you and not against you? Find out tips, tactics, and timesavers from a Microsoft Certified Trainer and Microsoft Office Specialist Master Instructor to save time and avoid frustration when you are editing and formatting your important documents in Microsoft Word.
- Discover hidden tips and shortcuts for quickly navigating through your documents
- Answer your questions about formatting and how you can take control of your big projects
- See how adding automation tools can upgrade your work and help you create great looking documents with ease
- Find out the secrets of section breaks so you can build complex documents in minutes
- Tap into the options and tools that will help you simplify your work if you only knew where to find them
- Stop fighting with a do-it-yourself table of contents by embracing the easy steps to build a table of contents and index automatically
- Explore shortcuts and how to customize your workspace to take advantage of the new Word 2010 and Word 2007 interface even though your familiar toolbars are gone
- Breathe easy by seeing how built-in styles can create professional looking documents in minutes
- Expand your skills with smart and easy tips to make your work look more professional
Recommended Session Length: 1 to 3 hours (may include hands-on learning) How many times have you struggled with a Microsoft Word document only to give up and do it “the hard way” or to find out later that there was a simple (but not obvious) solution? Even experienced Word users can discover new and quick ways to save time and effort and to be more productive. Attend this session to learn how to more effectively create and edit Word documents with the many tips, tricks, tools, and techniques built into Microsoft Word. A Certified Microsoft Word Expert and Master Instructor will share: - Smart and easy shortcuts
- Ways to customize and automate Word
- Document navigation tricks
- Timesaving tips for layout and design
- Understanding and mastering track changes and other top reviewing features
- Other hidden secrets and techniques
Recommended Session Length: 1 to 3 hours (may include hands-on learning)  Microsoft Office 2007 is the most significant update in over 10 years. Even though the core function of each program remains, the look and feel of Office 2007 is dramatically different. Familiar menus and toolbars are gone, a radical user interface was added, and well-known steps need to be re-learned. Join Dawn Bjork Buzbee, a software speaker and certified Microsoft Office 2007 Instructor, to discover what you need to know to easily make the switch to Office 2007 and to smoothly move between different versions of Microsoft Office. In this session explore:
- 5 key changes to the Microsoft Office 2007 interface
- How to manage new file formats and file compatibility
- Microsoft Office 2007 tips, tricks, and shortcuts
- New and updated features in Outlook 2007, Excel 2007, Word 2007, PowerPoint 2007, Access 2007 (topics custom-tailored to audience)
Recommended Session Length: 1 to 3 hours (may include hands-on learning; can be customized to audiences and organizations) Transition to Microsoft Office 2007 training also presented in webinar and video format. >>Find out more about Office 2007 options 
Don't see the topic you want?
The Software Pro® specializes in customized conference presentations, training and consulting, webinars, videos, and other software and technology solutions. Contact us to learn more.
| |
|
Tips, Tricks, Secrets
that you need to know now!
|
Audience interaction and participation significantly increases retention and implementation of new skills and processes.
|
| Customized programs and presentations from The Software Pro® will target your organization goals. |
|
