and the Microsoft Office Specialist Excel Expert examination Prerequisites Before attending this course, students must have: Attended the Excel Introduction...
and the Microsoft Office Specialist Excel Expert examination Prerequisites Before attending this course, students must have: Attended the Excel Introduction...
the forecasting facilities available in Excel. By the end of the course delegates will be able to: Recognise options and settings within Excel that may be adjusted...
/ unhide columns and rows Format for currency and dates Format using one of Excels built in templates Add borders and shading Module 5 Create charts using...
Pivot Tables Define an area using a named range. Group information Re-define a named range and refresh data. Move table to show different information Drill down to show detail Show or hide detail...
/>4 sessions provided 9.30am start and 4pm close. Plenty of exercises and tutoted learning. Course notes provided Intermediate and Advanced courses to follow....
MODULES 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...
Number formatting Creating custom formats The four parts of a format Scaling numbers Conditional formatting Creating/using cell rules Data bars and colour sets Validation and protection Setting...
MODULES 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...
This 1 day course, assuming a basic understanding of windows, covers a variety of features including: Basic Editing, Introduction to Formulas, Using Functions (such as Autosum, Average,...
, but we will adapt the training session to suit the needs and preferences of the participants. What’s new in Microsoft Excel? An overview of the newest features...
This course is designed as a follow up course for delegates who have already attended an Excel 2000 Introduction course. Delegates will gain further...
This course is designed to provide delegates with an Introduction to Excel, and Spreadsheet Concepts in general. This course is beneficial for those...
In this course we build on the knowledge gained in the introduction level course to reach what we would call "office level" in Excel. By this we mean...
For the latest courses and offers in this subject area, sign up for alerts.