Excel Intermediate

Microsoft Excel - Intermediate | Commencing: 17st September

10 Week Course | 1 Night per Week

€349

Monread Shopping Centre, Naas, County Kildare.

Course Outline

This course can act as a follow on from the excel beginners course or as a standalone. It will cover creating complex models that will involve linking multiple worksheets and files. Logical functions along with the creation of graphs and charts for industry usage along with conditional formatting. It will enable a participant to perform much more complex tasks in excel – eliminating the need for manual efforts and act as an aid to decision making. Real live examples from industry domains will be used.

Course Objectives

Upon completion of this course participants will be able to:

  • Create Complex business models using multiple worksheets and files
  • Perform logical functions acting as an aid to interpretation of business outcomes
  • Use data functions
  • Use charts and graphs and integrate them into business overviews
  • Create pivot tables – for more complex modelling
  • Protect cells

Who should attend

This course is suitable for those who have completed an excel beginners course. Or those who are using excel on a day to day basis and can perform basic excel operations such as create, edit, format and print along with understanding and creating basic formula and functions.

Course Syllabus

Module 1: Recap of Basics

  • Recap of the basics

Module 2: Multiple worksheets

  • Inserting, deleting and renaming a sheet
  • Moving and copying sheets
  • Naming cell ranges
  • Using named ranges in formulas
  • Using a formula to link sheets
  • Using a formula to link sheets from an external file
  • Using Past Special
  • Hyperlinks

Module 3: Charts and Drawing

  • Introduction to chart types and usage – Industry-specific examples
  • Using the chart wizard
  • Formatting and editing charts
  • Refreshing data
  • Using the drawing tools: Illustrations, Autoshapes and SmartArt

Module 4: Formatting

  • Freezing rows and columns
  • Flash fill (dividing or combining multiple columns/rows)
  • Conditional Formatting
  • Manage conditional formatting rules
  • Creating and modifying cell styles
  • Applying themes
  • Using Comments

Module 5: Logical Functions

  • IF statements (incl., nested IF statements)
  • SUMIF, AVERAGEIF, MAXIF, COUNTIF, ISERROR
  • VLOOKUP and HLOOKUP
  • TRANSPOSE
  • Date and Time functions

Module 6: Lists and Data operations

  • Data Sorting – (single and multiple columns (by values, colour, font colour, cell icons)
  • Data Filtering – single and multiple columns (by values, colour, font colour, cell icons)
  • Subtotals
  • Group and outline
  • Data Forms, Data Validation
  • Customising Quick Access toolbar and ribbons

Module 7: Pivot Tables

  • Creating, updating and formatting a pivot table
  • Creating charts from the PivotTable
  • Grouping in pivot tables
  • Adding calculated fields in pivot tables

Module 8: Protection

  • Protecting cells, sheets and files

Certification Information

On successful completion of this course, you will receive a certificate of completion.

Enrol Now

If you would like to enrol in Microsoft Excel – Intermediate, you can purchase an enrolment pass below. If you have any further questions about the course, please get in touch.