It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life

Microsoft Office Specialist

This training is jointly organized by BITM & Nanotec Solution & Consultany Limited

 

Students will gain basic hands-on experience using the integrated programs of Microsoft Office 2010. This course is designed to use the basic features of Word, Excel, Access, and PowerPoint, and to integrate data between the applications. Lecture, 2 hours per week; lab, 2 hours per week.

 

Training will be held on Nanotec Solution & Consultany Limited's premises.

FEE - Tk 10000

Prerequisite

 

N/A

 

Project Oriented Course

Will be discussed during the session.

Course Outline

Microsoft Word Specialist:

Introduction to Microsoft Word, Document Views, Entering and Editing Text, Saving and Opening Documents, Navigating and Selecting Text, Editing, Copying and Moving Text, Formatting  Documents, Using Bulleted and Numbered Lists, Using Tabs, Introduction to Tables, Inserting  Pictures, Page Layout and Printing, Introduction to Styles, Themes and Templates Managing Bulleted and Numbered Lists, Customising Tables ,and using Formulas, Inserting Text Objects, Inserting Graphic  Objects, Using Quick Parts ,Multi-Section Documents, Headers and Footers in large  documents ,Proofing Tools.

 

Microsoft Excel Specialist:

Introduction to Microsoft Excel,Entering and Amending Data,Saving and Opening Workbooks,Navigating and Selecting Ranges,Entering Formulas,Inserting/Deleting Rows and Columns,Formatting Worksheets,Using Simple Functions,Copying, Moving and AutoFill,Relative vs. Absolute References,Previewing and Printing. Find and Replace,Introduction to Range Names,Using Multiple Worksheets,Cell Styles and Conditional Formatting,Paste Special,Text and Date ,Formulas,IF Function,Using Charts,Sorting and Filtering Lists,Using Tables,SmartArt and Drawings,Comments and Hyperlinks,Importing and Exporting Data, Managing Range NamesDate and Time Formulas,Custom Formats,IF and Related Functions,VLOOKUP and Related Functions,Advanced Filter / Subtotals,Database Functions,Multiple Workbooks ,ConsolidationData Validation,Auditing,Pivot Tables,Shared Workbooks / Tracking,Protecting WorksheetsUsing Templates, Excel in accounting and effective spreadsheet design,Managing cell and range Names,Date and time formulas for accounting records,Using Data Validation to ensure accuracy of data input

 

Accounting functions of Ms Office:

Accounting functions for calculating depreciation of assets / cash flows,Varying cell content and format with If functions and Conditional Formats,Looking up Accounting Data from with Vlookup and related functions,More complex data location for Vlookup using Index and Match functions,Filtering / totalling data with advanced filter, subtotals, database functionsLinking and consolidating data from multiple workbooks,Auditing and error checking your accounting spreadsheets,Financial Reporting: advanced graphs and charts,Summarising accounting data with Pivot Tables and charts,Automatically extending data selection with Dynamic Data Ranges,Forecasting: What If Analysis with Goal Seek, Solver and Scenarios,Forecasting and Budgeting: moving averages and trend analysis

 

Microsoft PowerPoint Specialist:

Introduction to Microsoft PowerPoint,Creating a Presentation,Entering and Editing Text,Managing Text,Text Boxes and Tables,Pictures and Drawings,SmartArt and ChartsPresentation Designs and Formatting,Printing PowerPoint Presentations,Simple AnimationsRunning Slide Shows,Integrating with Word and Excel,Managing Slide Masters,Multimedia Objects,Custom Animations,Collaborating with Colleagues,Publishing a resentation,Preparing and Presenting a Show,Overview of Relational Databases,Introduction to Microsoft Access,Creating a Database,Creating Tables and Modifying Table Design,Working with Tables,Select Queries,Creating and Using Forms,Creating and Using Reports,Database Management,Relational Database Design,Modifying Table DesignUsing Lookup Fields,Modifying Queries,Outer Joins,Calculated Fields,Query WizardsSimple Parameter Queries,Modifying Form Design,Controls and the Property SheetManaging Controls,Modifying Report Design,Sorting and Grouping,Database ManagementObject Dependencies,Importing and Exporting Data,Table Validation Rules,Input MasksUsing Subreports,The Tab Control,Parameter Queries,Action Queries,Self Joins,UNION Queries,SQL and SubQueries,Using Subforms,Calculated Controls,Multi Column ReportsLinking to other Databases,Analysing and Documenting,Start Up Options,Introduction to Macros,Event Driven Macros,Validation and Calculation Macros.

Used Tools

Ms office (Latest Version)

COURSE SUMMARY

Course Duration : 90 Days
Total Hour : 36 Hours
Number of Batch : 1 Batch

Application Last Date : 12 December, 2016

Class Schedule

Day & Time : Saturday 11:00 am - 1:00 pm
: Monday 11:00 am - 1:00 pm
: Wednesday 11:00 am - 1:00 pm
Duration : 2 hours per class

Project:

Microsoft Office Specialist


Certificate:

 Certificate will be provided after the completion of the course.