Professional Training on MS Excel

Training Contents (Very Basic to Advanced)

course detail

Trainer

SAIKAT BISWANGRI
SAIKAT BISWANGRI
Read More
Excel Trainer - SDC;
CA (CC) & Certificate Level;
BBA, MBA in Accounting.

Course Duration:

10 Weeks (30 Hrs)

Number of Classes:

10

Level:

Basic to Advanced

Language:

Bangla and English

Training Mode:

Offline

Course Fee

0
0

The price for Skills Bangladesh

objectives

Get the most out of Microsoft Excel faster and easier than ever and be the Excel Expert of your work place. In this training, maximize your productivity with Microsoft Excel’s best tools and shortcuts; because this training has been designed for the students, newly recruited professionals, mostly regular excel users & keenly interested MS Excel learners who are want to improve and sharp or re-sharp their knowledge in this case. Participants will learn to excel features & functions from the very basic stage to the mostly advanced stage phase by phase with the 100% practical project work & real life example.

BENEFIT OF THIS COURSE

It is widely agreed that close to 70% of Excel users leave 80% of Excel untouched. That is, most users don’t tap into the full potential of Excels built-in utilities. In this course we will explore those uncovered area on such fine manner that attendees can readily imply them in their regular work just after attending the program.

Pre-Requirements

  • Participants should have minimum computer knowledge & its operating skills i.e. Opening & Shutting Down PC / Laptop, Starting & Closing MS Excel, Copy & Paste etc.).
  • Must be installed MS Excel 2010 / 2013 / 2016 / 2019 / Office 365 (Recommended : MS Excel 2013 or above). 
  • For offline / venue based training : Participants have to bring laptop.
  • For online training : Attendees should have internet connected PC or mobile.

OFFLINE COURSE MODULE

3 Hours 

  • Getting Familiar With MS Excel Interface & Its Common Options:
    • Customize Quick Access Toolbar
    • Discussion About Backstage View
    • Customize Ribbon
    • How To Add Developer Tab
    • Managing Worksheets: Hide, Unhide, Insert, Delete, Color
    • Sheet Move or Copy & Rename
    • Inserting & Hiding Columns & Rows
    • Adjusting Row Hight & Columns Width
    • Name Box & Formula Bar
    • Fill & Advanced Autofill
    • Create & Manage Hyperlink
    • Uses of Format Painter
    • Basic Calculation (Addition, Subtraction, Multiplication & Division)
    • Change Workbook View
    • Create & Manage Custom View
  • Practice With Font Group:
    • Professional Font Size
    • How To Maintain Fill Color & Text Color
    • Increase & Decrease Indent
    • Customizing Border
    • Strikethrough, Superscript & Subscript
  • Practice With Alignment Group:
    • Horizontal & Vertical Alignment
    • Text Control: Wrap Text, Shrink To Fit, Merge Cells
    • Text Orientation
  • Practice With Number Group:
    • Number Format
    • Comma Style And Increase & Decrease Decimal
    • Currency, Text, Date & Time
  • Preparing Invoice
 

3 Hours 

  • Discuss & Practice With Insert Tab
    • Insert & Edit Pictures
    • Insert Shapes
    • Insert SmartArt
    • Insert Text Box
    • Insert Equation & Symbol
    • Table & Chart (Basic Part)
  • Page Setup & Printing A Worksheet Smartly:
    • How To Print Large Worksheet Professionally
    • Managing Page Margins & Orientation : Top, Bottom, Left & Right
    • Managing Print Titles & Gridlines : Rows To Be Printed At Top On Each Page
    • Setting Page Number
    • Printing A Specific Area Of A Worksheet
    • Customizing Header & Footer
    • Managing Page Break
  • Necessary Functions & Formulas (Part 01):
    • Mathematical Function : Sum, Average, Min, Max, Variance
    • Text Function : Left, Right, Mid, Lower, Upper, Proper, Trim, Concatenate, Len, Value
  • Viewing Data On Worksheet:
    • Showing – Hiding The Screen Objects
    • Freeze Top Row & First Column
    • Freeze & Unfreeze Pane While Scrolling
  • Entering Data In Cells & Sheets:
    • Paste Specials Options
    • Go To Special Options
    • Relative Cell Reference
    • Absolute Cell Reference
    • Mixed / Partial Relative & Absolute Cell Reference
 
 

3 Hours 

  • Necessary Functions & Formulas (Part 02):
    • Logical Functions : If Condition (Excluding & Including Else), Nested If Formula

  • Formula Auditing & Show Formula
  • How To Prepare & Maintain A Salary Sheet
  • Data Sorting & Filtering:
    • Data Sorting With Single & Multiple Criteria Respectively
    • Sort By Month or Day Name
    • Data Sort By Color
    • Row & Column Wise Sort
    • Data Filtering : Single & Multiple Criteria
    • Data Filtering By Color
    • Customized Filtering : Text Values, Number Values
    • Clear Filtered Data By One Click
  • Conditional Formatting:
    • Single & Multiple Conditional Formatting
    • Highlighting Top Or Bottom Values
    • Highlighting Cells Rules
    • Data Bar Type Conditional Formatting with Gradient & Solid Fill
    • Color Scale Conditional Formatting
    • Icon Set Conditional Formatting
    • Customizing Icon Set
    • Clearing The Conditional Formatting
 
 

3 Hours 

  • Preparing Result Sheet Using If Condition

  • Necessary Functions & Formulas (Part 03):
    • Lookup Functions: VLOOKUP, Hloookup, Match, Index Function, Combination of Index & Match Function.
    • Date & Time Functions: Day, Month, Year, Now, Today, Weekday, Edate, Dated If, Days360, Network days.
    • Logical, Financial & Statistical Function: And, Or, Not, IS, Sum If, Count If, Count A, Count Blank, PMT Function.
 
 

