Excel Part - I
- Excel menu system, toolbar and shortcut
keys
- Work with Excel sheets - rename, move, add
& delete, copy & paste, hide & unhide, tab color, background
- Work with columns and rows - width/height,
copy & paste, move, hide & unhide, auto-fit
- Work with range and cells - copy and paste,
move, add comments, name range, auto fill, clear contents/format/comments
- Work with options - show/hide column
headers, gridlines, tab, scroll bars, zero values, comments, auto/manual calculations
- Basic print setup - print area setup,
margin, header & footer, fit into one page, center on page, etc.
- Basic functions - value lookup, logical,
math & trig, date & time, etc.
- Basic format and conditional format -
number, date and time, currency, accounting, scientific, special
- Basic charts - chart type, chart options,
format data series/line types
- Basic sort and filter
- Basic data entry validation
- Find & replace, insert symbols
- Normal view, page break view, zoom view,
show/hide toolbars, status bars and formula bars
- Import external data/text files and export
sheet as csv files
- Record macros and assign macros to buttons,
macro security
- Brief introduction to some advanced
features
VBA Part - I
- Introduction to VBA editor menu system
- Introduction to VBA - object based programming language
- Introduction to Excel objects
- Record and modify macros, assign macros to buttons
- Define variables, constants, and control structures
- Write user's own functions and procedures
- Work with Excel objects -worksheet, range, and cells
|