List of online resources to help home study learners improve their knowledge of Microsoft Excel 2013. Includes official Microsoft Office links and videos.

 

Microsoft Online Training

Top tips for working in Excel Online
Use Excel Online to change the formatting of numbers and text to help make your information stand out.
http://office.microsoft.com/en-us/office-online-help/video-top-tips-for-working-in-excel-online-VA104146726.aspx?CTT=5&origin=HA104032083

 

AutoFill and Flash Fill
Use Excel Online to change the formatting of numbers and text to help make your information stand out. And see 3 ways to quickly add numbers, too.
http://office.microsoft.com/en-us/excel-help/video-autofill-and-flash-fill-VA104072617.aspx?CTT=5&origin=HA104032083

Average a group of numbers
You may have used AutoSum to quickly add numbers in Excel. But did you know you can also use it to calculate other results, such as averages.
http://office.microsoft.com/en-us/excel-help/video-average-a-group-of-numbers-VA104072635.aspx?CTT=5&origin=HA104032083

 

Insert headers and footers
Learn what headers and footers are, where they're located, and how to print them in Excel.
http://office.microsoft.com/en-us/excel-help/video-insert-headers-and-footers-VA104121791.aspx?CTT=5&origin=HA104032083

 

Take conditional formatting to the next level
In the course Use conditional formatting, we covered the basics of conditional formatting. Here, we'll go a few steps further and see how to apply conditional formatting to cells, tables, PivotTables, and worksheets. For example, to quickly conditionally format cells, you can use a Quick Analysis option or an option on the Conditional Formatting button in the ribbon. We'll also use formulas to apply conditional formatting, and learn how to edit and delete rules using the Conditional Formatting Rules Manager.
http://office.microsoft.com/en-us/excel-help/training-courses-for-excel-2013-HA104032083.aspx?CTT=1