Excel Intermediate, Welshpool, 11th April 2023

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: Tuesday 11th April 2023

Cost: Free to attend

Venue: Welshpool

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

Book online using the booking form below, call 01686 628778 or email sam@mwmg.org