MS Excel Mastery Course training centre in Bangladesh

New

MS Excel Mastery Course

Introduction

By the completion of this computer based Excel training for Microsoft Excel, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer.With the ability to handle advanced tasks in Excel, you`ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process.

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:

- Quick Access Toolbar
- Backstage view
- Merge Cell
- Wrap Text
- Text Alignment
- Format Painter
- Hide Gridlines
- Freeze Panes
- View Multiple Workbooks
- View Multiple Worksheets

2. Find & Select:

- Find
- Replace
- Find and replace tricks to avoid formulas easy way.

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
- Advance shorting

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
- Report filter
- Calculated field
- Pivot Chart
- Use of Data bar in line chart
- Trend line Use

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
- Flash fill to avoid text and string

14. Lookup Functions:

- VLOOKUP
- HLOOKUP
- VLOOKUP utilization

16. Logical Functions:

- IF Function
- AND Function
- OR Function
- Nested If
- Set print area and center

17. Data Analysis:

- Goal Seek
- Data Consolidate

Record Macro and its troubleshooting ALT and other shortcut keys.
This is an exclusive for them who have experience working with Microsoft Excel and would like to learn more about creating dynamic reports and dashboards.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.