Microsoft Excel Intermediate
This course is suitable for those who have completed the Excel Beginners 2 half day courses or have some previous knowledge of spreadsheets.
We have broken the course down into 2 half day sessions as we feel that this gives the delegate an opportunity to practice the initial skills and gain confidence before moving on to the second section.
Course duration:
2 x half day sessions
Course Content: Session 1
- review the use of formulas
- Use various functions such as, count, minimum and maximum
- Use the IF function
- Understand the use of Absolute cell references
- Naming cells
- Percentages
- Format cells/text alignment
- Use format painter
- Hide and unhide rows and columns
- Freeze columns and rows
Course Content: Session 2
- Working with a large spreadsheet
- Printing selections and rows to repeat
- Sorting data using more than one level
- Apply filters to data
- insert and delete worksheets
- rename/move and copy worksheet
- link cells/paste special
- Advanced charts and graphs
- Advanced autofill
Description:
This course, broken down into 2 bite size sessions, will build on your existing skills in Excel. You will gain knowledge in using Functions and Absolute Cell References and working with large spreadsheets. By following the structured exercises you will gain confidence which will make you more efficient and productive in the work place.
Call us now on 01403 734431 to book on this course.
