Introduction
This course seeks to improve proficiency with Microsoft Excel. It includes working with multiple worksheets, adding database capabilities, split screens and more Excel functions. It also takes charting a step further and introduces passwords to Excel.
Course code
SIEX
Location
Dumfries Campus
Price
£95.00
Course Content
Key Topics
- Creating, renaming and deleting worksheets
- Navigating between worksheets
- Using 3D formula
- Using links in Excel
- How to edit existing charts
- Select and format chart elements
- Using chart elements and options
- Creating Sparklines
- How to use IF function
- How to use the VLOOKUP and HLOOKUP functions
- How to name cells and use named cells
- Sorting and filter tables
- Introduction to data forms
- Using database functions
- Introduction to Pivot Table
Progression
Advanced Microsoft Excel | Dumfries and Galloway College
Course Contact Details
If you would like more information or to reserve a place on a course, please get in touch.
Telephone: 01387 734199
E-mail:shortcourses@dumgal.ac.uk
Booking Terms & Conditions | Dumfries & Galloway College (dumgal.ac.uk)