Excel Essential Training

This course teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, and format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.

Learning objectives

What is Excel and what is it used for?Using the menusWorking with dates and timesCreating simple formulasFormatting fonts, row and column sizes, borders, and moreInserting shapes, arrows, and other graphicsAdding and deleting rows and columnsHiding dataMoving, copying, and pastingSorting and filtering dataPrinting your worksheetSecuring your workbooksTracking changes