Back to All Events

Excel Intermediate Level - Welshpool

Excel Intermediate, Thursday 10th October 2024

The Excel Intermediate level covers the following 2 modules.

Module 3 - Creating Formulas

  • This course can be delivered as a full day course or as individual half day modules

  • * Using the AutoSum feature to automatically add values

  • * Understanding Formulas and their rules

  • * Creating Basic Formulas

  • * Copying and Pasting Formulas

  • * Using and Creating Absolute Formulas to enable a specific value to be used many times, i.e. VAT rate

  • * Finding Minimum, Maximum and Average values of a list of data

  • * Using named ranges within a formula

  • * Using the Function Library

  • * Inserting and Formatting Dates and Times

  • * Using Dates within Formulas

    Module 4 - Links, Graphs & Basic Conditional Logic

    * Linking Workbooks

  • * Working with Hyperlinks

  • * Protecting Formulas and Worksheets

  • * Understanding Conditional Logic, i.e. IF statements

  • * Working with Multiple Worksheets within a Single Workbook, Renaming, Inserting, Copying Information and Creating Summary Worksheets

  • * Creating Graphs

Duration: 1 day

Date: Thursday 10th October 2024

Cost: Free to attend for those living or working in Powys.

Venue: Welshpool

Course Delivery: This course will be delivered by Pat Jones, PS Training.

Book online using the booking “Sign Up” button below, call 01686 628778 or email sam@mwmg.org

If there are no spots available and you wish to be added to the reserve list in case of cancellation please email sam@mwmg.org

‘This project is funded by the UK government through the UK Shared Prosperity Fund.’

Previous
Previous
October 10

Process Analysis - Newtown

Next
Next
October 16

Excel Advanced Level - Advanced Formulas & Database Functions - Welshpool