Excel 2010 Core Skills
Learn how to
- Understand the structure and layout of Spreadsheets
- Create, modify and Save Spreadsheets
- Enter information
- Perform calculations using formulas
- Format spreadsheets to make them look professional
- Create a variety of different charts
- Print Spreadsheets
Content
Excel Introduction
What is Microsoft Excel?
Starting Excel
The Excel Screen
The Tab-and-Ribbon Interface
The Quick Access Toolbar
Keyboard Shortcuts
Using Help
Workbooks and Worksheets
The Structure of Excel Files
XLS and XML
Opening an Existing Workbook
Saving a Workbook
Starting a New Workbook
Navigating a Workbook
Managing Worksheets
Entering Information
Spreadsheet Information
Formatting Cells for Specific Contents
Entering Labels
Using Numbers as Labels
Using Spellcheck
Using AutoComplete
Entering Numbers
Using Currency and other formats
Date and Time
Using Percentages
Using Fractions
Selecting a Range
Using Autofill
Entering Formulas
Basic Formulas
Order of Operations (BODMAS)
Basic Mathematical Functions
Using SUM
Using AVERAGE
Using COUNT
Using MAX
Using MIN
Using AutoSum
Referencing Other Cells in Formulas
Multiple Worksheets and WorkBooks
Referencing Cells in Other WorkSheets
Referencing Cells in Other Workbooks
Opening Workbooks with External References
Formatting Workbooks
Editing Cell Contents
Selecting Cells
Copying and Moving Cells
The Clipboard
Inserting and Deleting Cells, Rows and Columns
Using Undo and Redo Using Find and Replace Cell Comments Formatting Cell Content
Advanced Cell Formatting
AutoFormat
Using Format Painter
Row Height and Column Width
Cell Styles
Themes
Charts
Chart Types
Creating a Chart
Formatting and Editing Chart Objects
Changing the Source Data of a Chart
Charging a Charts Type
Annotating Charts
Printing a Worksheet
Using Print Preview
Printing a Large WorkSheet
Printing a Chart
Additional Print Options