Module 1: Recap of Basics
- Recap of the basics
Excel Intermediate
Microsoft Excel - Intermediate | Commencing: September 2019
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 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.
Register your Interest
Please contact us if you are interested in this course offering, courses are run subject to demand.
Copyright © 2019 Cenit Group. All Rights Reserved.