Record ID | ia:microsoftexcel200000frye |
Source | Internet Archive |
Download MARC XML | https://archive.org/download/microsoftexcel200000frye/microsoftexcel200000frye_marc.xml |
Download MARC binary | https://www.archive.org/download/microsoftexcel200000frye/microsoftexcel200000frye_meta.mrc |
LEADER: 08214cam 2200637 a 4500
001 ocn619919197
003 OCoLC
005 20180331235752.0
008 101220s2010 waua 001 0 eng
010 $a 2010284384
040 $aUKM$beng$cDLC$dUKM$dBTCTA$dIK2$dC#P$dYDXCP$dWI9WB$dVP@$dJRN$dUOI$dEINCP$dUKMGB$dBDX$dT3V$dEEK$dOCLCF$dBEDGE$dOCLCQ$dUV1$dOCLCQ$dOCLCO
015 $aGBB052723$2bnb
016 7 $a015535271$2Uk
019 $a609544301
020 $a9780735627277$q(pbk.)
020 $a0735627274$q(pbk.)
035 $a(OCoLC)619919197$z(OCoLC)609544301
042 $alccopycat
050 00 $aHF5548.4.M523$bF787 2010
082 04 $a005.54$222
084 $a14.2 FRYE 2010$2z
100 1 $aFrye, Curtis,$d1968-
245 10 $aMicrosoft Excel 2010 plain & simple /$cCurtis D. Frye.
246 3 $aMicrosoft Excel 2010 plain and simple
260 $a[Redmond, Wash.] :$bMicrosoft ;$aSebastopol, Calif. :$bO'Reilly Media,$c℗♭2010.
300 $axiii, 303 pages :$bcolor illustrations ;$c19 x 24 cm.
336 $atext$btxt$2rdacontent
337 $aunmediated$bn$2rdamedia
338 $avolume$bnc$2rdacarrier
490 1 $aPlain & simple
500 $aIncludes index.
520 $aAn illustrated guide to using Microsoft Office Excel 2010 that covers the interface; creating, building, managing, formatting, and viewing workbooks; using formulas and functions; formatting and printing worksheets; customization; sorting and filtering data; and more.
505 0 $a1. Introduction: about this book : No computerese! ; Useful tasks ; ... And the easiest way to do them ; A quick overview ; A few assumptions ; A final word (or two) -- 2. What's new and improved in Excel 2010 : Managing Excel files and settings in backstage view ; Previewing data using paste preview ; Customizing the Excel 2010 user interface ; Summarizing data using more accurate functions ; Summarizing data using sparklines ; Visualizing data using improved conditional formats ; Creating and displaying math equations ; Editing pictures within Excel 2010 -- 3. Getting started with Excel 2010 : Surveying the Excel program window ; Starting Excel ; Finding and opening existing workbooks ; Using file properties ; Creating a new workbook ; Working with multiple workbooks ; Sizing and viewing windows ; Zooming in or out on a worksheet ; Viewing a worksheet in full-screen mode ; Saving and closing an Excel workbook ; Using the Excel help system -- 4. Building a workbook : Understanding how Excel interprets data entry ; Navigating the worksheet ; Selecting cells ; Entering text in cells ; Entering numbers in cells ; Entering dates and times in cells ; Entering data using fills ; Entering data with other shortcuts ; Creating an Excel table ; Editing cell contents ; Inserting a symbol in a cell ; Creating hyperlinks ; Cutting, copying, and pasting cell values ; Clearing cell contents ; Using the Office Clipboard ; Undoing or redoing an action ; Finding and replacing text ; Checking the spelling of your worksheet -- 5. Managing and viewing worksheets : Viewing and selecting worksheets ; Renaming worksheets ; Moving worksheets ; Copying worksheets ; Inserting and deleting worksheets ; Hiding or showing a worksheet ; Changing worksheet tab colors ; Inserting, moving, and deleting cells ; Inserting, moving, and deleting columns and rows ; Hiding and unhiding columns and rows ; Entering data and formatting many worksheets at the same time ; Changing how you look at Excel workbooks ; Naming and using worksheet views.
505 0 $a6. Using formulas and functions : Creating simple cell formulas ; Assigning names to groups of cells ; Using names in formulas ; Creating a formula that references values in an Excel table ; Creating formulas that reference cells in other workbooks ; Summing a group of cells without using a formula ; Creating a summary formula ; Summing with subtotals and grand totals ; Exploring the Excel function library ; Using the IF function ; Checking formula references ; Debugging your formulas -- 7. Formatting the cell : Formatting cell contents ; Formatting cells containing numbers ; Formatting cells containing dates ; Adding cell backgrounds and shading ; Formatting cell borders ; Defining cell styles ; Aligning and orienting cell contents ; Formatting a cell based on conditions ; Changing how conditional formatting rules are applied ; Stop when a condition is met ; Displaying data bars, icon sets, or color scales based on cell values ; Deleting conditional formats ; Copying formats with format painter ; Merging or splitting cells or data -- 8. Formatting the worksheet : Applying workbook themes ; Coloring sheet tabs ; Changing a worksheet's gridlines ; Changing row heights and column widths ; Inserting rows or columns ; Moving rows and columns ; Deleting rows and columns ; Outlining to hide and show rows and columns ; Hiding rows and columns ; Protecting worksheets from changes ; Locking cells to prevent changes -- 9. Printing worksheets : Previewing worksheets before printing ; Printing worksheets with current options ; Choosing whether to print gridlines and headings ; Choosing printers and paper options ; Printing part of a worksheet ; Printing row and column headings on each page ; Setting and changing print margins ; Setting page orientation and scale ; Creating headers and footers ; Adding graphics to a header or a footer ; Setting and viewing page breaks -- 10. Customizing Excel to the way you work : Opening ready-to-use workbook templates ; Adding commands to the Quick Access Toolbar ; Modifying the ribbon user interface ; Controlling which error messages appear ; Defining AutoCorrect and AutoFormat entries.
505 0 $a11. Sorting and filtering worksheet data : Sorting worksheet data ; Creating a custom sort list ; Filtering data quickly with AutoFilter ; Creating an advanced filter ; Validating data for correctness during entry -- 12. Summarizing data visually using charts : Creating a chart quickly ; Changing a chart's appearance ; Formatting chart legends and titles ; Changing the body of a chart ; Customizing chart data ; Working with common charts ; Working with uncommon charts ; Adding a trendline to a chart ; Summarizing data using sparklines -- 13. Enhancing your worksheets with graphics : Adding graphics to worksheets ; Adding drawing objects to a worksheet ; Adding fills to drawing objects ; Adding effects to drawing objects ; Customizing pictures and objects ; Aligning and grouping drawing objects ; Using WordArt to create text effects in Excel ; Inserting clip art into a worksheet ; Inserting and changing a diagram ; Creating an organization chart ; Adding an equation to a shape -- 14. Sharing Exel data with other programs : Linking and embedding other files ; Exchanging table data between Excel and Word ; Copying Excel charts and data into PowerPoint ; Exchanging data between Access and Excel ; Importing a text file -- 15. Using Excel in a group environment : Sharing workbooks in Excel ; Commenting in cells ; Tracking changes in workbooks ; Accepting or rejecting changes ; Saving worksheets to the Web ; Dynamically update worksheets published to the Web ; Retrieving Web data using Excel ; Modifying Web queries ; Interacting over the Web using XML.
630 00 $aMicrosoft Excel (Computer file)
650 0 $aBusiness$xComputer programs.
650 0 $aElectronic spreadsheets.
650 7 $aLogiciels.$2eclas
650 7 $aBureautique.$2eclas
650 7 $aTableaux statistiques.$2eclas
650 7 $aManuels.$2eclas
630 07 $aMicrosoft Excel (Computer file)$2fast$0(OCoLC)fst01366659
650 7 $aBusiness$xComputer programs.$2fast$0(OCoLC)fst00842283
650 7 $aElectronic spreadsheets.$2fast$0(OCoLC)fst00907463
630 07 $aMicrosoft Excel (Computer file)$2sears
830 0 $aPlain & simple.
938 $aBrodart$bBROD$n11417951$c$24.99
938 $aBaker and Taylor$bBTCP$nBK0008940333
938 $aYBP Library Services$bYANK$n3378162
029 1 $aAU@$b000045826325
029 1 $aNZ1$b13453084
029 1 $aUKDOR$b121612244
029 1 $aUNITY$b121612244
994 $aZ0$bPMR
948 $hNO HOLDINGS IN PMR - 364 OTHER HOLDINGS