Microsoft Excel Crash Course training centre in Bangladesh

Forgot password?
Sign in with
New
Caution

Microsoft Excel Crash Course

Introduction

Microsoft Excel is most widely used productivity tool in today`s corporate world. Day to day corporate analysis, reporting tools and applications are prepared with Excel. Corporate industry requires highest level of Microsoft Excel proficiency. To managing and analyzing a group of related data easier, we can turn a range of cells into an Excel Table. And a Pivot Table gathers all the data in an Excel spreadsheet and presents a summary of this data in a table. Charts and graphs are used to make information clearer and easier to understand. And Dashboard reports allow managers to get high-level overview of the business and help them make quick decisions. It will be an advantage for course attendees to learn practical and advanced usages of this mostly renowned Excel tools for their daily task in multiple ways.

Methodology

Practical examples, exercises & case studies with Q&A discussion sessions. The course is designed for practical Excel applications at participants“ works rather than theoretical notes. Presentation slides will be provided after course usage. Participants will go through with relevant examples that they can relate to their daily office works.

Contents of Training:

1. Some Basic Tools:

New Line in a Cell
Quick Access Toolbar
Merge Cell
Wrap Text
Text Alignment
Format Painter
Hide Gridlines
Freeze Panes
Spelling Check
View Multiple Workbooks
View Multiple Worksheets

2. Find & Select:

Find
Replace
Copy Visible Cells Only

3. Paste Special:

Skip Blanks
Transpose
Add or Subtract

4. Page Setup:

Header & Footer
Page Number
Date & Time

5. Format Cell:

Numbers to Text
Leading Zeros
Add Text

6. Cell References:

Hyperlink
Linking Data

7. Print:

Print Multiple Copies
Center on Page
Repeat Specific Row

8. Sort:

One Column
Multiple Columns
Sort by Color

9. Data Filter:

Filtering
Number and Text Filters
Date Filters
Advanced Filter
Remove Duplicates
Subtotal

10. Conditional Formatting:

Highlight Cells Rules
Top/Bottom Rules
Find Duplicates

11. Pivot Table & Chart:

Pivot Table
Pivot Chart

12. Count and Sum Functions:

Count
Countif
Countifs
Sum
Sumif
Sumifs
Count Blank/Nonblank Cells

13. Text Functions:

Join Strings
Partial Strings
Text to Columns
Lower/Upper Case

14. Lookup Functions:

VLookup
HLookup

15. Round Functions:

Round
Round Up
Round Down
MRound
Even & Odd

16. Logical Functions:

IF Function
AND Function
OR Function

17. Data Analysis:

Goal Seek
Data Consolidate

18. Mail Merge:

Why Mail Merge
Mail Merge Process
Final Mail Merge

Related Courses

Price 3,000 Tk + VAT
Syed Saniat Ahmmad
  • 20 Jul - 1 Aug 2022

Practical examples, exercises & case studies with ...

IT
Online Training Register Wishlist
Price 4,500 Tk + VAT
Md. Feroz Kibria
  • 22 - 23 Jul 2022 (2 Sessions)

Having good spreadsheet skills gives you the ability to ...

IT
Offline Training Register Wishlist
Price 3,000 Tk + VAT
Sonny DCosta
  • 28 Jul - 9 Aug 2022

This is a hands-on course for anyone who wishes to ...

IT
Online Training Register Wishlist
Price 4,500 Tk + VAT
Md. Feroz Kibria
  • 5 - 6 Aug 2022 (2 Days)

Day to day HR and Admin data analysis, reporting, tools and ...

IT
Offline Training Register Wishlist

Who can Attend

This is an exclusive training for them who have experience working with Microsoft Excel and would like to learn more about this.

Boarding

Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.

Related Jobs 277




Bdjobs eLearning, a division of Bdjobs.com Limited, started its operation in 2005. Currently it is the largest professional training house in the country that runs training ........ more

Get Email Alert

We'll email you updates on job trends, new courses, study tips and more.

About Bdjobs eLearning

Courses by Industry

Courses by Functional Area

Courses by Type

social link fb social link fb social link fb