Microsoft Excel Training

Home
Objectives
Presentation
Quiz
Exercises
Demonstration

Required attachments will be given during the training


Welcome to Microsoft Excel

This site is set for Microsoft Excel users to get hands on in just few days.It consists of Lecture Notes, Quiz's, Exercise's and many other tools to aid to prepare you to work with Microsoft Excel.

Microsoft Excel (full name Microsoft Office Excel) is a proprietary spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and, except for Excel 2008 for Mac OS X, a macro programming language called VBA (Visual Basic for Applications). It is overwhelmingly the dominant spreadsheet application available for these platforms and has been so since version 5 in 1993, and is bundled as part of Microsoft Office. Excel is one of the most popular microcomputer applications to date.
-------------------------------------------------------------------------------------
Objectives

Spreadsheet Basics

* Screen elements
* Adding and renaming worksheets
* The standard toolbar - opening, closing, saving, and more.

Modifying A Worksheet

* Moving through cells
* Adding worksheets, rows, and columns
* Resizing rows and columns
* Selecting cells
* Moving and copying cells
* Freeze panes
* Exercise

Formatting Cells

* Formatting toolbar
* Format Cells dialog box
* Dates and times
* Styles
* Style dialog box
* Create a new style
* Format Painter
* AutoFormat
* Exercise

Formulas and Functions

* Formulas
* Linking worksheets
* Relative, absolute, and mixed referencing
* Basic functions
* Function Wizard
* Autosum
* Exercise

Sorting and Filling

* Basic ascending and descending sorts
* Complex sorts
* Autofill
* Alternating text and numbers with Autofill
* Autofilling functions
* Exercise

Graphics

* Adding clip art
* Add an image from a file
* Editing a graphic
* AutoShapes
* Exercise

Charts

* Chart Wizard
* Resizing a chart
* Moving a chart
* Chart formatting toolbar
* Copy a chart to Microsoft Word
* Exercise

Page Properties and Printing

* Page breaks
* Page orientation
* Margins
* Headers, footers, and page numbers
* Print Preview
* Print
* Exercise

Customizing Excel

* Menus
* Customize toolbars
* Recording a macro
* Running a macro
* Exercise

Project

* Based on the Objectives

-------------------------------------------------------------------------------------
Presentation

Powerpoint Presentations are available for users to go through.

Introduction

Working with Data