Meeting Between Colleagues

Excel Intermediate

Duration: 1 day

Attendees: 1 - 10

Format: Virtual

This course is designed for learners and teams who wish to gain the skills to create, edit, format and print Microsoft Excel worksheets.

This course is suitable for users of Microsoft Excel 2013, 2016 or 365 subscription editions.

Managing Large Worksheets

  • Comparing data in Rows and Columns Freeze Panes Row and Column Hiding Outline View

 

Managing Worksheets

  • Copying worksheets Moving worksheets Using grouped worksheets Linking Data between different worksheets Linking Data between different files Editing/Fixing Links

 

Using Range Names

  • Working with range names Jumping to a named range Assigning names Using range names in formulas Creating range names from headings

 

Using Advanced Functions

  • Using the VLOOKUP function Using the HLOOKUP function Using the IF function Summarising with CountIF, SumIF and average

Using Paste Special

  • Working with Paste Special Copying values between worksheets Copying formulas between worksheets

Dates and Times

  • Date and Time Functions Dates in Formulas Using Conditional Formats Applying conditional formats (e.g. Traffic Light System) Changing a conditional format Editing a conditional format rule Creating a custom format

Using Worksheet Protection

  • Unlocking cells in a worksheet Protecting a worksheet Unprotecting a worksheet Protecting workbook windows Unprotecting workbook windows Assigning a password Opening a password-protected file