Microsoft Excel - Intermediate
Date: 7th September 2022
Time: 9:30am to 4:30pm
Location: Online
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.
Who Should Attend?
This 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. You should already know how to create charts.
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.
Important notes from the Trainer re these Online courses:
Participants need to ensure that they have Microsoft Excel working on their computer and that their sound is working.
They MUST know how to switch between applications during the course, i.e. They will have a folder open with work files, they will also have ZOOM open, and they will have Excel open. On the day, they will watch the tutor perform the task on ZOOM. They will then switch to the folder which contains the work files and they will open the file. The file will open in Excel where they will perform the task themselves. they must know how to open, save and close work files before attending the course. They therefore need to be able to switch between all three areas frequently. If they are unable to do this they should consider not attending an online course as the tutor will be unable to assist them from a distance – a classroom based course would be more beneficial in this circumstance.
The trainer will send a link to the work files needed for the course.
You will need to download these work files before the course and place them in a folder on your desktop.
All participants must have a copy of Microsoft Excel on their laptop or PC. Ideally the version of Excel will be from Office 365 or Office 203 or Office 2016.
