Excel - VBA
This 1 day course progresses from the one day introduction course to study multiple worksheets, charts and drawings, databases, statistical functions and other useful features of Lotus 123
Pre Requisites
Users should have completed an Introduction to Lotus 123 course or are familiar with basic formulas and entering/ editing data
Course Objectives
Linking worksheets and workbooks, Setting up, analysing and reporting on lists, Creating charts, If Statements, lookup Wizards , Other useful features of Lotus 123
Course Content
• Splitting Screens
• Freezing Panes
• Hide/Unhide
▪ Hide Columns & Rows
▪ Hide Worksheets
• AutoFill
▪ Stepping through Range Fill
▪ Creating Custom Lists
• Relative v. Absolute
• If Function
▪ Other Logical Operators
• Lookup Tables
• Multiple Worksheets
▪ Navigating
▪ Renaming sheets
▪ Manipulating sheets
▪ Selecting§ Formatting
▪ Calculating
• File & Sheet Linking
• Graphical Images
▪ Inserting Pictures or Clipart
▪ The Drawing Toolbar
• Charts / Graphs
▪ Chart Terms
▪ Using the Chart Wizard
▪ Formatting the Charts
▪ Printing Charts
• Databases
▪ Data Form
▪ Sorting
▪ Filtering
▪ Advanced Filter
▪ Calculating
-----------------------
l
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- excel vba userform listbox multiselect
- free excel vba code samples
- excel vba commands
- excel vba code library
- excel vba quick reference pdf
- excel vba listbox multiple selection
- excel vba character code
- excel vba guide pdf
- excel vba reference
- excel vba reference library
- excel vba listbox selected value
- excel vba cheat sheet