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!

8 Comments
500 characters max
Johan C
Thanks
500 characters max
Tedecia W
i need to learn how to do the if and and statement
Trump Excel
IF Function() - https://curious.com/trumpexcel/using-if-function-in-excel?skip_course=1
Trump Excel
AND Function - https://curious.com/trumpexcel/using-the-and-function-in-excel?skip_course=1
500 characters max
jim r
How to square a number?
Trump Excel
You can use =A1^2 (assuming that the value is in cell A2)
500 characters max
hafiz n
how to create the persentage in Excel
Trump Excel
If you have a number and you want to make it a percentage Go to Home --> Niumber group and from the drop down select Pecentage
500 characters max