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.
