Professional Training on MS Excel

Training Contents (Very Basic to Advanced)

course detail

Trainer

Excel Trainer, Skill Development Cell

Course Duration:

5 Weeks

Total Hours:

20 Number of Classes:

10 Level:

Intermediate

Language:

Bangla and English

Training Mode:

Offline

Course Fee

৳ 0

৳ 2000

★ 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

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

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.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

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