Excel Level 2 Training

Date: 9/12/2013
Time: 8:00 AM TO 3:00 PM

1 Maplebank Road
Victoria, BC V9A 4M1

---

Event Description: Working with Ranges: Defining Range Names, Protecting Cells, Worksheets and Workbooks, Creating a Template, Working with Microsoft Templates More Functions and Formulas: Using Logical Functions (IF), Using Financial Functions (PMT), Using Lookup Functions (VLOOKUP), Understanding Formula Errors, Displaying and Tracing Formulas Working with Multiple Workbooks and Worksheets: Viewing Multiple Workbooks, Viewing Multiple Worksheets, Linking Cells, Worksheets and Workbooks, Editing and Re-establishing a Link Additional Viewing Options: Splitting and Freezing Worksheets, Creating Headers and Footers, Grouping and Outlining Data Working with Data Ranges: Sorting and Filtering Data, Custom Sorting and Filtering, Using Text to Columns, Using Advanced Filters Working with Tables: Creating a Table, Adding and Removing Data, Working with the Total Row, Removing Duplicate Rows of Data, Formatting the Table, Summarizing a table with a PivotTable, Converting to a Range


Directions:
The Industrial Marine Training and Applied Research Centre (IMTARC)

---