Внимание!!! AdBlock блокирует показ некоторых скриншотов. Пожалуйста, все вопросы к разработчкикам
Автор
Сообщение
Galfimbul
Excel Timesaving Techniques For Dummies - Over 60 Timesavers
Год: 2004 Автор: Greg Harvey Жанр: Справочник Издательство: Wiley Серия: For Dummies Язык: Английский Формат: PDF Качество: Отсканированные страницы Интерактивное оглавление: Нет Количество страниц: 408 Описание: Few things are more disappointing to me as a software trainer than F to see people who have just enough basic knowledge to work in a sophisticated program such as Excel waste inordinate amounts of time doing their work “the hard way" because they don‘t really know how to go about harnessing the program’s features. This book is a vehicle for taking that next step into efficient use of Microsoft Excel, a program about which I have written a great deal and am naturally very partial. It is my sincere hope that it helps you become not only more competent in Excel but also much more confident in your ability to use rather than be used by it.
Part I: Making Excel Work Your Way 5 Technique 1: Customizing the Excel Screen Display 7 Technique 2: Customizing the Excel Menus and Toolbars 13 Technique 3: Perfecting Your Spreadsheet Workspace 19 Technique 4: Saving Your Worksheets So You Can Find Them 22 Technique 5: Tailoring Excel’s Error Checking to Your Needs 27 Technique 6: Utilizing Excel’s Editing Settings 31 Technique 7: Streamlining Excel Programm Startup 36 Technique 8: Saving Time with Excel Add-ins 40 Part II: Quick Worksheet Creation Tricks 45 Technique 9: Navigating the Worksheet in a Snap 47 Technique 10: Making the Most Efficient Cell Selections 53 Technique 11: Speeding Through Long Data Entries with AutoCorrect 58 Technique 12: Data Entry Tricks 62 Technique 13: Speeding Up Data Entry with AutoFill 67 Technique 14: Ensuring Accurate Data Entries with Data Validation 72 Technique 15: All Aboard the Numerical Entry Express! 78 Technique 16: Verifying Entries with Text to Speech 82 Part III: Handy Ways to Format and Present Worksheet Data 85 Technique 17: Instant Range Formatting 87 Technique 18: Style Formatting Magic 92 Technique 19: Controlling When Certain Formats Are Used 97 Technique 20: Customizing Number Formats 102 Technique 21: Dazzling Alignments for Data Entries 111 Technique 22: Charting Data in a Snap 117 Technique 23: Chart Customization Tricks 123 Part IV: Worksheet Formula Timesavers 129 Technique 24: Efficient Formula Copying 131 Technique 25: Speeding Up Table Creation with Array Formulas 137 Technique 26: Using Range Names 141 Technique 27: Smarter Formula Construction 148 Technique 28: Trapping Those Terrible Errors 154 Technique 29: Eliminating Errors with Error Tracing 158 Technique 30: Creating Efficient Date and Time Formulas 164 Part V: Worksheet Editing Timesavers 169 Technique 31: Quickly Finding the Workbook You Want to Edit 171 Technique 32: Controlling the Worksheet Window Display 177 Technique 33: Managing Worksheet Windows 182 Technique 34: Quick and Easy Insertion and Deletion 187 .......and other
Доп. информация: Excel 2003
Внимание! AdBlock блокирует показ скриншотов, все вопросы к разработчикам )))