Course Outlines

Microsoft Excel

Foundation MS Excel

  • Introduction to spreadsheets
  • Overview of the Excel menus and toolbars
  • Entering & editing data and text
  • Saving workbooks
  • Formatting spreadsheet data & text
  • Calculating using AutoSum
  • Modifying spreadsheet (resizing & inserting columns, rows etc)
  • Constructing basic formulas
  • Copying formulas
  • Understanding absolute cell references
  • Introduction to Excel functions
    • The SUM function
    • The MIN function
    • The MAX function
    • The Average function
    • The COUNT & COUNTA functions
  • Working with the date and time functions
  • Highlighting data with Conditional Formatting
  • Managing large workbooks (freezing rows, columns & panes etc)
  • Printing workbooks & selected spreadsheet data

 

Intermediate MS Excel

  • Excel overview refresher
  • Linking workbook data
  • Protecting workbooks & cell ranges
  • Advanced conditional formatting techniques
  • Finding data records with VLookups & HLookups
  • Filtering data with the Auto & Advanced filters
  • Macros and their uses
  • Calculating Subtotals and working with Levels
  • Sorting data using Pivot Tables & Pivot Charts
  • Consolidating data in multiple spreadsheets
  • Linking worksheets with 3D formulas
  • Using the Watch Window
  • Data validation & creating drop-down lists
  • Creating and applying custom styles
  • Creating spreadsheet templates
  • Embedding & linking spreadsheets in Word documents & PowerPoint slides

Advanced MS Excel

  • Using advanced functions
    • Conditional Logic: using the IF function
    • Using Not, AND, OR functions
    • Nested IF functions
    • The IFERROR function
  • Using maths & statistical functions
    • The SUMIF function
    • The COUNTIF function
    • The AVERAGEIF function
  • Introduction to the new 2007 Excel functions: SUMIFS, COUNTIFS, AVERAGEIFS
  • Working with data
    • Tidying the database with the TRIM function
    • Extracting text & data using FIND and MID functions
    • Using the VALUE function
    • Finding data records using MATCH and INDEX functions
  • Working with advanced database functions
    • The DSUM function
    • The DAVERAGE function
    • The DCOUNT function
  • Working with analytical tools
    • Using Goal Seek
    • Creating & merging Scenarios
  • Introduction to Macros

 

Microsoft Office

Microsoft Office

  • Overview of Microsoft Windows & the Office Suite
  • Setting up a simple file structure
  • Creating files & folders
  • Opening & closing applications
  • Working with multiple applications
  • How to set up an email account
  • How to send & receive email
  • Introduction to Microsoft Word
  • Entering and editing text
  • Formatting text and paragraphs
  • Saving & printing documents
  • Introduction to MS Excel
  • Entering and editing data
  • Adding up columns and rows
  • How to construct simple formulas
  • Saving & printing spreadsheets

Microsoft PowerPoint

Foundation PowerPoint

  • Overview of PowerPoint capabilities
  • Overview of menus and toolbars
  • Introduction to the PowerPoint screens & views
  • Using the Auto Content wizard for quick slideshows
  • Creating slides using AutoLayout templates
  • Customising slide colour schemes
  • Adding graphics, photos and video
  • Adding slide transitions
  • Adding text animation effects
  • Running the slideshow

Microsoft Project

Foundation MS Project

  • Introduction to Project Views
  • Creating & Defining a New Project
  • Defining Working Times and custom calendars
  • Entering and linking Tasks
  • Setting Milestones & deadlines
  • Setting Lag and Lead Time
  • Entering & assigning Resources
  • Resolving overallocated Resources
  • Setting baselines & tracking the project

Advanced MS Project

  • Setting task constraints
  • Applying different cost rates
  • Applying custom calendars& work times
  • Entering material resource consumption rates
  • Interrupting work & rescheduling tasks
  • Updating the progress of tasks
  • Leveling overallocated resources
  • Consolidating and sharing projects
  • Sharing resources between projects

 

Microsoft Word

Foundation MS Word

  • Overview of Word menus and toolbars
  • Creating a file and folder structure
  • Opening and saving Word documents
  • Entering and formatting text
  • Formatting paragraphs
  • Formatting bulleted lists
  • Setting and using tabs
  • Using Tables for more complex page layouts
  • Editing and importing graphics & photos
  • Proofing text
  • Printing documents

 

Advanced MS Word

  • Professional document layout with Headings & Levels
  • Creating & using custom Styles
  • Working in Ouline view
  • Creating a Table of Contents
  • Creating an Index
  • Creating & using forms
  • Protecting document contents
  • Adding Bookmarks
  • Using Macros to speed tasks
  • Setting up & using mail merge