Complete Office Program

✅✅*SSC/HSC/Degree পরীক্ষার পর সবাই কম্পিউটারের উপর অফিস কোর্স করতে যায় কিন্তু আধুনিক ডিজিটাল যুগে শুধু অফিস কোর্স কি আপনার ভবিষ্যতের জন্য কতটুকু সহায়ক?

✅✅*অনেকে অল্প টাকায় কোর্স করায় যেটা কি যুগপোযুগী? বর্তমানে ডিজিটাল যুগে আপনাকে অফিস কোর্স এর সাথে আরো অনেক নলেজ থাকতে হয় যা নিচে আমাদের ২১ টি কোর্সের নাম দেয়া আছে।

✅✅*কেন আমাদের কাছে SSC/HSC/Degree পরীক্ষার পর Complete Office Program(COP) কোর্সটি করবেন?
১। আমরা এ প্রোগ্রামটি সাজিয়েছি এমনভাবে যাতে ভবিষ্যতে একজন স্টুডেন্ট অফিসিয়াল কাজ সাবলীলভাবে করতে পারে।
২। আমাদের হয়ত রাস্তায় পোস্টার বা ব্যানার কম কিন্ত কোয়ালিটি ট্রেইনার আছে যেমনঃ ঢাকার সবচেয়ে বড় ট্রেনিং কোম্পানি বিডিজবস বড় তিনজন ট্রেইনার আমাদের ট্রেইনার। 
৩। আপনার কম্পিউটারের যে কোন ছোট খাট সমস্যার জন্য কারো কাছে যেতে হবে না। 
৪। বেশীরভাগ আইটি সেন্টার অফিস কোর্সে ডাটাবেস (DATABASE) পাশ কাটিয়ে যায় যা আমরা করিনা।
৫। এই কোর্সটিতে অনলাইনের রিসার্সের যে অংশ আছে তা হায়ার স্টাডির জন্য খুবই জরুরী। 
৬। কোর্স শেষে সার্টিফিকেট দেয়া হয়। 
৭। আমরাই নারায়নগঞ্জে আইটির সব ধরণের কোর্স করাই।

✅✅*Course Name: Complete Office Program (1 in 21)
1. Typing
2. Online Researching 
3. Computer Hardware Basic
4. Computer Software Basic
5. Printing Concept
6. Search Engine Concept
7. How Google works 
8. Advanced Searching
9. Google Keywords Concept 
10. Ms-word
11. Ms-excel
12. Ms-power point
13. Database for Office
14. Basic concept of Email
15. Google spreadsheet
16. Google Drive share and upload
17. Google Form creating
18. Note Pad 
19. Basic Concept of Graphic Design
20. Basic Concept of Freelancing
21. Basic Concept of Operating System

Now we are giving the details contain of MS-Office (number 10 – 13 of above 21 lists)

Introduction

Microsoft Office is the most widely used software application around the globe. Business and non-business organizations prefer Microsoft Office as the single solution to document processing, spreadsheet analysis and presentations. The application package also includes database, communication and collaboration solutions.

This course will specifically focus on Microsoft Excel (spreadsheet solution), Microsoft Word (document processing solution), Microsoft PowerPoint (presentation solution) and Microsoft Access (Database). The level of skills to be achieved is intermediate to advanced levels.

Learning Outcomes
The highlighted learning outcome of this course is to enable the participants to use Microsoft Excel, Word and PowerPoint with high level of efficiency and productivity. Following learning outcomes are breakdown of the major outcome:

(1) Gaining skills on Microsoft Excel at an expert level for data management, analysis, and advanced reporting;

(2) Gaining skills on Microsoft Word at an expert level for creating, publishing and sharing highly professional documents;

(3) Gaining skills on Microsoft PowerPoint at an expert for creating, publishing and sharing highly professional presentation;

(4)Gaining skills on Microsoft Access at an expert for creating, publishing and sharing highly professional database;

(5) Consolidate skills in Excel, Access, Word, and PowerPoint to solve real life cases with professional expertise.

Methodology

Hands-on Training with project assignments.

Contents of Training:

1. Understand the Environment of the Microsoft Excel Application Platform Including Customization of the Application Window.
1. Working with the Excel environment
2. Creating and Opening Workbooks
3. Fluent Interface of 2007,2010 and 2013 versions and difference with older versions
4. Basic Customization

