Office Mangement

About The Course

Office management

An office manager serves as the supervisor for administrative support staff and also ensures that the office runs smoothly. Office management course covers different administrative positions and duties. Students learn ways to supervise, how to communicate effectively with staff and how to build relationships.

Microsoft Word

Page Setup, Formatting Basic Text, Adding Headers & Footers, Formatting Tables, Keyboard Shortcuts, Inserting Pictures, Inserting Clip Art, Inserting Shapes, Inserting SmartArt, Merging a mailing list to produce labels, Adding a bookmark, Creating a Table of Contents, Creating Endnotes, Creating Footnotes, On Set Assignments

MS Access

Building the structure of a database. Create a new database. Create a table using the design view. Manage tables. Set table field properties. Creating relationships between tables. Modify, add, and delete table fields. Sort and filter records in table. Create a Query, Add Criteria to a Query, Compile field to multiple table, and Add a Calculated Field to a Query, Perform Calculations on a Record Grouping. Create form by using wizard, Create form by design view, Changing the Look of Forms Changing the Arrangement of Forms. Create sub forms. Creating Reports by Using a Wizard, Modifying Report Design, Previewing and Printing Reports. Create and use a switchboard, Exporting Data to an Excel Workbook, Creating Word Mail Merge Documents, Importing Data, Linking Data to an Access Table and Protect Database.

MS Excel

Set up print options for single and multiple worksheets, Work with multiple worksheets, Format worksheets to suit needs, Add graphic elements to a chart, Create and work with charts, Enter formulas and work with formulas and functions, Use advanced features such as Goal Seek and the Analysis Identify, Identify the ways to use a scenario, Use macros to automate complex and repetitive tasks, Create custom functions, Send workbooks through e-mail, Use auditing features and incorporate comments in Excel, Create and work with PivotCharts, Create and work with PivotTables, Use data outlining and consolidating features, Use sorting and filtering features, Identify elements of a list, Identify database functions, Use the nested IF function, Use advanced functions and Assignments.

MS PowerPoint

Changing The Slide Layout, Adding Additional Slides, Creating a Slide Design, Using WordArt Styles, Creating & Formatting Chart, Using Action Buttons, Outputting a Presentation, Keyboard Shortcuts, On Set Assignments

Urdu In page & Internet

Introduction to Languages, Page Setup, Keyboard View & Setting, Creating Tables, Formatting, Print Setting, Introduction to internet, getting to connect internet, browsing, searching, downloading, creating email address, using email address

Course Outline

Peachtree Introduction

  • Installation Peachtree
  • Starting Peachtree
  • Opening a sample company
  • Peachtree Menus

New Company Set-up

  • New Company Set-up Wizard
  • Real-Time vs. Batch Posting
  • Accounting Periods
  • Chart of Accounts
  • General Journal Entries

Inventory

  • Inventory Defaults
  • Adding Items
  • Maintain Sale Price
  • Set Trade Discount in Items
  • Set Unit Measure
  • Inventory Reports
  • Entering Inventory Beginning Balances

Accounts Payable

  • Vendor Defaults
  • Adding Vendors
  • Purchase Orders
  • Purchase Invoices
  • Entering Payments
  • Purchase Return
  • Accounts Payable Reports
  • Purchase Discount

Accounts Receivable

  • Customer Defaults
  • Sales Taxes
  • Adding Customers
  • Quotes
  • Sales Orders
  • Sales Invoices
  • Applying Customer Receipts
  • Accounts Receivable Reports
  • Sale Return
  • Cash Discount

Payroll

  • Payroll Setup Wizard
  • Adding Employee
  • Entering Employee

Reports

  • Financial Statements
  • Balance Sheet

Security

  • Admin
  • Users
  • Backup & Restore
  • Import & Export
  • Create PDF