MS Office Specialist
MS Office Specialist
MS Office Specialist
Description of the Course
Introduction to MS office is going to be a basic trip through Microsoft word, PowerPoint, Excel and Access where beginners would have the opportunity to explore some great shortcuts in order to run those databases more efficiently. Therefore, the course teaches the basic skills for word processing, for creating excel spreadsheets, for building databases and preparing presentations, through the use of Microsoft Office Word, Excel, Access, and PowerPoint programs.
Career pathway
Typical Jobs for MS Office skills:
- Administrative Assistant
- Computer Operator / Data Entry Operator
- Receptionist
- Coordinator
- Research Associate
- Executive Assistant
- Sales Associate
- Customer Services Jobs
- Office Manager
- Graphic Designer
- Secretary / PA
- Technician Writer
- Research Assistant
- Human Resources
- Data Analysts
- Supervisor / StoreIn-charge
Benefits
Familiarity with the Microsoft Office interface Understand what each application is used for
- Gain hands on experience of using MS Office
- Be able to create and save your first files
- Create some basic spreadsheet formulas
- Run a PowerPoint slideshow
- Send emails with attachments
Learn about the following topics:
- Computer Hardware
- Software Fundamentals
- Microsoft Windows
- Microsoft Word
- Microsoft Excel
- Microsoft Access
- Microsoft Power Point
- Printers and Fonts
- Maintaining Computers
- Graphics
- Internet
Intro to IT & Computers
- Basic Concept of IT
- What is a Computer?
- Components of a Computer
- Classification of Computers
- Computer Software
- System Software
- Operating System – Ms Windows
- Application Software
MS Office
Operating System
- The Windows 7 Desktop
- Desktop Wallpaper
- The Taskbar
- Setting the Date and Time
- Toolbars
- The Windows 7 Start Button
- Share your computer with others
- Setting Parental Controls in Windows 7
- Copying Pictures to a New Folder
- How to take a Screenshot in Windows
Microsoft Word
Getting Started With Microsoft Word
- Creating a basic document
- Enter text
- Saving a new document
- Preview document
- Print document
- Online help
Editing a Document
- Insert text
- Select text
- Create an auto text entry
- Move and copy text
- Delete text
- Undo changes
- Find and replace text
Formatting Text
- Apply font styles and effects
- Change text color
- Highlight text
- Bulleting text
Formatting Paragraphs
- Set tabs to align text
- Control paragraph layout
- Add borders and shading
- Apply styles
Adding Table
- Create a table
- Modify the table structure
- Format a table
- Table toolbar
Header and Footer
- Understanding header and footer
- Creating / editing header and footer
- Insert page number / text on header & footnote and
Endnote option menu
- Creating / editing footnote and endnote
Drawing Toolbar – Word Art
- Use of Drawing toolbar
- Use of auto shape
- Adding shadows and text to a shape
- Working with textbox object
- Create word art
- Advanced word art
Create Word Macros
- What is a macro
- Create a macro
- Assign a macro to the keyboard
- Delete your macro
Proofing a Document
- Check spelling, grammar and word count
- Customize autocorrect options
Microsoft Excel
Getting Started With MS Excel
- Excel rows and columns
- Workbook & worksheet
- Enter text and numbers in a cell
- Edit text in a cell
- Cell formatting
- Font formatting
- Merge cells
- Save your work
Formulas and Functions
- Entering formulas
- Copying data and formulas
- Using AutoSum
- Understanding functions
- Using simple aggregate functions (Sum, Count, Average,
- Min, Max)
- Copying formulas
Editing Features
- Using cut , copy, and paste operations
- Using paste special with values
- Selection techniques
- Navigation techniques
Working with the Large Workbooks
- Freezing and unfreezing panes
- Splitting windows
Inserting page breaks for printing-Working with Charts
- Creating charts using Chart Wizard
- Creating different types of charts
- Including titles and values in charts
- Formatting of charts
Inserting Graphic Objects
- Insert and modify pictures and clipart
- Draw and modify shapes
- Illustrate workflow using smartart Graphics
Previewing and Printing
- Previewing worksheets
- Page setup
- Printing of worksheets in multiple pages
- Repeating rows and columns for multiple pages
- Printing multiple worksheets
Simple Database Operation
- Sorting tables
- Filtering data with auto filter
- Referring data from other worksheets
- Create hyperlinks
Analyzing Data Using Pivot Tables and PivotCharts
- Create a pivot table report
- Analyze data using pivot charts
PowerPoint
Using PowerPoint
- Opening PowerPoint
- Opening a presentation
- Navigating between slides
- Using the Zoom tool
- Changing PowerPoint views
- Saving a presentation
- Closing a presentation
- Closing PowerPoint
- Opening multiple presentations
- Switching between multiple presentations
- Creating a new presentation
- Inserting a new slide
- Recommended techniques when creating slide content
- Undo and Redo
- Saving a presentation
- Saving a presentation using a different name Manipulating Slides
- Inserting slides with a particular slide layout
- Modifying the slide layout
- Changing the background color on the active slide
- Changing background color on all the slides within a presentation
- Themes & Text Boxes manipulating text
- Font Formatting & Paragraph Formatting
- Tables Graphics & Manipulating Graphics Slide Shows
- Running a slide show
- Adding Slide show transition effects
- Removing transition effects
- Adding slide show animation effects
- Modifying slide show animation effects
- Removing animation effects
- Hiding slides
- Displaying hidden slides within a slide show Printing and Proofing
- Spell-checking
- Portrait or Landscape slide orientation
- Selecting your output format
- Visually inspect each slide before printing
- Printing options
- Setting the number of copies to print
- Selecting a different printer
- Printing selected slides
- Setting the number of slides per page to be printed.
- Single or double sided (duplex) printing
- To print a presentation
MS Access
Course objectives:
It is designed for people who are used to managing data in spreadsheets but wish to understand why and how a database will provide a better solution. The course covers the difference between spreadsheets and databases and takes students through the process of creating a database, from design through to data population.
Course Contents:
- Introduction
- What is a database?
- Why use a database?
- Understanding your Data
- Designing a database
- Data modeling
- Overview of Access Components
- Creating a database
- Creating Tables, Attributes & Data types
- Adding/Editing Data
- Manual editing
- Importing data
- Filtering/Exporting Tables
- Filtering/sorting data
- Exporting data
- Table Relationships
- Types of relationship
- Referential Integrity
Internet & Emails
Objective:
Students will know how to access the Internet, how to search effectively, and sign-up for and use an Email account using an Internet Service Provider (ISP).
- The Internet and Internet Explorer
- Introducing the Internet
- Introduction to Internet Explorer
- Getting Help
- Exploring the Web
- Working with Web pages
- Searching the Internet
- Performing advanced searches
- Customizing the search features
- Working with Web pages
- Working with Favorites
- Using links
- Using the History list
- Printing Web content
- Internet transactions and security
- Internet transactions
- Web security considerations
- Outlook basics
- E-mail basics
- Introduction to Outlook 2000
- Using Help
- Working with e-mail messages
- E-mail messages
- Handling messages
- Managing e-mail
- Personal folders
- Searching and sorting messages
- Printing messages
- Address books
- Searching & Surfing
- Jobs Consultancy & Resume Making.
Thank You
For
Joining us
Classes Schedule
| Seminar Date & Time | August 24, 2024 at 8PM |
| Last Date of Submission of Forms & Fees | August 24, 2024 at 8PM |
| Commencement of Classes | August 26, 2024 at 8AM & 6PM |
| Classes Days | Monday to Friday ( 2 Hours Daily ) |
| Duration | 3 Months |
| Fee ( PKR ) | PKR 12000/Participant |
| Discount | Group or Sibling |
| Diploma Charges | PKR 2000 – for 6 months diploma PKR 6000/- for 1 year diploma DIT |
| Admissions Charges | PKR 500/- |
For details and registration, please contact or visit:
CREATIVE INSTITUTE OF IT MULTAN
Block W/1, New Multan, Multan-60000: Tel: +92 300 738 3401 | 333 763 5061
E–Mail: creativesoftec@gmail.com || Website: www.creativeitedu.com