Microsoft Office | Word and Excel Training Courses

Microsoft Office – Microsoft Word Level 2

The Advanced Microsoft Word Level 3 aims to provide delegates with skills in integrating text and graphics, producing complex documents with the use of advanced layout and structural and presentation tools, and creating on-line forms.

Who Is The Course Aimed At?

Delegates with a good all-round knowledge of Word who are interested in gaining particular expertise in desktop publishing and handling long documents in Word.

Course Content

• Newspaper-style Columns
• Styles
• Table of Contents Generation
• Automatic Indexing
• Footnotes
• Inserting & Handling Graphics, including Cropping
• Using the Drawing Tools, including Text Boxes & Callouts
• WordArt
• Linked Text boxes or Autoshapes with Running Story
• Creating On-Line Forms with Form Fields, Drop Down
• Lists and Check Boxes

Entry Requirements

Delegates should have a sound knowledge of Word, with mouse use, preferably having previously attended the Intermediate course.

Microsoft Office – Microsoft Excel Level 2

This course looks at some of the formulas and functions that can be used in Excel, including ones that allow you to link Spreadsheets.

Who Is The Course Aimed At?

This workshop is aimed at those who have been using Excel for a while and now want to take their skills to the next level.

Intermediate Excel Course Objectives

• Being able to use AutoSum to produce calculations
• Using addition, subtraction, multiply and divide
• Being able to format a spreadsheet to improve it’s appearance
• Preparing a Spreadsheet for printing
• Being able to save and share a workbook
• Being able to show data in a Chart format

Training method:

Hands on training in a friendly and relaxed atmosphere

Course outcome/qualification:

Certificate of Attendance.

Course Content

• Being able to use $ and brackets in formulas effectively
• Linking Worksheets and Workbooks
• Use the Watch Window to make using more than 1 sheet at a time easier
• Being able to use Names in Formula
• Protecting Worksheets
• Using dates within Formulas
• Being able to use all features of the Fill Handle

Entry Requirements

Ability to create basic formulas i.e. +, – etc and functions i.e. Sum, Average

Microsoft Office – Microsoft Excel Level 3

The Advanced Microsoft Excel Level 3 aims to introduce delegates to the powerful data summary features of Excel, What If? facilities, advanced, conditional and financial functions, automating a spreadsheet and web interactivity.
Who Is The Course Aimed At?

Delegates with a solid foundational knowledge of Excel who wish to explore the advanced features of Excel.

Course Content

• Financial Functions: PMT, FV
• Lookup Functions:
  – MATCH
  – INDEX
  – Data Tables
• Conditional and Summary Functions
  – IF
  – COUNTIF
  – SUMIF
  – SUMPRODUCT
  – Automatic Subtotals
• Pivot Tables and Pivot Charts
• Macros, including:
  – Assigning Macros to a Toolbar Button
  – Editing VBA code
  – Creating a Function Procedure
• Goal Seek
• Scenarios and Scenario Manager
• Web Interactivity, including:
  – Lookup tables on the World Wide Web
• MsQuery
  – Querying External Databases
  – The Web Query
• Workbook Hiding & Protection Facilities

Entry Requirements

Delegates should have a good all-round knowledge of Excel and have preferably attended both the introductory and intermediate Excel courses.

Microsoft Office – Microsoft Excel Level 4

The Microsoft Excel Level 4 course is designed for people who want to take their skills on to the next level having previously completed a Level 3 course.  It will progress on the skills learnt in order to set up a Dashboard for interacting with the data in a user friendly manor.

Programme Objectives

• Learning about using Excel as a Dashboards
• Preparing data to use in a Dashboard
• How to design the Dashboard report
• Using Excel to create forms

Programme Content

• Getting your data ready
• Using Data Validation to stop input errors
• Formatting your data for Reporting
• Designing the Dashboard
• Combining VLOOKUP to INDEX/MATCH
• Revision of Formatting/Analysing a PivotTable report
• Creating Multiple Pivot Table on one Dashboard
• Applying Conditional Formatting
• Adding Slicers to the data
• Controlling Data with Slicers
• Timelines
• Adding Charts and Pivot Charts
• Choosing the right Chart for your data
• Formatting a Dashboard
• Visualising mapped data in 3D Maps (aka Power Map)
• Using Macros to add buttons to a Dashboard
• Creating and Using interactive Forms

Entry Requirements

Delegates should have a good all-round knowledge of Excel and have preferably attended both the introductory and intermediate Excel courses.