Courses / Microsoft Excel Intermediate
Microsoft Excel Intermediate
- Provider
- Abal Computer Services
- Summary
- This course is suitable for people who have been using Excel for some time or who have completed the Microsoft Excel Introduction course and wish to extend their range of commands and make use of the products more complex facilities.
You will need to be familiar with the basic operation of Microsoft Excel.
About the Course
- Target
- Business users and Home users. The course is aimed at those who wish to extend their range of commands and make use of the product's more complex facilities
- Entry requirements
- Participants will need to be familiar with the basic operation of Microsoft Excel
- Outcome
- Participants willl extend their range of commands and make use of the product's more complex facilities.
- Content
- THE FOLLOWING TOPICS WILL BE COVERED:
MODULE 1- Managing workbooks
- Copy and move sheets making workbooks more manageable
- Enter data to several sheets at once using Group Mode
- Format a group of worksheets at the same time
- Consolidate data from different worksheets
MODULE 2- Creating reports
- Use Group and Outline
- Expand and collapse an Outline
- Create quick summary reports
- Use automatic subtotal
MODULE 3- Sorting and managing lists, working with database features
- Filter to find records that meet your criteria
- Analyse data using database functions
- Sort data by specific criteria
- Use a data form to enter data
MODULE 4- Worksheet functions
- Creating and using Range Names
- Using Conditional Logic =IF function
- Working with Lookup Tables =Vlookup and =Hlookup
MODULE 5- Charting your data
- Creating standard charts
- Creating custom charts
- Updating Charts with new or additional data
- Bar, Column and Pie charts
- Classic Combination charts
- Plotting data using secondary axis
- Custom Scatter graphs
- Line and column combination graphs
MODULE 6- Customising your workspace
- Display and customise toolbars
- Split worksheets to see more than one section of data at a time
- Arrange sheets within windows to see more than one sheet at a time
Abal Computer Services train a maximum of 7 delegates at each training session and individual support is always available. Abal have now become a Learn Direct Centre, open 9.30am-5.00pm, Wed and Thurs 9am-9pm, for more information please contact Abal Computer Services on 01787 374138. - Managing workbooks
- Cost
- Contact course provider for details
- Enrolment
- Contact the provider for details.
Availability
- Starts
- .
- Duration
- One day
- Timetable
- .
- Provider
- Abal Computer Services
Venue and Contact details
Main
Unit 4, South Suffolk Business Centre
Alexandra Road
SUDBURY
Suffolk
CO10 2ZX
UNITED KINGDOM
Telephone 01787 374138
Fax 01787 312089
Email training@abal-computers.com
Website http://www.abal-computers.com
Contact Notes Tel: 01787 374138
Courses
Syndicate
