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