Date: 18 & 19 Feb 2022
Time: 8:00 PM - 10:00 PM
Total Hours: 4 Class Schedule: Friday & Saturday Registration Deadline: 19 February 2022
No. of Classes/Sessions: Total 2 classes Venue: Online (Live Class on Zoom)
After completion of the training, participants will be able to do basic calculations and report as per business requirements. Those who are already in the job market/involved in business will be able to make a business report on their own. The training will make the attendees confident in MS Excel before entering the job market.
Session 01
1. Getting Started with Microsoft Office Excel 2016
2. Modifying a Worksheet
3. Performing Calculations
i) IF
ii) SUM
iii) COUNT
iv) COUNTA
v) VLookup
Session 02
1. Performing Calculations: Functions
IFERROR
SUMIF
COUNTIF
HLookup
Text Formula (Trim, Left, Right, CONCATENATE, LEN, etc.)
2. Performing Calculations
Combination of Formulas and Functions
3. Formatting a Worksheet
Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply Basic Conditional Formatting
Md. Rashedul Islam is working as a BI Analyst at DARAZ Bangladesh Ltd. Previously, he worked at Sheba Platform Ltd., Shohoz Ltd., Kazi...
Mentor Details
Excel
Total 2 Sessions
29 & 30 Dec 2023BDT 599
Enrol
Content
Total 2 Sessions
10 & 11 Nov 2023BDT 1000
Enrol
MS Excel
Total 1 Session
15 Nov 2023BDT 399
Enrol
MS Excel
Total 1 Session
18 Nov 2023BDT 600
Enrol
MS Excel
Total 4 classes
30 Dec 2021 & 01, 02, 04 Jan 2022BDT 600
Enrol
