Instructor: Isaac Gottlieb

This workshop is designed to give students a strong foundation in the basics of Microsoft Excel for business applications. The following topics will be covered:

Excel Basics and Efficiency:

  • Auto Fill
  • Selecting in Excel
  • Formulas, Functions, and Addressing
  • Renaming Cells and Ranges
  • Conditional Formatting

Charts:
  • Simple & Quick Charts
  • Advanced Charting techniques
  • Sparklines

Text to Columns

Statistics Using Excel:
  • Descriptive Statistics
  • Frequency Distributions
  • Data Analysis
  • Histograms
  • Regressing Using Excel and Excel Charts

Data Menu:
  • Sorting Data
  • Auto Filter
  • Grouping and Outlining Data
  • Subtotals

IF Functions in Excel