This free online course is an intermediate Excel 2021 guide that describes the essential functions of this program. This step-by-step guided course helps you learn essential functions in the program Microsoft Excel 2021. This course is a complete outlet to help you manage data. You will see what it can do for you and examine all its functions, including the use of formulas. We provide information to assist you in creating a spreadsheet that is readable and easy to navigate. We answer questions like ‘what is a function?’ or ‘why use a formula?’.
| College | Alison |
| Course ID | 192160 |
| Course Type | Online Learning |
| Course Qualification | CPD Certificate |
| Course Duration | 4-5 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 | In This Free Course, You Will Learn How To • Analyse the ‘golden rules’ of using spreadsheets • Explain adding ‘navigation’ buttons • Identify the various functions in the spreadsheet • Identify how to use ‘nested if’ functions • Indicate how to utilise ‘Vlookup’ functions such as ‘approx match’ and ‘exact match’ • Evaluate the various functions like ‘Xlookup’ and ‘Xmatch’ • Recognise how to sort through multiple columns • Explain how to apply custom date formats and formulas |
| Course Code | 1037 |
Learn how to rewild a garden by letting nature restore its ecosystems in this free online sustainable gardening course.
This free online digital marketing course explains how to syndicate your content and boost engagement with social media.
Develop your leadership skills by studying the professional supervision methods and styles in this free online course.
Gain insights into eCommerce and various information systems strategies for businesses in this free online course.
