Excel 2010/13/16 Intermediate

Prerequisite: Has attended the Excel Introduction course or has equivalent knowledge.

Duration: One day

Course Topics

Tipsand tricks
* Viewing multiple workbooks
* Workspace file
* Splitting a spreadsheet window into panes
* Freezing spreadsheet titles
* Zoom
* Hide columns and rows

Multiple Worksheet Formulas
* Entering data and formulas in multiple sheets
* Page break preview
* Excel formulas
* Absolute, mixed and relative references
* Using range names in formulas
* Manual calculation

Advanced Excel functions
* Dates in formulas
* Date functions
* Vlookup and HLook up
* Financial functions
* Logical functions (if, and, or)
* Nesting functions

Databases
* Creating a list
* Sorting data
* Filtering a list
* Subtotals
* Pivot tables
* Pivot table chart

Spreadsheet security
* Password protecting a workbook
* Protecting sheets and book structure

Charting
* Creating a chart using the wizard
* Creating a chart using the F11 key
* Changing chart types
* Formatting charts
* Adding or deleting new data to charts
* Combination charts