Master amazing and effective tricks in Microsoft Excel using easy-to-understand videos in this free online course. Discover some amazing and helpful tricks you can effectively use in Microsoft Excel with these short practical training videos. This course will introduce you to handling day-to-day life data, filling data automatically, and linking different sheets. In addition, we explore how to extract the required data from a complex source of information, make cell data conditional, and so much more. Enrol today and become an expert in Microsoft Excel!
| College | Alison |
| Course ID | 195210 |
| Course Type | Online Learning |
| Course Qualification | CPD Certificate |
| Course Duration | 1.5-3 hours |
| Course Fee | Free |
| Entry Requirements | Like all courses on the Alison Free Learning platform this is a free, CPD-accredited course. A Graduate can choose to buy a certificate or diploma upon successful completion of a course, but this is not required or necessary. At Alison we believe that free education, more than anything, has the power to break through boundaries and transform lives. Alison is the world’s largest free online empowerment platform for education and skills training, offering over 5000 CPD accredited courses and a range of impactful career development tools. It is a for-profit social enterprise dedicated to making it possible for anyone, to study anything, anywhere, at any time, for free online, at any subject level. Through our mission, we are a catalyst for positive social change, creating opportunity, prosperity, and equality for everyone. |
| Career Path | What You Will Learn In This Free Course • Indicate how to fill data in a spreadsheet automatically • Describe how to link data from different spreadsheets • Explain how to freeze a specific section • Select and extract the desired data from a complex data source • State and control the input values in the cells • Compare the values in the data set • Recall crucial steps when creating an income spreadsheet • Evaluate the numbers of the input data in a complete spreadsheet |
| Course Code | 4519 |

Learn safe food-handling practices required for the catering industry with this free online food hygiene course.
Learn about Exchange Traded Funds (ETFs) and tokenisation in this free online course to create, fund, and regulate them.
Review maths content in preparation for the Junior Certificate Higher Level in this free online course.
This free online animal care course teaches you how to feed dogs a natural diet of raw foods to improve their wellbeing.