Home > Podcasts > Home & Office Computing > Microsoft Applications

OnHomeandOffice (Video)

Expert video tips and tutorials from Home and Office Computing authors: Microsoft Applications, Windows Vista, Social Networking, Gadgets, and more. Learn everything you need to get more out of the technologies you rely on at work and for play.

Subscribe RSS Details

Topics: Home & Office Computing, Microsoft Applications

EpisodeDurationDateFormat

Facebook Essentials: Navigating Facebook

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:33Jun 16, 2010Video MP4

Adding Pivot Table Calculations in Excel 2003 (Video)

By Bill Jelen

Change the pivot table calculation from a normal sum in Excel 2003. Create running totals or percentage of totals.

5:28Mar 4, 2009Video MP4

Application Development with Microsoft Access 2007

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:18Nov 30, 2009Video MP4

Avoid the AutoSum Icon When Recording a Macro (Video)

By Bill Jelen

Never use the AutoSum icon when you are recording a macro. Learn how to get around this annoying problem.

6:24Mar 4, 2009Video MP4

Breaking Apart Text (Video)

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:23Mar 4, 2009Video MP4

Changing a Pivot Table in Excel 2007 (Video)

By Bill Jelen

Learn how to change an existing pivot table in Excel 2007.

3:54Mar 4, 2009Video MP4

Chart Different Orders of Magnitude on a Chart (Video)

By Bill Jelen

See details when your Excel chart contains differing orders of magnitude

6:17Mar 3, 2009Video MP4

Converting Live Formulas to Value (Video)

By Bill Jelen

Convert Excel formulas to their current values.

6:03Mar 4, 2009Video MP4

Copy Worksheets by Ctrl+Drag Worksheet Tab & Group Mode (video)

By Bill Jelen

Faster ways to make a copy of your Excel worksheet. How to make changes to multiple worksheets at one time.

6:00Mar 4, 2009Video MP4

Create a Chart With One Click & Customize by Right Clicking (Video)

By Bill Jelen

Create an Excel chart with one keystroke. Quick ways to customize the chart.

5:51Mar 3, 2009Video MP4

Creating a Pivot Table in Excel 2003 (Video)

By Bill Jelen

Pivot tables are an amazing tool for summarizing data. Create your first pivot table in Excel 2003.

4:32Mar 4, 2009Video MP4

Creating a Pivot Table in Excel 2007 (Video)

By Bill Jelen

Pivot tables are an amazing tool for summarizing data. Learn how to create your first pivot table in Excel 2007.

3:59Mar 4, 2009Video MP4

Discover New Functions in Excel (Video)

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:58Mar 4, 2009Video MP4

Drag and Drop New Data on a Chart (Video)

By Bill Jelen

Add new data to an existing Excel chart.

4:47Mar 3, 2009Video MP4

Exploring the Metro Interface in Windows 8 Consumer Preview

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:36Mar 27, 2012Video MP4

Fill Handle Tricks (Video)

By Bill Jelen

Faster ways to use the fill handle when you are creating an Excel worksheet.

5:53Mar 4, 2009Video MP4

Filter by Selection (Video)

By Bill Jelen

Access has offered Filter by Selection for many years. Don't you wish Excel offered the same functionality? It does!

4:21Mar 4, 2009Video MP4

Formula Auditing in Excel, Including Evaluate Formula (Video)

By Bill Jelen

Explore how a worksheet is working by using the Formula Auditing tools.

5:43Mar 4, 2009Video MP4

Goal Seek in Excel (Video)

By Bill Jelen

If you need to back into an answer in Excel, use the Goal Seek command.

4:50Mar 4, 2009Video MP4

IF formula in Excel - Part 1 (Video)

By Bill Jelen

Perform conditional calculations in Excel using the IF function.

6:17Mar 4, 2009Video MP4

IF Formula in Excel - Part 2 (Video)

By Bill Jelen

