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