Excel 2010 - Sorting and Filtering Data, Formatting Numbers and Conditional Formatting |
| |
The "Excel 2010 - Sorting and Filtering Data, Formatting Numbers and Conditional Formatting" lesson covers the following topics:- Sorting and Filtering Data
- Custom and Conditional Formats
|
|
| |
Sorting and Filtering Data |
|
| |
Upon successful completion you will be able to:
1. Filter Data; 2. Apply Multiple Search Criteria; 3. Customise Filters; 4. Sort with AutoFilters; 5. Remove Filters; 6. Sort on Multiple Columns; 7. Add and Remove Subtotals; 8. Display Unique Values; 9. Remove Duplicate Entries.
|
|
| |
Custom and Conditional Formats |
|
| |
Upon successful completion you will be able to:
1. Apply Built-in Numeric Formats; 2. Identify Built-in Numeric Formats; 3. Create a Custom Numeric Format; 4. Use Conditional Formatting; 5. Use the Rule Manager; 6. Display Icon Sets; 7. Use Data Bars; 8. Clear Rules.
|
|
| This course can be purchased either individaully or as part of a package. |
| Single Training Course - Excel 2010 - Sorting and Filtering Data, Formatting Numbers and Conditional Formatting : |  |
| Program Training Courses - Microsoft Excel 2010 : |  |
| Office Suite Training Courses - Microsoft Office 2010 : |  |
|
| © 2017 Online Training Masters |