| |
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
|
| | >>Download the Excel with Excel Learning Series Flyer  Even 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. Busy schedule? Can’t attend a training session? Out of the office? No worries--a video recording of each webinar is included with your registration so you can still get the training even if you can't connect for the "live" meeting. Time for webinars:
1:00 PM Mountain (12:00 PM Pacific, 2:00 PM Central, 3:00 PM Eastern)
60-75 minutes each - Excel with Excel Learning Series-Group/Site Package of Webinars
$477 for complete series of 6 webinars (20% savings)
These 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. Call us to share cost among departments.
Includes participant handouts and session recordings
"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 This date has passed; order below to receive webinar video and handout
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
This date has passed; order below to receive webinar video and handout
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
This date has passed; order below to receive webinar video and handout
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
This date has passed; order below to receive webinar video and handout
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
This date has passed; order below to receive webinar video and handout
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
This date has passed; order below to receive webinar video and handout
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. 
| |
|
Tips, Tricks, Secrets you need to know now!
|
Save hours or even weeks of frustration by signing up for an Excel webinar today!
|
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. |
|
