Beginners to Intermediate on MS Excel


The most widely used spreadsheet application in the world, Excel is a key part of the Microsoft Office suite of applications. You can use Excel for anything from a small spreadsheet of household finances to monster databases of all your company™s products, customers, and sales. You can use Excel either on its own or together with the other Office applications. This course will guide you to touch almost all the powerful tools of Excels.

How participants will benefit after the course:
It is widely agreed that close to 50% 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.


This will be an instructor led program delivered through hands on labs with real life example. Audience will taste a new level of experience by attending the course.

Contents of Training:

1. Advanced Subtotals
2. Formatting the Subtotal Rows
3. Adding and Copying with Subtotals
4. Consolidating Data
5. Introducing the SUMIF Command
6. Working with the SUMIF Command
8. Looking at AutoSum Tricks
9. Utilizing Fill Handle Tricks

1. Creating a Pivot Table
2. Rearranging Fields in a Pivot Table
3. Explaining the Report Layout Options
4. Using the Report Filters Feature
5. Using Top 10 & Date Filters
6. Handling Blank Cells
7. Drilling Down in the Pivot Table
8. Sorting a Pivot Table
9. Formatting a Pivot Table
10. Creating Custom Formats
11. Explaining the Grouping Options
12. Adding Formulas to a Pivot Table
13. Changing a Calculation in a Pivot Table
14. Replicating a Pivot Table
15. Counting with a Pivot Table
16. Using Pivot Charts

1. Charts Refresher
2. Moving, Sizing & Copying Charts
3. Formatting Charts
4. Formatting a Series
5. Exploring the Home & Format Ribbons
6. Deciding What Chart Format to Use
7. Show a Time Series with Column or Line Charts
8. Using Combination Charts
9. Using Line Chart Accessories
10. Using Bar Charts to Show Comparisons
11. Using Component Charts
12. Using Correlation Charts
13. Exploring Other Charts
14. Chart Lies Revealed & Advanced Chart Types
15. Creating a Custom Layout

1. Using Conditional Formatting
2. Using Advanced Conditional Formatting
3. Highlighting, Sorting & Filtering Columns
4. Using SmartArt Functions
5. Using Different SmartArt Graphics
6. Embedding a Formula into a Shape

1. Using Goal Seek to Find an Answer
2. Auditing Formulas
3. Shrinking the Formula Bar
4. Understanding Errors
5. Joining Text Columns
6. Using Custom Formatting Codes
7. Pasting Values
8. Using Paste Special
9. Breaking Apart Text
10. Converting Text to Numbers
11. Using Date Functions
12. Using Bizarre Date Functions
13. Using Exponents
14. Using the VLOOKUP Function
15. Using Index Match
16. Using the Offset Function
17. Using the Convert Function
18. Looking at Interesting but Obscure Functions
19. Using the Rand Function
20. Working with Regression
21. Ranking & Sorting Formulas

1. Displaying the Developer Tab
2. Recording a Simple Macro
3. Simplifying the Macro
4. Recording Using Relative References

Final Touch and Tips and Tricks
1. Showing Off New Tips in Excel 2007
2. Tips for Handling Worksheets
3. Using Excel as a Word Processor
4. Miscellaneous Tips
5. Validating Data
6. Changing Text Entry Direction
8. Freeze Pane
9. Split Windows
10.Protecting Cells and Work Books
11. Password protecting a file
12. Showing list from a drop down
13. Random Tips for Preparing Dashboard

Related Courses

Muhammad Arif-ur-Rahman
  • 24 - 25 Feb 2017 (2 Days Long)

Advanced Microsoft Excel 2007 & 2010 course to develop ...

Price 3,000 Tk + VAT
Moshiur Rahman
  • Saturday, February 25, 2017

Advertising on Facebook is easy for you and your customers. ...

Moshiur Rahman
  • 26 Feb - 6 Apr 2017

This course will help you to know how to promote your ...

Samiul Huq
  • 28 Feb - 9 Mar 2017

This course will walk you through the world of business ...



9140345, 9117179 Ltd.

19 th floor (East), BDBL Building (Old BSRS)
12 Karwan Bazaar
Dhaka - 1215

This course is very useful for anyone who works in Excel. The target audiences are the Managers, Executives, Teachers, Developers, Students, and Researchers.