Free Training Videos

You can find more of Bob’s videos at www.Lynda.com. Get a free pass here. These videos are also available as a YouTube channel.

SharePoint 2010:

Several ways of saving Microsoft Office 2010 programs on a SharePoint 2010 site

Excel 2010:

Insert math equations with improved tools

Inserting SmartArt — professionally formatted diagrams

Sharing your work using a Microsoft SharePoint portal

Creating a basic PivotTable

Customizing the Ribbon bar

Adding numbers automatically using the Sum and AutoSum features

Using improved tools to edit pictures

Inserting Sparklines — miniature charts that fit in a cell

Move through large worksheets by freezing panes

Prevent errors using absolute references

Using templates

Using Backstage view (a/k/a the File tab)