MS Excel - Level 2

Linking Worksheets and Workbooks
- Point and Click Approach
- Managing and Editing Links

Grouping Worksheets
- Reasons for grouping
- Grouping selected sheets and de-selecting
- Grouping all sheets

Functions
- Logical Functions
- Nested Functions
- Lookup and Reference Functions
- The insert function option
- Text functions

Working with Lists
- List layout
- Data forms
- Sorting
- Filtering
- Sub totals

Data Validation
Add Grouping and outlining to ranges
Conditional Formatting
Goal Seek
Scenarios

Templates
- Creating, using and editing

Customising Excel
- Customising menus
- Creating new menus
- Customising Toolbars
- Create, edit and run macros

Creating Pivot Tables

Workgroup Collaberation
- Modify passwords, protections and properties
- Creating shared workbooks
- Tracking changes
- Merging Workbooks

Although the above are covered on the course- the tutor will also happily assist with any specific queries not covered on the course.