For help content on your search phrase, click the option Get Help on "search phrase". You can also access Help from the File menu. In any Office app, click File and in the top right corner, click the familiar? Or use the F1 function key anytime to open the Help Viewer window for the Office app you are working on. You can also add a help shortcut to your Quick Access Toolbar if you want to be able to get to it easily.
Here's how:. Under the dropdown where it says Choose commands from , select All Commands. When you're done, click OK. The shortcut to help will be added to your Quick Access Toolbar in the upper-left corner. Need more help? Work with stocks and geography data. Turn your data into insights. List of all Excel functions available. IF function. Create a drop-down list.
Combine text from two or more cells. Create a PivotTable to analyze worksheet data. Design the layout and format of a PivotTable. Sort data in a PivotTable or PivotChart. Manage your finances Get a personal finance experience like never before in Excel. Sync your financial accounts, see spending trends, get personalized tips, and more. Explore Money in Excel. When you press Alt, Excel helps you out with KeyTips next to every tab, over the Office menu, and over the buttons in the Quick Access toolbar.
In some cases, a command might have two letters, in which case you need to press both keys, one after the other. To trigger it, press Alt, then H, then F, and then D.
You can back out of KeyTips mode without triggering a command at any time by pressing the Alt key again. These are key combinations that start with the Ctrl key. Usually, you find out about a shortcut key by hovering over a command with the mouse. The traditional File menu that lets you open, save, and print files has been transformed into the Office menu. You get there using the Office button, which is the big round logo in the top-left corner of the window Figure I The Office menu is generally used for three things:.
Working with files creating, opening, closing, and saving them. Printing your work Chapter 7 and sending it off to other people by email Chapter Configuring how Excel behaves. Choose Excel Options at the bottom of the menu to get to the Excel Options dialog box, an all-in-one place for configuring Excel Section 1. You can then press the S key to choose the Paste Special command. Fortunately, Microsoft went to a little extra trouble to make life easier for longtime Excel aficionados.
The result is that you can still use your menu shortcuts, but they work in a slightly different way. All Excel gives you is the tooltip. However, the tooltip lets you know that Excel is paying attention.
Some menu commands hide submenus that have more commands. Take for instance the Print command. From the Office menu, you can choose Print to fire off a quick printout of your work. But if you click the right-pointing arrow at the edge of the Print command or if you hover over it for a moment , you see a submenu with more options, as shown in Figure I The Office menu is bigger and easier to read than a traditional menu.
It also has a list of the documents you used recently on the right side. Print is both a clickable menu command and holder of a submenu. To see the submenu, you need to hover over Print without clicking or click the arrow at the right edge shown here. The ribbon also has a few buttons that work this way. Keen eyes will have noticed the tiny bit of screen real estate that sits on the right side of the Office button, just above the ribbon.
It holds a series of tiny icons, like the toolbars in older versions of Excel Figure I These commands are singled out because most people use them more frequently than any other commands. However, the nifty thing about the Quick Access toolbar is that you can customize it.
The Appendix shows how. Microsoft has deliberately kept the Quick Access toolbar very small. Even if you go wild stocking the Quick Access toolbar with your own commands, the rest of the ribbon remains unchanged.
And that means a coworker or spouse can still use your computer without suffering a migraine. Other hot additions include:.
Fewer limits. Excel worksheets can now be bigger, formulas can be more complex, and cells can hold way more text. Although Faster speeds. One of the newest pieces of computing hardware is a dual core CPU. The CPU is the brain of any computer. A dual core CPU can perform two tasks at once, but it performs best with software that knows how to take advantage of the way it works.
Excel knows all about dual core CPUs, which means intense calculations are even faster on these computers. Better-looking charts. Excel shakes things up with a whole new graphics engine that lets you add fantastic looking charts, diagrams, and shapes to your spreadsheets. You can even throw in fancy effects like textures, shadows, and three-dimensional text. Part 4 deals with chapters and graphics.
Formula AutoComplete. The latest in a whole bunch of auto-do-something features, formula AutoComplete just might be the most helpful innovation yet. It prompts you with possible values when you type in complex formulas. When Microsoft created Excel , they added a wildly popular list feature that helped people manage lists of information.
In Excel , lists morph into tables and get even more powerful. Chapter 14 has all the details. Easier and prettier conditional formatting. Every spreadsheet designer wants to make sure important information stands out. Previous Excel versions had a conditional formatting feature to help out, but it was mind-numbingly difficult to use.
In Excel , conditional formatting gets much easier and picks up a few new frills—like a way to highlight values with shaded bars and tiny icons. Easier and prettier pivot tables. Pivot tables are one of the hidden gems in Excel. They let you slice and dice vast amounts of data to create intelligent, supremely flexible summaries. Excel takes the drudgery out of creating pivot tables and makes the final results easier to read. Chapter 21 tells their story.
0コメント