Course Detail
IT Office
[Download Free Outline]
Introduction to Ms Office
Microsoft Office (IT Office) is a collection of software and services developed by Microsoft. Stepping into the world of Microsoft and learning will benefit you in every aspect of life. Ms Office consists of many software like Word, Excel, Powerpoint and Outlook etc.
Microsoft Office 2019
Microsoft Office 2019 will facilitate with security updates and will only run on Windows 10 and on the most recent versions of macOS. On the other hand, Ms office 365, gets updated regularly with new features.
Microsoft Word
Learn ms word which is a computer program developed by Microsoft and is used to construct and edit text documents. The highlighting ability of word is to make changes easily, such as spelling correction, deleting, formatting and relocating text. Adding to it, the document can be printed quickly and accurately saved for later modifications.
Why learn Microsoft Word?
Microsoft Office is a very helpful tool widely used by almost every company and business. In today's world, every business needs documentation, data handling and presentation. The importance of MS Office tools like Word is quite significant to all types of businesses. Industry-recognized certification will help advance your career as it provides a widely-recognized certification that you could earn after your training.
Microsoft Excel
Excel is an electronic spreadsheet program that is utilized in recording and analysing numerical data. The sheet is spread as a collection of columns and rows that form a table. Alphabetical letters are usually allocated to columns and numbers are assigned to rows. A cell is represented by the letter which addresses the column and a row is represented by the number. Learn ms excel which has many functions to extract and analyse the data that range from basic mathematical functions to complex statistical analyses will help in managing accounts, etc.
Why Learn Advanced Microsoft Excel?
Excel is a universal language that is used worldwide to deal with numbers in many ways. So, for the ease of people, Microsoft Excel is used if we want to record, analyze and store numeric data. Excel training will enable you to work efficiently and make the process of organising and manipulating data quite fast. If you acquire the great analytical skills of excel, the chance of higher employability increases. On top of that, starting with excel basic training will help you to understand the concepts and functions of this application.
Microsoft Powerpoint
Microsoft PowerPoint is a slideshow presentation program created by Forethought, Inc. Microsoft has released an abundance of updated versions of powerpoint which offers more features and incorporating better technology. Furthermore, powerpoint was unified into Microsoft Office and embrace common elements and a connected user interface.
Why learn Microsoft Powerpoint?
Powerpoint facilitates you to create remarkable and staggering presentations. The image editing capabilities that PowerPoint offer gets better and better with every new version. Starting to learn Microsoft PowerPoint can be difficult if you are not familiar with it, but as you step into its environment it appears to be easy. Powerpoint is a reliable program and is secure. Additionally, It is easy to start over powerpoint as it has numerous features. Accordingly, powerpoint presentation is easy to share by any format including html5, PDFs, and Word documents and its macros can be used in powerful ways.
Microsoft Outlook
Microsoft Outlook office is widely used as a desktop email client to communicate over the internet. Many organizations and companies utilize Outlook to send or receive emails or coordinate meetings, etc. MS Outlook can be easily expanded with a smartphone allowing users to access their email data anywhere around the world.
Why learn Microsoft Outlook?
Outlook has integration with the Microsoft Exchange. Outlook's coordination with active directory; as the users don't have to fill all login credentials, again and again, to log into the exchange server account. In addition, outlook supports many smart devices which provide access to mailbox data from anywhere around the world. E-mails are managed easily with outlook. However, the Outlook is not limited only to messaging instead it allows swift workflow strategies. Several accounts can be configured in outlook with powerful security mechanisms.
Microsoft Office certification
Demonstrate your skills needed to get the most out of Office by earning a Microsoft Office Specialist (MOS) certification in a specific Office program. There are 3 steps to get Microsoft office certification:
Step 1: Empowering skills
Step 2: Select any MOS [Word, Excel, Powerpoint] exam to get certified in that program
Step 3: Attempt Certification Exam
Microsoft Office course in Lahore, PK
ICT-training institute trains the complete ms office course applications to candidates in a precise manner by the hand. Candidates will get MS office training using the program from scratch! As you gain confidence in word, excel, powerpoint and outlook, you will learn ms courses with more advanced features that will be deeply explained by the trainees.
After completion of the course, the participants will be able to use the computer, including Internet services, will be able to create documents, develop reports, make presentations, data analysis, charting, and can perform various other tasks for everyday home or office use.
Microsoft Office Course Contents
Microsoft Office curriculum follows the Microsoft standards and is designed to meet the requirements of every home & office user needs.
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 Desktop
- Desktop Wallpaper
- The Taskbar
- Setting the Date and Time
- Toolbars
- The Windows Start Button
- Share your computer with others
- Setting Parental Controls in Windows
- 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
Microsoft PowerPoint
Getting Started
- Microsoft Office Toolbar
- Quick Access Toolbar
- Mini Toolbar
Creating a Presentation
- New Presentation
- Save a Presentation
- Add Slides
- Theme
Working with Content
- Enter Text
- Select Text
- Copy and Paste
- Cut and Paste
- Undo/Redo
- Spell Check
Formatting Text
- Change Font Typeface and Size
- Font Styles and Effects
- Change Text Color
- WordArt
- Change Paragraph Alignment
- Indent Paragraphs
- Text Direction
Adding Content
- Resize a Textbox
- Bulleted and Numbered Lists
- Nested Lists
- Formatting Lists
- Adding Video
- Adding Audio
Graphics
- Adding a Picture
- Adding ClipArt
- Editing Picture and ClipArt
- Adding Shapes
- Adding SmartArt
Tables
- Create a Table
- Enter Data in a Table
- Format a Table
- Insert a Table from Word or Excel
Charts
- Create a Chart
- Edit Chart Data
- Modify a Chart
- Chart Tools
- Paste a Chart from Excel
Slide Effects
- Slide Transitions
- Slide Animation
- Animation Preview
Printing
Package a Presentation
Practical Approach
- The real-life examples will be given throughout the lectures.
www.ict-trainings.com/curriculum/msoffice-leaflet.pdf