Full Microsoft Office Management Course

Microsoft Office Management

“Efficient Microsoft Office Management for Streamlined Operations!

Discover the power of seamless business processes with Sack Trading’s Microsoft Office Management services. Our dedicated team ensures that your organization harnesses the full potential of Microsoft Office tools, optimizing workflow, enhancing collaboration, and boosting productivity.

Key Features of Our Microsoft Office Management Services:

1. Document Organization: Effectively manage and organize your documents using Microsoft Word, Excel, and PowerPoint for a more structured and accessible workspace.
2. Data Analysis and Reporting: Leverage the analytical capabilities of Excel for data-driven insights, creating comprehensive reports that drive informed decision-making.
3. Email and Calendar Management: Streamline communication with efficient email management using Outlook, coupled with strategic calendar organization for better time management.
4. Collaborative Solutions: Foster collaboration among teams through the collaborative features of Microsoft Office 365, enhancing teamwork and communication.
5. Customized Training: Tailored training sessions to empower your team with the skills needed to maximize the potential of Microsoft Office applications.

Experience the efficiency and versatility of Microsoft Office Management with Sack Trading. Let us elevate your workplace productivity. Explore our services now!”

 

COMPUTER OFFICE APPLICATION

Introduction:

Computer Office Applications course provides a solid foundation in the basic and intermediate skills for working with computer system, Word Processor, Spread sheet, PowerPoint, Database, Email and Internet basic applications, practices Google G-suite & concept on Freelancing. This course is ready to extend the knowledge and upgrade skill into some of the more specialized and advanced capabilities of basic operations in computing.

 

Objectives:

After completion of the course the students will be able to-

• Operate pc with windows operating system.
• Work with word processor
• Work with spread sheet program
• Present a presentation using power point.
• Create, maintain and manipulate database.
• Work with Internet & Email Application.
• Work with Google G-suite
• Concept on Freelancing
• Develop Soft Skills
• Practices communicative English

 

1. Generic Competency

(Soft skills & English communication)

2. Core Competency

(Sector based)

 

1. Overview of Computer and Operating System

2. Word Processing including Typing

3. Spread sheet Analysis

4. Presentation Design and Delivery

5. Database Management

6. Email and Internet using

7. Google G-suite

8. Basics of Freelancing

 

Core Competencies (300 Hours) details:

1. Overview of Computer and Operating System

• Describe the history of computer,
• Classify computer depending on capability, size, speed & generation etc.

1.1 Define Hardware.

List and demonstrate different parts of a Personal

Computer and Laptop.

• Define Software & Firmware,
• Classify Software
• Describe Operating System(OS) and the importance of system software

• List the types of Memory,
• Demonstrate primary and secondary memories,

 

1.2 Distinguish between RAM and ROM,

• State Bit, Byte, Kilobyte, Megabyte, Gigabyte, and Terabyte.

• Describe computer virus and anti-virus, computer security.

• State desktop screen icon, icon-shortcut, file, folder/Directory

• Describe file management & windows explorer

 

1.3  Practice on Operating System Environment.

• Select, open and close Desktop icons for navigation purposes.
• Create / Rename a folder, Cut/Copy/Paste a File or Folder.

 

1.4 Install and Uninstall basic application software.

• Install and update Anti-Virus Software.

 

2.1Word Processing

• Getting Started with Word
• Exploring the Word window
•  Familiarization with Menu, Ribbon & Tools
• Using Standard/Personalized Menus
• Typing Practice with Type Tutor
• Editing Document
• Opening an Existing File

 

2.2 Inserting Text in a Document

• Selecting, Deleting and Restoring Text
• Creating a Folder/Saving alternatively named files
• Typing Practice with Type Tutor
• Formatting Text

• Using the Formatting Toolbar: Aligning, Cutting, Pasting Text, Drag and Drop, Copy and Paste

• Applying Styles
• Creating a Paragraph Border, Adding Shading

• Previewing/Printing a Document

 

2.3 Changing Page Margins

• Inserting Page Breaks/Numbers
• Formatting a Paragraph
• Indenting Text
• Changing, Setting and Clearing Tab settings
• Creating/Customizing Headers & Footers
• Working with Columns
• Typing Practice with Type Tutor

 

2.4 Using Automated Formatting, Editing & Proofing Tools

• Setting AutoFormat Options
• Creating an Automatic Bulleted/Numbered List
• Creating and Printing a Mailing List

• Checking Spelling Grammatical Errors in a
• Document
• Finding/Replacing Specific Text

• Inserting Special Characters
• Typing Practice with Type Tutor

 

2.5 Working with Graphics & Tables

• Inserting a Picture from a File/Clip Art Gallery
• Creating WordArt & Drawing a Shape
• Inserting a Table

• Inserting and Deleting Columns & Rows
• Merging/split Table Cells
• Adding Shading to a Table
• Apply Text direction & Simple Formula

 

2.6 Understand Bangla typing and its procedure.

• Practice Bangla typing.
• Merging Documents for Mailing

• Creating a Main Document

2.7 Creating a Data Source

• Adding Merge Fields and Merging Documents
• Generating Mailing Labels

 

2.8 Using Macros

•    Recording, Assigning & Running a Macro

• Editing, Renaming & Deleting a Macro

 

2.9 Working with Tables of Contents & Indexes

• Formatting and Compiling a Table of Contents
• Updating a Table of Contents

