Learn Office Management

Complete Guidence to Professional Office Management

Microsoft Word Task & Assignment

• Create A Professional CV / Resume
• Experience Letter
• Termination Letter
• Offer Letter
• Customization Table
• Page Setup & Alignment
• Page Margin & Padding
• Page Printing
• Documentation

Microsoft Excel

• Customization Table
• age Setup & Alignment
• Page Margin & Padding
• Page Printing
• Formulas and Functions
• Result Card
• Sale Invoice
• Installment Plan
• Admission Form Listing
• Student Card Listing
• Sale Report
• Cash Report
• Income Tax
• GST
• Sale Tax
• Roznamcha Register

PowerPoint

• Create A PowerPoint presentation
• Page & Setup Alignment
• Page Margin & Setting

Data Entry

• Web Research
• Data Collection on Google Search 
• Different Companies Collection on Google or Website
• Page & Setup Alignment
• Page Margin & Setting
• Data Mining
• Data Scraping

Typing & Tech

• Urdu Typing
• English Typing
• Arabic Typing
• Math Typing

Other Skill

• Create A Bootable USB
• Windows Installation
• Office Installation

Office Management Course in Lahore

Office Management Essentials Skill for Modern Workplace

1. Explore Word
   1. Working in the user interface
   2. Creating, editing text and saving documents
      1. Creating a new blank document
      2. Entering text
      3. Saving the document
      4. Saving into a new folder
      5. Compatibility with older versions
   3. Opening, moving around in and closing documents
   4. Viewing documents in different ways
      1. Switching between different views
      2. Displaying non-printing characters
      3. Zooming in the document
      4. Switching between different word documents
      5. Arranging windows of open documents
      6. Displaying rulers in document window
   5. Editing and Proofread Text
   6. Making text changes
      1. Selecting text
      2. Deleting text
      3. Drag and drop
      4. Cut, Copy and Paste
      5. Paste Options
      6. Undo and redo
   7. Office clipboard
   8. Find and replace text
      1. Using find and replace
      2. Navigation pane
   9. Fine-tuning text
      1. Thesaurus
      2. Mini-translator
   10. Correcting spelling and grammatical errors
       1. Spell check
       2. Auto Correct
   11. Viewing document statistics
   12. Inserting saved text
       1. Building Blocks
       2. Create a new building block
   13. Changing the Look of Text
   14. Quickly formatting text
       1. Paragraph styles
       2. Character Styles
   15. Changing a document’s theme
       1. Switching between different themes
       2. Saving a new theme
   16. Manually changing the look of characters
       1. Changing font, font size and font colour
       2. Bold, Italic and Underline
       3. Using the Mini Toolbar
       4. Format Painter
       5. Font dialog box
       6. Highlight text
       7. Clear Formatting
   17. Manually changing the look of paragraphs
       1. Indenting
       2. First Line and hanging indents
       3. Paragraph alignment
       4. Setting up Tabs
       5. Adjusting line spacing
       6. Paragraph spacing
       7. Borders and Shading
   18. Character formatting and case considerations
   19. Find and replace formatting
   20. Creating and modifying lists
       1. Bullets and Numbering
       2. Customizing bullets and numbering
       3. Sorting lists
       4. Formatting text as you type
   21. Organizing Information in Columns and Tables
   22. Presenting information in columns
       1. Inserting columns
       2. Justify paragraphs
       3. Column options
   23. Creating tabbed lists
   24. Presenting info in tables
       1. Inserting a table
       2. Inserting and deleting columns and rows
       3. Resizing columns
       4. Merge cells
       5. Table alignment
       6. Converting text to table
   25. Performing calculations in tables
   26. Other layout options & formatting table
       1. Manual formatting
   27. Add Simple Graphic Elements
   28. Inserting and modifying pictures
       1. Insert Picture
       2. Resize and crop a picture
       3. Picture corrections and picture styles
       4. Artistic effects
   29. About ClipArt
   30. Changing a document background
   31. Inserting Building Blocks
       1. Inserting a Cover page
       2. Inserting Page Numbers
       3. Headers and Footers
   32. Microsoft Word Intermediate
   33. Creating Diagrams
       1. Creating and Positioning a diagram
       2. Using the text pane
       3. Inserting shapes into a diagram
       4. Promoting and Demoting shapes in diagram
       5. Change a diagram’s layout, colours and shapes
       6. Use picture diagrams to show photographs
   34. Insert and Modify Charts
       1. Insert a chart into a document
       2. Customize a chart, and save it as template
       3. Plot Excel data in a chart
       4. Formatting a chart
       5. Changing chart types
       6. Adding axis titles and labels
       7. Insert WordArt into the document
       8. Wrap text around Word Art
   35. Preview, Print and Distribute Documents
   36. Previewing and adjusting page layout
       1. Adjusting Page size and orientation
       2. Setting up margins
   37. Controlling what happens on each page
       1. Page breaks
       2. Section breaks
   38. Printing documents
   39. Preparing documents for electronic distribution
       1. Document properties
       2. Document inspector
       3. Marking a document as final
   40. Use other visual elements
       1. Adding text and graphic watermarks
       2. Insert a symbol
       3. Building an equation and add it to the equation gallery
       4. Draw and manipulate shapes
       5. Insert a screen clipping
   41. Organize & Arrange Content
       1. Reorganize a document by adjusting its outline
       2. Arranging multiple pictures
       3. Insert and format nested tables
   42. Creating Documents for use outside of word
       1. Save files in different formats
       2. Creating and modifying web documents
       3. Create and publish blog posts
   43. Explore More Text Techniques
       1. Adding hyperlinks
       2. Inserting fields
       3. Adding Bookmarks and Cross References
   44. Use Reference Tools for Longer Documents
       1. Adding Footnotes and End notes
       2. Creating and Modifying Table of contents
       3. Table of figures
       4. Table of Authorities
       5. Creating and modifying indexes
       6. Adding Sources and compiling bibliographies
       7. Creating Master Documents
   45. Work with Mail Merge
       1. Understanding Mail Merge
       2. Preparing Data Sources
       3. Using an Outlook Contact List as a Data Source
       4. Preparing Main Documents
       5. Merging Main Documents and Data Sources
       6. Printing Envelopes
       7. Sending Personalized Emails to Multiple Recipients
       8. Creating and Printing Labels
   46. Collaborate on Documents
       1. Co-authoring Documents
       2. Sending Documents Directly from Word
       3. Adding and Reviewing Comments
       4. Tracking and Managing Document Changes
       5. Comparing and Merging Document Changes
       6. Password-Protecting Documents
       7. Restricting Who Can Do What to Documents
       8. Controlling Changes
   47. Working in Word More Efficiently
       1. Working with Styles and Templates
       2. Default Program Options
       3. Customizing the Ribbon
       4. Customizing the Quick Access Toolbar
   48. Macros in Word
       1. Enabling Macros
       2. Recording a New Macro
       3. Running a Macro
       4. Copying a Macro from one Document to another
   49. Setting up a Workbook
       1. Creating Workbooks
       2. Excel Terminology
       3. Excel Environment
       4. Customizing Quick Access Toolbar
       5. Creating a New Workbook
       6. Entering Data into Workbook
       7. Saving a Workbook
       8. Open a Workbook
       9. Zoom
       10. Insert a New Worksheet
       11. Renaming a New Worksheet
       12. Changing the Tab Colour of Worksheet
       13. Rearranging the Order of Worksheets
       14. Move or Copy Worksheet
       15. Hide/Unhide Worksheet
       16. Switch Windows
   50. Modifying Workbooks and Worksheets
   51. Changing Column Widths and Row Heights
       1. Insert Columns/Rows
       2. Delete Columns/Rows
       3. Hide/Unhide Columns or Rows
       4. Insert Cells
       5. Moving Data by Dragging
