Course Overview
Teacher
Sumit Bansal is an Excel Enthusiast who started Trump Excel as an initiative to share amazing things about Excel Spreadsheet. Through his video courses, he has helped many people learn excel and get ahead in their professional career and personal... View ProfileDetails
- Total Time 42 min
- Lessons 12
- Attachments 4
- Exercises 14
-
28 CQ
12 Lessons in This Course
-
3 minFREEMicrosoft Office lesson 1Free2 CQ
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.
with Trump ExcelLooking 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.
-
5 minSTEM lesson 23 CQ
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.
with Trump ExcelIn 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.
-
3 minSTEM lesson 32 CQ
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.
with Trump ExcelIn 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.
-
4 minMicrosoft Office lesson 43 CQ
In this quick and easy lesson from Trump Excel, learn how to use SUBSTITUTE function and its arguments to replace characters or text strings.
with Trump ExcelIn this quick and easy lesson from Trump Excel, learn how to use SUBSTITUTE function and its arguments to replace characters or text strings.
-
2 minMicrosoft Office lesson 52 CQ
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.
with Trump ExcelThe 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.
-
2 minMicrosoft Office lesson 62 CQ
The RIGHT Function in Excel extracts a specified number of characters from the right part of a string of text. Learn about function syntax and usage here!
with Trump ExcelThe RIGHT Function in Excel extracts a specified number of characters from the right part of a string of text. Learn about function syntax and usage here!
-
2 minMicrosoft Office lesson 72 CQ
The LEN Function in Excel returns the number of characters in a string and can be used with both text and numbers. Learn how to use this function in Excel!
with Trump ExcelThe LEN Function in Excel returns the number of characters in a string and can be used with both text and numbers. Learn how to use this function in Excel!
-
3 minMicrosoft Office lesson 82 CQ
Use the MID Function in Excel when you want to extract a particular string of text from a cell’s content. Learn about the function syntax and usage here.
with Trump ExcelUse the MID Function in Excel when you want to extract a particular string of text from a cell’s content. Learn about the function syntax and usage here.
-
2 minMicrosoft Office lesson 92 CQ
If you want to convert capitalized letters into lowercase letters, then the LOWER Function in Excel is for you. Learn about its syntax and uses in this lesson.
with Trump ExcelIf you want to convert capitalized letters into lowercase letters, then the LOWER Function in Excel is for you. Learn about its syntax and uses in this lesson.
-
2 minMicrosoft Office lesson 102 CQ
The PROPER Function capitalizes the first character of each word in your Excel spreadsheet data. Learn about function syntax and usage in this lesson.
with Trump ExcelThe PROPER Function capitalizes the first character of each word in your Excel spreadsheet data. Learn about function syntax and usage in this lesson.
-
4 minMicrosoft Office lesson 113 CQ
Learn how to use the TEXT Function in Excel so you can change the format of a number or combine text and numbers (name and date) in an Excel spreadsheet!
with Trump ExcelLearn how to use the TEXT Function in Excel so you can change the format of a number or combine text and numbers (name and date) in an Excel spreadsheet!
-
5 minMicrosoft Office lesson 123 CQ
Formatting a document with values in Excel? You might want to know about the IF function. Determine if values are true or false with this common formula.
with Trump ExcelFormatting a document with values in Excel? You might want to know about the IF function. Determine if values are true or false with this common formula.
-
782 min7-part Microsoft Office course45 CQ
Excel 2016 offers many features for daily data tracking. In this course, learn how to use major features of Excel 2016 such as formulas, formatting, charting, pivot tables, and more.
with Trump ExcelExcel 2016 offers many features for daily data tracking. In this course, learn how to use major features of Excel 2016 such as formulas, formatting, charting, pivot tables, and more.
-
3 minFREEMicrosoft Office lessonFree2 CQ
Do you have a draft worksheet you want to share with your colleagues? In this lesson, learn how to place a watermark in your work-in-progress Excel worksheets.
with Trump ExcelDo you have a draft worksheet you want to share with your colleagues? In this lesson, learn how to place a watermark in your work-in-progress Excel worksheets.
-
9 minMicrosoft Office lesson5 CQ
Do you have a long list of data in your Excel worksheet? Learn how to build a scrollbar so you can display only part of the scrollable list at once.
with Trump ExcelDo you have a long list of data in your Excel worksheet? Learn how to build a scrollbar so you can display only part of the scrollable list at once.
-
14 minMicrosoft Office lesson8 CQ
As a beginner working with Microsoft Excel, it's important to start by getting comfortable with the workspace. Discover basic features and functions in Excel!
with Trump ExcelAs a beginner working with Microsoft Excel, it's important to start by getting comfortable with the workspace. Discover basic features and functions in Excel!
-
12 minMicrosoft Office lesson7 CQ
It's time to learn about entering data in Microsoft Excel! In this comprehensive Excel lesson, learn several ways to edit data, delete, and Autofill data.
with Trump ExcelIt's time to learn about entering data in Microsoft Excel! In this comprehensive Excel lesson, learn several ways to edit data, delete, and Autofill data.
-
762 min7-part Microsoft Office course33 CQ
New to Microsoft Office? Then you're probably eager to get started with Microsoft Word, the go-to program for creating text documents. Over the course of 13 lessons, instructor Richard Rost will walk you through an overview of Microsoft Word basics. Learn to navigate the program using the Word interface and ribbon. Once you're comfortable, learn to create a document—a business letter—and enter edit, and format text. You'll learn a few keyboard shortcuts and how to print, email, and save files.
with AmicronNew to Microsoft Office? Then you're probably eager to get started with Microsoft Word, the go-to program for creating text documents. Over the course of 13 lessons, instructor Richard Rost will walk you through an overview of Microsoft Word basics. Learn to navigate the program using the Word interface and ribbon. Once you're comfortable, learn to create a document—a business letter—and enter edit, and format text. You'll learn a few keyboard shortcuts and how to print, email, and save files.
-
11137 min11-part Microsoft Office course73 CQ
Learn how to crunch through your PowerPoint slides, create decks you’re proud of, and finish your PowerPoint presentation quickly and professionally with hotkeys and the Quick Access Toolbar!
Learn how to crunch through your PowerPoint slides, create decks you’re proud of, and finish your PowerPoint presentation quickly and professionally with hotkeys and the Quick Access Toolbar!
-
26150 min26-part Microsoft Office course89 CQ
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
-
12175 min12-part Microsoft Office course94 CQ
Whether you’re a beginner or have Excel experience, this course will help you master one of the most powerful Microsoft Office programs available. Motion Training covers the fundamental skills you need to become a power user, including: proper spreadsheet set up, workbooks, calculations, formulas, functions (such as AutoFill and AutoSum), cell formatting, and charting. All lessons include .xlsx files so you can follow along for practice. Note that videos show Excel 2010.
with Motion TrainingWhether you’re a beginner or have Excel experience, this course will help you master one of the most powerful Microsoft Office programs available. Motion Training covers the fundamental skills you need to become a power user, including: proper spreadsheet set up, workbooks, calculations, formulas, functions (such as AutoFill and AutoSum), cell formatting, and charting. All lessons include .xlsx files so you can follow along for practice. Note that videos show Excel 2010.
-
661 min6-part Microsoft Office course34 CQ
Learn everything you need to know to get up and running with Powerpoint in just 1 hour! This course covers design, style, transitions, animations and a few advanced topics too.
Learn everything you need to know to get up and running with Powerpoint in just 1 hour! This course covers design, style, transitions, animations and a few advanced topics too.