Microsoft Excel is an indispensable tool that has become an integral part of most business organizations across the globe. Excel is used for various purposes by different business establishments, from the micro to the large enterprises. No report is really complete without a few Excel based graphs or charts.

The course is to equip the participants with the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer.

• Indicate the names and functions of the Excel interface components
• Enter and edit data
• Format data and cells
• Construct formulas, including the use of built-in functions, and relative and absolute references
• Create and modify charts
• Preview and print worksheets
• Use the Excel online Help feature

Intro Section:

• Workplace Intelligence
• The Benefits
• The Staff and The Workplace
• Common Mistakes
• Workplace Intelligence: An Overview.

Part One:

• Workplace Dynamics
• When You Left For Work This Morning, What Did You Leave Behind?
• Hostile Working Environment
• Four Generations At Work
• Values And Generational Feedback
• Generational Interaction In The Workplace.

Part Two:

• What Is Organizational Culture?

Exploring Excel

• Finding and using commands
• Moving around a worksheet
• Navigating the workbook

Basic Workbook Skills

• Creating a workbook
• Selecting cells and ranges
• Opening, closing and saving workbooks
• Entering data into cells
• Entering values into ranges

Creating Simple Formulas

• Writing formulas in cells
• Using the Formula Bar
• AutoSum and other basic functions
• The Paste Function tool
• Automatic calculation

Copying And Moving Data

• Copying and cutting data
• Absolute cell references
• Filling cells
• Using drag-and-drop
• Undo and Redo
• Find and Replace

Managing Worksheets

• Naming worksheets
• Copying and moving worksheets
• Grouping worksheets
• Moving data between sheets
• Adding and deleting worksheets
• Creating 3-D formulas

Printing

• Choosing what to print
• Previewing and printing
• Page Setup
• Margins and page orientation
• Headers and footers
• Repeating column/row headings
• Page Break Preview
• Printing gridlines

Formatting Data And Cells

• Formatting numbers
• Formatting text
• Colouring data and cells
• Wrapping and shrinking text
• Merging cells
• Using indents
• Applying borders to cells
• The Format Painter
• Conditional formatting

Working With Columns and Rows

• Selecting columns and rows
• Changing column width and row height
• Hiding and unhiding
• Inserting and deleting

Using Large Spreadsheets

• Changing the magnification
• Full Screen view
• Splitting the window
• Using Freeze Panes

Named Ranges

• Naming a range of cells
• Jumping to a named range
• Using range names in formulas
• Re-defining and deleting range names

Working With Data Series

• Creating a linear series
• Working with Date series
• Using Autofill

• Management Trainee
• Specialist Staff
• Managers