MS Excel 2007 Introduction:
Our Introduction to Excel assumes no prior knowledge of the program and allows users to grasp key spreadsheet concepts as well as getting to grips with the powerful time-saving features unique to Excel.
Course Fees: Rs.1000/-
Duration: 8 Hours
Requires no experience of using Excel, just basic computing skills.
Course Outline…
Basics
Ø Standard toolbar overview
Ø Formatting toolbar overview
Ø Data entry
Ø Block selection
Ø Copying data
Ø Moving data
Ø Inserting cells, rows and columns
Ø Deleting cells, rows and columns
Ø Resizing rows and columns
Ø Using the AutoFit facility
Ø Undoing and redoing operations
Ø Spell checking
Ø Printing a spreadsheet
Formatting
Ø Setting alignment
Ø Using cell shading
Ø Adding borders to cells
Ø Using Autoformat
Ø Number and date Formats
Ø Creating styles
Ø Applying styles
Ø Modifying Styles
Ø Using conditional formatting
Formulas
Ø How formulas work
Ø About cell references
Ø About Excel ranges
Ø Overview of functions
Ø Using the AutoSum facility
Ø Using the formula palette
Ø Using conditionals
Ø Statistical functions
Ø Financial functions
Ø Creating external references
Charts
Ø Creating a chart
Ø Setting chart options
Ø Editing chart elements
Ø Editing chart data
Ø Adding logos and graphics
Ø Printing charts
Productivity
Ø Creating reports
Ø Setting print options
Ø Creating custom lists
Ø AutoCorrect
Ø Password protecting documents
Ø Protecting worksheets
Ø Using hyperlinks
Ø Save As Web Page
Web Page Preview
