10% Off IT and Computing Diplomas – Use Code ITDIPS10
Excel has proved itself as an essential tool for the success of any business.
Microsoft Excel is a powerful, industry standard application central to any role working with data. As organising and manipulating data becomes increasingly important across a multitude of industries, employees who have advanced knowledge of this tool are highly sought after.
Knowing the advanced techniques of Excel will allow you to analyse and summarise data and present professional reports and dashboards to decision makers. Using Excel as a foundation, your analytical skills will improve, and you will save time and work more efficiently. Having experience in Advanced Excel is extremely valuable to employers and will increase your chances of being hired.
What Will I Learn From This Course?
Excel is a highly valued skill across many industries. Understanding the power of Excel and learning to design robust, safe, and scalable spreadsheets is a critical skill for most businesses.
Whether you are new to Excel or understand the basic concepts, this course is designed to build your analytical skills and take you to an advanced level of proficiency in Excel. Our lecturers have many years of industry experience across Business Intelligence and Analytics teams and will bring this experience to you using real-life examples and practical applications of Excel.
When you take this course, you will build on the fundamentals to help you acquire professional techniques that will provide long-lasting practical spreadsheet development skills, and help you command a higher salary in today’s Excel reliant world.
This course introduces you to the foundational skills of basic formula and formatting, then takes you through more advanced concepts of working with data, pivot tables and VBA (Excel’s programming language) It concludes with the advanced topics of creating professional visualisations and dashboards which would impress at any level of an organisation.
Excel Foundations (2 weeks)
- Excel Fundamentals
- Text and Formulas
- Formatting Data
- Sorting and filtering
- Inserting Images and Shapes
- Creating Basic Charts
- Printing Worksheets
- Data Validation
- Importing and Exporting Data
Advanced Excel Concepts (3 weeks)
- Text based functions
- Lookup functions
- Statistical functions
- Conditional functions
- Formula-based formatting
- Date and Time functions
- Logical operators
- Array formulas
- Excel Macros and VBA concepts
Excel Pivot Tables for Data Analysis (3 weeks)
- Connecting to data sources
- Data structures in Excel
- Power pivot
- Pivot Table layouts and styles
- Design and formatting options
- Sorting, filtering, and grouping tools
- Calculated fields, items and values
- Pivot Charts, slicers, and timelines
Data Visualisation in Excel (2 weeks)
- Column and bar charts
- Pareto charts and histograms
- Line charts and trend lines
- Area charts
- Scatter plots and Bubble charts
- Waterfall and Funnel charts
- Heat maps, 3-D Surface, and contour charts
- Creating Excel dashboards
A basic understanding of working with Windows or Mac applications.
Students will be required to have Office software downloaded onto their devices for the duration of this course.
See price for monthly Microsoft subscription here: https://bit.ly/3n9stFT
Diploma in Excel – Advanced Course Fee
(€795 if paying in instalments)
Online course: €595
(€695 if paying in instalments)
If paying in instalments by direct debit, the deposit to book a place is €150 and the balance is split into three equal monthly payments.
Non-EU students: Call +353 1 4160034
John Honan is a Software Engineer with over 20 years’ experience across the e-commerce and finance industries. Having worked as Global Head of Data Strategy at Groupon, John knows how to build robust BI systems that deliver meaningful business information. He has also mentored and led teams of data analysts and delivered analytics solutions at companies including Google, Microsoft and AIB.
John has an in-depth knowledge of RDBMS databases and frameworks from mySQL and Oracle up to high-volume systems like Hadoop, together with the programming languages and analytics tools needed to leverage that data; SQL, Excel, Python, R, Java, and Tableau.
John holds a Masters in Computer Science from The Open University, UK and has several peer-reviewed publications.
A pass grade on the written assignment will be required for awarding of the Diploma.
Similarly, the Project must be handed in on the due date unless a sound reason for lateness is provided. In such instances, an extension may be awarded at the discretion of the lecturer.
Why City Colleges
- Courses for students who are passionate about their subject, delivered by leaders in their field.
- Live lectures which are also streamed live on Moodle and recorded for review
- City centre location in South Great George’s Street, convenient for bus, LUAS, DART
- Southside Dublin, Ireland location
- Study rooms and library in our City Centre location in Dublin, Ireland
- Limited class size