Key Excel 2016 Core Topics Covered
Introducing Excel, learn how Excel works, understand how to move within Excel, create a workbook, enter data into a worksheet and work with files.
Constructing Cell Data, learn how to make changes to data in the worksheets, change the structure, and add and remove worksheets in the workbook.
Using Formulas, learn about formulas – what they are, how they work, how to insert simple formulas and use built-in functions to create some formulas.
Formatting the worksheet, learn how to use a variety of methods to format cells in a worksheet to emphasize different worksheet areas.
Viewing and Printing Workbooks, learn how to change the views in preparation for printing worksheets, Print and preview worksheets and customise the page setup for printing worksheets.
Working with Charts and Graphics, you will learn to work with charts and work with different types of graphic images including shapes and pictures.
Organising Data, you will will look at various methods of organising data to improve your ability to analyze it.
Using Data Tools, you will learn about a variety of Excel data to include importing and exporting data between other applications, searching worksheets for a value, using hyperlinks, and making workbooks more accessible.