EDITC - Education & Information Technology Centre

Schedule

Training Course Schedule

Microsoft Excel Expert level

Code:	ED18B06
Type:	IT InstructorLed Courses
Category:
Course:	Microsoft Excel Expert Level For Technical, Scientific & Supervisory Staff

Date:	23 Oct 2018 08:15 - 24 Oct 2018 16:00

Microsoft Excel Expert Level will help the participants become familiar with the advanced features of Microsoft Excel. This Microsoft Excel course focuses on the Excel features for data analysis such as sorting, filtering, advanced filtering, pivot tables, consolidation and subtotals as well as formulae and nested functions in order to create “smart” spreadsheets. It also presents features such as data validation in order to minimize data entry errors . The course also introduces various financial analysis tools such as goal seek, scenario manager and data tables. Finally the course presents ways to protect the spreadsheets and formulae and to create templates.

Duration:	14 hours (2 days)
Location:	EDITC & MMC Conference Center, 16 Imvrou Street, 1055 Nicosia
Language:	Greek
Attendance:	4-12

Price:	€245.00

Subsidy:	€0.00

Total:	€245.00

Topics

Unit1: Databases
Apply data filters (AutoFilter)
Perform single and multi-level sorts
Extract data (Advanced Filter)
Use data validation
Use subtotalling
Use grouping and outlines

Unit2: Naming Ranges
Creating a named range
Changing a named range
Selecting fields by using names
Using names in Functions

Unit3: Using Functions And Nested Functions
Using IF (& nested IF)
Using VLOOKUP
Using AND, OR Functions
Using Financial Functions
Using Text Functions

Unit 4: Collaborating
Creating a comment
Changing workbook Properties
Protecting and Unprotect workbooks and spreadsheets
Protecting a file using passwords
Protecting and Unprotect workbooks and spreadsheets
Protecting a file using passwords

Unit 5: Templates
Creating new Templates
Using the existing Templates

Unit6: Advanced Number Formatting
Apply number formats (accounting, currency, number)
Create custom number formats
Using conditional formatting

Unit7: Analysis Tools
Creating and Using PivotTables
Using Goal Seek
Creating pivot chart reports
Working with Scenarios
Using Solver (Goal Seek)

Unit8: Use data analysis and PivotTables
Creating PivotTables
Summarizing data using various functions
Working with Pivot Tables
Creating PivotCharts

Unit9: Auditing
Using the Auditing tools
Finding and correcting Formulae errors

Unit10: Printing
Preparing Sheets for Printing
Previewing and Printing Multiple workbooks

Who Should Attend
Participants may come from various departments and are dealing or wish to create complex spreadsheets. Participants who seek for ways to utilize all the excel features in order to create “smart sheets” or analyze data will find this course very useful.

Purpose
Microsoft Excel Expert Level will help the participants become familiar with the advanced features of Microsoft Excel. The course focuses on the Excel features for data analysis such as sorting, filtering, advanced filtering, pivot tables, consolidation and subtotals as well as formulae and nested functions in order to create “smart” spreadsheets. It also presents features such as data validation in order to minimize data entry errors . The course also introduces various financial analysis tools such as goal seek, scenario manager and data tables. Finally the course presents ways to protect the spreadsheets and formulae and to create templates.

Objectives

The participants will be able to use advanced features of Excel in order to:

Filter and analyze data
Analyze data with Pivot Tables
Group and create subtotals
Use popular Functions such as IF function, VLOOKUP, PMT etc
Create nested functions for automation and analysis of calculations
Track formulae and function errors
Protect Workbooks, files, sheets and cells
Use Analysis tools for financial analysis

Prerequisites
Basic knowledge of Microsoft Excel. Additionally participants should have basic knowledge on the creation of formulae and functions.

Methodology

The course is 100% practical. The topics are delivered with short presentations by the instructor followed by a step-by-step demonstration by the instructor and repetition by the students, examples and discussions on how a feature may be used with real life examples and practice through written exercises.

Equipment
The classrooms are equiped with computers (one for each student) projector, Internet access, whiteboard, flipchart and printing facilities.
Each student has a step by step book.

TimeTable

Monday, 23/10/2018
Tuesday, 24/10/2018