Submitting Order. Please hold on...

Excel for Professionals – From Foundation to Advanced
Date
26 - 27 April 2017
Time
09:00 - 16:00
Venue
Castille, Casa Leone, Pjazza Robert Samut, Floriana

Contact Person
Ms Anne Marie Gilson
Event Overview

Foundation - This module sets out essential concepts and skills relating to understanding the concept of spreadsheets and demonstrating an ability to use a spreadsheet to produce accurate work outputs. Participation will equip attendees with the required tools and techniques to succeed the ECDL spreadsheet module. 

Advanced - This module is a high-level programme which presents registrants with the opportunity to bring their spreadsheet skills to an expert level. Completion of this module will enable attendees to master the more advanced functions of spreadsheet applications, enabling them to produce more sophisticated reports, and to perform complex mathematical and statistical calculations, thus saving time and improving productivity in the completion of tasks. Participation will equip attendees with the required tools and techniques to succeed the ECDL spreadsheet module.

Speakers

Kris Baron

Member of the Information Systems Audit and Control Association (USA), Fellow of the Association of Chartered Certified Accountants (UK) and a Fellow of the Malta Institute of Accountants.
Kris has worked as a senior auditor with the National Audit Office, where he managed various high level compliance, statutory and value-for-money audits of government owned corporations. Kris was also a systems, financial and compliance auditor at the Lotteries & Gaming Authority (LGA) where he managed a wide portfolio of gaming operators and platforms.
Kris is the Director in charge of regulatory and compliance matters and is responsible for remote gaming and e-commerce clients; is a Certified Information Systems Auditor and holds an Auditor’s warrant issued by the Malta Accountancy Board.

Programme
26 April - Foundation

08:30
Welcome Coffee & Registrations 

09:00 PART 1
First Look at Excel 
Help and Selection Techniques 
Manipulating Rows and Columns 
Copying, Moving and Deleting 

11:00
Coffee Break

11:15 PART 2 
Manipulating Worksheets 
Font Formatting & Cell Styles 
Alignment Formatting 
Number Formatting 
Freezing Row and Column Titles 

13:00 
Light Lunch 

14:00 PART 3 
Formulas (creating and easy use) 
Cell Referencing 
Functions (common, count & IF) 
Charts Formatting Techniques 
Customizing Excel 
Worksheet Setup 
Print a Worksheet 

16:00
Concluding Remarks 

27 April - Advanced
08:30
Welcome Coffee & Registrations 

09:00 PART 1
Functions: date, time, mathematical, statistical, text, financial, lookup, logical, database, nested, etc.
Importing data 
Templates 

11:00
Coffee Break 

11:15 PART  2
Analyzing data (goal seek, data tables, scenario manager and pivot tables)
Auditing 
Subtotals
Macros and Custom Controls 

13:00
Light Lunch

14:00 PART 3
Protection and Security 
Sorting and Querying Data 
Linking and Consolidating Data 
Practical tests and examples

16:00
Concluding Remarks

IMPORTANT NOTE: It is recommended to take your own laptop.
Why should delegates attend?

Foundation

Successful participants will be able to:
- Work with spreadsheets and save them in different file formats; 
- Choose built-in options such as the Help function within the application to enhance productivity;
- Enter data into cells and use good practice in creating lists; Select, sort and copy, move and delete data; 
- Edit rows and columns in a worksheet; Copy, move, delete and appropriately rename worksheets; 
- Create mathematical and logical formulas using standard spreadsheet functions; 
- Use good practice in formula creation and recognize error values in formulas; Format numbers and text content in a spreadsheet;
- Choose, create and format charts to communicate information meaningfully; 
- Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets.

Advanced

Successful participants will be able to:
- Apply advanced formatting options such as conditional formatting, customised number formatting and worksheets handling;
- Use functions such as those associated with logical, statistical, financial and mathematical operations;
- Create charts and apply advanced chart formatting features; 
- Work with tables and lists to analyse, filter and sort data; 
- Create and use scenarios; 
- Validate and audit spreadsheet data; 
- Enhance productivity by working with named cell ranges, macros and templates;
- Use linking, embedding and importing features to integrate data; 
- Collaborate on and review spreadsheets; 
- Apply spreadsheet security features.

Other Information
CPE Core Hours – to be confirmed.
Registration Information
EUR 200 Foundation Module
EUR 200 Advanced Module
EUR 320 Foundation + Advanced Module

Call to reserve a seat on: +356 20933000 or e-mail to: institute@castilleresources.com.

Excel for Professionals – From Foundation to Advanced

Booking Information

Please ensure that the email address stipulated for each attendee is his or her own personal email address.

Group Discounts: A discount of 10% will be applied if you register 5 or more attendees, from the same company, at the same time, for this event.
Early-bird Discounts: A discount of 0% will be applied if you register till the .

Title *
Name *
Surname *
Email *
Confirm Email *
Company *
Industry *

(You may select multiple industries by holding the CTRL key whilst clicking.)
Country *
Number of attendees

Attendees

Sub Total: €0.00
Group discount: €0.00
Early bird discount: €0.00
Total for 1 ticket is €0.00
Pass Type
Title *
Name *
Surname *
Email *
Confirm Email *
ID Card No
Company *
Job Title *
Industry *

(You may select multiple industries by holding the CTRL key whilst clicking.)
Country *
Attending the Networking Conference? Yes
No
Please choose your workshop * WORKSHOP A - PENSIONS
WORKSHOP B - CROWDFUNDING/VENTURE CAPITAL
WORKSHOP C - FINTECH
Comments
Ticket Price €0.00

View important upcoming events... view calendar

featured

Integra Private Wealth Ltd

Integra Private Wealth Ltd is a boutique wealth management and investment services firm offering Discretionary Portfolio...
View profile