Return ArrowBACK TO ALL EVENTS

Location

Virtual Event

Virtual Event

This event is held entirely online. Access detials will be provided from the host, upon registration.

Return ArrowBACK TO ALL EVENTS

Thu | May 26 9:30 AM - 12:30 PM

Online Workshop: Intermediate Microsoft Excel Part 2

Business Northumberland Business Northumberland

Have you attended Online Workshop: Intermediate Microsoft Excel Part 1?
Book onto part 2!

Covering topics:
Named Ranges
• Creating Named Ranges
• Using Named Ranges in Calculations

Function wizard
• Using the Function Wizard to Structure your Function
• Using the Function Wizard to find out about New Functions

Logical Functions
• IF – to perform 2 different actions based on a condition, for example giving a discount if more than a certain number of the product is bought otherwise charging full price
• AND and OR – to make IF more flexible
• Nested IF – to perform multiple different actions based on multiple different conditions, for example having multiple different discount percentages based on multiple different quantities sold

Avaialble IconAVAILABLE TO: CostCOST:

Members

Non Membersprices start from

FREE - must be registered to programme

Avaialble IconONLINE ZONE

Online Only

Subscribe To View Zone(s)

VISIT EVENT SITE