Microsoft Excel has proven to be one of the most important applications for businesses around the world. Yet most of its powerful features are underutilized. Boost your productivity with an Excel 2016 training course and learn to utilize them to the full. Their curriculum starts at an introductory level and moves to an advanced level.
Contents of Training:
Segment -1 [Basic]
1. Why Excel is important
2. What you can do with excel .
3. Basic orientation of MS excel
4. Basic Calculations
5.Paste Special
6.Fill and Auto Fill
7.Shor & Filter
8.Conditional Formatting
9.MIN/MAX/LEFT/RIGHT/Average
10.Text to Columns
Segment -2 [Intermediary Level ]
11.Convert text to your preferred case
12.Join multiple cell values
13.When Excel cannot read dates
14.Count/Count/RANK
15.DATA Validations
16.Creating table
17.Conditional formats
18.Cell lock ($)
SEGMENT -3 [ Advance Level ]
19. LOOKUP [ VLOOPUP,HLOOPUP,INDEX]
20. Logical functions [ IF,IF_OR,IF_AND,SUMIFS,COUNTIFS ]
21. Advance PIVOT
22. Report Automations
23. Dynamic dashboard
24. Macro
25.Case analysis
26. Tips and tricks
Location:
BangladeshBenefits
- Certificate
- Expert Trainer
- Gift ITEM- T-Shirt
- Refreshment: (Lunch+ 2 times Tea Break)
Eligibilities
Open for all.
Eligible Regions: BangladeshApplication Process
Apply online through the given link
Application Deadline: January 2, 2019
Application ClosedOfficial link
