Excel Level 2 (Intermediate)

Course Description

Students will learn the skills and concepts necessary to create charts and to use the list-management capabilities of Excel.

Course Content

Lesson 1: Managing workbooks and worksheets
Viewing large worksheets
Printing large worksheets
Working with multiple worksheets
Linking worksheets with 3D formulas
Using multiple workbooks
Linking workbooks
Lesson 2: Advanced formatting
Using special number formats
Using functions to format text
Working with styles
Working with themes
Other advanced formatting
Lesson 3: Outlining and subtotals
Outlining and consolidating data
Creating subtotals
Lesson 4: Cell and range names
Creating and using names
Managing names
Lesson 5:Tables
Sorting and filtering data
Advanced filtering
Working with tables
Lesson 6: Web and Internet features
Saving workbooks as Web pages
Using hyperlinks
Sharing workbooks
Lesson 7: Documenting and auditing
Auditing features
Comments in cells and workbooks
Protection
Workgroup collaboration
Lesson 8:Templates and settings
Application settings
Built-in templates
Creating and managing templates


pdf Printable course details

Prerequisites

Excel Level 1 or equivalent knowledge.

Course Duration

7.5 hours

Study Methods Available

Individual Tuition
Group Training
Distance Learning


Prices

Distance Learning price
         £85
       Paypal logo
For other prices, please contact us.

Follow-on Courses

Excel Level 3

All Courses

Click here to see all our courses.

Further Information

Enquiry Form
OCR
  Cisco

Sage

CompTIA logo

   BCS logo
ECDL logo
 MCP logo

     Adobe logo