STEM

# Excel Formulas

28 CQ
12 Lessons
Previous...
• Playing
Free
2 CQ
1. Using the FIND Function in Excel
A lesson with Trump Excel

Looking for a text string in a large spreadsheet? Learn how to use the FIND function in Excel to locate the position of a word or character within a cell.

Looking for a text string in a large spreadsheet? Learn how to use the FIND function in Excel to locate the position of a word or character within a cell.

• Playing
3 CQ
2. Using the SEARCH Function in Excel
A lesson with Trump Excel

In this beginner’s lesson on how to use Excel, you’ll learn how to use the search function to find the location of a word or character within a cell.

In this beginner’s lesson on how to use Excel, you’ll learn how to use the search function to find the location of a word or character within a cell.

• Playing
2 CQ
3. Using the AND Function in Excel
A lesson with Trump Excel

In this lesson, learn how to use AND Formula in Microsoft Excel—for when you want to evaluate multiple conditions and make sure that they are all true.

In this lesson, learn how to use AND Formula in Microsoft Excel—for when you want to evaluate multiple conditions and make sure that they are all true.

• Playing
3 CQ
4. Using the SUBSTITUTE Function in Excel
A lesson with Trump Excel

In this quick and easy lesson from Trump Excel, learn how to use SUBSTITUTE function and its arguments to replace characters or text strings.

In this quick and easy lesson from Trump Excel, learn how to use SUBSTITUTE function and its arguments to replace characters or text strings.

• Playing
2 CQ
5. Using the LEFT Function in Excel
A lesson with Trump Excel

The LEFT function in Excel extracts a specified number of characters from the left part of a string. Learn how to use this function in an Excel spreadsheet.

The LEFT function in Excel extracts a specified number of characters from the left part of a string. Learn how to use this function in an Excel spreadsheet.

More...
• Recommended Recommended
• History & In Progress History
• Browse Library
• Most Popular Library

### Get Personalized Recommendations

Let us help you figure out what to learn! By taking a short interview you’ll be able to specify your learning interests and goals, so we can recommend the perfect courses and lessons to try next.

You don't have any lessons in your history.
Just find something that looks interesting and start learning!

500 characters max
Clark G
Great job!
500 characters max
wendy m
Can I do it later
500 characters max
Harmeek K
keep helping....
500 characters max
Sara F
How to make a formula in ms excel with produce \$6143 shipping \$243 handling \$86 insurance \$90 sale price \$10856 and the brokers receive 35% of the profit on each sale did not match with any Answers results.
Trump Excel
Hi Sara.. Can you explain a bit more on this.. Based on what I understand, IF Function can be helpful.. have a look - https://curious.com/trumpexcel/using-if-function-in-excel
500 characters max
steven w
thank you i never knew this ty
500 characters max