MS Excel 2013: From Novice to Professional training centre in Bangladesh


MS Excel 2013: 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

Md. Nizamul Islam
  • 21 Nov - 17 Dec 2018

This course is a powerful relational database program that ...

Mostofa Monower
  • 24 Nov - 28 Dec 2018

Upon successfully completion of this training, participants ...

Md. Feroz Kibria
  • Friday, November 30, 2018

Organizations use Microsoft Office Excel to track sales ...

Price 6,000 Tk + VAT
Muhammad Rabiul
  • 5 - 24 Dec 2018 (6 sessions)

The course has designed to become familiar with an ...

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.