Master Excel’s formulas and advanced functions to create better reports with this free online MS Excel course. Improve your ability to analyze numerical data with this free online Excel course that teaches you how to use this Windows, Android, MacOS and iOS spreadsheet program. This Excel tutorial will teach you how to use the logical, financial, text, lookup and reference functions along with how to track changes, modify templates, macros and external data sources. This course allows you to get the most out of this powerful program in a practical way.
| College | Alison |
| Course ID | 196036 |
| 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 logical and financial functions in a spreadsheet • Compute values using the ‘if’ function • Indicate arguments as true or false using the ‘and’ function • Compare the uses of logical functions ‘and/if’, ‘iferror’ and ‘xor’ • List the uses of financial functions: present Value, future value, payment, price and yield • Analyze data and information with the use of financial functions • Identify the applications of ‘text’, ‘lookups’ and ‘reference’ functions in Excel • Arrange data in a user-friendly format • Classify data according to specified categories or values • Summarize findings for meaningful reporting • Compare the features of ‘lookup’ functions • Select the right tabs and perform different tasks in Excel |
| Course Code | 3548 |
Investigate periodic elements and thermodynamics with this free online A-level diploma in chemistry course.
Express yourself in Russian by learning vocabulary and phrases to boost your fluency with this free online course.
Learn useful Linux commands and shell script and create your custom programs in this free online course.
This short course on ISO 27701 focuses on privacy management.
