Excel Level 3 (Advanced)

Course Description

Students will learn various advanced techniques for analysing and manipulating data in Excel.

Course Content

Lesson 1: Advanaced functions and formulas
Logical functions
Conditional functions
Financial functions
Text functions
Date functions
Array formulas
Lesson 2: Lookups and data tables
Using lookup functions
Using MATCH and INDEX
Creating data tables
Lesson 3: Advanced data management
Validating cell entries
Advanced filtering
Lesson 4:Advanced charting
Chart formatting options
Combination charts
Graphic elements
Lesson 5: PivotTables and PivotCharts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
Using PivotCharts
Lesson 6: Exporting and importing
Exporting and importing text files
Getting external data
Lesson 7: Analytical tools
Goal Seek and Solver
Scenarios
Lesson 8:Macros and custom functions
Running and recording a macro
Working with VBA code



pdf Printable course details

Prerequisites

Excel Level 2 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 VGA Programming
ECDL

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