Advanced Excel
UCD Professional Academy extends UCD's heritage of educational excellence to professionals looking to give their career an advantage. Successful completion of a UCD Professional Academy programme denotes a professional's specialist skills and practical business knowledge in the given area of study.
Skills / Knowledge
- Practical aspects of Excel data types
- Common data type errors
- Efficient navigation
- Data entry techniques
- Data manipulation
- Data cleaning and conversion techniques
- Handling errors, duplicates, and non-uniform data
- Flash fill
- Text-to-columns functionality
- Understanding formulas
- Using formulas effectively
- Array formulas for data analysis
- Data search best practices
- Find, replace, advanced filtering, and wildcards
- Highlighting using conditional formatting
- Lookup and conditional calculation functions
- Collaboratively addressing real-world challenges
- Implementing and validating Excel solutions
- Data validation and error checking
- Handling errors in formulas
- Circular references
- Fundamentals and purpose of dashboards
- Creating interactive elements with basic slicers
- Multi-dimensional analysis with pivot tables
- Advanced charts and graphics for data visualisation
- Exploring dynamic dashboards and form controls
- Leveraging AI for problem solving
- Collaboratively resolve real-world Excel challenges