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: Word 2007, Odd pages, SmartArt graphics...

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

...deleting rows and columns Sorting Data Formulae and Functions Arithmetic and Logical Formulae - addition, subtraction, multiplication, division... Learn about: Font type, Columns
, 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, Text size, 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: Editing Data, Cell styles, Selecting Data...

...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: Creating Templates, MS Excel, Manipulating Worksheets...

...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: Workgroups

, Microsoft Word, Inserting an index...

...and endnotes Creating and deleting footnotes and endnotes Modifying existing footnotes and endnotes Modifying format and positioning of footnotes and endnotes... Learn about: Word Internet features, Compressing images, Ms Word...

...and endnotes Creating and deleting footnotes and endnotes Modifying existing footnotes and endnotes Modifying format and positioning of footnotes and endnotes... Learn about: Field codes, Collaborative editing, 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, Advanced image techniques, Stained Glass...

...and Reports Creating a PivotTable report Creating a PivotChart report Resetting a summary function in a PivotTable report Creating a PivotTable report... Learn about: SmartArt graphics, Auditing a worksheet, 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, Slide numbering, Master slide...

...PivotTables and Reports Creating a PivotTable report Creating a PivotChart report Resetting a summary function in a PivotTable report Creating a PivotTable... Learn about:
Solver, Scenario manager, Tracing errors...

...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, Functions




, Structured references...

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

...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: Action buttons, Automatic slide shows, Drawn objects...

...removing images from a master slide, adding text to slide footers, applying automatic slide numbering, automatically updating dates on slides Text... Learn about: Microsoft Powerpoint, Applying shadow, Compatibility checker...

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

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

...Macros Recording macros Running macros Editing macros... Learn about: MS Excel, Running macros, Tracking changes...