MS Office 2021 (MS Excel) in English
About Course
In this MS Excel (MS Office) course I explained each and every option available in
MS Excel. I share with you the real-life skills people need to get the best from the software in the workplace, gathered over many years. By taking this course you will be able to:
-
Confidently use the core MS Excel options in the workplace
-
Learn the skills employers expect you to have in Excel
-
Apply best practices to your work
Topics List
| Total | 59 Videos | Total Duration: 10:54:3 |
| 1. | introduction to Excel | 7m 9s |
| 2. | Starting Excel and Working Environment of Excel | 13m 44s |
| 3. | Data Entry in Excel | 35m 37s |
| 4. | Excel cell Borders, fonts & colors | 11m 15s |
| 5. | Cell Alignments-Merging-Wrapping text in EXCEL | 16m 42s |
| 6. | Number Format Options in Excel | 10m 19s |
| 7. | Conditional formatting in Excel | 28m 53s |
| 8. | Format as table in Excel | 9m 40s |
| 9. | Cell styles in excel | 5m 22s |
| 10. | insert and delete cells columns rows and sheets in excel | 5m 28s |
| 11. | Adjusting height and width of cells in Excel | 7m 47s |
| 12. | How to Hide and Show columns rows and sheets | 4m 40s |
| 13. | How to protect and organize sheets in Excel | 11m 6s |
| 14. | Auto sum options in Excel | 5m 44s |
| 15. | FILL OPTIONS IN EXCEL | 22m 54s |
| 16. | CLEAR CELLS OPTION IN EXCEL | 5m 33s |
| 17. | Sorting and Filtering Data in Excel | 11m 24s |
| 18. | Find and select options in excel | 15m 41s |
| 19. | Paste options in Excel | 13m 20s |
| 20. | Pivot Table in Excel | 16m 29s |
| 21. | Illustrations pictures icons smart art screenshot in Excel | 17m 52s |
| 22. | Table option in Excel | 12m 47s |
| 23. | Add ins to get More Apps into Excel | 10m 21s |
| 24. | Column and Bar charts in Excel | 21m 55s |
| 25. | Line and Area Charts in Excel | 13m 1s |
| 26. | Pie and Donut Charts in Excel | 6m 39s |
| 27. | hierarchy Charts Treemap and SunBurst in Excel | 7m 33s |
| 28. | Statistical charts Histogram and box and wishker in Excel | 4m 4s |
| 29. | Scatter XY and Bubble charts in Excel | 5m 13s |
| 30. | Water fall Funnel radar etc charts in Excel | 6m 47s |
| 31. | Combo charts in Excel | 5m 30s |
| 32. | MAP charts in EXCEL | 13m 13s |
| 33. | 3D MAP in EXCEL | 3m 50s |
| 34. | PIVOT CHARTS IN EXCEL | 7m 3s |
| 35. | Spark Lines small charts in Columns in excel | 5m 35s |
| 36. | Slicer and Timeline filters in Excel | 14m 44s |
| 37. | Preparing Organization charts in Excel | 5m 3s |
| 38. | How to place links of other files and web pages in Excel | 6m 2s |
| 39. | How add textbox word art header and footer and objects to Excel sheet | 11m 43s |
| 40. | How to insert Equations and symbols into Excel | 6m 17s |
| 41. | Applying Themes in Excel | 3m 30s |
| 42. | Page setup and view options in Excel | 23m 33s |
| 43. | Formula auditing in excel | 8m 18s |
| 44. | Defining names to cells | 7m 32s |
| 45. | Calculation options automatic and manual in Excel | 4m 10s |
| 46. | Introduction to Functions and formulas in Excel | 9m 58s |
| 47. | Financial Functions in Excel | 22m 57s |
| 48. | Logical Functions in Excel | 15m 23s |
| 49. | Text Functions in Excel | 18m 20s |
| 50. | Lookup and Reference Functions | 12m 2s |
| 51. | Vlookup and Hlookup functions in Excel | 17m 43s |
| 52. | Lookup and XLookup functions in Excel | 17m 4s |
| 53. | Math trig functions in excel | 16m 53s |
| 54. | Get data into excel from other sources | 9m 11s |
| 55. | Flash Fill in Excel | 4m 32s |
| 56. | Converting text to columns in Excel | 2m 46s |
| 57. | Removing duplicate values in Excel | 3m 12s |
| 58. | Data validation in excel | 5m 16s |
| 59. | Consolidation in excel | 7m 44s |
Course Content
MS Excel Fundamentals
-
MS Excel Basics
07:08 -
Starting Excel and Working Environment of Excel
13:43 -
Data Entry in Excel
35:36
Formatting Cell/Columns in Excel
Auto Sum-Fill-Sort-Filter-Find-Select-Paste Options in Excel
Pivot Table & Table Options in Excel
Illustrations – Pictures – ICONS – Smart Art – Add Ins Options in Excel
How to user different types of CHARTs in Excel
Links – Word Art – Header & Footer – Objects – Equations & Symbols in Excel
Themes – Page Setup – View – Formula Auditing – Define Names – Calculation Options in Excel
ALL Functions & Formulas in Excel
Get Data from Other source – Flash Fill – Convert text to Columns in Excel
Removing Duplicates – Data Validation – Consolidation in Excel
Student Ratings & Reviews
No Review Yet
Edusoft Learning Systems