Advanced Office Applications specialized on Excel and Access (Long-Term Course)

Course Content

  • Introduction to Computer
  • Introduction to computer
  • Classification of different types of computer
  • Application of different types of computer
  • Basic components of  a computer
  • Basic Operation of Operating System
  • Basic use of computer
  • Turn on the pc
  • Identifying File-Folder-Drive
  • Open a new file
  • Search for an existing file
  • Find location of  a file
  • Change location of files
  • Change file installing  a new hardware
  • Antivirus and Computer Security
  • The Basics (Excel)
  • Creating a New Workbook
  • Navigating in Excel
  • Moving the Cell Pointer
  • Using Excel Menus
  • Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
  • Entering Values in a Worksheet and Selecting a Cell Range
  • Previewing and Printing a Worksheet
  • Getting Help from the Office Assistant
  • Saving a Workbook & Re-opening a saved workbook

 

What you will learn

  • Formatting a Worksheet
  • Creating Headers, Footers, and Page Numbers
  • Adjusting Page Margins and Orientation
  • Adding Print Titles and Gridlines, rows to repeat at top of each page
  • Formatting Fonts & Values
  • Adjusting Row Height and Column Width
  • Changing Cell Alignment
  • Adding Borders
  • Applying Colors and Patterns
  • Using the Format Painter
  • Using AutoFormat
  • Merging Cells, Rotating Text, and using AutoFit
  • Using AutoFill
  • Managing your workbooks
  • Switching Between Sheets in a Workbook
  • Inserting and Deleting Worksheets
  • Renaming and Moving Worksheets
  • Protecting a Workbook
  • Hiding Columns, Rows and Sheets
  • Splitting and Freezing a Window
  • Inserting Page Breaks
  • Advanced Printing Options
  • Editing a Workbook
  • Entering Date Values and using AutoComplete
  • Editing, Clearing, and Replacing Cell Contents
  • Cutting, Copying, and Pasting Cells
  • Moving and Copying Cells with Drag and Drop
  • Collecting and Pasting Multiple Items
  • Using the Paste Special Command
  • Inserting and Deleting Cells, Rows, and Columns
  • Using Undo, Redo, and Repeat
  • Checking Your Spelling

 

Requirements & who can attend

There are no formal entry requirements for the course. The qualification is open to all – from school leavers to post graduates and employees who want to increase their skills in work place, be more efficient and more employable.

 

Learn by doing

Able to:

  • Improves your productivity in your work
  • Helps you present information in a better way
  • Get rid of writing on papers and start making charts
  • You can also access excel online from anywhere even your mobile phone.
  • Be efficient at work place

Course at a Glance

Price:

Starting and Ending Date

Last Date of Registration

Class Schedule

Enroll Now

Resource Person