[youtube]http://www.youtube.com/watch?v=rVEBJW0-HIQ[/youtube]
Chapter 1 - GETTING COMFORTABLE WITH EXCEL

The Excel Web App interface is different from the traditional Excel application in that the web app runs within your web browser. The Ribbon at the top of the Excel Web App interface screen contains tabs, such as Home and Insert.
The Home tab contains common functionality in groupings, such as Clipboard, Font, Alignment, Number, Tables, Cells, Data, and Office.

Features of the Home Tab

Home Tab Section	Description
Clipboard	Allows you to cut, copy, and paste data between cells within the spreadsheet
Font	Allows you to adjust the font size and style
Alignment	Set the alignment of the data in the cells and allow text to wrap
Number	Change the formatting of numeric data
Tables	Sort and filter tables or access the table options
Cells	Insert or delete cells in the spreadsheet
Data	Find data in the spreadsheet or refresh any connections to external data
Office	Open the spreadsheet in Excel located on your local computer

The Insert tab allows you to insert a table or hyperlink into your Excel Web App document. A table allows you to manipulate data with functionality, such as sorting the data in ascending or descending order or filtering the data based on specific criteria. A hyperlink allows you to create clickable text that, when clicked, opens up a new website.
For example, you can create a hyperlink with text that says “Learn More” that takes anyone viewing the Excel Web App document to a news article.
In addition to the Ribbon tabs, the interface also includes a File menu. The File menu allows you to perform functionality, such as saving the document as a different name, opening the document in the traditional Excel application located on your computer, downloading a snapshot of the document, or downloading a copy of the document.


Course Info:

This series is for anyone who wants to know Excel in a non-intimidating, soup-to-nuts manner. If you've never used Excel, this is your starting point. No prior experience is necessary. If you've used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you are efficient and accurate. If you've used previous versions of Excel (prior to Office 2007) then there are a lot of features and changes you need to be aware of to fully utilize this software. In this course we take you from start to finish including entering data, configuring workbooks, working with calculations, applying regular and conditional formatting, creating custom formats, using names, leveraging the power of tables and charts and outputting your work. These are the skills every Excel user needs to know no matter how new or how experienced you may be!
Highlights

1. Break down Excel into its component parts to make it more manageable and less overwhelming
2. Use common, understandable names to replace confusing cell references
3. Apply traditional formatting, create custom formats and apply formatting that automatically changes based on conditions you designate
4. Truly understand how formulas and functions work, no matter how seemingly simple or complex
5. Learn the Commandments of Excel Usage™ to ensure your work is efficient and accurate
6. Embrace the power of tables to sort, filter and manage data more easily
7. Create charts with just one click