Description
This programme will cover the essential features and tools required to work with range names, perform calculations (using formulae and functions) and work with multiple sheets.
In order to consolidate learning and maximise the investment in training, learners should put their newly acquired skills into practice as soon as they return to the workplace.
What you will learn
Course content:
• Formulae & AutoSum
• Absolute Cell References
• Introduction to Range Names
• Calculating with time
• Time formats
• Common functions: AVERAGE, MIN, MAX
• Using the Function tool
• Conditional Formatting
• The basic IF function
• Using COUNTIF
• Using multiple worksheets
• Referencing data on another sheet
• Linking formulas across worksheets
• Protection
• Subtotals
• Pivot Tables
020 7375 7300
Email