PC Applications Courses Hertfordshire

...Spreadsheet modelling Games development Communicating in the IT industry Working in the IT industry Website development Computer systems Installing computer... Learn about: IT Development...

...in all functions * Sales people * PAs and secretaries who prepare PowerPoint presentations for others to use How to design a powerful presentation using...

...and those who need a quick refresher course. Duration...

...Modify page margins, orientation and scaling. Apply headers and footers to the printed page. Print the whole worksheet or specific areas of the worksheet...

...To help users to set up their voice recognition systems and familiarise them with the main features of the program. Suitable for: Users. Special Needs teachers... Learn about: Sending and receiving emails, Dragon General Dictation, Dragging objects...

...As well as the theoretical elements, student will also gain practical experience of the. areas covered in the GCSE syllabus. Suitable for: students students...

...Apply outlining to collapse and expand levels of detail on the worksheet. Summarise data using Pivot Tables. Share workbooks to enable multi-user simultaneous editing...

...to provide a thorough insight for those upgrading. This course is designed to introduce the concepts and facilities used in everyday working routines... Learn about: Microsoft Office...

...a table slide Changing row height/column width Inserting/deleting rows/columns Applying borders and shading Formatting Slides Live Previews of Formatting...

...and print preview Document navigation Printing all or part of a document Printing envelopes and labels Move and Copy Using cut, copy and paste Moving...

...contents Inserting cross references Inserting footnotes and endnotes Creating indexes Working with a master document Inserting captions Outlining The Outline...

...AutoFill and custom lists Checking spelling and grammar Using cut, copy and paste Saving, closing and opening Formatting a Spreadsheet Applying text formatting...

...and date formats Applying conditional formatting Naming Cells and Ranges Defining named cell ranges Editing and deleting named ranges Using named ranges...

...AND OR operators Lookup functions Text functions Summarising Worksheets Group and outline a worksheet Hiding and displaying outlines Pivot Tables Creating...

...closing and opening Selecting/altering the slide layout Creating title and bullet slides Entering and editing text Formatting text and bullets Inserting...

...a table autoformat Repeating table headings Inserting tabs within tables Convert text to a table Automatic Numbering Applying automatic numbering Applying...

...Excel 2007 New Features Using the New Conditional Formatting Using the Improved List Features, Including Sorting and Filtering Improved Formula Construction...

...a table slide Changing row height/column width Inserting/deleting rows/columns Applying borders and shading Formatting Slides Live Previews of Formatting...

...notes Creating and editing task relationships Displaying the Critical Path Setting lead and lag times Managing Date Constraints Date constraint types Creating...

...Colors Creating Custom Colors Adding Patterns Adding Drop Shadows Creating a Multi Page Diagram Copying Shapes Repeat Duplication Foreground and Background...