Courses / Microsoft Excel Advanced
Microsoft Excel Advanced
- Provider
- Abal Computer Services
- Summary
- This course is for experienced users of Excel who wish to extend their range of commands and make use of the products more complex facilities. It explores some of the more advanced commands and functions and enables you to apply them to solving your own business problems.
This course will provide you with an opportunity to explore individual interests within the framework of a structured course.
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 experienced users of Excel.
- Outcome
- Participants willl explore some of the more advanced commands and functions and will be enabled to apply them to solving their own business problems. Participants will have the opportunity to explore individual interests within the framework of a structured course.
- Content
- THE FOLLOWING TOPICS WILL BE COVERED:
MODULE 1- Filtering to find information
- Filtering to display a set of related records
- Calculating filtered sets of records
- Summing a set of records without filtering
- Pivot Tables
- Getting external data into a workbook
- Creating a dynamic summary using a Pivot Table
- Modifying the data displayed in a Pivot Table
MODULE 2- Create Macros to automate repetetive tasks
- Edit Macros
- Add comments to your Macro making it easier to understand
- Create a Macro button to run the Macro
MODULE 3- Using Advanced worksheet functions
- Conditional Logic If and Nested If
- Financial functions =PMT, =PV and =FV
- Using one input data tables
- Using two input data tables
MODULE 4- Create Linking formula
- Create links to use the same data in more than one worksheet
- Auditing your work, tracing dependents
- Protecting your workbook
- Share your workbook and track changes
MODULE 5- Analysing and sharing your data
- Comparing alternatives for better decisions
- Using goal seek to determine the best price
- Creating multiple scenarios to compare alternatives
- Test different values using What-If
- Working with Scenario Manager
MODULE 6- Sharing data with other Applications
- Embedding information between programs
- Pasting an Excel chart into a Word document
- Converting a worksheet into a Microsoft Access table
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. - Filtering to find information
- 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
