Microsoft Excel – Intermediate Level

OVERVIEW

This 1-day course is specifically for those who already have some experience of Excel and know how to input data and format a spreadsheet. It will specifically be of interest to those who are working on spreadsheets created by others but want to know how to set up and manage their own workbooks.

At the end of the session participants will have a better understanding of how formulas are constructed and will have a thorough knowledge of how to structure spreadsheets and databases within Excel.

SYLLABUS

  • Conditional Formatting
  • Average – AverageIF – AverageIFs – Clean – Concat – Concatenate – Count – CountIF – CountIFs – CountA – Countblank – HLookup – IF – Left – Lower – Max – Mid – Min – Now – Proper – Right – Sum – SumIF – SumIFS – Today – Trim – Upper – VLookUp
  • Understanding the difference between “relative” and “absolute” cell references
  • Create custom formats for dates and numbers
  • Use the IF function
  • Understand and use the VLOOKUP and HLOOKUP functions
  • Learn how to use the SUMIF(s), COUNTIF(s) and AVERAGEIF(s) functions
  • Work with Text by using the common Text functions
  • Import data from other systems and clean it up
  • Review the basics from Excel – Introductory Level

Trainer

  • Microsoft Excel - Intermediate
    7th July 2021
    9:30 am - 4:30 pm

Registration Options

Details Price Qty
Costshow details + €85.00 (EUR)  

Venue:  

Address:
Ireland

Description:
This event is being hosted online