IT, ICT and Computing Short courses

1 Excel Basics • Spreadsheet Concepts • Entering Text & Numbers • Summing Rows and Columns 2 Excel Workbooks • What is a spreadsheet? • Opening and Saving Workbooks • Switching between Workbooks • Entering Text and Numbers • Entering Pre Defined Lists • Defining a Custom List • Summing Rows and Columns • Saving and Closing a Workbook 3 Calculations & Corrections • Entering Formulae • Correcting Mistakes 4 Moving, Copying and Inserting • Moving/Copying...it, ict and computing training

1 More about Calculations • Absolute References • Using Functions • Examples of Functions 2 More Features • Using Comments • Splitting and Freezing • Using Zoom • The Paste Special Command 3 More about Printing • Adding Headers & Footers • Setting the Print Area • Using Print Titles • Controlling Page Breaks 4 More about Charts • The Chart Menu • Revising a Chart • Further Formatting • Drag and Plot 5 Working with Multiple Worksheets • Selecting Multiple Worksheets • Navigating...it, ict and computing training

1 Data Functions • Text Functions • Logical Functions • HLOOKUP/VLOOKUP • Error Functions 2 Handling Worksheets • Working with multiple sheets • Inserting / Deleting / Renaming • Moving / Copying 3 Formatting and Validation • Custom Number Formats • Conditional Formatting • Data Validation & Cell Protection • Hiding Cell Entries 4 Using Lists • Advanced Sorting & Data Filtering • Pivot Tables • Database Functions 5 More about Worksheets • Worksheet Auditing • Using Views • Scenarios & Report Manager • Designing...it, ict and computing training

Creating a Basic Worksheet •Explore the User Interface and the Ribbon •Navigate and Select in Excel •Obtain Help •Enter Data and Save a Workbook •Customize the Quick Access Toolbar Performing Calculations •Create Basic Formulas •Calculate with Functions •Copy Formulas and Functions Modifying a Worksheet •Manipulate...it, ict and computing training

Calculating Data with Advanced Formulas •Manage Cell and Range Names •Calculate Data across Worksheets •Use Specialised Functions •Analyse Data with Logical and Lookup Functions Organising Worksheet and Table Data •Create and Modify Tables •Format Tables •Sort or Filter Worksheet or Table Data •Calculate Data in...it, ict and computing training

Streamlining Workflow •Create a Macro •Edit a Macro •Apply Conditional Formatting •Add Data Validation Criteria •Update a Workbook's Properties •Modify Excel's Default Settings Collaborating with Others •Protect Files •Share a Workbook •Set Revision Tracking •Review Tracked Revisions •Merge Workbooks •Administer Digital Signatures •Restrict Document Access Auditing Worksheets •Trace Cells •Troubleshoot Errors in Formulas •Troubleshoot...it, ict and computing training

Creating and Editing Documents •Starting Documents •Starting Word •Identifying Components of the Word Screen •The Word 2007 Ribbon •Creating and Opening Documents •Moving the Insertion/Cursor Point •Building and Editing Documents •Selecting Text •Replacing and Deleting Blocks of Text •Moving and Copying Text •Modifying Page Breaks •Finishing Documents •Previewing Documents •Printing Documents •Closing Documents •Assignment Formatting Documents •Formatting...it, ict and computing training

Please note course content is currently being revised so may vary slightly when you attend. In the first course in this series, Microsoft® Office Word 2007: Level 1, you gained all the basic skills that you need to create a wide range...it, ict and computing training

Sorting and Merging Text and Data •Sorting •Merging •Protect •Document •Exercise 1 Introduction to Macros •Recording and Running Macros •Managing Macros •Deleting Macros Working With Formulas, Worksheets and Charts •Calculating in Tables •Using Formulas •Using •Worksheets •Creating and Modifying Worksheets •Embedding Existing Excel Worksheets •Working...it, ict and computing training

Getting Started with Word 2010 • Identify the Components of the Word Interface • Customise the Word Interface • Display a Document in Different Views • Enter Text in a Document • Save a Document Editing Text in a Word...it, ict and computing training

Managing Lists •Sort a List •Renumber a List •Customise a List Customising Tables and Charts • Sort Table Data • Control Cell Layout • Perform Calculations in a Table • Create Charts Creating Customised Formats with Styles and Themes •Create or...it, ict and computing training

Using Microsoft Office Word 2010 with Other Programs • Link a Word Document to an Excel Worksheet • Send a Document Outline to Microsoft® Office PowerPoint® • Send a Document as an Email Message Collaborating on Documents • Modify User...it, ict and computing training

PowerPoint Basics •Foreword •Getting Started with PowerPoint 2007 •Starting PowerPoint •Opening an Existing Presentation •Identifying Elements of the PowerPoint Window •The Ribbon •Moving Between Slides •Using PowerPoint Help •Using the Help Table of Contents Index •To use the Help Topics Index •Changing PowerPoint Views •Changing the Zoom Level •Viewing the Presentation in Outline...it, ict and computing training

Customising •Customising PowerPoint •About the Quick Access Toolbar •Add-in programs Drawing Tools •Drawing Options •Drawing Shapes •Editing shapes •Group/Ungroup objects Working with Objects •Insert a Table •Insert/Delete Rows/Columns •Merge Cells •Add Borders •Sorting a table in PowerPoint •Organisation Charts •How to Insert/Edit an Organization Chart •Inserting/Deleting boxes •How to Convert a Box •Box borders/Colour •Changing...it, ict and computing training

Getting Started with PowerPoint •Identify the Elements of the User Interface •View Presentations •Save a Presentation •Use Microsoft PowerPoint Help Creating a Basic Presentation •Select a Presentation Type •Enter Text •Edit Text •Format Text Placeholders •Add Slides to a Presentation •Arrange Slides •Work...it, ict and computing training

Customising the PowerPoint Environment •Customise the PowerPoint Interface •Set Options for Working with PowerPoint Customising a Design Template •Set Up a Slide Master •Create Custom Slide Layouts •Add Headers and Footers •Modify the Notes Master •Modify the Handout Master Adding SmartArt...it, ict and computing training

Introduction to Databases •Database Concepts •Database Layout •Launching Access •The Access Menu System •Dialogue Boxes •Getting Help •Creating a New Database •Closing a Database •Opening a Database Tables •Database Design. •Creating Tables Using the Table Wizard •Creating Tables In The Datasheet View •Creating Tables in the Design View •Data Types •Field Properties •Data...it, ict and computing training

Action Queries •Types of Query •The Crosstab Query •The Make Table Query •The Append Query •The Delete Query •The Update Query Reports •The Report Wizard •Creating a Report with Calculated Totals •Using the Chart Wizard •Altering the Chart •Using the Label Wizard •Modifying and Redesigning the Report. •Publishing Access Data on the Web Customising...it, ict and computing training

Managing Relational Databases •Database Concepts. •Database Design •Normalisation •Database Integrity •Types of Relationship •Creating Table Links •Referential Integrity Optimising and Administering Access •Optimising Performance •The Performance Analyzer •The Add-in Manager •Compacting your Database •The Database Documentor •The Database Splitter •Recovering Damaged Databases •Importing and Linking Tables Advanced Forms Customising •List and Combo Boxes •Check Boxes, Option &...it, ict and computing training

Getting Started with Access Databases •Identify the Elements of the Access 2010 Interface •Identify the Components of a Database •Examine the Relational Database Design Process Building the Structure of a Database • Create a New Database • Create a Table Using the Design...it, ict and computing training