Introduction

Navigating the Excel user interface

Understanding worksheet Insert, Rename, Delete, Move & Copy

Understanding Rows and Columns

Row and Column operation Insert & Delete

Text entry and customization

Formatting Cells

Fill Handle

Different types of paste option

Data validation

Cell referencing

Text functions for data cleaning

Find and Replace

Sort and filter

Table Creation

Remove Duplicates and remove blanks

Arithmetic Operation

Sum and Average

Min Max

Statistical Function Count

Excel for Professionals: Practice

Introduction

IF function

Nested IF

AND Function

OR function

COUNTIF & COUNTIFS function

SUMIF & SUMIFS function

IFERROR function

VLOOKUP

HLOOKUP

Index - Match

Pivot Table

Slicer

Data Analysis tool pack

Goal Seek

Solver

Power Query

Error Handle

Pie Chart

Bar Chart, Column Chart and Histogram

Combo Chart , Pivot Chart

Tree map

Dash Board

Keyboard Shortcuts

Resources

BYLC Development Sector Career Bootcamp 2023: Part 2