
Gain practical, hands-on experience with advanced spreadsheets through assignments, with feedback on Udemy, covering the full syllabus and updates; ensure Office is installed.
Learn how to submit an assignment in Udemy. Download the file, solve the task, and submit by taking screenshots or writing a description; wait for instructor feedback.
Create pivot tables to summarize and analyze data in Excel, arranging rows, columns, and values to show sales per salesman, with filters and quick recommendations.
Explore how pivot charts visually summarize pivot tables, linking fields like product and salesman to filter data and adjust value fields, with seamless updates and the option to revert designs.
Explore how to create calculated fields and calculated items in pivot tables to compute income, multiply quantity by price, and summarize products like shoes and boots.
Learn how to transpose data in Excel to switch rows and columns, preserving or copying formatting, and compare linked versus unlinked results for efficient data presentation.
Protect a worksheet by clicking unprotected on the top ribbon, selecting default options to define user permissions, and setting a password for confirmation.
Rate and comment on the epilogue of the advanced spreadsheets module to help us improve these lectures, and apply what you learned—knowledge not used can never become a skill.
Learn to claim a free Test4u subscription by following the link, entering your Udemy profile name, passing the not-a-robot check, and activating 12 months of access.
(updated September 2023)
We have made various minor improvements to the course content. These include fixing typos and clarifying instructions. These changes are intended to improve the quality and accuracy of the course and provide a better learning experience for our students.
The TEST4U ECDL / ICDL Advanced Spreadsheets Course
The TEST4U team realized that there is a need for a complete hands-on Training system for ECDL / ICDL Advanced Spreadsheets exam, so we created the ECDL / ICDL Advanced Module - Advanced Spreadsheets, course. It is targeted to people who want to succeed in the ECDL / ICDL Advanced Spreadsheets exam.
The Course at a glance
In this course you will find:
55 assignments properly categorized
55 distinct files for each of the above assignments
55 solution videos for every assignment
The Course in detail
55 assignments properly categorized
In this course you will practice on the following categories, using Microsoft Excel:
1. Formatting
2. Functions and Formulas
3. Charts
4. Analysis
5. Validating and Auditing
6. Enhancing Productivity
7. Collaborative Editing
55 distinct files for each of the above assignments
Each and every assignment comes with its distinct file(s) that are necessary to answer the assignment
55 solution videos for every assignment
All assignments are accompanied by detailed video solutions. We recommend you try to solve the assignments without viewing the solution. This way you will better understand your limitations and be able to focus on them. You can then see the video after you have solved it, to know if you answered the question correctly.
Fast feedback from our instructors
We give feedback to all assignments, usually within one or two working days. Although in many cases we have been known to answer within a few hours.