PC Applications courses Liverpool

...the foundations for a career in using information technology. National Open College Network (NOCN) Information Technology Award Course Content...

...• Creating & Working With Tables • Modifying & Formatting Tables • Using Table AutoFormats • Working with Columns & Using Section Breaks • Creating & Using...

...Suitable for delegates whi have attended an Introductory level course. not suitable for anyone with no experience of using this software. Review of... Learn about: Word 2007...

...Headers & Footers • Using Outline View & Document Map • Bookmarks & Cross References • Footnotes & Endnotes • Creating a Table of Contents • Creating an...

...•Inserting endnotes and footnotes •Assigning macros to toolbar buttons and shortcut keys •Working with bookmarks and cross-references •Editing macros •Designing... Learn about: Word 2007...

...& Action Queries • Working with SubForms & Linked Forms • Modifying Forms & Reports • Working with Control Properties • Using, Customising & Creating AutoFormats...

...Review of Word day to day Features OutlinesIndexes •Viewing documents in outline view •Marking index entries •Formatting/editing documents in outline view...

...• Using Criteria in Queries • Summarising Data with Queries • Designing Data Entry Forms • Using AutoForms & the Form Wizard • Creating & Using Main Forms...

...and Closing workbooks • Navigating around a worksheet Formatting and Manipulating Worksheets • Keyboard Shortcuts and Menu Items • Formatting text • Formatting...

...Resource calendars· Assign priority· Level resources· Contouring· Multiple base calendarsMultiple Projects· Share resource· Sub projects· Consolidate projects·...

...custom sequences •Function to combine data from multiple cells •Filtering data with AutoFilter •Date functions •Creating customised and advanced filters...

...Format Painter & AutoFormat • Cut, Copy & Paste Techniques • Creating Simple Calculations • Moving & Copying Formulae • Using AutoSum • Statistical Functions...

...level Excel training or equivalent. Those who have attended our Intermediate level Excel training or equivalent. Review of Excel day to day features Pivot...

...Course Outline: • Customising & Creating Your Own Toolbars • Working with Multiple Worksheets • Sheet Names & Tab Colours • Moving & Copying Worksheets...

...Suitable for: Delegates should have already attended our Excel Advanced course or be able to demonstrate equivalent knowledge. Delegates should have already...

...Seeker & Solver Linking Multiple Workbooks Entering Formula Across Workbooks More on Data Lists Advanced Filters Database Functions Grouping & Outlining...

...Suitable for: N/A N/A Microsoft PowerPoint Introduction •The PowerPoint workspace •Creating and saving a new presentation •Opening, closing and switching... Learn about: PowerPoint 2007...

...& Shading • Using ClipArt & Word Art • Using the Drawing Tools • Creating & Modifying Charts & Graphs • Using Design Templates • Working with Different...

...basic business features available with this software. Project Management Concepts •Project management •The project lifecycle •Outlining System Overview...

...Objects • Manipulating & Creating Clips • Managing the Clip Art Gallery • Working with Slide Comments • Using Outline View • Speaker & Audience Notes • Creating Custom Backgrounds...