By the end of the course, attendees would have been exposed to and have become more confident in Conditional Formatting, Workbook Automation Techniques amongst other techniques. Students will also be able to perform higher complex mathematical calculations, while being able to create their own calculations.
Learning Outcomes
Manage and Share Workbooks
- Manage multiple workbooks
- Modifying workbook templates
- Managing workbook versions
- Copying styles between templates
- Copying macros between workbooks
- Connecting to external data
- About the Excel Data Model
- Tracking changes
- Protecting workbooks for sharing
- Properties vs. metadata
- Manage workbook changes
- Displaying & Reviewing changes
- Merging workbooks
- Identifying errors & Tracing formulas in separate worksheets
Apply Custom Formats and layouts
- Creating custom formats (number, time, date)
- Using advanced Fill Series options
- Apply advanced conditional formatting and filtering
- Using functions to format cells
- Creating advanced filters
- Managing conditional formatting rules
- Apply custom styles and templates
- Creating custom templates
- Creating and modifying cell styles
- Creating themes
- Creating form fields
- Prepare workbooks for internationalization and accessibility
Create Advanced Formulas
- Apply functions in formulas
- Using nested functions
- Using the SUMIFS, AVERAGEIFS, and COUNTIFS functions
- Using financial functions
- Using the TRANSPOSE function
- Apply advanced date and time functions
- Using functions to serialize dates and times
- Create scenarios
- Using what-if analysis tools
- Using the Scenario Manager
- Merging scenarios
- Consolidating data
Create Advanced Charts and Tables
- Create advanced chart elements
- Adding trendlines to charts
- Creating dual-axis charts
- Creating custom chart templates
- Create and manage PivotTables
- Modifying field selections and options n Creating slicers
- Using PowerPivot
- Create and manage Pivot Charts
- Manipulating options in existing Pivot Charts n Applying styles to Pivot Charts
Accreditation and MQF level
A CPD Award accredited with 1 ECTS credits (MQF Level 5) by the Malta Further & Higher Education Authority (MFHEA), the Award in MS Excel Intermediate: The Use of Formulae & Intermediate Data Operations will be awarded.
Course Duration
This course is made up of 2 half-day sessions.
Entry requirements
A foundation in basic Excel techniques is advised. This course will prepare students for a more advanced course, helping them to learn new tools and functions to make their work in the office more precise and efficient.
Trainer
Mr. Andrew Catania
Andrew Catania is a Senior Marketing Analyst working for Tipico. He obtained his B.Sc. in Statistics, Operational Research and Mathematics at the University of Malta. He has been working in the online industry for the past 13 years in various positions which were mainly in Data Warehousing and Analytics.
Course Funding Options
For Companies
- INVESTING IN SKILLS
Through this scheme, employers have the opportunity to get back a significant percentage of the costs that would have been incurred in any employee’s professional development via training. The ‘Investing in Skills’ scheme was launched to promote the training of persons actively participating in the Maltese Labour Market, with the aim to increase productivity and enhance adaptability.
Learn more about this scheme »