MS Excel Advanced, Workshop, 1 Day
MS Excel is an important computer program that most people think is only for data capturing in rows and columns but there’s a lot of functions that come with excel that make it more superior that MS Word and all this will be introduced to learners as per outline below. The format of this Training above will be classroom training at the client’s premises.
The content to be covered during the Training will be as per below:
- Create and Edit a Macro
- Update Workbook Properties
- Apply Conditional Formatting
- Add Data Validation Criteria
- Trace Cells
- Create a Data List Outline
- Create Sparklines
- Create Scenarios
- Perform a What-If Analysis
- Perform a Statistical Analysis with the Analysis ToolPak
- Create Interactive Data with Power View
- Consolidate Data
- TLink Cells in Different Workbooks
- Merge Workbooks
- Export Excel Data
- Import a Delimited Text File
- Integrate Excel Data with the Web
- Create a Web Query
Download course outline here