Make the Excel IF function more powerful by using AND, OR, and NOT functions.

5:56Mar 4, 2009Video MP4

Improve the Fill Handle Using a Custom List (Video)

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:36Mar 4, 2009Video MP4

Join Text in One Column with Text in Another Column. Copy a Formula by Double-Clicking the Fill Handle (Video)

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:55Mar 4, 2009Video MP4

Mac OS X Lion: Creating and Using Playlists

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:43May 30, 2012Video MP4

Mac OS X Lion: Using Face Time

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:04May 30, 2012Video MP4

Mac OS X Lion: Using Photo Booth

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:30May 30, 2012Video MP4

Microsoft Excel 2010: Bubble Charts

By Bill Jelen

Compare the relationship between three variables in an Excel Bubble Chart.

5:44May 4, 2011Video MP4

Microsoft Excel 2010: Chart New Data

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:40May 4, 2011Video MP4

Microsoft Excel 2010: Chart Templates

By Bill Jelen

Create a perfect Excel chart in one keystroke using a Chart Template.

4:56May 4, 2011Audio MP3

Microsoft Excel 2010: Combination Chart

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:51May 4, 2011Video MP4

Microsoft Excel 2010: Compare Two Lists

By Bill Jelen

Compare two lists without using VLOOKUP! This episode shows you an easy Pivot Table solution.

5:17Jun 9, 2011Video MP4

Microsoft Excel 2010: Custom Sorting

By Bill Jelen

Sort your Excel data into a custom sequence using a Custom List

6:04May 11, 2011Video MP4

Microsoft Excel 2010: Customize All Future Workbooks

By Bill Jelen

Hate the default margins in Excel? Teach Excel your favorite settings for all new workbooks and worksheets.

7:33May 18, 2011Video MP4

Microsoft Excel 2010: Double Space

By Bill Jelen

Double- or Triple-space an Excel data set in seconds.

4:03Jun 9, 2011Video MP4

Microsoft Excel 2010: Fast Worksheet Copy

By Bill Jelen

Make copies of your Excel worksheets in less than a second.

4:23May 11, 2011Video MP4

Microsoft Excel 2010: Fill 100k Cells

Fill the numbers 1, 2, 3, …, 100000 in seconds using this Excel trick.

3:43May 4, 2011Video MP4

Microsoft Excel 2010: Fill Blanks

By Bill Jelen

Excel 2010 finally offers a solution for filling the blank cells in the outer row fields of a pivot table.

4:45Jun 2, 2011Video MP4

Microsoft Excel 2010: Filling 1,2,3

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:55May 4, 2011Video MP4

Microsoft Excel 2010: Filter by Selection

By Bill Jelen

Add Filter by Selection to Excel. This favorite feature from Access is in Excel, but the icon is mislabeled.

4:43Jun 9, 2011Video MP4

Microsoft Excel 2010: Format Painter

By Bill Jelen

Copy a format to many Excel cells using this secret Format Painter technique.

4:18Jun 16, 2011Video MP4

Microsoft Excel 2010: Formulas to Values

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:20Apr 26, 2011Video MP4

Microsoft Excel 2010: Frequency Chart

By Bill Jelen

Frequency Distributions in Excel are difficult to master; dump the =FREQUENCY function and use this pivot table solution instead.

5:31Jun 16, 2011Audio MP3

Microsoft Excel 2010: Group Mode

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:20May 18, 2011Video MP4

Microsoft Excel 2010: IFERROR

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:06May 4, 2011Video MP4

Microsoft Excel 2010: Interactive Chart

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:40May 4, 2011Video MP4

Microsoft Excel 2010: Negative Data Bar

By Bill Jelen

Excel introduced data bars in Excel 2007 and complaints ensued. Those complaints were addressed in Excel 2010.

4:28Jun 16, 2011Video MP4

Microsoft Excel 2010: Picture Background Removal

By Bill Jelen

