Course Description
After completing this 1-day Excel 2010 Introduction training course course, students will know how to:
- Start Microsoft Excel and identify the components of the Excel interface;
- Open an Excel workbook;
- Use the Help window;
- Navigate worksheets;
- Enter & edit text, values, & formulas;
- Examine the order of operations;
- Insert pictures;
- Use AutoFill;
- Save and update a workbook;
- Save a workbook as a PDF file;
- Move and copy data and formulas;
- Use the Office Clipboard;
- Use Paste Link;
- Work with relative and absolute references;
- Insert and delete ranges, rows, and columns;
- Use the SUM function, AutoSum, and the AVERAGE, MIN, MAX, COUNT, and COUNTA functions to perform calculations in a worksheet;
- Format cells, rows, and columns;
- Merge cells;
- Apply color and borders;
- Format numbers;
- Create conditional formats;
- Copy formatting;
- Apply table styles;
- Sort data;
- Use Find and Replace to update the formatting for specific content;
- Check spelling;
- Find and replace text and data;
- Preview and print a worksheet;
- Set page orientation and margins;
- Create & format headers and footers;
- Print gridlines;
- Create, format, modify, and print charts based on worksheet data;
- Work with various chart elements;
- Apply chart types and chart styles;
- Freeze panes and split a worksheet;
- Open and arrange a new window with the current worksheet content;
- Hide and unhide data;
- Set print titles and page breaks to optimize print output;
- Insert different even and odd headers;
- Manage multiple worksheets;
- Represent data graphically within cells by applying three forms of conditional formatting (data bars, color scales, and icon sets);
- Insert and modify SmartArt graphics; and insert and modify screenshots;
This course will help students prepare for the Microsoft Office Specialist exam for Excel 2010 (exam 77-882). For comprehensive certification training, students should complete our Introduction, Intermediate, and Advanced courses for Excel 2010.
Pre-requisites
Ability to use a windowed operating system such as WIndows XP, Windows Vista, Windows 7 or Windows 8.
Who is this Course for ?
For newcomers to Excel 2010.
Further Training
After some further on-the-job experience with Excel 2010, we recommend students attend our Excel 2010 Intermediate course to gain higher-level skills in the usage of Excel 2010.
Course content
Outline
Getting started
Spreadsheet terminology
The Excel environment
Getting help
Navigating a worksheet
Spreadsheet terminology
The Excel environment
Getting help
Navigating a worksheet
Entering & editing data
Entering and editing text and values
Entering and editing formulas
Working with pictures
Saving and updating workbooks
Entering and editing formulas
Working with pictures
Saving and updating workbooks
Modifying a worksheet
Moving and copying data
Moving and copying formulas
Absolute and relative references
Inserting and deleting ranges, rows, and columns
Moving and copying formulas
Absolute and relative references
Inserting and deleting ranges, rows, and columns
Using functions
Entering functions
AutoSum
Other common functions
AutoSum
Other common functions
Formatting
Text formatting
Row and column formatting
Number formatting
Conditional formatting
Additional formatting options
Row and column formatting
Number formatting
Conditional formatting
Additional formatting options
Printing
Preparing to print
Page Setup options
Printing worksheets
Page Setup options
Printing worksheets
Charts
Chart basics
Formatting charts
Formatting charts
Managing large workbooks
Viewing large worksheets
Printing large worksheets
Working with multiple worksheets
Printing large worksheets
Working with multiple worksheets
Graphics & screenshots
Conditional formatting with graphics
SmartArt graphics
Screenshots
SmartArt graphics
Screenshots