Microsoft Office Training - Campus to Corporate training centre in Bangladesh

New
EMI EASY PAY

Microsoft Office Training - Campus to Corporate

  • Date : 22 January - 20 February 2019
  • Duration : Evening(6.30 pm-9.30 pm)
  • No. of Classes/ Sessions : 10 sessions
  • Class Schedule : Sunday and Tuesday
  • Total Hours : 30
  • Last Date of Registration : 20 January, 2019
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.

Introduction

Being successful in career now a days, requires a prodigious strength of knowledge of Microsoft Office package which is equally critical for every department of corporate world. Based on this key aspect, this training is designed by focusing on how to manage your workload, your career and eventually yourself through Microsoft Office rather than being completely Lack of guidance. This training program enhance the confidence and skills of future leaders to move forward.

Assurance:
Our training program assure you to implement the knowledge that we transfer to you. We strictly follow KSA process.
K– Knowledge S– Skill A– Ability

Methodology

Hands on training with practice sessions.

Contents of Training:

A. Microsoft Excel 2016

Getting Started With Excel
 MS Excel Stands for
 Spreadsheets or Worksheets
 Exploring Microsoft Excel
 Cell and cells range
 Column width and row height
 Deleting rows or columns
 Editing cells value or formula
 Text wrapping in excel
 Insert or delete a worksheet
 Inserting columns and rows
 Moving or coping a worksheet
 Find and replace option
 Portrait and Landscape orientation
 Printing excel documents
 Spelling check option
 Viewing and printing formulas
 Worksheets renaming
 Cells reference styles
 Cells referencing or addressing
 Excel key board shortcut
 Data modeling concept
Excel data visualization and data tools
 Formatting stands for
 Excel Cell and Table formatting
 Basic Data formatting
 Basic Date formatting
 Basic Conditional formatting
 Text to Column
 Remove Duplicates
 Data validation
 Grouping and Un-grouping option
 Excel Sorting and Filtering
Microsoft Excel Functions
 Excel function and formula stands for
 Categories of Excel functions
 Value, Concatenate function
 Left, Right, Mid function
 Lower, Proper, Upper function
 IF, nested IF, complex IF function
 Now, Today function
 Sum, Count, Average function
 Max, Min, Maxa, Mina function
 Round, Roundup, Round down function
 Sumifs, Countifs, Averageifs function
 Lookup, Vlookup function
 Precedent and dependent
Microsoft Excel Pivot Tables
 Creating and pivoting Pivot Tables
 Summarizing Pivot Table data
 Managing subtotals and grand totals
 Visualization using Slicer and Timeline
 Grouping Pivot Table data
 Using formulas in Pivot Table
Microsoft Graph or Chart
 Create an excel chart
 Excel chart elements
 Ignoring blank cells in chart
 Plotting secondary axis in chart
 Switch row or column data in chart
 Excel charts customization
 Creating charts using custom template

B. Microsoft Word

Working with Long Documents
 Adding a Table of Contents
 Updating the Table of Contents
 Deleting the Table of Contents
 Footnotes and End notes
 Inserting Citations and a Bibliography
Review and Collaborating on Documents
 Adding Comments
 Tracking Changes
 Viewing Changes, Additions, and Comments
 Accepting and Rejecting Changes
Managing Mailings
 Creating Envelopes and Labels
 Using Mail Merge
Protecting Documents
 Making Word Documents Read Only
 Password Protect Word Documents
Random Useful Items
 Using Bookmarks
 Adding Watermarks
Using the Go to Feature
 Configuring Documents to Print
 Print Document Sections
 Set Print Scaling

C. Microsoft PowerPoint

Getting Started
 Start and end a PowerPoint session
 Edit a presentation
 Create different types of slides
 Outlines and Slides
Visualization
 ClipArt’s of presentation
 Working with Images
 Working with Tables and Charts
 Working with Special Effects
 Using Smart Art
 Usages of Multimedia
 Working with Special Effects
 Formatting Slides
 Setting up the Slide Show
 Run a slide show
 Managing Multiple Presentations
 Print various components of a presentation
 The Backstage View (The File Menu)
 Finalizing Microsoft PowerPoint Presentations
Customization
 Theme customization
 Presentation Masters
 Slide Mastering and it’s uses
Automation
 Manage hyperlinks
 Dynamic presentation file creation
 Automatic update slides from Excel data

D. Microsoft Access

 Quick Overview of the Access User Interface
 Fundamentals of database
 Tables and Their Views and properties
 Relationships between tables
 Importing Data from various sources
 Fundamentals of queries, forms & reports
 Select & Crosstab queries buildup
 Editing queries through SQL & Design view
 Work with forms and the Form Wizard
 Work with reports and the Report Wizard
 Finalizing a output

E. Microsoft Outlook

 The Outlook 2016 Interface
 Working with Tasks and Notes
 Using Signature and Themes
 Managing Your Inbox
 Search for Messages
 Sort Messages
 Move Messages between Folders
 Group Your Mailbox Items
 Filter Messages
 Organize Messages
 Create and Manage Rules
 Add an Attachment
 Add Voting Options
 Set Up Availability Status
 Print Your Schedule
 Share Your Calendar
 Schedule a Meeting
 Make Updates to Meetings
 Cancel a Meeting
 Reply to a Meeting Invitation
 Schedule an Appointment
 Make Updates to an Appointment
 Archive Your Messages
 Create Auto-Replies

Related Courses

Md. Feroz Kibria
  • Friday, January 25, 2019

Organizations use Microsoft Office Excel to track sales ...

IT
Course at Sylhet
Price 2,000 Tk + VAT
Ataur Rahman Rony
  • Saturday, January 26, 2019

Excel remains one of the most extensive pieces of software ...

IT
Ashim Kumar Sikder
  • 26 Jan - 1 Mar 2019

Trainee will be capable to develop and deploy database ...

IT
Mostofa Monower
  • 26 Jan - 15 Feb 2019

This training program builds upon advanced level knowledge ...

IT
Executives, Managers, Teachers, Developers, Students, Researchers - People looking for a job and would like to do better in future through working with Microsoft Office.

Resource Person

Mostofa Monower, MCP, MCSAM

Analyst, Contact Experience, CSD Robi Axiata Limited

Mostofa is a Microsoft Certified Professional (MCP) and Microsoft Certified System Administrator with Messaging (MCSAM). He has been completed on Cisco Certified Network Associate (CCNA) form American International University (AIUB). Other courses that he has completed and specialized are Red Hat Certified Engineer (RHCE), ComTIA A+, ComTIA Network+, and International Computer Driving License (ICDL).
Mr. Mostofa Monower has over 9 years of working experiences in Network Infrastructure, Workforce Management and MIS reporting. He has started his career with Gemcon Group in early 2007 and also has working experience with TK Group as System Administrator. Currently he is working as Analyst, Contact Experience, CSD in Robi Axiata Limited. He is proficient of creating dynamic MIS Reports, templates, dashboards and maintaining database. He has excellent knowledge in Microsoft Office, especially in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Outlook and Microsoft Word. He has been providing training on Microsoft office package since 2011. He has given consultancy to develop reporting systems for some renowned organizations of Bangladesh. He is dedicated to develop and improve professional skills and unlock resource potential in order to increase efficiency and productivity.

Hands on training with practice sessions.