Microsoft Excel 2007 PC: Excel Training

Microsoft Excel 2007 PC: Excel Training

$159.00

Get ready to be the master of all things Excel 2007. Your boss, colleagues, and friends will soon be groveling at your feet in amazement.

Add To Cart

With Excel Everest, you'll master the following business-critical skills: 

THE ESSENTIAL EXCEL BASICS

Cells and cell properties

  • Number types
  • Move and autofill cells
  • Absolute vs. relative references

The power of paste special

  • Paste options
  • Transpose function

Basic to advance formatting

  • Colors and borders
  • Text options
  • Formatting tables
  • Conditional formatting

Sorting and auto-filters

  • Sorting
  • Auto-filters

Text to columns and find and replace

  • Text to columns
  • Find and replace
  • Combing these functions

Manipulating rows and columns

  • Adding, moving, and deleting rows
  • Hiding and resizing
  • Grouping

The drawing toolbar

  • Grouping, ordering, and selecting objects
  • Shapes, pictures, and object properties

PLAYING WITH FORMULAS

The critical business formulas

  • Vlookup
  • IF statements

Basic math formulas

  • Sum, count, average
  • Percentile, percent rank
  • Rand & randbetween

Text formulas

  • Quotes and ampersand
  • Right, left, and trim

Statistical formulas

  • Average, median, mode, max, min, correl, and stdev

ANSWERING QUESTIONS ABOUT NUMBERS

The basics that your boss will ask for

  • Pivot tables
  • Basic charting
  • Chart formatting

TIPS AND TRICKS

Business tricks you'll love

  • Making an email list
  • Working with multiple tabs
  • The F5 key
  • Getting ride of duplicates
  • Basic macros
  • Printing from Excel

The joy of keyboard shortcuts

  • Tab/enter & navigation
  • Paste special
  • Ctrl-Y and F4