Professional Office application

Most work today happens on a computer. Optimize your effort by learning useful software tips and tricks that you can apply for decades to come, saving you valuable time, money and effort.
Want to get noticed by your boss or earn the respect of your colleagues? Become the office superstar by being the go-to expert on everything related to MS Office 2016.

Who should take this course?

  • Those new to using Microsoft Excel, PowerPoint, and Word 2016
  • This course is created for absolute beginners.
  • If you want to refresh your memory and understanding of Excel, Word and PowerPoint
  • Users of earlier versions of Excel, Word and PowerPoint

Course includes

  • Spreadsheets with Excel 2016
  • Documents with Word 2016
  • Presentations with PowerPoint 2016
  • Basic computer: Hardware and Software

Course Duration: 20 classes
Class Duration: 1.30 - 2 hours
Class Time: 2:00PM - 4:00PM
Class Time: 5:00PM - 7:00PM
Total Seat: 10 per batch
Course Fee : BDT 6000
Pre-requisite: Any one can join
Apply

Course Curriculum

MS Word Syllabus

  • Getting Started with Word 2016
  • Performing Calculations
  • Modifying a Worksheet
  • Formatting a Worksheet
  • Printing Workbooks
  • Managing Workbooks
  • Customizing the Excel Environment

  • Creating Advanced Formulas
  • Creating Advanced Formulas
  • Analyzing Data with Functions and Conditional Formattin
  • Organizing and Analyzing Datasets and Tables
  • Analyzing Data with PivotTables, Slicers, and PivotCharts

  • Sharing and Protecting Workbooks
  • Automating Workbook Functionality
  • CApplying Conditional Logic
  • Using VLookup, if formula
  • Using Slicer
  • Insert data using form

MS Excel Syllabus

  • Getting Started with Microsoft Office Excel 2016
  • Editing a Document
  • Formatting Text and Paragraphs
  • Adding Tables
  • Managing Lists
  • Inserting Graphic Objects
  • Simplifying and Managing Long Documents

  • Controlling Page Appearanc
  • Proofing a Documen
  • Customizing the Word Environmen
  • Working with Tables and Charts
  • Forms

  • Customizing Formats Using Styles and Themes
  • Using Images in a Document
  • Creating Custom Graphic Elements
  • Controlling Text Flow
  • Using Templates
  • Using Mail Merge
  • Collaborating on Documents
  • Adding Reference Marks and Notes

MS PowerPoint Syllabus

  • Getting Started with PowerPoint 2016
  • Creating a Basic Presentation
  • Formatting Text on Slides
  • Adding Graphical Objects to a Presentation
  • Modifying Graphical Objects in presentation

  • Preparing to Deliver a Presentation
  • Adding Animation
  • Transitions
  • Designing Slides

  • Working with Tables
  • Working with Charts

Basic working knowledge about different computer Hardware and Software