This free online course will teach you how to use the various Excel table tools and features to their maximum potential. Excel has hundreds of valuable functions, but most of us only utilize a small amount of them. Imagine how much easier everyday tasks would be if you could unlock even more of the powerful tools offered by the Excel platform. With this free online Excel course, you will learn all about the world of Excel tables, shortcuts, formula-driven development, macros, the many controls available and how to create interactive charts.
| College | Alison |
| Course ID | 196147 |
| 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 • Identify the main rules and the advantages of using Excel tables • Describe the Excel function that allows making decisions easier • Distinguish between the sorting and decision functions • Outline the concept of data aggregation • Explain the process of creating filters on Excel tables • Compare the pros and cons of Excel Form and ActiveX controls • Summarize the shortcomings of classic Excel development • Discuss the notion of formula-driven development |
| Course Code | 3765 |

Learn how residential care facilities help children to live with disabilities in this free online caregiving course.
Learn about the globalization of information systems and major technological advancements in this free online course.
Learn how organisms interact with each other and their environment to form ecosystems in this free online course.
This free online course discusses the concept of sustainability and how to achieve the Sustainable Development Goals.