Call us on 07966 326 753 or email us on business@advancenorthumberland.co.uk
In partnership with European Regional Development Fund and Northern Powerhouse
 

Online Workshop: Intermediate Microsoft Excel Part 2

Microsoft Office
NAT_1397
Date: 2021-06-28 09:30 - 12:30

Venue: Microsoft Teams

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

All attendees must be registered to the Business Northumberland programme prior to the workshop.
Registered businesses will receive an email with a link inviting them to Microsoft Teams where they will be able to attend the workshop!



Please note this workshop will be focusing on Excel for PC.

 

Seats available
22
Number of seats
25

 

All Dates


  • 2021-06-28 09:30 - 12:30

Powered by iCagenda

Business Northumberland Logo
ERDF Logo
Advance Logo
Northern Powerhouse