Embedded Files
Excel
Excel
GCF LearnFree.org is a hands-on tutorial on how to use Microsoft Excel. Click the box below to launch the site.
Check out this YouTube Playlist on Excel 2013.
There are 83 videos on the basics of Microsoft Excel
Important parts of a Workbook
Important parts of a Workbook
Ribbons
Ribbons
Home
Home
Access to the most commonly used commands. The Home tab is selected by default whenever you open Excel.
Insert
Insert
Insert charts, tables, and more.
Page Layout
Page Layout
Change the print formatting. (margin width, page orientation, etc.
Formulas
Formulas
Access to the most commonly used functions and formulas in Excel. They can help calculate and analyze numerical data, such as averages and percentages.
Data
Data
Makes it easy to sort and filter information.
Review
Review
Access Excel's powerful editing features, including comments and track changes.
View
View
Allows you to switch between different views for your workbook and freeze panes for easy viewing.
Contextual Tabs
Contextual Tabs
Contextual tabs will appear on the Ribbon when working with certain items, like tables and pictures. These tabs contain special command groups that can help you format these items as needed.
Formatting Cells
Formatting Cells
- Font
- Font size
- Bold / Italics / Underline
- Color font
- Fill cell color
- Alignment
- Numbers, dates, etc. (custom)
Modify: Cells, Columns and Rows
Modify: Cells, Columns and Rows
Double click in between columns to auto adjust the column width
Right click on column letter to insert or delete a column
Do the same thing for a row, by right clicking the row number.
Right click to “cut” column, then Right click to “insert cut cells”
Select cell, click wrap text
Common Formulas & Functions
Common Formulas & Functions
Freezing Panes
Freezing Panes
Sorting Data
Sorting Data
Sort a range
Sort a sheet
Filtering Data
Filtering Data
Using more than one worksheet
Using more than one worksheet
Insert new
Right-click to Rename
Right-click to Move or Copy
Right-click to change tab color
Report abuse