• Formatting and Compiling an Index
• Editing and Updating an Index

 

2.10 Long Document Formats

• Inserting Footnotes and Endnotes
• Modifying the Reference Mark Style

• Creating and Using Bookmarks
• Creating Master Documents and Subdocuments
• Practices with Review options (Word count, Track changes, compare etc.)

 

2.11   Use shortcut keys in MS Word.

• Create simple documents like application, Question

 

2.12 Paper (Bangla, English, Math & Chemistry etc.),

Prepare a Bio-data in Bengali and English with formatting.

3. Spread sheet Analysis

Learning Worksheet Fundamentals

• Creating Workbooks
• Understanding MS Excel Window Environment

3.1 Editing Cell Contents

• Moving Between Worksheets
• Naming and Saving Workbooks
• Opening Workbooks & Renaming Worksheets
• Closing Workbooks and Quitting Excel
• Editing and Formatting Worksheets

• Formatting Numbers
• Adjusting the Size of Rows and Columns
• Aligning Cell Contents

 

3.2 Creating and Applying Conditional Formats

• Finding and Replacing Cell Content
• Inserting and Deleting Cells/Rows/Columns
• Cutting/Copying/Pasting/Clearing Cells
• Using Additional Paste Features
• Formatting Cells

• Formatting Text
• Formatting Numbers as Currency

 

3.3 Using Format Painter

• Adding Borders/Shading to Cells
• Using AutoFormat
• Creating and Applying Styles
• Merging Cells
• Changing Print Options

• Adding Headers and Footers

 

3.4 Changing the Orientation and Scale

• Adding and Deleting Page Breaks
• Setting and Clearing a Print Area
• Rows/Columns/Worksheets/Workbooks

• Magnifying and Shrinking a Worksheet on Screen

 

3.5 Hiding and Un-Hiding Rows and Columns

• Freezing and Unfreezing Rows and Columns
• Data Sorting & filtering
• Working with Charts
• Creating Charts Using the Chart Wizard
• Moving/Resizing/Deleting Charts
• Modifying Chart Titles and Adding Axis Labels

 

3.6 Moving and Formatting Chart Elements

• Changing the Chart Type & Organizing Source Data
• Updating Data and Formatting the Axes
• Adding Gridlines and Arrows
• Previewing and Printing a Chart

 

3.7 Performing Basic Calculations

• Building/Editing/Copying Formulas
• Practice Mathematical Functions- Abs(), Sum(),
• SUMIF(), CEILING(), FLOOR(), MOD(), POWER() etc.

 

3.8 Using Basic Financial Functions

• Using the PMT Function to Forecast Loan Payments
• Practice Financial Functions- DB(), FV(), PMT(), PV(), RATE(), IPMT(), ISPMT(), NPER(), NPV() etc.

 

3.9 Create advanced formulas

• Using the IF, AND, and OR functions
• Using the SUMIFS, AVERAGEIFS, and COUNTIFS functions

 

3.10 Create advanced charts and tables

• Create advanced chart elements
• Create and manage PivotTables
• Create and manage PivotCharts
• Create a Tabulation Sheet for representing data through different types of charts.

 

3.11 Create a standard Salary sheet, Generate Electric Bill etc.

Presentation Design and Delivery

 

4.1 Create a Presentation

• Create a new presentation
• Create a presentation based on a template
• Import Word document outlines

 

4.2 Insert and Format Slides

• Insert specific slide layouts
• Duplicate existing slides

• Apply a different slide layout
• Modify individual slide backgrounds
• Inset slide headers, footers, and page numbers

 

4.3 Change Presentation Options and Views

•  Change slide size

• Change views of a presentation
• Set file properties

 

4.4 Configure a Presentation for Print

• Print all or part of a presentation
• Print notes pages
• Print handouts
• Print in color, grayscale, or black and white

 

4.5 Configure and Present a Slide Show

• Create custom slide shows
• Configure slide show options

• Rehearse slide show timing
• Present a slide show by using Presenter View

 

4.6 Insert and Format Text

• Insert text on a slide
• Apply formatting and styles to text
• Apply WordArt styles to text

• Format text in multiple columns
• Create bulleted and numbered lists
• Insert hyperlinks

 

4.7 Insert and Format Images

• Insert images
• Resize and crop images
• Apply styles and effects

 

4.8 Insert and Format Charts

• Create a chart

•    Import a chart

• Change the Chart Type
• Add a legend to a chart
• Change the chart style of a chart

 

4.9 Insert and Format SmartArt graphics

• Create SmartArt graphics

•   Convert lists to SmartArt graphics

• Add shapes to SmartArt graphics
• Reorder shapes in SmartArt graphics
• Change the color of SmartArt graphics

 

4.10 Insert and Manage Media

• Insert audio and video clips

•   Configure media playback options

• Adjust media window size
• Set the video start and stop time
• Set media timing options

 

 

4.11 Animate Slide Content

• Apply animations to objects

•   Apply animations to text

• Set animation effect options
• Set animation paths

 

4.12 Set Timing for Transitions and Animations

•   Set transition effect duration

• Configure transition start and finish options
• Reorder animations on a slide

 

4.13 Finalize Presentations

• Protect a presentation

•   Inspect a presentation

• Proof a presentation
• Preserve presentation content
• Export presentations to other formats

 

4.14 Create a Slide Show presentation about your biography within 10 slides.