The Resource Microsoft Excel 2010 plain & simple, Curtis D. Frye

Microsoft Excel 2010 plain & simple, Curtis D. Frye

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
Creator
Subject
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
Member of
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
Link
https://archive.org/details/microsoftexcel200000frye
Instantiates
Publication
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
Link
https://archive.org/details/microsoftexcel200000frye
Publication
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 Locations

  • Internet ArchiveBorrow it
    300 Funston Ave, San Francisco, CA, 94118, US
    37.7823215 -122.4716373

Library Links

Processing Feedback ...