Description
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 | 25 Videos | Total Duration: 11:17:5 |
| 1. | Introduction to Excel | 25m 30s |
| 2. | Data entry in ms excel | 24m 19s |
| 3. | Borders and Alignments in Excel and number formatting in Excel | 32m 27s |
| 4. | conditional formatting in Excel including tables and cell styles | 35m 18s |
| 5. | Formatting Editing and protecting sheets cells in Excel | 47m 9s |
| 6. | Statement preparation in Excel | 30m 9s |
| 7. | Tables and Pivot tables in Excel | 32m 19s |
| 8. | Types of charts column and bar charts in Excel | 40m 38s |
| 9. | Charts in excel line area pie donut | 37m 20s |
| 10. | Creating different types charts and maps in Excel | 56m 38s |
| 11. | Page Layout in MS Excel | 38m 12s |
| 12. | Formulas and Functions in Excel Financial statistical functions | 36m 43s |
| 13. | Math and Trig functions in Excel | 41m 27s |
| 14. | Text functions in Excel | 45m 19s |
| 15. | Date and Time Functions in Excel | 32m 12s |
| 16. | Logical Functions in Excel | 41m 55s |
| 17. | Lookup and Reference Functions | 12m 2s |
| 18. | Vlookup and Hlookup functions in Excel | 17m 43s |
| 19. | Lookup and XLookup functions in Excel | 17m 4s |
| 20. | Get data into excel from other sources | 9m 11s |
| 21. | Flash Fill in Excel | 4m 32s |
| 22. | Converting text to columns in Excel | 2m 46s |
| 23. | Removing duplicate values in Excel | 3m 12s |
| 24. | Data validation in excel | 5m 16s |
| 25. | Consolidation in excel | 7m 44s |
Edusoft Learning Systems
Reviews
There are no reviews yet.