PC Applications courses Twickenham

...sections in a document Deleting section breaks in a document Columns Creating multiple column layouts and modifying column layouts Inserting a column break... Learn about: Mail Merge, Editing paragraphs, Text boxes...

...labels The Drawing Toolbar Text boxes Word Art AutoShapes Linking and embedding objects Microsoft Excel charts and data Other objects... Learn about: Word Art, Creating data sources, Ms Word...

...deleting rows and columns Sorting Data Formulae and Functions Arithmetic and Logical Formulae - addition, subtraction, multiplication, division... Learn about: Text orientation, Microsoft excel training, Text size...

...replacing existing cell content, using the undo and redo buttons •Finding and Replacing •Rows and Columns - inserting rows and columns, modifying row height and cell width... Learn about: Columns
, Microsoft Excel, Font colour...

...replacing existing cell content, using the undo and redo buttons Finding and Replacing Rows and Columns - inserting rows and columns, modifying row height and cell width... Learn about: Inserting Data, Sorting Data, Header and footer...

...Data validation Charts Plotting non-contiguous data ranges Pie charts Adding new data to an existing chart Chart formatting techniques Use of Excel... Learn about: Manipulating Worksheets, Data validation, Financial functions...

...paragraphs and tables Word Internet features Saving a Word document as a Web page Linking a Word document to a Web page Macros Creating a macro Applying... Learn about: Word Internet features, Workgroups

, Modifying notes...

...and endnotes Creating and deleting footnotes and endnotes Modifying existing footnotes and endnotes Modifying format and positioning of footnotes and endnotes... Learn about: MS Excel, Field codes, Word 2007...

...and endnotes Creating and deleting footnotes and endnotes Modifying existing footnotes and endnotes Modifying format and positioning of footnotes and endnotes... Learn about: Editing text comments, Document Inspector, Style sets...

...and endnotes Creating and deleting footnotes and endnotes Modifying existing footnotes and endnotes Modifying format and positioning of footnotes and endnotes... Learn about: Protecting a form, Microsoft Word, Advanced image techniques...

...and Reports Creating a PivotTable report Creating a PivotChart report Resetting a summary function in a PivotTable report Creating a PivotTable report... Learn about: Microsoft Excel, MS Excel, Data Analysis Tools...

...removing images from a master slide, adding text to slide footers, applying automatic slide numbering, automatically updating dates on slides Text... Learn about: Compatibility checker, Zoom tool, Open presentations...

...PivotTables and Reports Creating a PivotTable report Creating a PivotChart report Resetting a summary function in a PivotTable report Creating a PivotTable... Learn about: Goal seek, Tracing errors, Microsoft excel training...

...using a 3D sum function Charts and graphs - Changing angle of pie chart slices, formatting chart axes numbers or text, re-positioning title... Learn about: Excel Tables, Formula AutoComplete, Freezing panes...

...removing images from a master slide, adding text to slide footers, applying automatic slide numbering, automatically updating dates on slides Text... Learn about: Slide Show Effects, Compatibility checker, Ms PowerPoint...

...rescaling an image Rotating, mirroring and flipping an image Applying effects to images Converting an image into greyscale or black and white format Converting... Learn about: PowerPoint

, Ms PowerPoint, Automatic slide shows...

...removing images from a master slide, adding text to slide footers, applying automatic slide numbering, automatically updating dates on slides Text... Learn about: Changing shape attributes, Ms PowerPoint, Microsoft Powerpoint...

...removing images from a master slide, adding text to slide footers, applying automatic slide numbering, automatically updating dates on slides Text... Learn about: Resizing pictures, Microsoft Powerpoint, Ms PowerPoint...

...Moving, Deleting Slides Formatting Formatting Text - changing font type, applying italics, bold, underlining, case changes, shadowing, using subscripts and superscripts... Learn about: Microsoft Powerpoint, Ms PowerPoint, Zoom tool...

...Macros Recording macros Running macros Editing macros... Learn about: Recording macros, Merging workbooks, Lookup functions...