Online Excel Training-Excel Videos

Accelerate Your Excel Expertise with Online Excel Training Classes

Excel with Excel Learning Series

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? How much time are you wasting trying to hunt down the how-to steps to get your work done?

In these tips-packed, online Excel 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 targeted Excel training session or grab them all! High value online Excel training for as little as $25 each!

Note: These are video recordings of past webinars on Microsoft Excel 2010 (with support for Excel 2007). You will have immediate access to the recordings, workbooks, and sample files after your order is processed. Microsoft Excel 2016 videos will be available in the future. Join our monthly newsletter to be the first to find out about these training opportunities.

Choose Your Online Excel Training

• Tips, Tricks & Timesavers You Should Know
• Top Essential Functions
• Filtering & Sorting Techniques
• Linking & Sharing Data
• Getting Started with PivotTables
• Charts & Graphics
• Getting Started with Macros

Or grab the entire online Excel training series and accelerate your Excel skills!

Grab the Entire Series and Become an Excel Expert!

Interested in this program? We’re in the process of moving to a simpler shopping system.
Please contact us at 303-699-6868 or Dawn@TheSoftwarePro.com to place your order.

Excel with Excel Learning Series-Individual Package of Webinars
$177 for complete series of 6 webinar video recordings (30% savings)

Includes participant handouts and session recordings
Video downloads: Download link page provided immediately after order is completed
(Single-user licenses only; not for sharing)
75 minutes each

Excel with Excel Learning Series-Group/Site Package of Webinars
$477 for complete series of 7 webinar video recordings (30% savings)

Includes participant handouts and session recordings
Video downloads: Download link page provided immediately after order is completed
Great for Lunch & Learn workshops, staff meetings, and quick, focused training; includes group/site license for video recordings and materials.
75 minutes each

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 features and tools and include video recording of the training, and participant workbook. High value online Excel training at a great value–as little as $25 each!

All webinars videos created personally by Dawn Bjork, 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.

Excel with Excel: Tips, Tricks & Timesavers You Should Know

For Microsoft Excel 2010
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 work, and learn the steps and shortcuts to quickly and easily get your work done.

• Navigating shortcuts
• Customizing the Quick Access Toolbar and Ribbon
• Tricks for managing workbooks
• Fast formatting and editing by grouping worksheets
• Easy ways to copy and paste
• Tricks with AutoFill
• Data entry tips
• Quick formatting with the Format Painter
• Automation shortcuts
• Customizing Excel options

Interested in this program? We’re in the process of moving to a simpler shopping system.
Please contact us at 303-699-6868 or Dawn@TheSoftwarePro.com to place your order.

Excel with Excel: Tips, Tricks & Timesavers-Individual $37
Includes participant handouts and session recordings
Video downloads: Download link page provided immediately after order is completed
(Single-user license only; not for sharing)

Excel with Excel: Tips, Tricks & Timesavers-Group/Site $99
Includes participant handouts and session recordings
Video downloads: Download link page provided immediately after order is completed
(Group/site license)

Or join the entire webinar series and accelerate your Excel skills!

Excel with Excel: Top Essential Functions

For Microsoft Excel 2010
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

Interested in this program? We’re in the process of moving to a simpler shopping system.
Please contact us at 303-699-6868 or Dawn@TheSoftwarePro.com to place your order.

Excel with Excel: Top Essential Functions-Individual $37
Includes participant handouts and session recordings
Video downloads: Download link page provided immediately after order is completed
(Single-user license only; not for sharing)

Excel with Excel: Top Essential Functions-Group/Site $99
Includes participant handouts and session recordings
Video downloads: Download link page provided immediately after order is completed
(Group/site license)

Or join the entire webinar series and accelerate your Excel skills!

Excel with Excel: Filtering & Sorting Techniques

For Microsoft Excel 2010
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

Interested in this program? We’re in the process of moving to a simpler shopping system.
Please contact us at 303-699-6868 or Dawn@TheSoftwarePro.com to place your order.

Excel with Excel: Filtering & Sorting Techniques-Individual $37
Includes participant handouts and session recordings
Video downloads: Download link page provided immediately after order is completed
(Single-user license only; not for sharing)

Excel with Excel: Filtering & Sorting Techniques-Group/Site $99
Includes participant handouts and session recordings
Video downloads: Download link page provided immediately after order is completed
(Group/site license)

Or join the entire webinar series and accelerate your Excel skills!

Excel with Excel: Linking & Sharing Data

For Microsoft Excel 2010
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

Interested in this program? We’re in the process of moving to a simpler shopping system.
Please contact us at 303-699-6868 or Dawn@TheSoftwarePro.com to place your order.

Excel with Excel: Linking & Sharing Data-Individual $37
Includes participant handout and session recording
Video downloads: Download link page provided immediately after order is completed
(Single-user license only; not for sharing)

Excel with Excel: Linking & Sharing Data-Group/Site $99
Includes participant handout and session recording
Video downloads: Download link page provided immediately after order is completed
(Group/site license)

Or join the entire webinar series and accelerate your Excel skills!

Excel with Excel: Getting Started with PivotTables

For Microsoft 2010
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

Interested in this program? We’re in the process of moving to a simpler shopping system.
Please contact us at 303-699-6868 or Dawn@TheSoftwarePro.com to place your order.

Excel with Excel: Getting Started with PivotTables-Individual $37
Includes participant handouts and session recordings
Video downloads: Download link page provided immediately after order is completed
(Single-user license only; not for sharing)

Excel with Excel: Getting Started with PivotTables-Group/Site $99
Includes participant handouts and session recordings
Video downloads: Download link page provided immediately after order is completed
(Group/site license)

Or join the entire webinar series and accelerate your Excel skills!

Excel with Excel: Charts & Graphics

For Microsoft 2010
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

Interested in this program? We’re in the process of moving to a simpler shopping system.
Please contact us at 303-699-6868 or Dawn@TheSoftwarePro.com to place your order.

Excel with Excel: Charts & Graphics-Individual $37
Includes participant handouts and session recordings
Video downloads: Download link page provided immediately after order is completed
(Single-user license only; not for sharing)

Excel with Excel: Charts & Graphics-Group/Site $99
Includes participant handouts and session recordings
Video downloads: Download link page provided immediately after order is completed
(Group/site license)

Or join the entire webinar series and accelerate your Excel skills!

Excel with Excel: Getting Started with Macros

For Microsoft 2010
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 graphic

Interested in this program? We’re in the process of moving to a simpler shopping system.
Please contact us at 303-699-6868 or Dawn@TheSoftwarePro.com to place your order.

Excel with Excel: Getting Started with Macros $37
Includes participant handouts and session recordings
Video downloads: Download link page provided immediately after order is completed
(Single-user license only; not for sharing)

Excel with Excel: Getting Started with Macros/Site $99
Includes participant handouts and session recordings
Video downloads: Download link page provided immediately after order is completed
(Group/site license)

Or join the entire webinar series and accelerate your Excel skills!