2. Customizing Excel
   1. Arranging Multiple Workbook Windows
   2. Customizing the Ribbon
   3. Minimizing the Ribbon
   1. Working with Data and Excel Tables
      1. Entering Data
      2. Copy, Cut and Paste
      3. Pick from Drop Down List
      4. Find and Replace Data
      5. Spell Check
      6. Thesaurus
      7. Format as Table
      8. Table Design
   2. Basic Formulas
      1. How to Create a Basic Formula
      2. Operators
      3. Copy Formula Down
      4. Absolute Cell Reference
   3. Basic Functions
      1. What is the Difference Between Formulas and Functions
      2. Insert a Function
      3. AutoSum, SUM, MIN, MAX, and AVERAGE
   4. Changing Workbook Appearance
   5. Format Cells
      1. Changing Font, Font Size, and Font Colour
      2. Borders
      3. Bold, Italic, and Underline
      4. Fill Colour
   6. Themes
   7. Format Numbers as Percentage, Currency, and General
   8. Insert a Picture
      Picture Styles, Remove Background, Picture Effects
      Insert Background
   9. Printing
      1. Inserting Headers and Footers
      2. Print Preview
      3. Page Setup
      4. Page Break Preview
      5. Print Active Worksheets
      6. Print Entire Workbook
      7. Print Selection
      8. Print Titles
      9. Set Print Area
      10. Centre Data on Page
   10. Performing Calculations
       1. Naming groups of Data using Named Ranges
       2. Creating Formulas to Calculate Values
       3. Summarizing data meets specific condition using IF function
   11. Formula Auditing
       1. Adding a Watch Window
       2. Tracing Formula Errors
       3. Tracing Precedents and Dependent Cells
   12. Changing workbook appearance
       1. Defining Styles
       2. Making Numbers Easier to Read
       3. Transposing Data
       4. Changing Cell Orientation and Merging Cells
       5. Change Appearance of Data Based on Its Value
   13. Focusing on specific data by using filters
       1. Inserting Filters
       2. Sort A to Z using Filters
       3. Number Filters
       4. Clear Filters
       5. Advanced Filtering (Criteria Range)
       6. Summarizing Worksheets with Hidden and Filtered Rows (Subtotal and Aggregate Functions)
       7. Data Validation
