Get 10% discount

MS Excel 2010: From Novice to Professional


Get the most out of Microsoft Excel faster and easier than ever andbe the Excel Guru of your work place. In this Course, maximize your productivity with Microsoft Excel’sbest tools and shortcuts. The course simplifies powerful features including PivotTables, PowerPivot, Sparklines, Goal Seek, Conditional Formatting, Report Automation, Subtotals, Tips and Tricks and many more! Get more things done faster with customized workbooks, the Quick Access Toolbar, and keyboard shortcuts…control and analyze data more effectively…communicate more visually with new charting tools and SmartArt…and plenty more!

The course is separated in three Difficulties level- Beginner, Intermediate and Advance. As the course progresses you will be introduces with Powerful Techniques that will take you from Novice to Professional.

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:

Part 1 Beginners Excel

Session 1
Handling Text with Formulas and Built in Tools

• Drag the Fill Handle
• Create Your Own Series
• Joining Text
• Rapid Formula Copy
• Convert to Proper Case
• Formulas to Values
• Breaking Apart Text
• Parsing Fixed Width

Tips of the Session 1

• Navigate Fast through Range workbooks and Worksheets
• Removing Duplicates
• Number Format Shortcut

Session 2
Sorting & Filtering

• Data Preparation
• Sorting by Color

Formulas Begins

• AutoSum Tricks
• Relative Versus Absolute Formulas
• Tables and Table Formulas
• Goal Seek

Tips of the Session 2

• Shrink Text
• Transposing Tricks
• Hide Data
• Important Sheet

Part 2 Intermediate Excel

Session 3

Advance Formulas

• IF Formulas
• Sumifs
• Date and Time

Tips of the Session 3

• Data Validation
• Fill up in the sideways
• Switch Column Trick
• Fill Blank Trick

Session 4

Charting and SmartArt

• Creating and Formatting a Chart
• Adding or Removing Chart Data
• Charting Differing Orders of Magnitude
• Pie Chart Tricks
• Sparklines
• Creating SmartArt

Visual Impact

• Color Scales, Icon Sets, Data Bars
• Icons for Only a Subset
• Paired Bar Charts with Negative Data Bars

Tips of the Session 4

• Formula to Value
• F4 trick
• Format Part of Cell
• Copying Sheets

Part 3 Advance Excel

Session 5

Pivot Tables

• Creating a Pivot Table
• Changing a Pivot Table
• Pivot Gotchas
• Pivot Formatting
• Drill Down
• Pivot Calculations
• Summarizing Dates
• Pivot Sorting
• Filtering Row Fields
• Top 10 Report
• Filtering a Pivot Table with Slicers
• Slicers on Two Pivot Tables
• 50 Reports in 5 Seconds

Tips of the Session 5

• Insert Blank Rows
• Text Box Trick
• Pick from List

Session 6

Recording Macros

• Displaying the Developer Tab
• Recording a Simple Macro
• Simplifying the Macro
• Keys to Successful Recording


• Understand Solver
• Using Solver to Solve your Business Problem

Tips of the Session 6

• Print Small Selection
• Fit to One Page Trick
• Speak Cells

Related Courses

Samiul Huq
  • 5 - 6 May 2017 (2 Days)

Excel is the most widely used Data Analytical Tool while ...

Md. Rabiul Islam
  • 5 - 6 May 2017 (2 Days)

In this course, you gain the skills needed to extract value ...

Price 3,000 Tk + VAT
Mohammad Asad Bin Yousuf
  • Friday, May 5, 2017

This training is designed to take trainees from starter to ...

Price 20,000 Tk + VAT
Chowdhury Shahreaar Ekram
  • 6 May - 16 Jun 2017


Price: Tk. 7,000+VAT

(15% VAT is applicable in every purchase.)

Get 10% discount for online payment


9140345, 9117179 , 01926673098, 01811410862

This course is very useful for anyone who works in Excel. The target audiences are the Managers, Executives, Teachers, Developers, Students, and Researchers.
Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.

"This training program is good for our professional life" Nusrat Jahan Khan