The Resource Microsoft Excel 2010 plain & simple, Curtis D. Frye
Microsoft Excel 2010 plain & simple, Curtis D. Frye
Resource Information
The item Microsoft Excel 2010 plain & simple, Curtis D. Frye represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Internet Archive - Open Library.This item is available to borrow from all library branches.
Resource Information
The item Microsoft Excel 2010 plain & simple, Curtis D. Frye represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Internet Archive - Open Library.
This item is available to borrow from all library branches.
- Summary
- An 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
- Language
- eng
- Extent
- 1 online resource (xiii, 303 pages
- Note
- Includes index
- Contents
-
- 1. 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
- 6. 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
- 11. 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
- Label
- Microsoft Excel 2010 plain & simple
- Title
- Microsoft Excel 2010 plain & simple
- Statement of responsibility
- Curtis D. Frye
- Title variation
- Microsoft Excel 2010 plain and simple
- Language
- eng
- Summary
- An 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
- Cataloging source
- UKM
- http://library.link/vocab/creatorDate
- 1968-
- http://library.link/vocab/creatorName
- Frye, Curtis
- Dewey number
- 005.54
- Illustrations
- illustrations
- Index
- index present
- LC call number
- HF5548.4.M523
- LC item number
- F787 2010
- Literary form
- non fiction
- Nature of contents
- dictionaries
- Series statement
- Plain & simple
- http://library.link/vocab/subjectName
-
- Business
- Electronic spreadsheets
- Logiciels
- Bureautique
- Tableaux statistiques
- Manuels
- Business
- Electronic spreadsheets
- Label
- Microsoft Excel 2010 plain & simple, Curtis D. Frye
- Note
- Includes index
- Carrier category
- volume
- Carrier category code
- nc
- Carrier MARC source
- rdacarrier
- Content category
- text
- Content type code
- txt
- Content type MARC source
- rdacontent
- Contents
-
- 1. 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
- 6. 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
- 11. 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
- Extent
- 1 online resource (xiii, 303 pages
- Form of item
- online
- Media category
- unmediated
- Media MARC source
- rdamedia
- Media type code
- n
- Other physical details
- color illustrations)
- Specific material designation
- remote
- System control number
- (OCoLC)1039968985
- Label
- Microsoft Excel 2010 plain & simple, Curtis D. Frye
- Note
- Includes index
- Carrier category
- volume
- Carrier category code
- nc
- Carrier MARC source
- rdacarrier
- Content category
- text
- Content type code
- txt
- Content type MARC source
- rdacontent
- Contents
-
- 1. 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
- 6. 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
- 11. 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
- Extent
- 1 online resource (xiii, 303 pages
- Form of item
- online
- Media category
- unmediated
- Media MARC source
- rdamedia
- Media type code
- n
- Other physical details
- color illustrations)
- Specific material designation
- remote
- System control number
- (OCoLC)1039968985
Library Links
Embed (Experimental)
Settings
Select options that apply then copy and paste the RDF/HTML data fragment to include in your application
Embed this data in a secure (HTTPS) page:
Layout options:
Include data citation:
<div class="citation" vocab="http://schema.org/"><i class="fa fa-external-link-square fa-fw"></i> Data from <span resource="http://link.archive.org/portal/Microsoft-Excel-2010-plain--simple-Curtis-D./EGp4wLmZQGM/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.archive.org/portal/Microsoft-Excel-2010-plain--simple-Curtis-D./EGp4wLmZQGM/">Microsoft Excel 2010 plain & simple, Curtis D. Frye</a></span> - <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.archive.org/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.archive.org/">Internet Archive - Open Library</a></span></span></span></span></div>
Note: Adjust the width and height settings defined in the RDF/HTML code fragment to best match your requirements
Preview
Cite Data - Experimental
Data Citation of the Item Microsoft Excel 2010 plain & simple, Curtis D. Frye
Copy and paste the following RDF/HTML data fragment to cite this resource
<div class="citation" vocab="http://schema.org/"><i class="fa fa-external-link-square fa-fw"></i> Data from <span resource="http://link.archive.org/portal/Microsoft-Excel-2010-plain--simple-Curtis-D./EGp4wLmZQGM/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.archive.org/portal/Microsoft-Excel-2010-plain--simple-Curtis-D./EGp4wLmZQGM/">Microsoft Excel 2010 plain & simple, Curtis D. Frye</a></span> - <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.archive.org/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.archive.org/">Internet Archive - Open Library</a></span></span></span></span></div>
