审计excel 培训 excel training.pptxVIP

Updated May 2014;Introduction;Introduction;Summary;Formatting/Layout;Cell Formatting Menu :;Cell’s format is accessible via click right ;Custom – See excel;Conditional formatting is a handy tool to format the cells based in their value or text they contain. It is interesting to use this feature when you want to quickly identify inconsistent or unwanted values. In particular, it identifies duplicates in a list.;Before printing you can select a range of cells and set the print area to make sure of what is printed.;To freeze rows or columns for printing(often the first line of a larg