Excel Intermediate, Friday 6th September 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: Friday 6th September 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.’