Microsoft Excel Level Two

Microsoft Excel Level Two
1 or 2 Day Courses Available depending on experience and requirements
This course is designed for delegates who already have a thorough understanding of the subjects covered in Level one. They should have a good understanding of creating and editing spreadsheets and the basics of creating a formula.
During the course the learner will practice their skills with skill reviews and exercises. An evidence of learning form will be completed during the course and verified by the trainer. This can be used to prove competency in the areas covered by the learner. A certificate of completion will also be issued. At the end of this course the learner will be able to:
· Creating charts using the Chart Wizard
· Changing chart data, types and options
· Creating and Modifying Custom Lists
· Absolute and Relative Cell References
· Sort, Find and Replace
· Date and Time Functions
· Working with multiple workbooks
· If and Nested IF Functions
· Subtotals
· Filling cells and Auto fill
· Creating number series
· Creating data series
· Naming Cells
· Using names cells within formula