3 Hours 

  • Data Validation:
    • Setting Data Validation In A Specific Area
    • Drop Down List For Easy Data Entry
    • Changing Data Validation
    • Finding Data Validation
    • Array & Sheet Referencing
  • Secure Worksheet & Workbook By Generating Password:
    • Protect Worksheet Structure
    • Protect Workbook
    • Restricting Editing In A Specific Sheet Area
    • Unprotect The Sheet With Correct Password
    • Removing Password To Unprotected The Sheet
  • Interest Calculation Based On Deposit: Normal Interest, Compound Interest
  • Labour Payment Bill & Overtime Calculation

  •  
 
 

3 Hours 

  • Electricity Bill Calculation

     

  • Necessary Functions & Formulas (Part 04):
    • Round Function, Roundup Function, Rounddown Function, Goal Seek Command
  • Create & Manage Table:
    • Create An Excel Table From A Cell Range
    • Add Column & Rows In The Table
    • Customize Table Style Options
    • Controlling Table Using Slicer
    • Sorting & Filtering Table Data
    • Convert A Table To A Normal Range

3 Hours 

  • Data Visualization – Creating & Working With Charts:
    • Creating Recommended Charts
    • Moving & Resizing A Chart
    • Formatting And Editing Objects In A Chart
    • Changing A Charts Source Data
    • Changing A Chart Type
    • Working With Pie Charts, Bar Charts, Line Charts, Scatter Charts
    • Uses Of 3 Types Of Sparklines: Line, Column, Win & Loss
  • Create & Manage Pivottable & Pivotchart (Part 01):
    • Intro of Pivottable
    • Creating Pivottable With One Row & Column
    • Creating Pivottable Report With Multiple Groups
    • Changing Layout Pivottable
    • Text Orientation

3 Hours 

  • Create & Manage Pivottable & Pivotchart (Part 02):
    • Managing Subtotal & Grand Total
    • Changing The Data Field Summary Operation
    • Drill Down The Pivottable Value
    • Filtering The Pivottable Data
    • Creating Pivotchart
    • Use Slicers In Pivottable
    • Formatting A Pivotchart
    • Printing A Pivottable
    • Printing A Pivotchart
  • How To Prepare & Maintain A Professional Petty Cashbook In Excel Sheet

  • Concept Of Macro

3 Hours 

  • Concept Of VBA
  • Practice With Practical Business Case Study
  • Various Excel Secrets & Shortcuts
  • Problem Solving & Recap
    (Topics From 1st to 8th Class)

3 Hours 

  • Practical Exam

ONLINE COURSE MODULE

Training Schedule

OFFLINE / VENUE BASED

BATCH 1:- 

Friday : 9.00 am to 12.00 pm

Batch 1 :  Friday : 9.00 am to 12.00 pm

FAQ

4th Floor, Gausia Market, Beside Dewanhat Fire Service, Agrabad, Chattogram.

Hello, Welcome to Skill Development Cell. First, you need to click the Apply Now Button of this Course Page and you get an online Registration Form and you need to fill up this form with all information carefully. After Registration for book your seat, you can Payment Via Bkash for this course. Our Bkash No is +880 0000 000000

After Payment simply you send us a SMS to +880 0000 000000 with details Your Name,  Transit Mobile number which from you send money , and Transaction ID.

After your SMS You will get an welcome and confermation SMS/CALL From Us.

Thank You.

students say...

দাদা এতটা দরদ দিয়ে না শিখালে হয়তো ms_excel এর কাজ শিখতাম তবে এতটা বিশ্লেষিত ভাবে শিখতে পারতাম না। Skill Development Cell এর অধীনে excel এর ২ টি ক্লাস শেষ হয়েছে। তিনি যেভাবে প্রতিটি বিষয় হাতে কলমে বারবার শিখিয়ে দিচ্ছেন তাতে excel এর যে কোনো সমস্যা সমাধানের আগ্রহ জাগে মনে অথচ ২ সপ্তাহ আগে ও ভাবতাম এটা হবেনা হয়তো,পারবোনা মনে হয়। ডিইসি প্রেসিডেন্ট সৈকত দাদার কাছে অশেষ কৃতজ্ঞতা।
Bashundhara Abhi
Hubei University of Technology
Topic: Ms Excel Course.
প্রথমত ধন্যবাদ জানায় আামাদের প্রেসিডেন্ট স্যার কে, যিনি এতো ব্যস্ততার মধ্যেও সময় বের করে আমাদের জন্য কোর্স টি পরিচালনা করে যাচ্ছেন। MS Excel course টা যে কতটা গুরুত্বপূর্ণ তা যারা ক্লাস করছেন তারা উপলব্ধি করতে পেরেছেন। এই কোর্স সম্পর্কে অামার নিজের কোন ধারণা নেই বললেই চলে। তবে দুইটা ক্লাস সম্পন্ন করে অনেক কিছু বুঝতে পারলাম। কিভাবে ফাংশন ব্যবহার করে এবং কম সময়ে কোন প্রবলেম সমাধান করতে হয়। কিভাবে কোন ডকুমেন্ট খুব সহজে তৈরি করা যায় ইত্যাদি।Skill Development Cell এর অধীনে সল্প মূল্যে এতো গুরুত্বপূর্ণ কোর্স করার সুযোগ করে দেওয়ায় ধন্যবাদ জানায় ডিইসির সকলকে।
Hossain Shuvo
Port City International University

For More Information

+880 1810-067069

For More Information

+880 1810-067069