Corman Data Analysis & Training

(CDAT)

About Me | Excel tutorials | Excel Topics | Data Analysis | Rates

Excel Topics

I have been working with spreadsheets since the early '80s (anyone remember VisiCalc, QuattroPro, Multiplan??). The following is just a sampling of topics that I can cover in corporate or personal training. I am most comfortable in Windows-based Excel (shortcuts, commands, etc. are a bit different in Mac-based Excel). As mentioned in other areas of this website, I can customize coverage to meet your specific needs.

Introductory
Intermediate
Advanced
  • Worksheets - cells (rows and columns)
  • Inserting/Deleting rows/columns
  • Entering Formulas
  • Text vs. Numbers, vs. Dates
  • copy and paste within Excel
  • Functions
  • Formatting (text, numbers, and dates)
  • Editing Cells
  • Cell referencing (relative, absolute, mixed)
  • Charts (graphs)
  • Pivot Tables
  • Pivot Charts
  • IF, Vlookup, and other intermediate functions
  • Headers/footers
  • conditional formatting
  • data filtering (using tables)
  • data validation
  • linking tables
  • print areas/titles
  • Freezing rows/columns
  • goal seek
  • scenario manager
  • sparklines
  • slicers
  • data tables
  • Statistical functions
  • macros (elementary use)

In addition, I can be of assistance in Excel/Word integration such as mail merges.
E-Mail CDAT last updated: September 12, 2014