Rating 4.35 out of 5 (26 ratings in Udemy)

• Excel Fundamentals
• Formats, Fonts and Design
• Worksheet Properties
• Data Management in Excel
• Data Sort
• Data Sort From Left to Right
• Data Filter
• Table
• Remove Dublicates
• Custom List
• Subtotal and Data Groups
• Pivot Table
• Pivot Table Properties and Options
• User Defined Formulas in Pivot Table
• Merge Pivot Tables
• Excel Formulas
• Structure of Excel Formulas
• Text Formulas
• Flash Fill
• Statistical Formulas
• Date and Time Formulas
• SUBTOTAL Function For Filter
• Lookup Functions
• VLOOKUP For 2 Tables
• Advanced Filter Functions
• FORMULAS Menu
• Advanced Excel
• Data Validation
• Conditional Formatting
• Special Cells (GOTO SPECIAL)
• External Data From Other Sources
• Name Manager
• Consolidation
• Watch Window and Trace Cells
• Excel Protection
• Printer Settings
• Relation of PDF and Printer
• Graphics and Charts in Excel
• Simple Graphs
• Column Graphs
• Pie Chart Graphs
• Picture Graphs
• Graphics into the Cells
• Linear Modelling in Excel
• Goal Seek
• What-if Analysis / Data Table
• Excel Solver
• Senario Analysis
• Useful Tips
• Copy - Paste Options
• F4 Key
• Fix Headers
• VIEW Menu
• ComboBox
• Trendline
• Spin Button
• Animated Charts
• Scroll Bar
• Draw Shapes
• Fix Formulas (Details of F4 Key)
• Creating Custom Menu
• Watch Movie and Listen Music in Excel