Microsoft Excel

MS Office training at APEC offers administrative assistants requiring a strong knowledge of Word to project management positions demanding strong Excel ability, yielding real benefits in the workplace. Microsoft Office is the world’s most popular productivity suite made by Microsoft, as a collection of computer programs for home users and business users. APEC also provides advanced Microsoft Office training online.

  • Easily format information in Excel with tools and auto-complete data



CERTIFYING BODY

  • Microsoft
  • Inhouse Certification

CAREER PROSPECTS

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

SYLLABUS:

Introdction 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