Introduction | BYLCx
  • Navigation and Basics
    • Understanding worksheet (Insert, Rename, Delete, Move & Copy)
    • Understanding Rows and Columns
    • Row and Column operation (Insert & Delete)
  • Data Entry
    • Text entry and customization
    • Formatting Cells
    • Fill Handle
    • Different types of paste option
    • Data validation
    • Cell referencing
  • Data Cleaning
    • Text functions for data cleaning
    • Find and Replace
    • Sort and Filter
    • Table creation
    • Remove duplicates and remove blanks
  • Basic Data Analysis
    • Arithmetic operation
    • Sum and Average
    • Min and Max
    • Count function
    • Excel for Professionals: Practice File
      • Excel for Professionals: Practice file
    • Assessment and Certificate