3. Microsoft PowerPoint Basic
   1. Explore Powerpoint
      1. Working with the user interface
      2. Creating and saving presentations
      3. Compatibility with earlier versions
      4. Opening, moving around in, and closing presentations
      5. Viewing presentations in different ways
   2. Working with slides
      1. Adding and deleting slides
      2. Adding slides with ready-made content
      3. Slide Libraries
      4. Exporting presentations as outlines
      5. Dividing presentations into sections
      6. Rearranging slides and sections
   3. Reordering and summarizing data
      1. Sort Data
      2. Custom Lists
      3. Organizing Data into Levels Using Subtotals
      4. Creating an Outline
      5. Lookup Functions
   4. Combining Data from Multiple Sources
      1. Using Excel’s Built-in Templates
      2. Using Workbooks as Templates for Other Workbooks
      3. Linking to Data in Other Workbooks
      4. Consolidating Data
      5. Saving Workbooks as a Workspace
   5. Comments in Cells and Workbooks
      1. Viewing Comments in a Worksheet
      2. Adding and Removing Comments
      3. Adding Comments to a Workbook
   6. Protection
      1. Password Protect a Worksheet and Workbook
      2. Unlock Cells and Protecting Part of a Worksheet
      3. Track Changes
         Mark a Workbook as Final
   7. Format slides
      1. Applying Themes
      2. Using Different Theme Colours and Fonts
      3. Changing the Slide Background
      4. Changing the Look of Placeholders
      5. Changing the Alignment, Spacing, Size and Look of Text
   8. Add simple visual enhancements
      1. Insert Picture and ClipArt Images
      2. Inserting Diagrams
      3. Graphic Formats
      4. Converting Existing Bullets into a Diagram
      5. Inserting Charts
      6. Inserting Shapes
      7. Connecting Shapes & Adding Transitions
   9. Working with slide content
      1. Entering Text into Placeholders
      2. Adding Text Boxes
      3. Changing the Default Font for Text Boxes
      4. Editing Text
      5. Clipboard
      6. Correcting and Sizing Text While Typing
      7. Checking Spelling and Choosing the Best Words
      8. Research Information
      9. Find and Replacing Text and Fonts
   10. Microsoft PowerPoint advanced
   11. Add tables
       1. Inserting Tables
       2. Formatting Tables
       3. Inserting and Updating Excel Worksheets
   12. Fine tune visual elements
       1. Editing Pictures
       2. Customizing Diagrams
       3. Formatting Charts
       4. Arranging Graphics
       5. Alt Text
   13. Add animation
       1. Using Ready Made Animation
       2. Customizing Animation Effects
   14. Add sound and movies
       1. Inserting and Playing Sounds
       2. Inserting and Playing Videos
       3. Inserting Videos from Websites
   15. Share and review presentations
       1. Collaborating with Other People
       2. Broadcasting Presentations
       3. Saving Presentations in Other Formats
       4. Sending Presentations Directly from PowerPoint
       5. Password Protecting Presentations
       6. Adding and Reviewing Comments
       7. Merging Presentations Versions
   16. Create Custom Presentation Elements
       1. Creating Theme Colours and Fonts
       2. Viewing and Changing Slide Masters
       3. Creating Slide Layouts
       4. Saving Custom Design Templates
   17. Prepare for delivery
       1. Adapting Presentations for Different Audiences
       2. Rehearsing Presentations
       3. Recording Presentations
       4. Preparing Presentations for Travel
       5. Saving Presentations as Videos
   18. Customize PowerPoint
       1. Change Default Program Options
       2. Customizing the Ribbon
       3. Customizing the Quick Access Toolbar