PC Applications Courses Middlesex

...and workbooks •Adjusting Basic Settings - changing spreadsheet view mode, using the zoom tool, Quick Access toolbar, freezing and unfreezing row and/or column titles... Learn about: Sorting Data, Columns
, Font colour...

...and workbooks Adjusting Basic Settings - changing spreadsheet view mode, using the zoom tool, Quick Access toolbar, freezing and unfreezing row and/or column titles... Learn about: Formulae



, Editing Data, Microsoft excel training...

...Applying templates Editing templates Creating templates Formatting Applying number formats Creating conditional number formats Using conditional formatting... Learn about: Microsoft excel training, Financial functions, Editing templates...

...a bookmark Deleting a bookmark Using a bookmark Tables of contents, indices, footnotes, endnotes, cross-references Creating a table of contents Updating... Learn about: Ms Word, Microsoft Word, Word Internet features...

...within a master document Table of contents Creating a table of contents Updating and modifying an existing table of contents Applying formatting options... Learn about: MS Excel, Word 2007, Ms Word...

...within a master document Table of contents Creating a table of contents Updating and modifying an existing table of contents Applying formatting options... Learn about: Collaborative editing, Field codes, Editing text comments...

...within a master document Table of contents Creating a table of contents Updating and modifying an existing table of contents Applying formatting options... Learn about: Excel workbooks, Microsoft Word, Compressing images...

...workbook Creating a shared workbook Tracking changes Highlighting Accepting Rejecting Sorting Sorting data by multiple columns Performing custom sorts... Learn about: Goal seek, Data Analysis Tools, Microsoft excel training...

...using Help functions Adjusting Settings - using zoom tool, modifying basic options such as user name, and default folder to open and save presentation... Learn about: Zoom tool, Compatibility checker, Resizing pictures...

...protection from a workbook Creating a shared workbook Tracking changes Highlighting Accepting Rejecting Sorting Sorting data by multiple columns Performing... Learn about: Microsoft Excel, SmartArt graphics, Scenario manager...

...formatting worksheet backgrounds, freezing row and/or column titles, splitting worksheet window into panes, freezing panes, hiding/unhiding rows and columns... Learn about: Excel table, Microsoft Excel, Freezing panes...

...using Help functions Adjusting Settings - using zoom tool, modifying basic options such as user name, and default folder to open and save presentation... Learn about: Resizing pictures, Pie Charts, Compatibility checker...

...jpeg and bmp formats Pictures, images and drawn objects Converting pictures to drawn objects Grouping and ungrouping drawn objects Bringing images backwards... Learn about: PowerPoint 2007, Custom slide shows, Ms PowerPoint...

...using Help functions Adjusting Settings - using zoom tool, modifying basic options such as user name, and default folder to open and save presentation... Learn about: Changing shape attributes, Compatibility checker, Applying shadow...

...using Help functions Adjusting Settings - using zoom tool, modifying basic options such as user name, and default folder to open and save presentation... Learn about: Microsoft Powerpoint, PowerPoint 2007, Ms PowerPoint...

...using zoom tool, modifying toolbar display Document Exchange - saving an existing presentation in another file format, saving in a format appropriate... Learn about: Ms PowerPoint, Zoom tool, Organisational Chart...

...Creating a PivotTable report Creating a PivotChart report Resetting a summary function in a PivotTable report Creating a PivotTable report for the World... Learn about: Recording macros, Report Manager, Tracking changes...

...protection from a workbook Creating a shared workbook Tracking changes Highlighting Accepting Rejecting Sorting Sorting data by multiple columns Performing... Learn about: MS Excel, Microsoft Excel, Querying


...

...formatting worksheet backgrounds, freezing row and/or column titles, splitting worksheet window into panes, freezing panes, hiding/unhiding rows and columns... Learn about: Converting text, MS Excel, Structured references...

...formatting worksheet backgrounds, freezing row and/or column titles, splitting worksheet window into panes, freezing panes, hiding/unhiding rows and columns... Learn about: Database functions, Financial functions, Statistical functions...