Excel for Business Life, From Beginning to Advanced

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

This course is ideal for anyone who wants to learn Excel. The course is designed with an understandable and easy in English. The main goal of the course is to teach all the requirements you need in business life and to use Excel in the most efficient manner.

All videos here have examples and Excel files, and all of them are examples of real business life.

Expected Outcomes

  1. Excel Fundamentals
  2. Formats, Fonts and Design
  3. Worksheet Properties
  4. Data Management in Excel
  5. Data Sort
  6. Data Sort From Left to Right
  7. Data Filter
  8. Table
  9. Remove Dublicates
  10. Custom List
  11. Subtotal and Data Groups
  12. Pivot Table
  13. Pivot Table Properties and Options
  14. User Defined Formulas in Pivot Table
  15. Merge Pivot Tables
  16. Excel Formulas
  17. Structure of Excel Formulas
  18. Text Formulas
  19. Flash Fill
  20. Statistical Formulas
  21. Date and Time Formulas
  22. SUBTOTAL Function For Filter
  23. Lookup Functions
  24. VLOOKUP For 2 Tables
  25. Advanced Filter Functions
  26. FORMULAS Menu
  27. Advanced Excel
  28. Data Validation
  29. Conditional Formatting
  30. Special Cells (GOTO SPECIAL)
  31. External Data From Other Sources
  32. Name Manager
  33. Consolidation
  34. Watch Window and Trace Cells
  35. Excel Protection
  36. Printer Settings
  37. Relation of PDF and Printer
  38. Graphics and Charts in Excel
  39. Simple Graphs
  40. Column Graphs
  41. Pie Chart Graphs
  42. Picture Graphs
  43. Graphics into the Cells
  44. Linear Modelling in Excel
  45. Goal Seek
  46. What-if Analysis / Data Table
  47. Excel Solver
  48. Senario Analysis
  49. Useful Tips
  50. Copy - Paste Options
  51. F4 Key
  52. Fix Headers
  53. VIEW Menu
  54. ComboBox
  55. Trendline
  56. Spin Button
  57. Animated Charts
  58. Scroll Bar
  59. Draw Shapes
  60. Fix Formulas (Details of F4 Key)
  61. Creating Custom Menu
  62. Watch Movie and Listen Music in Excel