Microsoft Office 2010 Expert, Office 2007 Expert, software speaker, software training, consulting, software tips & tricks, Office 2007 trainer, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, Microsoft Outlook, tips, Microsoft Office 2007 trainingSoftware Tips & Tricks, Expert Speaker, Microsoft Office 2010 Training, Microsoft Certified Trainer, Microsoft Office Consultant, Books, Videos, Web Training  
 Home Products Programs Meet Dawn Free E-zine Media Room Contact 
Programs  

Technology Trainer
Software & Tech Speaker
Software Consultant
Tips & Tricks
The Pro Shop
Free Software Articles
How-To Lessons
Tips Newsletter
Bonus Resources

 
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)
WBENC Certified

WOSB (Women-Owned Small Business) Certified

(303) 699-6868
Dawn@TheSoftwarePro.com

Focused on Results!

The Software Pro® delivers software and technology speaking and training programs including: 

  • NSA, National Speakers Association, professional speaker, presenter, software speaker, trainerConference 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? Does your team want to be more productive in less time? Are you spending too much effort trying to figure out how to use yet one more group of new features?

Choose from this sampling of effective programs for your company, association, or organization (additional and customized programming is available too):

Go To Top of PageMicrosoft Office: Clearing the Cloud of Confusion

The Microsoft Office suite has moved into the web, a.k.a. cloud computing. What are your choices for creating, sharing, editing, and accessing your important Microsoft Office files from multiple devices and locations? How does this affect your e-mail and other important work? What are the differences between Office Web Apps, Office 365, and the latest version, Microsoft Office 2013? What are the top new features in Office 2013? And how do these options work together—or do they? A look at the latest changes to the programs we use every day!

Recommended Session Length: 1 to 2 hours (customized to audiences and organizations). Longer, hands-on training sessions are also available.

Go To Top of PagePresentation Success: Dodging Death by PowerPoint

"Goody! Another slide!" said nobody, ever.

You’ve probably heard the expression, “Death by PowerPoint.” People acknowledge it, laugh about it, and hate it when they are in an audience, but, yet…many continue to be guilty of doing it themselves!

How many times have you been bored, confused, or frustrated by ineffective, poorly designed PowerPoint presentations? How can presenters avoid “Death by PowerPoint” and other presentation sins? 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 2013, 2010, and 2007 (customized for the version you use)
  • 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)

Go To Top of PageWhat's New in Microsoft Office 2013?

Not only has the Microsoft Office suite has moved into the web, a.k.a. cloud computing, but the key programs have undergone a major facelift. What are the top new features in Microsoft Office 2013? How does this affect your e-mail and other important work? How can you still be productive when you upgrade? Tips, tricks, and techniques for working with the latest changes to the programs we use every day!

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 8 or Windows 7.

Go To Top of PageMicrosoft Office Mix:
Tips, Tricks & Techniques for Outlook, Word & Excel

Does it feel like there must be a quicker way to use with the Microsoft Office programs on your desktop? Are you taking too many steps to get your work done? What are the fast and easy tips you can use immediately to make the most of Microsoft Office? Designed in the format of 60 Tips in 60 Minutes, this fully customizable program focuses on the fast and easy tips and shortcuts you need to know in Microsoft Outlook, Word, and Excel; other programs including PowerPoint, Access, and OneNote can be added or swapped in to build a highly interactive and valuable conference, meeting, or educational session.

Recommended Session Length: 60 to 90 minutes (customized to audiences and organizations). Longer, hands-on training sessions are also available.

Go To Top of PageWhat's New in Microsoft Office 2010?

learn office 2010, microsoft office 2010 tips, upgrade to office 2010Microsoft 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.

Go To Top of PageWindows 7 Tips, Tricks & Techniques

windows 7, windows tips, moving to windows 7, tips and tricksWindows 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).

Windows 7 training also presented in webinar format or on video.

Go To Top of PageMicrosoft Outlook E-mail Tips, Tricks & Techniques

outlook 2010 tips, tricks with microsoft outlook, shortcuts, ms outlook, outlook 2007Do 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)

