Menu Close

Microsoft Excel

Microsoft Excel is a software program produced by Microsoft that allows users to create, organize, format and calculate data with formulas using a spreadsheet system. This software is part of the Microsoft Office suite and is compatible with other applications in the Office suite. MS Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a library of supplied functions to answer statistical, engineering and financial needs. Its specialised features like What-if analysis, charts, data management, validation features make stand special among all other competitors.

This course suits everyone who learns the basics of computer operation and word processing, to carry on routine daily operations and help them land employment or advance an existing career.

  • Computer Operator
  • Office Assistant
  • Admin Assistant

Students and business entrepreneurs who want to prepare statements, graphs and perform data management.

Introduction to Excel
• Introduction to Worksheets
• Introduction to Workbooks
• Cell, Column, Row, Range
• Entering / Editing data
• Copying / Moving data
• Reposition the data in cell
• Wrap text in a cell, Merge cells
• Move or copy cells / cell contents
• Copy specific cell contents
• Cell borders, Cell shading
• Text color, Text Formatting
• Gridlines, Sheet Background
• Selecting the cells
• Navigation in the worksheet
• Organizing the sheets
• Entering & Formatting Titles
• Worksheet calculations
• Formatting Rows/Columns
• Hiding Columns/Rows/Sheets
• Lock Cell
• Cell Alignment, Font styles
• Cell Formatting, Cell Styles
• Cell Referencing
• Row Height, Column Width
• Find, Replace, Goto
• Conditional Formatting
• Format as Table
• Number Series, Fill Handle
• Adding Formulas
• Formula bar, Status bar
• Math Functions
• Text Functions
• Date& Time Functions
• Logical functions
• IF function
• Add Pictures/Shapes
• W ordArt
• Smart Art graphic
• Screenshot
• Create Table
• Sort Data i n Table
• Filter Data i n Table
• Page Layout
• Themes, Colors, Effects
• Margins, Size, Orientation
• Page breaks, Page scaling
• Page background
• Print setup
• Print area, Print titles
• Gridlines, Headings
• Creating Graphs/Charts
• Types of Charts
• Insert Text Box
• Header & Footer
• Insert Object
• Insert Symbol
• Data Sort
• Data Filter
• Data Validation
• Macros – Record, Execute
• Add Header & Footer
• Workbook Views – types
• Freeze /Unfreeze panes
• Create Payrolls/Tables
• Keyboard shortcuts