|
Provided by: NobleProg - IT training courses Excel Introduction Training CourseExcel |
 |
|
|
||||||||||
Introduction
Running Microsoft Excel
Excel elements
Managing workbooks and worksheets
Entering Data into Spreadsheet
Formatting
Changing number and date formatting (currency, percentage, etc...)
Formating cell's borders and background
Formating row and column headers
Styles in Excel
Excel Navigation
Moving around a big spread sheet
Dealing with multiple workbooks projects
Copying and Moving data
Selecting and moving ranges of data
Paste Special utility
Filling spreadsheet with series of data (dates, weekdays, sequential number, etc..)
Formulas, Addresses and Names of Cells
Creating and moving formulas
When to use absolute and relative address
Solving circular reference problem
Conditional formatting
Referening other worksheets and workbooks
Creating and utilizing cells name
Excel Functions
Basic information about functions and Excel
Basic functions
Functions nesting
Conditional functions
Intesrt function dialogue box
Drawing
WordArt and Autoshapes
Static and dynamic graphics
Charts
Charts types and their utilization
Creating clear charts
Charts elements and their modification
Creating chart types
Hiding and Protecting Data
Hiding sheets, columns and rows
Hiding formulas and cells' data
Protecting sheets and workbooks against changes
Protecting workbooks from viewing
Printing
Printing spreadsheets
Printing charts
