Plano Independent School District. Microsoft Excel Advanced

Description

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.