In Excel Core Training, you will demonstrate the core features and tools in Excel 2016. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.

Learning Outcomes

Upon successful completion of this course, the participant will be able to:

  • Navigate your way through Microsoft Excel;

  • Create and work with a new workbook;

  • Understand, create and work with formulas and functions used to perform calculations;

  • Understand and use formula cell referencing and create more complex formulas;

  • Use font formatting techniques to greatly enhance the look of a worksheet;

  • Use a range of techniques to work with worksheets;

  • Apply a variety of page setup techniques;

  • Apply borders to cells and ranges in a worksheet;

  • Use the most popular and common worksheet functions;

  • Create and use defined names in a workbook;

  • Apply a range of number formatting techniques to worksheet cells;

  • Use goal seeking to determine the values required to reach the desired result;

  • Understand and create simple PivotTables;

  • Use a range of elements and features to enhance charts.