We're sorry, but all tickets sales have ended because the event is expired.
-
Microsoft Excel - Intermediate 1 Day Course
November 22, 2023
9:30 am - 4:30 pm
Microsoft Excel Online Level 2 – Intermediate 1 Day Course (in person)
Course Aims & Objectives
At the end of this course participants will have a better understanding of how formulas are constructed and will have a thorough knowledge of how to structure a spreadsheet and database within Excel.
Course Outline
The course content may include the items listed below. Charts, Sheet Layout and Formatting are covered at Level 1 – Introduction. Items not listed here (including PivotTables and Macros) are not covered on this course and are covered at a higher level.• Review of Excel Basics.
• Understanding the difference between “relative” and “absolute” cell references.
• Understanding and using dates in calculations.
• Creating Custom formats for dates and numbers.
• Introduction to the IF function.
• Using VLOOKUP (and HLOOKUP) function.
• Using the SUMIF(s), COUNTIF(s) and AVERAGEIF(s) functions.
• Conditional Formatting.
• Working with Text and using common TEXT functions.• Importing data from other sources.• Understand how to construct an effective database within Excel.
IMPORTANT INFORMATION
Dates & Times
- 22nd November 2023
- 9.30am – 4.30pm
Cost
- €75pp.