2. Understanding and formatting cells-cells range and Modifying Columns, Rows, and Cells
1. Cells Basic
2. To drag and drop cells and fill handle
3. Modifying Columns, Rows, and Cells
4. Wrapping text and merging cells
5. Formatting cell and Formatting text and numbers

3. Simple and complex Formulas with Full Knowledge of Absolute/Relative Referencing, Cell/Range Naming Concept
1. Static Formula Writing – Understanding of BODMAS rule and Arithmetic Operators
2. Formulas with Relative and Absolute Referencing
3. Formulas with Cell Names and Name Management
4. Dragging, Clicking, Copying/Pasting of Formula
5. Preparing Balance Sheet, Invoice, Sales Report/ forecast, business budget by formula

4. Understand the Differences between Formulas and Functions; Use Very Essential Statistical, Text, Date and Financial Functions.
1. Difference between Formula and Functions
2. Essential Statistical Functions
3. Essential Text Functions
4. Essential Date Functions
5. Essential Time Functions
6. Essential Financial Functions

5. Present Summarized Data Graphically with basic charts – Column, Bar, Line & Pie Chart
1. Column Chart
2. Bar Chart
3. Line Chart
4. Pie Chart & Doughnut Chart
5. Using Advanced Charting and Sparklines

6. Preparing Database and Data-Table and searching data from table
1. Database and Data-Table Fundamentals
2. Searching Data from Table using Vlookup and Hlookup Functions
3. Search Data using Match, Index ,Choose and Offset
4. How can HR use Vlookup for tracking Data record and Salary sheet?

7. Analyzing and Summarize Large Amount of Data Very Quickly with Subtotal and Pivot-Table Tools
1. Subtotal Function
2. Managing PivotTable Reports
3. Creating PivotChart Reports
4. Practical example of Pivot Table for office work.

8. Apply logical functions to make spreadsheet decision making tools
1. Basic IF function
2. Multiple/Nested IF
3. Sumif-sumifs and Countif-Countifs
4. If error Function

9. Use advance tools to establish control over data and protect data
1. Conditional formatting
2. Data Validation
3. Connect Spreadsheet with External Data Source
4. To use Spell Check and proofing
5. Protection

10. Access (2007-13) Database concepts and Customer management.
1. What is a database? /What is a relational database?
2. What is a table? /What is a record (row)?/What is a field (column)?
3. The difference between data and information/Data types/Common uses of large-scale databases
4. Database designers, database administrators and database users
5. How Database works for Customer management?

11. Opening and creating a database with table navigation, modification, forms, query and Report (Ms-access)
1. Opening a database within your samples folder
2. Creating a new blank database/Adding fields and setting the field type
3. Switching between ‘datasheet view’ and ‘design view’/Creating relationships between tables
4. Creating &Modifying forms
5. Creating a query and report
6. Importing an excel file into a database

12. Create and Publishing Smart Word Documents
1. Fonts, Paragraphs and Styles
2. Tables, Illustrations and Header/Footer
3. Themes, Colors and Bordering
4. Page Setup and Page Background

13. Review and Share Documents created by Microsoft Word
1. Proofing, Comments, Tracking and Changes
2. Creating and protecting form check boxes as electronic Document office work.
3. Advanced View Options
4. Protecting and Sharing Documents

14. Create Smart PowerPoint Presentations
1. Presentation Basics: content, texts and colors;
2. Creating new slides, editing backgrounds and formats
3. Tables and Illustrations
4. Themes and Animations

15. Apply Advanced Graphics and Animation
1. Create customized backgrounds;
2. Insert Excel Charts and External Graphics
3. Using Slide Master
4. Publishing, sharing and protecting presentations files.

16. Consolidate Excel, Word, PowerPoint and Access Outputs
1. Connect Excel with Word Documents and Power-Point Presentations and Access
2. Create collaborated report using Excel, Word and PowerPoint;
3. Solve real life reporting solution using all application packages.

To know more details then Visit our office

PC PLUS IT,
27 Allama Iqbal Road(College Road) , Narayanganj.
Mob: 01772699434
FB: FB/pcplusbd