The background removal tool in Excel 2010 actually works, if you follow a few simple guidelines.

4:23Apr 26, 2011Video MP4

Microsoft Excel 2010: Pivot List

By Bill Jelen

Allow an Excel pivot table source field to grow by using Ctrl+L or Ctrl+T.

5:37Jun 16, 2011Video MP4

Microsoft Excel 2010: Pivot Table

By Bill Jelen

Summarize your Excel data using a pivot table.

5:10May 25, 2011Video MP4

Microsoft Excel 2010: Recent Files

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:56May 11, 2011Video MP4

Microsoft Excel 2010: Slicers

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:45Jun 2, 2011Video MP4

Microsoft Excel 2010: Slowmotion

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:36Jun 9, 2011Video MP4

Microsoft Excel 2010: Sorting Subtotals

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:28May 25, 2011Video MP4

Microsoft Excel 2010: Sparkline Labels

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:55Apr 26, 2011Video MP4

Microsoft Excel 2010: Sparklines

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:26Apr 26, 2011Video MP4

Microsoft Excel 2010: Subtotals

By Bill Jelen

Add subtotals at each change in Customer in Excel.

6:01May 18, 2011Video MP4

Microsoft Excel 2010: Sum and Count

By Bill Jelen

The Excel Subtotal function offers 11 functions, but what if you have to Count one column and Sum another column?

5:09May 25, 2011Video MP4

Microsoft Excel 2010: SUMIFS

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:10Apr 26, 2011Video MP4

Microsoft Excel 2010: Top Ten (Pivot Tables)

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:28Jun 2, 2011Video MP4

Microsoft Excel 2010: Trend Line

By Bill Jelen

Forecast the future in an Excel chart with the trendline feature.

6:02Jun 16, 2011Video MP4

Microsoft Excel 2010: Two Slicers

By Bill Jelen

Excel Slicers are better than Report Filters since one set of slicers can drive multiple pivot tables.

4:36Jun 2, 2011Video MP4

Microsoft Excel 2010: Two-Way Lookup

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:04May 25, 2011Audio MP3

Microsoft Excel 2010: V Lookup

By Bill Jelen

Join two tables in Excel using the VLOOKUP function.

4:56Jun 2, 2011Video MP4

Microsoft Excel 2010: Word Processing

By Bill Jelen

Flow text between Excel columns using one of two methods.

5:27Jun 16, 2011Video MP4

Microsoft Excel 2010: Work Days

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:19Jun 9, 2011Video MP4

Microsoft Excel 2010: Worksheets Side by Side

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:03May 18, 2011Video MP4

Microsoft Excel 2010: Year Over Year

By Bill Jelen

Convert a database with daily dates into a year-over-year report with an Excel Pivot Table.

5:21Jun 2, 2011Video MP4

Microsoft Office Access 2007

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:47Nov 30, 2009Video MP4

Microsoft PowerPoint 2010: Cropping & Sizing Images

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:14May 30, 2012Video MP4

Microsoft PowerPoint 2010: Interface Overview

By Echo Swinford

This video provides an introduction to the Microsoft PowerPoint 2010 environment - from Microsoft PowerPoint 2010 LiveLessons Video Training.

4:25May 30, 2012Video MP4

Microsoft PowerPoint 2010: The Importance of Placeholders & Layouts

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:19May 30, 2012Video MP4

Microsoft Windows 7 (Video Training)

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:26Nov 30, 2009Video MP4

Microsoft Windows Vista : Mastering the Vista User Experience

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:02Nov 14, 2009Video MP4

Microsoft Windows Vista : Mastering the Vista User Experience

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:02Dec 1, 2009Video MP4

Music and Video Apps in Windows 8 Consumer Preview

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:24Mar 27, 2012Video MP4

People and Photos Apps in Windows 8 Consumer Preview

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:24Mar 27, 2012Video MP4

Pie Chart Tricks (Video)

By Bill Jelen

