Advanced Excel course for freshers by BCIT WORLD

Overview of Basic Excel

 Introduction About Excel
 How to Start excel
 All Excel Short cut key
 Home Tab
 Insert Tab
 Page Layout
 Formula Tab
 Data Tab
 Review Tab
 View Tab

Customizing Excel Ribbon

 Excel Ribbon Customizing
 Create default list
 Add Excel User Form
 Change Excel Default Option

Formatting and Number System

 Advance Conditional Formatting
 Number System
 Paste Special
 Go to Special

Formula

 Logical Formula
 Text Formula
 Date & Time Formula
 Financial Formula
 Lookup Formula
 Function Formula

Logical Formula

 If
 And
 Or
 Nested If
 If Error
 Is text
 Is Number
 Is Blank

Text Formula

 Upper
 Lower
 Proper
 Left
 Right
 Mid
 Len
 Trim
 Code
 Char
 Replace
 Substitute
 Concatenate

Date & Time Formula
 Now
 Date
 Time

 Hours
 Minute

 Second
 Year
 Month
 Day
 Eomonth
 Today
 Day 360
 Network days
 Dated if
 Week Day

Lookup Formula
 V Lookup
 V Lookup + List
 V Lookup + Search Box
 V Lookup + Match
 V Lookup+ Match + Search Box
 V Lookup+ Match + Conditional Formatting
 Offset
 H Lookup

 Match
 Index
 Rows
 Columns
 Reverse Lookup
 Transpose

Financial Formula
 PMT

 IPMT
 PPMT
 Rate
 PV
 NPER

Function Formula

 SUM

 SUM IF
 SUM IFS
 SUM PRODUCT
 SUM SQ
 COUNT
 COUNT A
 COUNT IF
 COUNT IFS
 AVERAGE
 Max
 Min
 Large
 Small
 Choose
 Rank

CHART

 Create Basic Chart
 Create 2D & 3D Chart
 Pie Chart
 Line Chart
 Column Chart
 Bar Chart
 Area Chart
 Basic Dashboard Chart

Pivot Table
 Intro Pivot Table
 Create Simple Pivot Table
 Basic & Advance Value Setting
 Project
 Power Pivot Table

Dashboard

 Intro Dashboard
 Create Simple Dashboard
 Adding Table & Chart to Dashboard
 Project work
 Create Dynamic Dashboard

Macro
 Intro Macro
 Basic Recording Macro
 Relative Macro Option
 Absolute Option
 Project work
 Basic Macro Coding

VBA
 Intro VBA
 What can you do with VBA?
 Basic VBA Coding
 Recording VBA code
 What Is Variable
 Data Type
 Massage Box
 Button
 If Else Statement
 Looping
 Macro Error
 Basic Macro Coding
 VBA formula Apply
 Create User Form
 Project Base Work

Tips & Trick

 Excel Sheet Password Break
 Excel Workbook Password Break
 Online Excel Work
 VBA Amazing Code
 Short Cut key
 Data Validation
 Number System
 Amazing tips and Trick
 Project Work