Excel easy program

Part 1: Excel Environment

• Lesson 1: Introduction to all Ribbons/Menu bars
• Lesson 2: Customising Quick Access Toolbar
• Lesson 3: Introduction to all Icons
• Lesson 4: Keyboard Shortcuts
• Lesson 5: Introduction to Status bar
• Lesson 6: Zoom Slider and Page Layout
• Lesson 7: Accessing Recent Documents
• Lesson 8: Save as PDF , CSV, Webpage, etc.
• Lesson 9: Introduction to Excel Options
• Lesson 10: Working with Templates.

Part 2: Excel New Features

• Lesson 11: Protecting the Excel sheet, Cell, Rows or Columns
• Lesson 12: Cell Styles and Document Themes.
• Lesson 13: Data formatting
• Lesson 14: Sort and Filter data by Color
• Lesson 15: Highlighting and removing duplicates
• Lesson 16: Inserting Picture
• Lesson 17: Introduction to WordArt , Smart Arts and Charts
• Lesson 18: Other New Features

Part 3: Formulas for beginners

• Lesson 19:  Number - Sum, Average, Count, etc.
• Lesson 20: Text- Trim, Concatenate, Proper, Lower, Upper, etc.
• Lesson 21: Dates and  time
• Lesson 22: Cell referencing
• Lesson 23: Rapid Formula Copy
• Lesson 24: Converting Formulas to Values
• Lesson 25: Breaking Text
• Lesson 26: Auto Function builder
• Lesson 27: Trace Precedents and Dependents

Part 4: Excel Customizations

• Lesson 28: Tips and Tricks of data entry
• Lesson 29: Customize excel tools
• Lesson 30: Copy Worksheets
• Lesson 31: Split Worksheets
• Lesson 32: Arranging Windows

Part 5: Sorting & Filtering Data

• Lesson 33: Preparing Data sheets
• Lesson 34: Sorting
• Lesson 35: Multiple sorting methods
• Lesson 36: Working with Filters
• Lesson 37: Advance filter tips

Part 6: Pivot Tables

• Lesson 38: Creating a Pivot Table
• Lesson 39: Changing a Pivot Table
• Lesson 40: Pivot Calculations
• Lesson 41: Pivot Formatting
• Lesson 42: New Filtering Options
• Lesson 43: Advance tips for Pivot tables

Part 7: Advance Formulas

• Lesson 44: AutoSum Tricks
• Lesson 45: Formula Auditing
• Lesson 46: IF Formulas for conditions
• Lesson 47: LOOKUP, VLOOKUP, HLOOKUP
• Lesson 48: IFERROR
• Lesson 49: SUNIF, SUMIFS
• Lesson 50: Super Formulas

Part 9: Macros

• Lesson 51: Recording a Macro
• Lesson 52: Recording Navigation
• Lesson 53: How Many Rows
• Lesson 54: Event Macros
• Lesson 55: Advance Macros Building tips