Learn cool tricks with Excel pie charts. Explode one slice or bring the small slices around to the front.

6:24Mar 3, 2009Video MP4

Pivot Tables - Replicating a Report for Every Customer (Video)

By Bill Jelen

Once you've created the perfect pivot table, replicate the pivot table for every customer, product, or region.

4:37Mar 4, 2009Video MP4

Pivot Tables - Summarizing Daily Dates by Months or Years (Video)

By Bill Jelen

Summarize daily dates up to monthly or yearly data in Excel 2007.

5:29Mar 4, 2009Video MP4

Pivot Tables - Top 10 Customer Report (Video)

By Bill Jelen

Create a report of the Top 10 customers in your Excel pivot table.

4:31Mar 4, 2009Video MP4

QuickBooks Essentials: For All QuickBooks Users (Video Training)

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:43Nov 30, 2009Video MP4

Record a Macro When the Cell Pointer Moves (Video)

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:03Mar 4, 2009Video MP4

Record your First Macro in Excel 2003 (Video)

By Bill Jelen

Record your first macro in Excel 2003.

5:35Mar 4, 2009Video MP4

Record your First Macro in Excel 2007 (Video)

By Bill Jelen

Record your first macro in Excel 2007

5:17Mar 4, 2009Video MP4

See all Formulas in Excel (Video)

By Bill Jelen

See all formulas in an Excel workbook at once. Also - highlight all formulas in Excel.

5:24Mar 4, 2009Video MP4

Setting up Data for Quick Sorting (Video)

By Bill Jelen

How to set up data for easy sorting and analysis

5:03Mar 4, 2009Video MP4

Subtotals Part 1 - Add Subtotals in Seconds (Video)

By Bill Jelen

Add hundreds of Excel subtotals in seconds.

4:47Mar 4, 2009Video MP4

Subtotals Part 2 - Copy Subtotal Lines (Video)

By Bill Jelen

See only the subtotal lines and how to copy those rows to a new workbook

4:32Mar 4, 2009Video MP4

Subtotals Part 3 - Format Subtotal Lines (Video)

By Bill Jelen

Learn how to Format the subtotal lines.

5:16Mar 4, 2009Video MP4

SUMIF and SUMIFS in Excel (Video)

By Bill Jelen

Do conditional sums in Excel using SUMIF and the new Excel 2007 SUMIFS functions

5:25Mar 4, 2009Video MP4

Three Ways of Entering Formulas in Excel (Video)

By Bill Jelen

Three different ways to enter a formula in Excel. Includes a discussion of relative and absolute references.

5:58Mar 4, 2009Video MP4

Turn a Range on its Side with Paste Special Transpose (Video)

By Bill Jelen

Turn an Excel table on its side with Transpose. And I'll show you how to Transpose with a formula.

4:41Mar 4, 2009Video MP4

Understanding Protected View in Office 2010

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:19Mar 30, 2011Video MP4

Unhide all Worksheets with a Macro (Video)

By Bill Jelen

Loop through all worksheets in the current workbook to unhide them.

6:45Mar 4, 2009Video MP4

VLOOKUP Formulas in Excel - Part 1 (Video)

By Bill Jelen

Use VLOOKUP to match up data from two Excel lists.

5:57Mar 4, 2009Video MP4

VLOOKUP Formulas in Excel - Part 2 (Video)

By Bill Jelen

Advanced VLOOKUP uses in Excel.

5:37Mar 4, 2009Video MP4

Ways to Run a Macro (Video)

By Bill Jelen

Run a macro from a keystroke, a button, an icon or a duck.

6:35Mar 4, 2009Video MP4

What-If Analysis in Excel (Video)

By Bill Jelen

Perform 100 Excel what-if analyses in seconds.

5:13Mar 4, 2009Video MP4

Windows 8 Consumer Preview: A Personal Tour of the Start Screen

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:48Mar 9, 2012Video MP4

OnHomeandOffice (Video)