Course details
Course description
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
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.
Learning outcome
ADVANCED MS-EXCEL | Dumfries & Galloway College (dumgal.ac.uk)
Entry requirements
Course options
Course details
Online
3rd Oct 2023 to 3rd Oct 2023
Cost: Visit the provider's website for details.
Venue details
Dumfries Campus
Bankend Road
Dumfries
DG1 4FD
Course details
Short course
3rd Oct 2023 to 3rd Oct 2023
Cost: Visit the provider's website for details.
Venue details
Dumfries Campus
Bankend Road
Dumfries
DG1 4FD