BYLC Development Sector Career Bootcamp 2023: Part 2

Course Unavailable

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