Top 25 Excel Formulas

Name: Top 25 Excel Formulas
Availability: InStock
Rating: 3.3 (94 reviews)

Master Excel’s formulas and advanced functions to create better reports with this free online MS Excel course.

Published by

Saved For Later

Confident you have the skills to certify without completing the course content?

Learning Outcomes

In this free course, you will learn how to:

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

Published by

Positive learner ratings

Learners Courses

Earn credentials that matter: Anyone can say they’re learning. A CPD-accredited Alison Certificate proves you followed through.
Get an edge over others: Add your Certificate to your CV, LinkedIn, and Alison Profile to strengthen job applications and promotion opportunities.
Show you’re serious about growth: A Certificate signals initiative, commitment, and a willingness to keep learning; qualities employers actively look for.