Course Overview
Intermediate Excel
Course Content:
• Learn how to use formulae and functions
• Explore the various user interface elements
• Use the Excel galleries
• Customise the interface
• Creating forms with Excel
• Replicate formulae and functions
• Create an absolute reference
• Range names and how they are applied
• Using Freeze Panes
• Recording the current date and time on the printed spreadsheet
• Turning your figures into charts
• Formatting charts
-
Entry Requirements
None
-
Summary of Outcomes
Intermediate Excel This is a step up from the Level 1 and covers more advanced topics in the use and manipulation of data
-
Method of Assessment
Observations and Portfolio work
Location
Locations across wales or in-house at your business
Course length
2D