excel与ppt在管理中的高级运用（The use of Excel and PPT in the senior management of the）.docVIP

excel与ppt在管理中的高级运用（The use of Excel and PPT in the senior management of the） [training number]: [training program]: Chapter 1, Excel data statistics and analysis I. Basic Techniques for substantially improving efficiency (basic skills are not familiar? The appearance of the table is too plain Worried about the leaked form? These questions can be found in this chapter 1. efficient data entry skills Master advanced selection and input skills, double operation efficiency The format of the data cell is customized by heart 2. beautification of financial statements Fast projecting important data Basic elements of beautifying a form Use the cell validity and conditional formatting to beautify the table 3. upgrade form security Hide the data you dont want others to see in the financial statements Add a lock to your Excel form file Two. Data reference and preliminary arrangement (quick access to data, so manual input is no longer tedious) 1. references data from multiple tables and multiple Excel files 2. refer to data in a more intuitive way 3. get data from other programs and format quickly Three. The soul of Excel - formulas and functions (Excels soul, proficiency in commonly used functions, allowing data to automatically analyze and calculate, and make you an expert in efficiency.) 1. function using methods and skills 2. commonly used dates and text functions 3. commonly used statistics and financial functions 4. so many functions, is there a self-study method? 5., the formula is wrong, what should I do? Four depth data mining and analysis Using powerful analysis and prediction tools to make Excel an analytical tool.) 1. general sorting and custom sorting 2. automatic screening and advanced screening 3. use aggregation to generate reports quickly 4. trick: use depth chart for depth analysis Five. Improve data insight (intuitive diagrams make it easier for us to discover the laws behind the data, and also the main way we report to our superiors and colleagues. This chapte