MS EXCEL TRAINING MODULE OFFLINE - SKILL DEVELOPMENT CELL

Professional Training on MS Excel

Training Contents (Very Basic to Advanced)

course detail

Trainer

Excel Trainer - SDC;
CA (CC) & Professional 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

★ 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

DAY 1

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

DAY 2

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

DAY 3

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

DAY 4

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.

DAY 5

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

DAY 6

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

DAY 7

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

DAY 8

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

DAY 9

3 Hours

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

DAY 10

3 Hours

Practical Exam

ONLINE COURSE MODULE

Training Schedule

OFFLINE / VENUE BASED

BATCH 1:-

Friday : 9.00 am to 12.00 pm

OFFLINE / VENUE BASED

FAQ

Where Is the location ?

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

How Can i Booked & payment for this course ?

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.

How Can i Confirmed/verify My transaction ?

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 এর অধীনে সল্প মূল্যে এতো গুরুত্বপূর্ণ কোর্স করার সুযোগ করে দেওয়ায় ধন্যবাদ জানায় ডিইসির সকলকে।