Learn how Microsoft Excel formulas and functions can make you a spreadsheet expert in this free online course. Microsoft Excel is a powerful tool that can help streamline your business processes and productivity but its many formulas, functions, and chart types to choose from can easily overwhelm you. Whether you are a beginner, intermediate or advanced user, this course offers plenty of shortcuts, tips and tricks to help you master Microsoft Excel by using the best formulas for your projects to increase business productivity.
| College | Alison |
| Course ID | 191907 |
| 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 | In This Free Course, You Will Learn How To • Discuss Excel and error messages in Excel • Analyse how to use ‘trim’ and ‘truncate’ functions • List examples and uses of spreadsheet applications • Identify ‘mode’ and ‘mod’ functions • Explain worksheet and cell name (cell reference) • Describe factorial and absolute value functions • Identify ‘active cell’, ‘name box’ and ‘formula’ bar • List the comparison operators in Excel • Discuss spreadsheet simple formulas • Describe how to use ‘concatenate’ and ‘log’ functions • Summarise the uses of ‘standard deviation’ and ‘power’ functions • Explain the ‘And’, ‘Or’ and ‘IF’ functions |
| Course Code | 266 |
Study the symptoms, types, diagnosis and treatment of epilepsy and its associated seizures in this free online course.
Learn about electrical transformer construction and components with this free online Electrical Engineering course! This free online Electrical Engineering course will teach you about electrical transformers, why we use them, and the features and functionality of their main components.
This free online course will teach you how to enhance your skills in creating professional, colourful hairstyles.
This free online course teaches you how to perform lymphatic drainage massage therapy (LDM) to boost immune systems.
