Crystal Multimedia & Training
Excel Intermediate
Excel Custom
For the new user of the Excel spreadsheet program. The basic features are introduced through a series of practical exercises such as cash-flow models and simple calculation tools. The duration of the course is 6-7 hours depending on the experience and requirements of the student.
Keyboard, computer and Windows experience recommended. New Windows users are advised to complete the Windows Foundation Course.
Getting started, exploring the screen, saving work. Moving around in a worksheet, opening and closing workbooks, using the help system. Entering text, numbers, formulae, inbuilt functions. Copying data. Editing, inserting and deleting cells. Sizing columns and rows. Moving sorting and rearranging data. Formatting numbers and enhancing characters. Using spell check. Using print preview and print options
This course aims to provide a general introduction to spreadsheets. After completion students will have the ability to use Excel for everyday tasks
Follow on to Excel Intermediate, & other application courses
This course follows on from Excel foundation and covers some of the more advanced features of Excel. Topics are introduced through a series of practical exercises. The duration of the course is 6-7 hours depending on the experience of the student..
Keyboard, computer and Windows experience recommended. New users are advised to complete the Windows Foundation and Excel Foundation courses.
Using borders and shading, automatic formatting. Inserting text and drawn objects. Overview of charts, creating and changing a chart. Overview of multiple sheets. Naming, grouping, inserting and deleting multiple sheets. Sharing data between sheets. Overview of lists. Creating, sorting, filtering data.
After completion students will be able to make further use of the facilities offered in Excel.
This is course is designed for the experienced Excel User The duration of the course is 5-7 hours depending on the experience and requirements of the student More or less time can be spent on each topic, other topics can be incorporated given notice This is a workshop course
Look up tables. Navigating between multiple sheets. Formulae and multiple sheets. Copying / Moving Information, Values, Formulae. Transposing. Headers and footers. Importing data, ASCII, CSV etc.. Logical comparisons in formulae. Auditing tools & other add ins. Fault finding formulae. Named Ranges. Pivot Tables. Goal seeking. Scenario manager. Publishing to the Web or Intranet. Management reporting. Protecting constant data and formulae. Application and Template development. Work group issues.
To enable the Excel user to develop robust applications and utilise Excels management reporting features.