Intermediate Microsoft Excel
Short course
In Worcester
Description
-
Type
Short course
-
Location
Worcester
-
Duration
1 Day
On completion of this course, delegates will be able to: Understand and create more complex formulas. Understand how worksheets make up a workbook and their manipulation. Competently sort data. Understand how charts relate to data. Understand series of lists. Suitable for: Staff who have grasped the basics of Excel and wish to increase their knowledge in the creation of more complex sheets and charts.
Facilities
Location
Start date
Start date
Reviews
Course programme
Course Overview -Intermediate Microsoft Excel
Written to take your understanding of Excel to the next level, this course will focus on the manipulation of data within workbooks, producing charts and advanced formulae. This course is ideal those who handle complex business data and need to produce detailed analysis and reports
Course Format and Duration
This is a tutor led and exercise based course which runs from 0930 until 1630. It allows the trainee to be led in group exercises as well as trying tasks out for themselves.
Course Outcomes
This course will equip delegates with the skills and knowledge to be able to:
• Use the Auto Calculate function and IF Statement
• Create different types of charts
• Add cell borders onto a worksheet
• Create a series of data
• Sort columns and rows of data
Intermediate Microsoft Excel