Introduction to Microsoft Excel

Explore Excel formulas, Pivot Tables, charts, and automation, then choose NYIM training for your spreadsheet experience and goals.

Microsoft Excel is a spreadsheet application for organizing information, performing calculations, and presenting results. A useful workbook begins with consistent data and a clear question, such as how sales vary by month or which expenses exceed a budget.

What Can You Do with Excel?

Formulas calculate values using cell references. Functions such as SUM, AVERAGE, IF, and SUMIFS support common calculations and conditional summaries. Lookup functions help match related records across lists.

Tables, sorting, and filters make lists easier to manage. Pivot Tables summarize data by categories, while charts show comparisons and trends. These tools are useful in finance, administration, operations, and many other roles.

Build Skills in a Practical Order

  1. Enter and format data consistently, including dates and numbers.
  2. Write formulas and understand relative and absolute references.
  3. Clean text, find matching records, and check calculations.
  4. Summarize results with Pivot Tables and appropriate charts.
  5. Explore reusable reporting workflows and automation.

Power Query can help prepare data for repeated analysis. Desktop Excel also supports VBA macros, but Excel for the web cannot create, edit, or run VBA macros. Features differ by version and platform, so check the requirements for any course or workbook you plan to use.

Learn Excel with NYIM

Choose Excel for Business Fundamentals, Intermediate Excel, or Advanced Excel based on your existing skills. The Excel for Business Bootcamp combines the three levels.

For specialized work, explore Excel VBA programming or Advanced Excel for Financial Modeling. Review each outline and practice on sample data before applying new techniques to an important workbook.

Topics

Learn more in these courses

Back to Blog
Yelp Facebook LinkedIn YouTube Twitter Instagram