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

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

The Software Pro has moved to TheSoftwarePro.com

Loaded with tips, tricks, shortcuts & other software goodies!


Excel with Excel Learning Series

Excel training, web classes, Excel 2010, Excel 2007Even if you use Microsoft Excel every day, you are probably missing many of the tools and techniques designed to help you move forward with your projects. How effectively are you using Excel to create, format, and analyze your important data? Do you know how to use all of the new features in Microsoft Excel 2010 or Excel 2007? How much time are you wasting trying to hunt down the how-to steps to get your work done? In these tips-packed, web-based training sessions, you will learn the smart and easy steps you need to build your skills and achieve the results you want in Microsoft Excel. Pick one Excel webinar or grab them all!

Be an Excel Expert! Designed for novice to intermediate Excel users to expand their knowledge and talents working with Excel. Likely to fill in learning gaps for even advanced users too! All sessions focus on step-by-step Excel 2010 and Excel 2007 features and tools and include live webinar, video recording of the training, and participant workbook.

All webinars presented personally by Dawn Bjork Buzbee, MCT, The Software Pro, Microsoft Certified Trainer, Certified Microsoft Excel Expert, and Certified Microsoft Office Specialist Master Instructor. Join the entire series or pick and choose individual Excel web sessions to create a custom training plan.

Go To Top of PageChoose Your Excel Training

Tips, Tricks & Techniques Everyone Should Know This date has passed; click on this link for webinar video & handout
Top Essential Functions This date has passed; click on this link for webinar video & handout
Filtering & Sorting Techniques This date has passed; click on this link for webinar video & handout
Linking & Sharing Data This date has passed; click on this link for webinar video & handout
Getting Started with PivotTables This date has passed; click on this link for webinar video & handout
Charts & Graphics This date has passed; click on this link for webinar video & handout
Getting Started with Macros This date has passed; click on this link for webinar video & handout

Grab the Entire Series and Become an Excel Expert!

  • Excel with Excel Learning Series-Individual Package of Webinars
    $207 for complete series of 7 webinars (20% savings)
    Live webinar
    dates have passed; order below to receive webinar videos and handouts
    (Single-user licenses only; not for sharing)
    Includes participant handouts and session recordings
    60-75 minutes each

     
  • Excel with Excel Learning Series-Group/Site Package of Webinars
    $555 for complete series of 7 webinars (20% savings)
    Live webinar
    dates have passed; order below to receive webinar videos and handouts
    (Show in one conference room or training lab)
    Great for Lunch & Learn workshops, staff meetings, and quick, focused training; includes group/site license for video recordings and materials.
    Call us to share cost among departments.

    Includes participant handouts and session recordings
    60-75 minutes each

     

"I really enjoyed your Excel with Excel series of webinars. I consider myself quite knowledgeable in Excel but I also learned quite a bit and you refreshed my memory on some areas that I don’t use very often."
  Robert, College Instructor

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

Live webinar date has passed; order below to receive webinar videos and handouts
For Microsoft Excel 2010 and Excel 2007
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 training 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
     
  • Excel with Excel: Tips, Tricks & Techniques-Individual $37
    (Single-user license only; not for sharing)
    Includes participant handout and session recording

     

Go To Top of PageExcel with Excel: Top Essential Functions

Live webinar date has passed; order below to receive webinar videos and handouts
More than 400 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

Live webinar date has passed; order below to receive webinar videos and handouts
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

Live webinar date has passed; order below to receive webinar videos and handouts
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

Live webinar date has passed; order below to receive webinar videos and handouts
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, of time 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

Live webinar date has passed; order below to receive webinar videos and handouts
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

Live webinar date has passed; order below to receive webinar videos and handouts
If you have tasks in Microsoft Excel you do repeatedly, you don't have to keep doing each step manually. Instead, you can 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

>>Webinar frequently asked questions (FAQ)

>>Create a custom-tailored webinar for your workplace (design your own program)

Note: Excel 2003 will not be specifically addressed due to the dramatic changes in the Excel interface and features with the latest versions of Microsoft Excel although some topics (functions, linking, macros) would still be of value to Excel 2003 users.

Go To Top of Page
 



Home for Dawn Bjork Buzbee, The Software Pro
Contact Dawn Bjork Buzbee, The Software Pro
Hot Tip
Save hours or even weeks of frustration by signing up for an Excel webinar today!
 
Did You Know?

How effectively are you using Excel to create, format, and analyze your important data? Do you know how to use all of the new features in Microsoft Excel 2010 or Excel 2007? How much time are you wasting trying to hunt down the how-to steps to get your work done?

Find out with the Excel with Excel Learning Series.


 
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