|
|
|
|
ONLINE- Excel 2010 Training Series- 28 hrs
SKU
EXCEL-2010-TRAINING-SERIES
Skill Level Required to enjoy this course: Intermediate
Summary:
Gain the required Excel 2010 knowledge to create complex business applications in Microsoft Excel. This series will teach you to analyse data, use formulae and apply filters.
Audience:
Anyone interested in learning about advanced data analysis features of Excel 2007.
Excel 2010 MOS: Becoming Familiar with Excel
- Learning the Excel Environment
- New and Existing Workbooks
- Moving Around a Workbook
- Saving Workbooks
- Checking Compatibility and Accessibility
- Working More Efficiently
- Recovering Workbooks and Updating Excel
Excel 2010 MOS: Performing Basic Workbook Tasks
- Selecting Cells, Rows, and Columns
- Entering Labels and Values
- Editing and Clearing Cell Contents
- Copying, Moving, and Pasting Content
- Inserting, Deleting, and Replacing
- Using AutoCorrect and Actions
Excel 2010 MOS: Working with Formulas and Functions
- Working with Formulas
- Editing Formulas and Using References
- Naming Cell Ranges
- Performing Calculations
- Correcting Errors
- Audits and Circular References
- Creating Functions
- Array Formulas and Nested Functions
Excel 2010 MOS: Modifying Workbooks and Worksheets
- Working with Excel Worksheets
- Moving, Copying, and Hiding Worksheets
- Selecting and Hiding Columns and Rows
- Inserting and Deleting Columns and Rows
- Adjusting Column Width and Row Height
- Freezing and Splitting Worksheets
- Creating Views and Saving Layouts
- Using Templates
Excel 2010 MOS: Formatting Worksheets
- Formatting Numbers and Text
- Applying Conditional Formatting
- Managing Conditional Formatting
- Adding Sparkline Formatting
- Adjusting Data Alignment and Text Flow
- Adding Color and Borders
- Using Themes
- Applying Cell Styles
Excel 2010 MOS: Viewing and Printing
- Setting Up Pages for Printing
- Adjusting Page Margins
- Adding Headers and Footers
- Inserting Page Breaks
- Customizing the Print Area
- Previewing and Printing
Excel 2010 MOS: Working with Graphics
- Using Clip Art and Media Clips
- Inserting Pictures and Screenshots
- Applying Styles, Shapes, and Borders
- Correcting and Recoloring Pictures
- Adding Transparency
- Creating WordArt Text
- Building SmartArt Graphics
- Drawing and Modifying Shapes
Excel 2010 MOS: Charting, Sorting, and Filtering Data
- Creating Charts
- Creating Tables
- Sorting Table Data
- Filtering Table Data
- Using PivotTables
Excel 2010 MOS: Reviewing and Sharing Data
- Using Cell Comments
- E-Mailing Workbooks
- Exporting and Importing Data
- Linking and Embedding Data
- Consolidating Data
- Getting External Data
- Publishing Workbooks to the Web
- Creating and Formatting Hyperlinks
- Saving Workbooks with Windows Live
|
|
|