Certificate Courses
Get Certified as an Excel Pro!
Microsoft
Basic42 episodes · 37m 38s847K views Excel
Data Management
Spreadsheet
Productivity
Professional Development
certificate
Episodes
1. 1. The Ultimate Data Tool: Microsoft Excel
1m 05s
Learn more about what Microsoft Excel is capable of through this video.
Learn more about what Microsoft Excel is capable of through this video.
2. 2. Starting Off With A Workbook
0m 33s
Here's how to open a new workbook and start your project.
Here's how to open a new workbook and start your project.
3. 3. How To Add Worksheet
0m 34s
You can create multiple worksheets in one workbook. Here's how.
You can create multiple worksheets in one workbook. Here's how.
4. 4. Get Your Data To Your Desired Place
0m 51s
Quick and easy ways to move or copy worksheets on Microsoft Excel Spreadsheets.
Quick and easy ways to move or copy worksheets on Microsoft Excel Spreadsheets.
5. 5. Insert Or Delete Rows/Columns Easily
1m 00s
Learn the steps to add or remove rows and columns on Microsoft Excel Spreadsheet.
Learn the steps to add or remove rows and columns on Microsoft Excel Spreadsheet.
6. 6. Select Cells However You Wish
0m 57s
Simple tricks to select multiple cells without having to drag most of the time.
Simple tricks to select multiple cells without having to drag most of the time.
7. 7. Fill In Dates In Seconds!
0m 53s
Easy steps to help Microsoft Excel users to get the software to fill in dates automatically.
Easy steps to help Microsoft Excel users to get the software to fill in dates automatically.
8. 8. Merge Texts Into One Cell
1m 44s
2 quick and easy formulas for you to combine data from multiple columns into one.
2 quick and easy formulas for you to combine data from multiple columns into one.
9. 9. Navigate Your Rows Or Columns
0m 57s
Move your cells in Microsoft Excel by just dragging or copying and pasting.
Move your cells in Microsoft Excel by just dragging or copying and pasting.
10. 10. Duplicate Your Desired Cells
0m 33s
Copy and paste cells to a different location in your Microsoft Excel Spreadsheet.
Copy and paste cells to a different location in your Microsoft Excel Spreadsheet.
11. 11. Change The Box Size In Excel
0m 40s
Learn how to adjust the column width and row height in Microsoft Excel to present data better.
Learn how to adjust the column width and row height in Microsoft Excel to present data better.
12. 12. Merge And Unmerge In Excel Easily!
0m 29s
Find out how to merge and unmerge cells in Excel!
Find out how to merge and unmerge cells in Excel!
13. 13. Quickest Ways To Format Numbers
0m 28s
Explore quick ways to make your numbers look more uniform in Excel!
Explore quick ways to make your numbers look more uniform in Excel!
14. 14. Highlight Cells As You Wish!
0m 59s
Try various types of conditional formatting to highlight cells according to personal preferences.
Try various types of conditional formatting to highlight cells according to personal preferences.
15. 15. Copy Cell Formatting Like A Wizard!
1m 01s
Explore shortcuts to copy cell and number formatting to make sheets more presentable.
Explore shortcuts to copy cell and number formatting to make sheets more presentable.
16. 16. Style Your Excel Sheet Like A Pro!
0m 58s
Explore the ways you can make efficient use of styles in Excel in this quick video.
Explore the ways you can make efficient use of styles in Excel in this quick video.
17. 17. A Formula Is What A Calculation Needs
1m 39s
In this video, discover how you can create formulas that make calculations easier in Excel.
In this video, discover how you can create formulas that make calculations easier in Excel.
18. 18. The Formula For Division In Excel
0m 32s
Watch this tutorial to discover how to do division in Excel using just one formula.
Watch this tutorial to discover how to do division in Excel using just one formula.
19. 19. Multiplying Couldn't Be Easier!
0m 32s
Here's a simple formula to solve multiplication in Excel spreadsheets using cell data.
Here's a simple formula to solve multiplication in Excel spreadsheets using cell data.
20. 20. Do Subtraction In A Flash!
0m 33s
Let's learn how to solve one of the basic arithmetic calculations, subtraction, in Excel.
Let's learn how to solve one of the basic arithmetic calculations, subtraction, in Excel.
21. 21. Find Your Data Using VLOOKUP
0m 53s
In this video, find out what VLOOKUP is and how to use it to make searching for data in Excel easy.
In this video, find out what VLOOKUP is and how to use it to make searching for data in Excel easy.
22. 22. How To Use The SUM Function In Excel
0m 28s
Check out this quick and easy way to calculate the total amounts in Excel using the SUM formula!
Check out this quick and easy way to calculate the total amounts in Excel using the SUM formula!
23. 23. Basics Of The IF Function In Excel
0m 57s
Learn the basics of Microsoft Excel’s IF function.
Learn the basics of Microsoft Excel’s IF function.
24. 24. Using The IFS Functions In Excel
1m 17s
Learn how to grade scores using Microsoft Excel’s IFS function.
Learn how to grade scores using Microsoft Excel’s IFS function.
25. 25. Using SUMIFS In Microsoft Excel
1m 06s
Learn how to calculate total sales using Microsoft Excel’s SUMIF function.
Learn how to calculate total sales using Microsoft Excel’s SUMIF function.
26. 26. Ways To Define And Use Names In Formulas
1m 46s
Define and use names in formulas to make your data manageable.
Define and use names in formulas to make your data manageable.
27. 27. Creating A Table In Microsoft Excel
0m 29s
Create a table on Microsoft Excel within a minute.
Create a table on Microsoft Excel within a minute.
28. 28. Sorting Data Tables In Microsoft Excel
1m 02s
Learn how to sort tabulated data on Microsoft Excel with three simple steps.
Learn how to sort tabulated data on Microsoft Excel with three simple steps.
29. 29. Filtering Data From A Range Or A Table
1m 03s
Learn how to easily filter out unneeded data from your Excel spreadsheet.
Learn how to easily filter out unneeded data from your Excel spreadsheet.
30. 30. Using Slicers To Filter Data In Excel
0m 37s
Get an understanding of Excel’s slicer tool and how it can filter out data from a table.
Get an understanding of Excel’s slicer tool and how it can filter out data from a table.
31. 31. Create A Pivot Table In Microsoft Excel
0m 45s
Find out how to convert data from a range or a table into a pivot table in this video.
Find out how to convert data from a range or a table into a pivot table in this video.
32. 32. Grouping Data From Pivot Tables
1m 37s
Discover how to group data from pivot tables in this video.
Discover how to group data from pivot tables in this video.
33. 33. Steps To Filter Pivot Table Data
0m 37s
Learn how to filter out unnecessary data from pivot tables today by watching this video.
Learn how to filter out unnecessary data from pivot tables today by watching this video.
34. 34. Develop A Pivot Chart In Microsoft Excel
1m 04s
Watch to find out how to create a pivot chart on Microsoft Excel.
Watch to find out how to create a pivot chart on Microsoft Excel.
35. 35. Share A Workbook In Microsoft Excel
0m 41s
Collaborate with others and share your workbook with these simple steps.
Collaborate with others and share your workbook with these simple steps.
36. 36. Adding And Reviewing Comments In Excel
1m 30s
Learn all about adding and reviewing comments in Microsoft Excel with this video.
Learn all about adding and reviewing comments in Microsoft Excel with this video.
37. 37. Use Passwords To Protect Your Workbook
0m 40s
Discover how to safeguard your Excel workbooks now with a password.
Discover how to safeguard your Excel workbooks now with a password.
38. 38. How To Create A Chart In Excel
0m 45s
Figure out how to create charts for your data on Microsoft Excel in this video.
Figure out how to create charts for your data on Microsoft Excel in this video.
39. 39. Chart Title Formatting In Excel
1m 07s
Watch the video and learn how to make your Excel charts more understandable.
Watch the video and learn how to make your Excel charts more understandable.
40. 40. Showing And Hiding A Chart Legend
0m 39s
Learn how to hide or show a chart legend on your spreadsheet.
Learn how to hide or show a chart legend on your spreadsheet.
41. 41. Showing Data Trends Using Sparklines
0m 39s
Explore the sparkline tool and learn how to use it to show data trends in this video.
Explore the sparkline tool and learn how to use it to show data trends in this video.
42. 42. Analyse Your Excel Data Within A Minute!
0m 37s
Learn how to analyse your Excel spreadsheet data quickly in this video.
Learn how to analyse your Excel spreadsheet data quickly in this video.
You might also like this
MicrosoftBasic14 episodes · 3h 24m44.8K views
MicrosoftBasic3 episodes · 28m 24s198K views
MicrosoftBasic10 episodes · 9m 48s17.2K views
MicrosoftBasic7 episodes · 1h 16m54.5K viewsTools and templates
Boost your job preparation with these essential tools and templates.
