Microsoft Excel Crash Course training centre in Bangladesh

New
EMI EASY PAY

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

Md. Rabiul Islam
  • 25 Jul - 25 Aug 2019

This Data Science course will cover the whole data life ...

IT
Course at Chattogram
Price 5,000 Tk + VAT
Fakharul Abedin (MCSA
  • 26 - 27 Jul 2019 (2 Days Long)

Hands on Training with Practical using of different tools ...

IT
Ashim Kumar Sikder
  • 27 Jul - 10 Aug 2019

Apex technology focus on developed single application that ...

IT
A. S. M. Shamim Reza
  • 30 Jul - 8 Oct 2019

This training will have Case Study, Hands-on LAB ...

IT
This is an exclusive training for them who have experience working with Microsoft Excel and would like to learn more about this.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.