CERTIFIED MASTER COURSE ON MICROSOFT EXCEL

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.

The Excel Screen

• Quick Access Toolbar
• Tabs
• Ribbion
• Name Box
• Formula Bar
• Rows, Columns, Cells
• Sheets
• Zoom
• Word book VS Word Sheet
• Cell VS Range
• Simple Data Entry
• Selecting Ranges
• Saving workbook formats
• Find & Replace

Text to Columns

• Separator is Space
• Separator is &
• Separator is @

Viewing Worksheets

• Hiding/ Unhiding Columns/Rows
• Freezing Panes
• Splitting windows

Custom Views

• Creating Custom Views
• Displaying Custom Views
• Deleting Custom Views

Basic Formula -2

• Sum
• Average
• Max
• Min
• Sumif
• Sumif
• Countif
• Chart Management
• Data Sorting
• Conditional Formatting

VLOOKUP & H-LOOKUP

• VLOOKUP with Exact Match
• VLOOKUP Approximate Match
• VLOOKUP Rules
• VLOOKUP with Trim
• H-Lookup

Formatting in Excel

• Font
• Alignment
• Number

Reference

• Relative Reference
• Absolute Reference
• Mixed Reference

Text formatting

• Left
• Right
• Mid
• Concatenate
• TRIM
• PROPER
• UPPER
• LOWER
• LEN

Copying and Pasting

• Copy
• Paste
• Paste Special
• Copying Cell(s) to One / Many Cells
• Copying to different Worksheets
• Using fill for quick copying

Basic Formula

• Add/Subtract/Multiphy/Divide
• BODMAS
• Count Formula
• Counta Formula
• Countblank
• Countif

Logical Test

• If Functions
• Nested IF

Filter & Table

• Advanced Filters
• Advanced Table
• Pivot Table

Course duration

Course Fee- 2,500/- 
Course Details 

Each Batch: 10 Participants
Course Duration- 5 Weeks

Our clients say

"A really excellent course in giving a rapid and in-depth introduction to MS excel. Good speed, materials & instructor. Most of all making it relevant to real work situations. Highly recommended."
Sabiha Sultana
"I'm so greatful to Manik Bhaia for arranging the crash course of MS Excel.The way he taught us and cleared my confusions regarding excel,it helped me a lot."
Farjana Sormila
"This institute provides advanced training sessions which are genuinely comprehensive in a congenial environment. At an astonishingly reduced cost, all corporate hopefuls and professionals can garner extensive knowledge and first-hand training on all possible situations in the workplace. The trainees are provided with additional care for their individual shortcomings. It really is the best possible solution for all of us job-seekers in Bangladesh."
Shaon Sarkar