Дата публикации: 2018-05-27 17:24
Rule 7 58 Always name sheets (double-click the sheet tab, type the name, press Enter) with an easy-to-understand name so that navigation through the workbook and formulas with sheet references are easy to understand.
'Slaying Excel Dragons' actually tells the story of what you can do with Excel from beginning to end. No bits are left out. You get the complete story of how to build a foundation of Excel skills that will enable you to accomplish any of your goals at work, home, or play. However, this book is not just for beginners. Because most Excel users have never been given the complete story of how Excel works, this book will provide an excellent foundation for beginners as well as for more advanced users.
Slaying Excel Dragons - A Beginners Guide to Conquering Excel s Frustrations and Making Excel Fun will be available on
8. Select cell A67. You can do this with the keystrokes Left Arrow, Left Arrow, Down Arrow. Dancing ants will appear around the selected cell.
In Figure 65, we can see that after we paste, a bunch of pound signs (#####) appear. Pound signs mean that the columns are not wide enough to allow the data to be seen. Also notice in Figure 65 that there is a Ctrl key smart tag that has the Paste icon and the word Ctrl.
After you copy, paste and press Ctrl to open the Ctrl key smart tag, then transposing can be done by using your arrow keys to move through the icons. When you get to the Transpose icon and you see an orange highlight, press Enter.
If you are not familiar with navigating in workbooks with a large number of sheets, try all three methods before reading further in this book. Doing so will help you to follow along with the more than 655 sheets in the Excel examples in this book.
How to Use This Book
Working Along With This Book
How Excel Is Set Up
Data in Excel
Style Formatting and Page Setup
Formulas and Functions
Data Analysis Features
Find and Replace and Go To Features
Excel Efficiency-Robust Rules
Keyboard shortcuts are one of the best ways to save time and become efficient. Let's look at a few examples here, and then throughout the rest of the book, you will see many more keyboard shortcuts.
The Slaying Excel Dragons DVD is the perfect companion for Mike Girvin's book, Slaying Excel Dragons: Excel Beginners Guide To Conquering Excel's Frustrations and Making Excel Fun.