Microsoft Excel Crash Course training centre in Bangladesh

New
Online Payment is Now Smarter, Easier, Safer

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

Muhammad Rabiul
  • 15 - 31 Dec 2019 (6 Sessions)

Design is a complex art that involves many different skills ...

IT
Rony Saha
  • 18 - 30 Dec 2019 (4 sessions)

This Power BI course is best suited for Business ...

IT
Price 6,000 Tk + VAT
Noman Siddikee
  • 18 - 30 Dec 2019 (4 Sessions)

SPSS Statistics is a GUI and syntax based statistical ...

IT
Price 12,000 Tk + VAT
Nusrat Jahan
  • 18 Dec 2019 - 20 Jan 2020 (10 sessions)

UX design is not just a fascinating field to get into, ...

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.