E-Book Overview
Office Manager’s Training. – Plano, Texas: Plano Independent School District, 2010. – 29 p. (Автор не указан).
Contents: Formulas & Functions. AutoCalculate. Simple Formulas. Relative vs. Absolute Reference. Relative Reference. Absolute Reference. Statistical Functions. SUM. AVERAGE. MEDIAN. MODE. COUNT. MAX. MIN. Logical Functions. IF. Nested IF. VLOOKUP. HLOOKUP. Text Functions. Merging/Combining Cells. Merging Cells. Combining Cells. Text to Columns. Practice Exercise. Conditional Formatting. What is Conditional Formatting? Based on Cell Value. Based on Formula. Creating Charts. Importing Data. Text Files. Opening a Text File. Saving the File. Importing External Data. Options. Saving the File. Advanced Microsoft Excel - Security & Proofing. Security Features. Workbook Protection. Specifying a password for opening a workbook. Specifying a password for saving a workbook. Removing a Workbook Password. Worksheet Protection. Protecting Worksheets. Un-Protecting Worksheets. Data Validation. Setting Data Validation. Protecting/Unprotecting Cells. Creating the Input Message. Creating the Error Alert. Data Validation - Another Example. Data Validation - One More Example. Removing Data Validation. Text to Speech. Reading back a group of cells. Using Speak On Enter. Toolbars. Modifying Menus and Toolbars. Toolbar Options.
E-Book Content
Microsoft Excel Advanced
Office Manager’s Training December 13, 2010
Plano ISD - Instructional Technology
1
Advanced Microsoft Excel
Table of Contents Formulas & Functions_ ___________________________________________________________ 5 AutoCalculate____________________________________________________________________ 5 Simple Formulas__________________________________________________________________ 5 Relative vs. Absolute Reference_ ____________________________________________________ 6 Relative Reference__________________________________________________________ 6 Absolute Reference_ ________________________________________________________ 6 Statistical Functions_______________________________________________________________ 7 SUM_______________________________________________________________________ 7 AVERAGE_ _________________________________________________________________ 7 MEDIAN____________________________________________________________________ 7 MODE_____________________________________________________________________ 8 COUNT____________________________________________________________________ 8 MAX_ _____________________________________________________________________ 8 MIN_______________________________________________________________________ 8 Logical Functions__________________________________________________________________ 8 IF________________________________________________________________________ 8 Nested IF__________________________________________________________________ 8 VLOOKUP__________________________________________________________________ 9 HLOOKUP_________________________________________________________________ 10 Text Functions___________________________________________________________________ 11 Merging/Combining Cells____________________________________________________ 11 Merging Cells______________________________________________________________ 11 Combining Cells_ __________________________________________________________ 11 Text to Columns_ __________________________________________________________ 12 Practice Exercise_________________________________________________________________ 13 Conditional Formatting__________________________________________________________ 14 What is Conditional For