Back to All Events

Excel Advanced Level - Advanced Formulas & Database Functions - Welshpool

The Excel Advanced level covers the following 2 modules.

Module 5 - Advanced Formulas

  • Using the Audit Feature to display cells used within Formulas

  • Use of the Transpose Feature to switch the display of data

  • Understanding Conditional Logic, i.e. IF statements

  • Creating formulas using Basic Conditional Logic

  • Creating formulas using Nested IF Statements

  • Creating formulas using Nested AND & OR statements

  • Using the =Countif feature to count data meeting specified criteria

  • Using the =Sumif feature to total data meeting specified criteria

  • Using the =Averageif feature to find the average of data meeting specified criteria

Module 6 - Using the Database Functions

  • Apply Conditional Formatting

  • Applying Data Validation to ensure the correct information is entered

  • Remove Duplicate Values for line of data

  • Understanding the Database Functions

  • Using AutoFilter to view a specific set of data

  • Inserting Automatic Subtotals

  • Converting Text Strings to separate columns

  • Creation of Pivot Tables to display data in varying formats

  • Creation and use of Vlook-up table

Duration: 1 day

Date: Wednesday 30th 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 form 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 30

Effective Storekeeping/Warehouse Training course - Newtown

Next
Next
November 5

Fundamentals of Negotiation - Newtown