MICROSOFT OFFICE COURSE
This course is a must have training for every professional field. You will be trained how to computerize your daily office work and activities. From writing letters, applications and memos to advance level of techniques in Microsoft Excel for accounting and data analysis. This professional course contains the following modules
Course Contents
- Introduction to Computers
- Hardware / Software
- Different Devices and cables
- Operating Systems
- Precautions
- Microsoft Windows
- Turning on and Logging on
- Desktop and its settings
- Icons and settings
- Creating and Managing Shortcuts
- Drives / Files / Folders
- Working with Different windows
- Copying / Moving files
- Searching Techniques
- Date / Time Settings
- Keyboard / Mouse Settings
- Regional Settings
- Getting Help
- Shutting Down
- Microsoft Office Word Professional
- The Environment and Ribbon
- Creating, Storing and Retrieving Files
- Text Editing
- Searching
- Clipboard
- Different Views
- Task Pan
- Working with Toolbars
- Headers and Footers
- Dynamic text
- References
- Using Clipart and pictures
- Diagrams
- Text Box usage
- Importing data form external file
- Inserting other media (object)
- Bookmark
- Linking Text and Documents
- Formatting text and Paragrahs
- Setting up Borders and Shading
- Working with Multiple Columns
- Using Tabs
- Spelling and Grammars
- Thesaurus
- Auto Correct
- Customizing MS Word
- Working with Tabs
- Page setup and Printing
- Shortcut keys
- Microsoft Office Excel Professional
- The environment
- The Excel Gridline
- Customizing Excel
- Using Fill
- Searching
- Views and Custom Views
- Working with Charts
- Formatting Cells
- Formatting Rows and Columns
- Conditional Formatting
- Protecting Worksheets
- Goal seek
- Scenarios
- Formula Auditing
- Sorting Data
- Filtering Data
- Subtotals
- Validations
- Consolidation
- Group and Outlines
- Pivot Tables and Charts
- Importing Data
- Page Setup and Printing
- Microsoft Office Power Point Professional
- Using wizards
- Grids and Guidelines
- Adding new slides
- Importing Slides
- Background
- Side Design
- Side Layouts
- Side Sorter
- Working with Chart and Tables
- Slide Transitions
- Custom Animations
- Working with Sound
- Running a presentation