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