LearnKey Training

Excel 2010 Course (77-882)

Excel 2010 Course (77-882)


Excel 2010 Course (77-882)

5 Sessions -
17 Hours of Interactive Training

In this course expert Michael Meskers will be covering all of the newest features of Excel 2010, giving you in depth explanations to create a better understanding of material. This course will provide you with 100's of tips and techniques that are taught in “Plain English” allowing you to increase efficiency and productivity in your day-to-day Excel use.

Benefits
  • 100s of tips and tricks to help you increase speed and efficiency
  • In-depth explanation of all topics taught
  • Learn all of the new and greatest features of Excel 2010

About The Author
Michael Meskers is more than just a trainer. With a B.A., two Masters Degrees and fluent in six languages, Michael is highly adept at helping students understand the complexities of applications in many languages. With 19 years of combined experience as an investment banker, supervisor and manager for commercial airlines, Michael brings real-world experience into his instruction. Michael’s clients include William H. Mercer Inc., Sanford Bernstein Inc., The New School University, Digi-Com Group and the Learning Annex. Michael also authored “The Learning Line: Windows Vista” published by J. Wiley & Sons Inc.

Session 1

Section A: Introduction

  • Course Overview
  • Excel 2010 Introduction
  • Quick Access Toolbar
  • Toolbar Customization
  • Additional Customization Buttons

Section B: Navigating Excel

  • Ribbon Organization
  • Function Grouping
  • Multiple Function Access
  • The Document Window
  • Basic Navigation
  • Workbook Options

Section C: Excel 2010 Shortcuts

  • Best Practice Guidelines
  • Common Hot Keys
  • Speed Keys
  • Function Keys
  • CTRL Keys
  • ALT Keys
  • Visible Speed Keys

Section D: Creating and Manipulating Data

  • Entering Data
  • Auto Fill a Series
  • Creating Custom Lists
  • Fill Adjacent Cells
  • Fill Non-Adjacent Cells
  • Auto Fill on Multiple Sheets

Section E: Managing Worksheets

  • Copying/Moving Worksheets
  • Renaming Worksheets
  • Inserting/Deleting Worksheets
  • Hiding Worksheets

Section F: Data Validation

  • Range Criteria
  • List Criteria
  • Extending the List
  • Input Message
  • Validation Error Alerts
  • Validation by Character

Section G: Modifying Cell Content

  • Copy/Paste Options
  • Paste
  • Inserting Columns
  • Transporting Data
  • Copy Cell Formatting
  • Removing Duplicates

Section H: Changing Views

  • Zoom
  • Workbook Views
  • Page Layout
  • Freeze Panes
  • Split Windows
  • Viewing Multiple Windows

Session 2

Section A: Formatting Data

  • Formatting Worksheets
  • Cell/Font Color
  • Background Images
  • Watermarks
  • Worksheet Tab Color

Section B: Formatting Numbers

  • Modifying Cell Formats
  • Format Painter
  • Date Formatting
  • Formatting Multiple Cells
  • Numerical Cell Values
  • Special Formats

Section C: Formatting Text and Tables

  • Formatting Fonts / Fills
  • Cell Height/Width
  • Noncompatible Commands
  • Cell Alignment
  • Inserting Comments
  • Merge and Center
  • Tables

Section D: Understanding Formulas

  • Operations
  • Arithmetic Operations
  • Additional Operation Symbols
  • SUM Function
  • Ranges in Functions
  • AutoSum
  • Average
  • Min/Max Functions
  • Count Formula
  • AutoCalculate
  • Modifying AutoCalculate
  • Copying Formulas
  • Cell Multiplication
  • Relative Cell References
  • Absolute Cell References

Session 3

Section A: Referencing Formulas

  • Totaling Multiple Sheets
  • AutoFit Multiple Cells
  • Linked Formulas
  • Grand Totals
  • Sparkline Graphics
  • Sparkline Colors
  • Consolidation
  • Consolidating Data
  • Linking to Source Data
  • Hierarchical Outline