breakpoint.
BYLCx

BYLC Development Sector Career Bootcamp 2023: Part 2

  • Bangla
  • Recorded
Lessons
47
Language
Bangla
Format
Recorded

Fee history

Listed here since 23 Oct 2026; the fee has not changed in that time.

Course outline

13 modules

Excel: Part 12 topics
  1. 1Introduction
  2. 2Navigating the Excel user interface
Navigation and Basics3 topics
  1. 1Understanding worksheet Insert, Rename, Delete, Move & Copy
  2. 2Understanding Rows and Columns
  3. 3Row and Column operation Insert & Delete
Data Entry6 topics
  1. 1Text entry and customization
  2. 2Formatting Cells
  3. 3Fill Handle
  4. 4Different types of paste option
  5. 5Data validation
  6. 6Cell referencing
Data Cleaning5 topics
  1. 1Text functions for data cleaning
  2. 2Find and Replace
  3. 3Sort and filter
  4. 4Table Creation
  5. 5Remove Duplicates and remove blanks
Basic Data Analysis5 topics
  1. 1Arithmetic Operation
  2. 2Sum and Average
  3. 3Min Max
  4. 4Statistical Function Count
  5. 5Excel for Professionals: Practice
Excel: Part 21 topics
  1. 1Introduction
Logical Function7 topics
  1. 1IF function
  2. 2Nested IF
  3. 3AND Function
  4. 4OR function
  5. 5COUNTIF & COUNTIFS function
  6. 6SUMIF & SUMIFS function
  7. 7IFERROR function
Data Finding Function3 topics
  1. 1VLOOKUP
  2. 2HLOOKUP
  3. 3Index - Match
MS Excel Advance7 topics
  1. 1Pivot Table
  2. 2Slicer
  3. 3Data Analysis tool pack
  4. 4Goal Seek
  5. 5Solver
  6. 6Power Query
  7. 7Error Handle
Data Visualization4 topics
  1. 1Pie Chart
  2. 2Bar Chart, Column Chart and Histogram
  3. 3Combo Chart , Pivot Chart
  4. 4Tree map
Dashboard1 topics
  1. 1Dash Board
Keyboard Shortcuts1 topics
  1. 1Keyboard Shortcuts
Resource Files2 topics
  1. 1Resources
  2. 2BYLC Development Sector Career Bootcamp 2023: Part 2

Details in this part come from BYLCx's course page.