Excel 2013 All-in-One For Dummies
Format: PDF / Kindle (mobi) / ePub
The comprehensive reference, now completely up-to-date for Excel 2013!
As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.
- Covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions
- Walks you through the new analysis tools that help make it easier to visualize data with the click of a mouse
- Details new ways to explore your data more intuitively and then analyze and display your results with a single click
Whether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, Excel 2013 All-in-One For Dummies has everything you need to know.
Within the scroll bar until the columns or rows that you want to see appear on the screen in the Worksheet area. When you hold down the Shift key as you scroll, the scroll button within the scroll bar becomes really narrow, The Excel 2013 User Experience You can use the Scroll Lock key to “freeze” the position of the cell pointer in the worksheet so that you can scroll new areas of the worksheet in view with keystrokes such as PgUp (Page Up) and PgDn (Page Down) without changing the cell.
The cell range listed in the Import List from Cells text box. (The range in this box lists the first cell and last cell in the current selected range separated by a colon — you can ignore the dollar signs following each part of the cell address.) To check that the cell range listed in the Import List from Cells text box includes all the entries for the custom list, click the Collapse Dialog Box button, located 108 Data Entry 101 to the right of the Import List from Cells text box. When you.
Enter .123 in a cell. ✦ Truncates decimal places in a number to display the whole numbers in a cell when the number contains too many digits to be displayed in the current column width. It also converts the number to scientific notation when the column width is too narrow to display all integers in the whole number. Remember that you can always override the General number format when you enter a number by entering the characters used in recognized number formats. For example, to enter the.
Bars, Color Scale, Icon Set, Greater Than, Top 10%, and Clear Format) displayed. You can then use Live Preview to sample how the selected data would appear in different conditional formats. When you see one you like, you can then apply it by clicking the particular conditional formatting option button. Identifying particular values or text entries in a cell range The options attached to the Highlight Cell Rules and Top/Bottom Rules items on the Conditional Formatting button’s drop-down menu.
New rules by clicking the New Rule button to open the New Formatting Rule dialog box. (See the “Creating your own conditional formatting rules” section immediately preceding.) ✦ Edit existing rules by selecting the rule in the Rule list box and clicking the Edit Rule button in the Editing Formatting Rule dialog box (which looks just like the New Formatting Rule dialog box except it contains the rule type, criteria, and formatting for the particular rule you selected). ✦ Delete rules by.