ΠΕΡΙΓΡΑΦΗ

The course aims to equip participants with advanced Excel skills necessary for efficient data analysis, enhanced data visualization, and secure worksheet management in professional environments.

ΣΚΟΠΟΣ ΣΕΜΙΝΑΡΙΟΥ

Participants will learn to:

1. Apply advanced Excel functions.
2. Use conditional formatting to highlight key data patterns and trends.
3. Efficiently manage and secure worksheets.
4. Create, modify, and analyze data using pivot tables, advanced sorting/filtering, and scenario tools.
5. Design professional charts, including sparklines and combined charts with customized elements and secondary axes.

ΣΕ ΠΟΙΟΥΣ ΑΠΕΥΘΥΝΕΤΑΙ

This seminar is ideal for finance professionals, data analysts, project managers, accountants, and auditors. Participants seeking ways to utilize all Excel features to create “smart sheets” or analyze data will find this course very useful.

ΠΕΡΙΣΣΟΤΕΡΕΣ ΠΛΗΡΟΦΟΡΙΕΣ

Course Topics

• Statistical Functions
• Lookup & Reference Functions
• Logical Functions
• Database Functions
• Conditional formatting
• Manage worksheets efficiently
• Protect worksheets and cells with passwords
• Create and modify pivot tables.
• Sort and filter data using advanced options.
• Use data tables and scenarios for analysis 
• Create combined and sparkline charts.
• Customize chart elements, including secondary axes and data series.

The Instructor: Daniel Tony Housard

Daniel is a seasoned Computer Science and MIS lecturer at the University of Nicosia, bringing over 25 years of experience in higher education and professional training. With a strong academic foundation—holding an MSc in Computer Science from Glasgow University—Daniel has dedicated his career to empowering university students and professionals through engaging seminars, technical training, and applied knowledge. Daniel specializes in software applications and programming, with expertise spanning Microsoft Office, Advanced Excel, Power BI, Python, and C++. He is widely recognized for his practical approach to teaching and his ability to break down complex technical concepts into clear, actionable insights. His seminars focus particularly on application software, helping participants build essential skills for both academic and workplace success. Certified by ECDL and Microsoft, and a GCE A-Level Computer Science expert, Daniel combines technical depth with a passion for education. Whether delivering lectures or hands-on workshops, he consistently supports learners in achieving digital fluency and confidence in modern computing tools.

Certification

All participants will be awarded a certificate. Each hour of attendance will account for one unit of Continuing Professional Development (CPD) as required for members of most professional bodies.