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:

5 Weeks (20 Hrs)

Number of Classes:

10

Level:

Basic to Advanced

Language:

Bangla and English

Training Mode:

Online

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.

ONLINE COURSE MODULE

2 Hours 

  • Getting Familiar With MS Excel Interface & Its Common Options:
    • Application of Navigation Tools
    • 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
    • Normal, Page Layout, Page Break Preview
    • Create & Manage Custom View
  • Practice With Font Group:
    • Professional Font Size
    • How To Maintain Fill Color & Text Color
    • Increase & Decrease Indent
    • Customizing Border
  • Practice With Alignment Group::
    • Horizontal & Vertical Alignment
    • Text Control: Wrap Text, Shrink To Fit, Merge Cells
    • Text Orientation
 
 
 
 
 
 
 
 
 

2 Hours 

  • Necessary Functions & Formulas (Part 01):
    • Mathematical Function : Sum, Average, Min, Max, Variance
    • Text Function : Left, Right, Mid, Lower, Upper, Proper, Trim, Concatenate
  • Cell Joining Using Ampersand (&)
  • Viewing Data On Worksheet:
    • Showing – Hiding The Screen Objects
    • Freeze Top Row & First Column
    • Freeze & Unfreeze Pane While Scrolling
  • 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
  • Preparing Invoice

 
 
 
 
 
 
 
 
 
 

2 Hours 

  • Necessary Functions & Formulas (Part 02):
    • Logical Functions : If Condition (Excluding & Including Else), Nested If Formula
  • Entering Data In Cells & Sheets:
    • Relative Cell Reference
    • Absolute Cell Reference
    • Mixed / Partial Relative & Absolute Cell Reference
  • Paste Special Options
  • Advanced Use of “Find & Replace” OptionOptions
 
 
 
 
 
 
 
 
 
 

2 Hours 

  • Necessary Functions & Formulas (Part 03):
    • Lookup Functions: Vlookup, Hlookup, Match, Index Function,
    • Combination of Index & Match Function
  • 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
  • Professional Use of “Clear” Option Under Editing Group
 
 
 
 
 
 
 
 
 
 

2 Hours

  • Necessary Functions & Formulas (Part 04):
    • Date & Time Functions: Day, Month, Year, Now, Today, Weekday, Edate, Dated If, Days360, Networkdays
    • Logical, Financial & Statistical Function: And, Or, Not, IS, SumIf, CountIf, CountA, CountBlank
  • 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
 
 
 
 
 
 
 
 

2 Hours 

  • Interest Calculation (Based On Deposit): Normal Interest, Compound Interest

  • Necessary Functions & Formulas (Part 05):
    • Round Function, Roundup Function, Rounddown Function
  • 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
 
 
 
 
 
 
 
 
 
 
 
 

2 Hours 

  • Electricity Bill Calculation

  • 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 Unprotect The Sheet
 
 
 
 
 
 
 
 
 
 

2 Hours 

  • Data Visualization with Charts & Graphs:
    • Creating Recommended Charts
    • Moving & Resizing A Chart
    • Formatting And Editing Objects In A Chart
    • Changing A Charts Source Data
    • Working With Pie Charts, Bar Charts, Line Charts, Scatter Charts
    • Uses of 3 Types of Sparklines : Line, Column, Win & Loss
  • Create & Manage Pivottable & Pivotchart:
    • Intro of Pivottable
    • Changing Layout Of Pivottable
    • Managing Subtotal & Grand Total
    • Drill Down The Pivottable Value
    • Filtering The Pivottable Data
    • Creating Pivotchart
    • Use Slicers In Pivottable
    • Formatting A Pivotchart
 
 
 
 
 
 
 
 
 
 
 
 
 

2 Hours 

  • Basic Concept Of Macro & VBA

  • Problem Solving & Recap (Topics From 1st to 8th Class)

  • Various Excel Secrets & Shortcuts

  • Providing Instructions To Submit The Final Assignment / Project

 
 
 
 
 
 
 
 
 
 
 
 

2 Hours 

  • Bonus Class: How to Professionally Use the Common Tools & Options of Microsoft Word

 
 
 
 
 
 

OFFLINE COURSE MODULE

Training Schedule

ONLINE BASED

BATCH 1:-  (2 Days Class in a Week)

Friday –  (7.30 pm to 10.30 pm) &
Saturday – 
(9.00 pm to 11.00 pm) 

 

Batch 1 :- (2 Days Class in a Week)

Friday – (7.30 pm to 10.30 pm)  &
Saturday – (9.00 pm to 11.00 pm)    

 

FAQ

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

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