Certificate in Microsoft Excel Course Guide

This course will provide an introduction to the key features of Excel, including but not limited to Excel screen components, how to start Excel and the basic layout of worksheets.

This course will provide an introduction to entering data effectively into a worksheet. It will include but not be limited to the fundamentals of data entry, how to enter and remove data from a worksheet, how to adjust a worksheet to accommodate data, and quick data entry techniques.

This course will provide an introduction to the file operations necessary for saving and accessing Excel files, including but not limited to how to save a workbook, how to open and close an existing workbook and how to move between open workbooks.

This course will provide an introduction to the fundamentals of creating calculations in Excel, including but not limited to understanding how to write formulas and use the built-in Excel functions, and the way Excel performs calculations (BEDMAS).

This course will provide an introduction to modifying the layout of a worksheet and how to copy data. It will include but not be limited to how to move and copy data in a worksheet and between worksheets and workbooks, how to make modifications to data, and how to create formulas with absolute cell references.

This course will provide an introduction to formatting commands necessary for effective presentation, including but not limited to setting the number format for cells and how to change the appearance of data using formatting options.

This course will provide an overview of print settings, including but not limited to how to preview a worksheet before printing to ensure the layout is correct and how to print all or part of a workbook or worksheet.

This course will provide an overview of the Sort and Filter features of Excel and their powerful ability to help manipulate lists of data and keep track of information in an orderly fashion. It will include but not be limited to how to sort a table of data, how to filter a table of data and how to work with filtered data.