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