Lessons
Share Exit Fullscreen Back to course
BYLC Development Sector Career Bootcamp 2023: Part 2
  • Excel: Part 1
    • Introduction
    • Navigating the Excel user interface
  • 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 Max
    • Statistical Function Count
    • Excel for Professionals: Practice
  • Excel: Part 2
    • Introduction
  • Logical Function
    • IF function
    • Nested IF
    • AND Function
    • OR function
    • COUNTIF & COUNTIFS function
    • SUMIF & SUMIFS function
    • IFERROR function
  • Data Finding Function
    • VLOOKUP
    • HLOOKUP
    • Index - Match
  • MS Excel Advance
    • Pivot Table
    • Slicer
    • Data Analysis tool pack
    • Goal Seek
    • Solver
    • Power Query
    • Error Handle
  • Data Visualization
    • Pie Chart
    • Bar Chart, Column Chart and Histogram
    • Combo Chart , Pivot Chart
    • Tree map
  • Dashboard
    • Dash Board
  • Keyboard Shortcuts
    • Keyboard Shortcuts
  • Resource Files
    • Resources
    • BYLC Development Sector Career Bootcamp 2023: Part 2