Learn how to develop and apply formulas and perform useful data analysis with this free online Microsoft Excel training. Did you know that Excel has become a prerequisite for almost all jobs in the analytics and consulting sector? Through this free online Microsoft Excel certification, you will gain the in-demand skills to generate and use lookup, conditional, and advanced Excel formulas and functions to conduct complex calculations, build professional reports as well as perform the data analysis and visualization of Excel tools, pivot tables and pivot charts.
| Course Category | Microsoft Excel, Computers & IT (Information Technology) |
| 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 • List the most frequently used lookup and decision formulas • Outline the methods for creating and applying formulas in a spreadsheet to locate specific data • Identify the correct formula for calculating a specific value, counting cells, or adding the provided data • Explain the syntax of several new Excel functions • Discuss the concept of named ranges • Outline the tools that can be used to customize the named ranges • Recognize the range operators that appear in the formula syntax • Describe the operations that may be performed within an Excel table • Discuss the mechanics of a pivot table and its capabilities • Summarize the steps for counting, averaging, and running totals with pivot tables • Explain how to use filters, slicers, timelines, and pivot charts to display dynamic views of data • Describe the process of creating a pivot chart |
| Course Code | 4015 |
Enrol with Alison today! This free online certificate course teaches you how to use CPR, AED, and first aid to save lives.
Enrol with Alison today! Learn how to give good care to the elderly with the nursing procedures and practices in this free online nursing course.
Enrol with Alison today! Learn the important functions and practices of human resource professionals in this free online diploma course.
Enrol with Alison today! In this free online course, learn how to implement the HACCP Food Safety System in your catering establishment.
