By Yvonne Johnson The playlist is at the heart of iTunes. In this video, Yvonne Johnson shows you how to import music into iTunes and then use that music to create and listen to playlists - from Mac OS X Lion Video Training. | 7:43 | May 30, 2012 |  |
By Yvonne Johnson Using Face Time, you can make video calls to other Mac and iPhone users. In this video, Yvonne Johnson makes and receives a video call and shows you how to turn Face Time off if you don’t want to be bothered - from Mac OS X Lion Video Training. | 6:04 | May 30, 2012 | |
By Yvonne Johnson Photo Booth is an application that uses the built-in camera to take photos and videos that you can view and share. Yvonne Johnson takes some spooky photos, made even scarier with special effects, and shows you how to record and trim a video. | 5:30 | May 30, 2012 | |
By Echo Swinford Learn how to work with photos in Microsoft PowerPoint 2010. Coverage includes cropping and sizing images - from Microsoft PowerPoint 2010 LiveLessons Video Training. | 2:14 | May 30, 2012 | |
By Echo Swinford This video provides an introduction to the Microsoft PowerPoint 2010 environment - from Microsoft PowerPoint 2010 LiveLessons Video Training. | 4:25 | May 30, 2012 | |
By Echo Swinford Learn about the importance of placeholders and layout in Microsoft PowerPoint 2010. Coverage includes inserting text, slide master, and layouts - from Microsoft PowerPoint 2010 LiveLessons Video Training. | 4:19 | May 30, 2012 | |
By Brien Posey Learn how to navigate the new Windows 8 Metro interface, which has been optimized for use on touch screen displays, from My Windows 8 Consumer Preview. | 7:36 | Mar 27, 2012 | |
By Brien Posey Get a preview of the new Music and Videos hubs coming with the Windows 8 release, from My Windows 8 Consumer Preview. This video demonstrates how Windows 8 categorizes and allows you to sort and play your music and video files. | 5:24 | Mar 27, 2012 | |
By Brien Posey See a preview of the new Windows8 People and Photos hubs, from My Windows 8 Consumer Preview. Learn how Windows 8 will augment the social networking experience; and how to use Windows 8 to organize and view your collection of digital photos. | 5:24 | Mar 27, 2012 | |
By Katherine Murray See the beautiful new Metro user interface of Microsoft Windows 8 Consumer Preview as Katherine Murray guides you through some the new features including Charms, Internet Explorer 10, Windows Explorer, and Windows Store. | 3:48 | Mar 9, 2012 | |
By Bill Jelen Copy a format to many Excel cells using this secret Format Painter technique. | 4:18 | Jun 16, 2011 | |
By Bill Jelen Frequency Distributions in Excel are difficult to master; dump the =FREQUENCY function and use this pivot table solution instead. | 5:31 | Jun 16, 2011 |  |
By Bill Jelen Excel introduced data bars in Excel 2007 and complaints ensued. Those complaints were addressed in Excel 2010. | 4:28 | Jun 16, 2011 | |
By Bill Jelen Allow an Excel pivot table source field to grow by using Ctrl+L or Ctrl+T. | 5:37 | Jun 16, 2011 | |
By Bill Jelen Forecast the future in an Excel chart with the trendline feature. | 6:02 | Jun 16, 2011 | |
By Bill Jelen Flow text between Excel columns using one of two methods. | 5:27 | Jun 16, 2011 | |
By Bill Jelen Compare two lists without using VLOOKUP! This episode shows you an easy Pivot Table solution. | 5:17 | Jun 9, 2011 | |
By Bill Jelen Double- or Triple-space an Excel data set in seconds. | 4:03 | Jun 9, 2011 | |
By Bill Jelen Add Filter by Selection to Excel. This favorite feature from Access is in Excel, but the icon is mislabeled. | 4:43 | Jun 9, 2011 | |
By Bill Jelen Understand complicated Excel formulas by watching Excel calculate the function in slow motion. This episode also shows an over-the-top SUMPRODUCT function to analyze each date between a start date and an end date. | 5:36 | Jun 9, 2011 | |
By Bill Jelen Calculate the number of workdays between two dates. Ignore holidays and weekends, even if your weekend is not Saturday and Sunday. | 5:19 | Jun 9, 2011 | |
By Bill Jelen Excel 2010 finally offers a solution for filling the blank cells in the outer row fields of a pivot table. | 4:45 | Jun 2, 2011 | |
By Bill Jelen Create a dashboard in Excel using the new visual filters for pivot tables. See how to set up Slicers in Excel 2010. | 5:45 | Jun 2, 2011 | |
By Bill Jelen There is a problem with the Excel Top 10 Filter in Pivot Tables. This episode shows how to exploit an Excel bug to create a better Top 10 report. | 6:28 | Jun 2, 2011 | |
By Bill Jelen Excel Slicers are better than Report Filters since one set of slicers can drive multiple pivot tables. | 4:36 | Jun 2, 2011 | |
By Bill Jelen Join two tables in Excel using the VLOOKUP function. | 4:56 | Jun 2, 2011 | |
By Bill Jelen Convert a database with daily dates into a year-over-year report with an Excel Pivot Table. | 5:21 | Jun 2, 2011 | |
By Bill Jelen Summarize your Excel data using a pivot table. | 5:10 | May 25, 2011 | |
By Bill Jelen After adding Excel subtotals, how can you get the largest customer to the top? The answer is easier than you would think! | 5:28 | May 25, 2011 | |
By Bill Jelen The Excel Subtotal function offers 11 functions, but what if you have to Count one column and Sum another column? | 5:09 | May 25, 2011 | |
By Bill Jelen Do both a VLOOKUP and HLOOKUP in the same Excel table using Excel functions MATCH and INDEX for a two-way lookup. | 6:04 | May 25, 2011 | |
By Bill Jelen Hate the default margins in Excel? Teach Excel your favorite settings for all new workbooks and worksheets. | 7:33 | May 18, 2011 | |
By Bill Jelen If you need to make changes to several Excel worksheets at once, you can do it quickly using Group Mode, provided the worksheets have a similar structure | 5:20 | May 18, 2011 | |
By Bill Jelen Add subtotals at each change in Customer in Excel. | 6:01 | May 18, 2011 | |
By Bill Jelen It is easy in Excel to compare two workbooks side by side. This episode will show you how to compare two worksheets from the same workbook side by side using New Window. | 5:03 | May 18, 2011 | |
By Bill Jelen Sort your Excel data into a custom sequence using a Custom List | 6:04 | May 11, 2011 | |
By Bill Jelen Make copies of your Excel worksheets in less than a second. | 4:23 | May 11, 2011 | |
By Bill Jelen People complained that the Recent Files list now requires twice as many clicks in Excel 2010. Learn how to access Recent Files in one click. | 4:56 | May 11, 2011 | |
By Bill Jelen Compare the relationship between three variables in an Excel Bubble Chart. | 5:44 | May 4, 2011 | |
By Bill Jelen Your 12 Excel charts are now hanging on the break room bulletin board. Unfortunately, you have to update all of those charts with a new month of data. This episode will show you how you can easily add new data to an existing chart. | 4:40 | May 4, 2011 | |
By Bill Jelen Create a perfect Excel chart in one keystroke using a Chart Template. | 4:56 | May 4, 2011 | |
By Bill Jelen Chart one series as a column on the left axis and another series as a line on the right axis. These Excel combination charts seemingly disappeared after Excel 2003, but you can still create them. | 5:51 | May 4, 2011 | |
Fill the numbers 1, 2, 3, …, 100000 in seconds using this Excel trick. | 3:43 | May 4, 2011 | |
By Bill Jelen The Excel fill handle can easily extend months or weekdays, but it has trouble with 1, 2, 3. Learn how to solve this problem. | 4:55 | May 4, 2011 | |
By Bill Jelen You've probably caught the #N/A errors using a combination of IF, ISNA, or ISERROR. Starting in Excel 2007, use the faster IFERROR function to avoid errors. | 5:06 | May 4, 2011 | |
By Bill Jelen You have to create an Excel chart for 100 different customers. The trick in this episode will show you how to create one chart that can show any selected customer. | 4:40 | May 4, 2011 | |
By Bill Jelen Whether you call it Range Value, Paste Special Values, Alt+ESV, Copy Here as Values Only or Paste Values, this new shortcut in Excel 2010 will give you a faster way to convert your formulas to values. | 5:20 | Apr 26, 2011 | |
By Bill Jelen The background removal tool in Excel 2010 actually works, if you follow a few simple guidelines. | 4:23 | Apr 26, 2011 | |
By Bill Jelen Professor Tufte's sparklines usually had labels but Excel's sparklines don't support labels. MrExcel shows you how to label your sparklines in Excel 2010. | 6:55 | Apr 26, 2011 | |
By Bill Jelen Professor Edward Tufte first described Sparklines in his book "Beautiful Evidence" as "Tiny, Intense, Word-Sized Charts." Take a look at how Excel 2010 implements sparklines. | 4:26 | Apr 26, 2011 | |
By Bill Jelen SUMIF could never deal with multiple conditions. The new SUMIFS function in Excel 2007 allows you to replace your complicated SUMPRODUCT functions with SUMIFS. | 5:10 | Apr 26, 2011 | |
By ClipTraining In this video tutorial you'll learn about the Protected View feature which protects your system from opening unsafe files in Office 2010. | 1:19 | Mar 30, 2011 | |
By Michael Miller What is where on Facebook? In this video lesson, Michael Miller takes you on a tour of the Facebook site, including how to navigate with the Facebook toolbar. | 8:33 | Jun 16, 2010 | |
By J. Peter Bruzzese J. Peter Bruzzese teaches Microsoft Windows Vista…now get the most out of it, faster and more easily than ever before! J. Peter Bruzzese shows you how to maximize your Vista productivity and fun with 100 quick video lessons. | 5:02 | Dec 1, 2009 | |
By Laura Madeira In just 18 quick, practical video lessons, renowned QuickBooks trainer Laura Madeira teaches every essential QuickBooks skill. Now, in QuickBooks Essentials: Video LiveLessons, she walks viewers through setting up QuickBooks | 8:43 | Nov 30, 2009 | |
By J. Peter Bruzzese J. Peter Bruzzese shows you all you need to maximize your productivity with Office 2007's best tools and shortcuts, and its brand-new ribbon interface! | 5:26 | Nov 30, 2009 | |
By Alison Balter Alison Balter teaches Microsoft Office Access 2007's most sophisticated features and techniques visually: just watch! You'll master high-powered Office Access 2007 skills at your own pace–and get specific answers and solutions immediately. | 6:47 | Nov 30, 2009 | |
By Alison Balter In Application Development with Access 2007, renowned Access developer, trainer, and author Alison Balter teaches all the skills you need to build professional-quality Access 2007 applications. | 5:18 | Nov 30, 2009 | |
By J. Peter Bruzzese J. Peter Bruzzese teaches Microsoft Windows Vista…now get the most out of it, faster and more easily than ever before! J. Peter Bruzzese shows you how to maximize your Vista productivity and fun with 100 quick video lessons. | 5:02 | Nov 14, 2009 | |
By Bill Jelen Change the pivot table calculation from a normal sum in Excel 2003. Create running totals or percentage of totals. | 5:28 | Mar 4, 2009 | |
By Bill Jelen Never use the AutoSum icon when you are recording a macro. Learn how to get around this annoying problem. | 6:24 | Mar 4, 2009 | |
By Bill Jelen Do you have City, State, and Zip Code all in a single column and need to sort by zip code? Learn how to break the data into 3 columns. | 5:23 | Mar 4, 2009 | |
By Bill Jelen Learn how to change an existing pivot table in Excel 2007. | 3:54 | Mar 4, 2009 | |
By Bill Jelen Convert Excel formulas to their current values. | 6:03 | Mar 4, 2009 | |
By Bill Jelen Faster ways to make a copy of your Excel worksheet. How to make changes to multiple worksheets at one time. | 6:00 | Mar 4, 2009 | |
By Bill Jelen Pivot tables are an amazing tool for summarizing data. Create your first pivot table in Excel 2003. | 4:32 | Mar 4, 2009 | |
By Bill Jelen Pivot tables are an amazing tool for summarizing data. Learn how to create your first pivot table in Excel 2007. | 3:59 | Mar 4, 2009 | |
By Bill Jelen With 356 functions in Excel, there is probably already a solution for your calculation. Learn how to discover new functions in Excel. | 4:58 | Mar 4, 2009 | |
By Bill Jelen Faster ways to use the fill handle when you are creating an Excel worksheet. | 5:53 | Mar 4, 2009 | |
By Bill Jelen Access has offered Filter by Selection for many years. Don't you wish Excel offered the same functionality? It does! | 4:21 | Mar 4, 2009 | |
By Bill Jelen Explore how a worksheet is working by using the Formula Auditing tools. | 5:43 | Mar 4, 2009 | |
By Bill Jelen If you need to back into an answer in Excel, use the Goal Seek command. | 4:50 | Mar 4, 2009 | |
By Bill Jelen Perform conditional calculations in Excel using the IF function. | 6:17 | Mar 4, 2009 | |
By Bill Jelen Make the Excel IF function more powerful by using AND, OR, and NOT functions. | 5:56 | Mar 4, 2009 | |
By Bill Jelen Teach the Excel fill handle how to extend lists from your company, such as cost centers, plant locations, and so on. | 4:36 | Mar 4, 2009 | |
By Bill Jelen Do you have first name in column A and last name in column B? Learn how to join these together into a single column. | 5:55 | Mar 4, 2009 | |
By Bill Jelen Once you've created the perfect pivot table, replicate the pivot table for every customer, product, or region. | 4:37 | Mar 4, 2009 | |
By Bill Jelen Summarize daily dates up to monthly or yearly data in Excel 2007. | 5:29 | Mar 4, 2009 | |
By Bill Jelen Create a report of the Top 10 customers in your Excel pivot table. | 4:31 | Mar 4, 2009 | |
By Bill Jelen Unfortunately, the macro recorder frequently fails. There is one setting you can change to allow more of your macros to work. | 6:03 | Mar 4, 2009 | |
By Bill Jelen Record your first macro in Excel 2003. | 5:35 | Mar 4, 2009 | |
By Bill Jelen Record your first macro in Excel 2007 | 5:17 | Mar 4, 2009 | |
By Bill Jelen See all formulas in an Excel workbook at once. Also - highlight all formulas in Excel. | 5:24 | Mar 4, 2009 | |
By Bill Jelen How to set up data for easy sorting and analysis | 5:03 | Mar 4, 2009 | |
By Bill Jelen Add hundreds of Excel subtotals in seconds. | 4:47 | Mar 4, 2009 | |
By Bill Jelen See only the subtotal lines and how to copy those rows to a new workbook | 4:32 | Mar 4, 2009 | |
By Bill Jelen Learn how to Format the subtotal lines. | 5:16 | Mar 4, 2009 | |
By Bill Jelen Do conditional sums in Excel using SUMIF and the new Excel 2007 SUMIFS functions | 5:25 | Mar 4, 2009 | |
By Bill Jelen Three different ways to enter a formula in Excel. Includes a discussion of relative and absolute references. | 5:58 | Mar 4, 2009 | |
By Bill Jelen Turn an Excel table on its side with Transpose. And I'll show you how to Transpose with a formula. | 4:41 | Mar 4, 2009 | |
By Bill Jelen Loop through all worksheets in the current workbook to unhide them. | 6:45 | Mar 4, 2009 | |
By Bill Jelen Use VLOOKUP to match up data from two Excel lists. | 5:57 | Mar 4, 2009 | |
By Bill Jelen Advanced VLOOKUP uses in Excel. | 5:37 | Mar 4, 2009 | |
By Bill Jelen Run a macro from a keystroke, a button, an icon or a duck. | 6:35 | Mar 4, 2009 | |
By Bill Jelen Perform 100 Excel what-if analyses in seconds. | 5:13 | Mar 4, 2009 | |
By Bill Jelen See details when your Excel chart contains differing orders of magnitude | 6:17 | Mar 3, 2009 | |
By Bill Jelen Create an Excel chart with one keystroke. Quick ways to customize the chart. | 5:51 | Mar 3, 2009 | |
By Bill Jelen Add new data to an existing Excel chart. | 4:47 | Mar 3, 2009 | |
By Bill Jelen Learn cool tricks with Excel pie charts. Explode one slice or bring the small slices around to the front. | 6:24 | Mar 3, 2009 | |
