Microsoft Excel Module 5 (Half Day)
Sponsored links
To interrogate lists of data in a database scenario and create sub-sets of data and cross-tabular reports
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
Duration:
Half a day (9:30 am to 12:30 pm or 1:30 pm to 4:30 pm).
Who Should Attend:
Those who use Excel regularly and need to put to use database management tools incorporating cross-tabular reporting.
Course Content:
● Creating A Database - Use Excel to set up a list of data relating to a particular subject.
● Searching - Use the search tool to locate a particular data record for editing/deleting.
● Filtering - Filter a database to select records matching a given criterion.
● Extracting Data - Extract records into a sub-set for further analysis.
● Reporting - Use the PivotTable Report tool to produce cross-tabular reports from a database
● Macros - Learn the process of recording simple macros to speed up the process of repetitive tasks. Create a Personal Macro Library and assign macros to toolbar buttons.
This Training Course is taught in classrooms in the following locations:
Sheffield
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
