Data Analysis, Visualization & Presentation with MS Office 2007/2010


Get the most out of Microsoft Office faster and easier than ever. Be the Office Expert of your work place from today. The course is a Wonderful and yet Powerful blend of Microsoft Excel and PowerPoint. Maximize your productivity with Excel’s best tools and shortcuts and at the same time present them to your Boss using PowerPoint. The course includes features like PivotTables Sparklines, Conditional Formatting, Tips and Tricks and many more! Analyze data more effectively and communicate more visually!

Learn how to leverage the linking and embedding features of Office to bring Excel tables and charts into PowerPoint. Learn to create links from PowerPoint to Excel to fire up a workbook directly from a presentation. If you've wondered how to create compelling, data-driven presentations that always stay up to date, this course is for you.

How participants will benefit after the course:
This course is a unique mix of Data Analysis, Visualization and Presentation. Most users fail to tap into the full potential of office’s built-in utilities. In this course we will explore those uncovered area so that you can implement them in your regular work from Day 1.


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: Data Analysis and Visualization with Excel

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

Diving into Formulas
• AutoSum Tricks
• Relative Versus Absolute Formulas
• Tables and Table Formulas

Sorting & Filtering
• Data Preparation
• One-Click Sorting
• Sorting by Color
• Sorting by Weekday
• Rearranging Columns
• Filter by Selection
• Other ways to Filter
• Remove Duplicates

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

• Creating and Formatting a Chart
• Adding or Removing Chart Data
• Pie Chart Tricks
• Sparklines

Visual Impact
• Color Scales, Icon Sets, Data Bars
• Paired Bar Charts with Negative Data Bars

Tips & Tricks
• Removing Duplicates
• Copying Sheets
• Shrink Text
• Transposing Tricks
• Insert Blank Rows
• Data Validation
• Switch Column Trick
• Fill Blank Trick
• F4 trick
• Fit to One Page Trick
• Speak Cells

Part 2: Presenting Data with PowerPoint 2007/2010

Getting Started

• Starting from scratch
• Adding slides and content
• Deleting slides and changing layouts
• Rearranging slides
• Saving time with Outline mode
• Separating your show into sections
• Adding photos and clip art
• Spell-checking
• Using the thesaurus
• Saving a presentation
• Applying a theme
• Running the show

Formatting a Presentation
• Using fonts and color
• Adding bullets and list numbering
• Changing text alignment
• Using picture effects
• Removing backgrounds from photos
• Understanding slide masters
• Changing slide backgrounds
• Adding a logo to the background
• Applying slide transitions
• Saving the design template

Adding Tables and Charts
• Creating tables
• Formatting tables
• Pasting tables from Excel
• Creating charts
• Pasting charts from Excel

Working with Shapes
• Adding shapes
• Moving, resizing, formatting, and rotating shapes
• Adding text to shapes
• Adding text boxes
• Working with layers (Send to Back and Send to Front)
• Animating text, shapes, and other objects

Adding Audio and Video
• Adding an audio clip
• Adding video
• Cropping video

Adding SmartArt and Diagrams
• Adding organizational charts
• Adding cycle diagrams, Venn diagrams, and other diagrams

Sharing with Others
• Printing a presentation
• Adding speaker notes
• Saving your presentation as a PDF
• Presenting on another laptop (packaging)
• Broadcasting on the web
• Saving as a video
• How to Do Presentation

Related Courses

Price 3,000 Tk + VAT
Moshiur Rahman
  • Friday, January 27, 2017

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

Abu Shams Mahmood Arif
  • Saturday, January 28, 2017

Most widely practiced Excel topics are covered in the ...

Moshiur Rahman
  • 31 Jan - 14 Mar 2017

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

Samiul Huq
  • 3 - 4 Feb 2017 (2 Days Long)

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 and PowerPoint. The target audiences are the Managers, Executives, Teachers, Developers, Students, and Researchers.