Go To Top of PageAdobe Acrobat Tips, Tricks & Techniques

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)

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!

Go To Top of PageExcel with Excel:
Tips, Tricks & Techniques Everyone Should Know

Microsoft Excel is packed full of features designed to help you create, edit, and format a wide range of worksheet projects. With all of its power, many Excel shortcuts, tips, and techniques are not obvious or intuitive. Join this valuable course to find out how to simplify actions in Excel, customize your workspace, and learn the steps and shortcuts to quickly and easily get your work done.

  • Navigating shortcuts
  • Customizing the default workbook
  • Customizing the Quick Access Toolbar and Ribbon
  • Creating an Excel workspace
  • Fast formatting and editing by grouping worksheets
  • Easy ways to copy and paste
  • Tricks with AutoFill
  • Data entry tips
  • Find & Replace on steroids
  • Quick formatting with the Format Painter
  • Automation shortcuts
  • Customizing Excel options

Go To Top of PageExcel with Excel: Top Essential Functions

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

Go To Top of PageExcel 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

Go To Top of PageExcel with Excel: Linking & Sharing Data

Some 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

Go To Top of PageExcel with Excel: Getting Started with PivotTables

Many 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

Go To Top of PageExcel with Excel: Charts & Graphics

Not 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

Go To Top of PageExcel with Excel: Getting Started with Macros & Automation

If 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

Go To Top of PageMicrosoft Word Wizard:
Tips, Tricks & Techniques Everyone Should Know

word training, Microsoft Word webinars, Word 2010, Word 2007, web training, Word documents, mail merge, reviewing, collaboration, forms, tablesHow 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? With all of its power, many Word shortcuts, tips, and techniques are not obvious or intuitive. Even experienced Word users can discover new and quick ways to save time and effort and to be more productive.  Find out how to stop fighting with Word automation, customize your workspace, and learn the steps and shortcuts to quickly and easily get your work done.

  • Changing the default formatting in a document
  • Stopping annoying automation
  • Customizing the Quick Access Toolbar and Ribbon
  • Easy text entry with AutoCorrect
  • Automatic text with Quick Parts
  • Navigation tips & tricks
  • Find & Replace on steroids
  • Quick formatting with the Format Painter
  • Tricks with graphics
  • Customizing Word options

Recommended Session Length: 1 to 3 hours (may include hands-on learning)

Go To Top of PageMicrosoft Word: Tips, Tricks & Techniques to Manage Long or Complex Documents

Microsoft Word 2010 Training on long documents, table of contents, section formatting, complex documentsAre 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)

Go To Top of PageMoving to Microsoft Office 2007

office 2007, switch to microsoft office 2007, new features in ms office 2007, changes in office 2007Microsoft 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, and other software and technology solutions.

Contact us to learn more.
Go To Top of Page
 



Home for Dawn Bjork Buzbee, The Software Pro
Contact Dawn Bjork Buzbee, The Software Pro
Hot Learning Tip
Audience interaction and participation significantly increases retention and implementation of new skills and processes.
 
Did You Know?
Customized programs and presentations from The Software Pro® will target your organization goals.
 
 
www.TheSoftwarePro.com
HomeContact Us | Training | Speaking | Consulting | Services | Tips & Tricks | Products | How-To Lessons | Free Articles | Newsletter | Resources | Site Map

© Copyright 2015 The Software Pro® & Dawn Bjork Buzbee - All Rights Reserved
(303) 699-6868
§ Dawn@TheSoftwarePro.com § www.TheSoftwarePro.com
Geek Speak Becomes People Friendly

Microsoft Certified Trainer (MCT)
§ Certified Microsoft Office 2013 Specialist (MOS 2013) Master
Certified Microsoft Office 2010 Specialist (MOS 2010) Master Instructor
§ Microsoft Certified Application Specialist (MCAS) Instructor
Certified Microsoft Office Specialist (MOS) Master Instructor
§ Certified Microsoft Office Expert
Certified Women's Business Enterprise (WBE) WBENC Certified
§ WOSB (Women-Owned Small Business) Certified
The Software Pro
® is a registered trademark
Terms & Conditions       Privacy Policy