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 1 hr, 22 min
- Lessons 7
- Attachments 4
- Exercises 16
-
45 CQ
7 Lessons in This Course
-
10 minMicrosoft Office lesson 16 CQ
Copy and paste keyboard shortcuts save tremendous amounts of time when formatting! In this Excel 2016 lesson, learn the power of Paste Special.
with Trump ExcelCopy and paste keyboard shortcuts save tremendous amounts of time when formatting! In this Excel 2016 lesson, learn the power of Paste Special.
-
11 minMicrosoft Office lesson 26 CQ
In this Excel spreadsheets lesson, learn the basics of using Excel formulas. Learn about operators, order of precedence, and three basics functions.
with Trump ExcelIn this Excel spreadsheets lesson, learn the basics of using Excel formulas. Learn about operators, order of precedence, and three basics functions.
-
15 minMicrosoft Office lesson 38 CQ
Now that you know some basic Excel functions, learn three advanced and powerful Excel spreadsheet functions: IF, SUMIF, and VLOOKUP in this lesson.
with Trump ExcelNow that you know some basic Excel functions, learn three advanced and powerful Excel spreadsheet functions: IF, SUMIF, and VLOOKUP in this lesson.
-
12 minMicrosoft Office lesson 47 CQ
In this lesson, learn about some tools that can help you handle large data sets in Excel. These tools include freeze panes, split, filter, and sort.
with Trump ExcelIn this lesson, learn about some tools that can help you handle large data sets in Excel. These tools include freeze panes, split, filter, and sort.
-
8 minMicrosoft Office lesson 55 CQ
In this lesson, learn about conditional formatting in Excel spreadsheets. This helps to add some visual analysis to your data and make it less boring.
with Trump ExcelIn this lesson, learn about conditional formatting in Excel spreadsheets. This helps to add some visual analysis to your data and make it less boring.
-
10 minMicrosoft Office lesson 66 CQ
In this lesson, learn the basics of Excel charting. This lesson runs through a practical example of plotting data in Excel charts, and different chart options.
with Trump ExcelIn this lesson, learn the basics of Excel charting. This lesson runs through a practical example of plotting data in Excel charts, and different chart options.
-
13 minMicrosoft Office lesson 77 CQ
In this lesson, learn about one of the best Excel tools: Pivot Tables. Using a Pivot Table, you can instantly summarize huge amounts of data sets!
with Trump ExcelIn this lesson, learn about one of the best Excel tools: Pivot Tables. Using a Pivot Table, you can instantly summarize huge amounts of data sets!
-
1242 min12-part Microsoft Office course28 CQ
Excel is a wonderful data organization software—if you know the functions. This comprehensive course from Trump Excel demonstrates how to use common excel functions, from “FIND” to “IF” functions.
with Trump ExcelExcel is a wonderful data organization software—if you know the functions. This comprehensive course from Trump Excel demonstrates how to use common excel functions, from “FIND” to “IF” functions.
-
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.
-
79593 min79-part Microsoft Office course337 CQ
Pivot tables make data analysis and visualization fun! This extensive course explores how to apply the powerful Microsoft Excel pivot table feature to create reports that impress any audience.
with MyExcelOnlinePivot tables make data analysis and visualization fun! This extensive course explores how to apply the powerful Microsoft Excel pivot table feature to create reports that impress any audience.
-
889 min8-part Analytics course49 CQ
Want to improve your website’s SEO? In this course, Collin from White List Marketing Firm shares how to reach the top of Google search results using simple, proven white hat SEO strategy.
with Collin McAdamsWant to improve your website’s SEO? In this course, Collin from White List Marketing Firm shares how to reach the top of Google search results using simple, proven white hat SEO strategy.
-
16187 min16-part Analytics course100 CQ
Google Analytics is an essential tool for any online marketer. In this course for beginners, get a comprehensive overview of how to use it to track and report valuable data about your website.
with EduonixGoogle Analytics is an essential tool for any online marketer. In this course for beginners, get a comprehensive overview of how to use it to track and report valuable data about your website.
-
11122 min11-part Entrepreneurship course66 CQ
Growing a business is much easier with a solid brand in place. Digital marketing expert Dr. Gigi Johnson reveals how to analyze web data to design the launch—or re-launch—of your business.
with Dr. Gigi JohnsonGrowing a business is much easier with a solid brand in place. Digital marketing expert Dr. Gigi Johnson reveals how to analyze web data to design the launch—or re-launch—of your business.
-
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.