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.
| College | Alison |
| Course ID | 188943 |
| 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 |
Learn about electricity, its applications, and the key aspects of the electrical trade with this free online course.
Gain a better understanding of a nurse's role as a team leader and teacher with this free online nursing course.
Master the essential steps to food product development from concept to market with this free online course.
Master the skills and strategies you need for a deep understanding of text in this free online deep reading course.
