PC Applications Courses Merseyside

...and data files •Creating form letters and labels •Using data from Excel and Access... Learn about: Word 2007...

...Course Outline: • Spreadsheet Concepts • The Excel Window & Task Pane • Working With Menus & Commands • Getting Help • Working With Cell Ranges • Worksheet...

...BCS Level: L2 Duration: 1 year Attendance Modes: Day Assessment: The ECDL contains 4 units. Each unit has a 45 minute assessment apart from 'Improving...

...• Using Group Editing • The IF Function • Data Calculations • Calculating Percentages • Entering Formula Across Worksheets • Conditional Formatting • Custom...

...(E3 Numeracy may be required for some subjects) Modules Studied: File Management and e-Document Production Creating Spreadsheets and Graphs Database Manipulation...

...Charts Using the Drawing Tools An Introduction to Macros Attaching Macros to Shortcut Keys &Toolbar Buttons Editing Macros Macro Virus Protection...

...and locating bookmarks •Creating master document cross-references •Editing and deleting bookmarks •Compiling indexes and tables of contents •Creating and...

...Course Outline: • All About PowerPoint 2003 • The PowerPoint 2003 Interface and Task Pane • Getting Help • Creating, Saving & Editing a Presentation •...

...formulas • Using SUM function Charts • Using AVERAGE, MIN, MAX and COUNT • Creating a simple chart using Chart Wizard • Copying formulas and functions...

...Unpacking Shows & the PowerPoint Viewer • Using Multimedia in Presentations • Sharing Information between Applications • Creating Macros & Assigning to Event Buttons...

...and rows •Applying conditional number formatting...

...• Alignment and Line Spacing • Cut, Copy & Paste Techniques • Using AutoCorrect • Spelling & Grammar Checking • Using & Editing the Dictionary • Using...

...•Checking for errors •Applying data validation to cells with input text and error messages Report Manager •Using Report Manager •Managing views and reports...

...and duration values Earned value Analyse costs in Excel Project Planning Create and use templates Customise global template Task calendars Base calendars...

...attended our Excel Advanced course or be able to demonstrate equivalent knowledge. Microsoft Excel VBA •Introduction to Excel VBA •Recording and running...

...text in columns •Creating and editing charts to give visual impact to data tables •Creating and editing organisation charts •Applying design templates... Learn about: PowerPoint 2007...

...Planning Techniques •Networks; Gantt Charts •Critical path analysis Scheduling with Dependencies •Entering dependencies •Critical path review •Recurring...

...How is it assessed? Informal assessment is ongoing throughout the programme, however, the final assessment is in the form of an external examination...

...loop while, until Loop for ... next Instructions loop break (exit) Array processing Quoted string Combining quoted strings (concatenation) Conversion to other types... Learn about: Visual Basic, Visual Basic training, MS Excel...

...Contingency Tables Test Hypothesis Concerning the Variance of Two Populations Introduction to Forecasting... Learn about: MS Excel, Confidence Training, Excel Sheet...