|
|
| Advanced Excel with Macros |
UNIT 1:
- Introduction
- Excel
- WORKSHUTS WITHIN WORKBOOK
- Excel
- Workshuts within workbook
- Enter and edit data
- All
- Range of all
- Entering and copying the formula
- All references
- Setting the column width
- Inserting alls column & rows
- Importance of functions
- Functions with examples
- Operators
- Logical operators
- Autosum
UNIT 2:
- Range name
- Conditional formatting
- Auto fill
- Applying background & work sheet
- Format paints
- Applying all border
- Applying fornt format
- Excercises
UNIT 3: Graphic objects and charts
- Graphic objects
- Conditional formatting
- Word art
- Charts
- Colouring different part of the chart
- Adding a data series
- Chart-toolbars
- Combination charty
- Excercises
UNIT 4: Database
- Database
- Dataform
- Creating a database
- Data consolidation
- Validation
- Pivot table
- Excercises
UNIT 5: Dynamic data range controls
- Function offset
- Index function
- Controls
- Creating list box
- Compo box
- Option button
- Check boxes
UNIT 6: Database
- Window
- Protection
- Auditing
- What if analysis
- Data tables
- Scenario manages
- Excercises
|
| |
|
|
|
|
