| Document Type
|
:
|
BL
|
| Record Number
|
:
|
1029752
|
| Doc. No
|
:
|
b784122
|
| Main Entry
|
:
|
McFedries, Paul.
|
| Title & Author
|
:
|
Teach yourself visually Excel 2010 /\ by Paul McFedries.
|
| Publication Statement
|
:
|
Indianapolis, IN :: Wiley,, ©2010.
|
| Series Statement
|
:
|
Teach yourself visually
|
|
|
:
|
Visual read less, learn more
|
| Page. NO
|
:
|
339 pages :: color illustrations ;; 24 cm.
|
| ISBN
|
:
|
0470577649
|
|
|
:
|
: 9780470577646
|
| Notes
|
:
|
Includes index.
|
| Contents
|
:
|
1. Working with Excel : Getting to know Excel ; Start Excel ; Tour the Excel window ; Work with Excel's ribbon ; Work with Excel's galleries ; Customize the quick access toolbar ; Customize the ribbon ; Work with smart tags ; Change the view ; Configure Excel options ; Add Excel to the Windows 7 taskbar ; Quit Excel -- 2. Entering and editing Excel data : Learning the layout of a worksheet ; Understanding the types of data you can use ; Enter text into a cell ; Enter a number into a cell ; Enter a date or time into a cell ; Insert a symbol ; Edit cell data ; Delete data from a cell -- 3. Working with Excel ranges : Select a range ; Fill a range with the same data ; Fill a range with a series of values ; Move or copy a range ; Insert a row or column ; Insert a cell or range ; Delete data from a range ; Delete a range ; Hide a row or column ; Freeze rows or columns ; Merge two or more cells ; Transpose rows and columns -- 4. Working with range names : Understanding the benefits of using range names ; Define a range name ; Use worksheet text to define a range name ; Navigate a workbook using range names ; Change a range name ; Delete a range name ; Paste a list of range names -- 5. Formatting Excel ranges : Change the font and font size ; Apply font effects ; Change the font color ; Align text within a cell ; Center text across multiple columns ; Rotate text within a cell ; Add a background color to a range ; Apply a number format ; Change the number of decimal places displayed ; Apply an AutoFormat to a range ; Apply a conditional format to a range ; Apply a style to a range ; Change the column width ; Change the row height ; Wrap text within a cell ; Add borders to a range ; Copy formatting from one cell to another.
|
|
|
:
|
11. Analyzing Excel data : Sort a range ; Filter a range ; Set data validation rules ; Convert a range to a table ; Create a data table ; Summarize data with subtotals ; Group related data ; Analyze data with Goal Seek ; Analyze data with scenarios ; Create a PivotTable ; Load Excel's analysis ToolPak -- 12. Visualizing data with Excel charts : Examining chart elements ; Understanding chart types ; Create a chart ; Add chart titles ; Add data labels ; Position the chart legend ; Display chart gridlines ; Display a data table ; Change the chart layout and style ; Select a different chart type ; Change the chart source data ; Move or resize a chart ; Add a sparkline to a cell -- 13. Formatting Excel charts : Format chart elements ; Customize a chart element background ; Set a chart element's outline ; Add effects to a chart element ; Apply a style to a chart element ; Apply a WordArt style to chart text -- 14. Adding and editing worksheet graphics : Draw a shape ; Insert a clip art image ; Insert a photo ; Insert a WordArt image ; Insert a SmartArt graphic ; Move or resize a graphic ; Crop a picture ; Format a picture ; Add a shadow or glow to a picture ; Add a reflection or 3-D effect to a picture ; Add an artistic effect to a photo ; Recolor an image -- 15. Collaborating with other people : Add a comment to a cell ; Protect a worksheet's data ; Protect a workbook's structure and windows ; Share a workbook with other users ; Track workbook changes ; Accept or reject workbook changes ; Send a workbook as an e-mail attachment ; Save Excel data as a web page ; Make a workbook compatible with earlier versions of Excel ; Collaborate on a workbook online.
|
|
|
:
|
6. Building formulas and functions : Understanding Excel formulas ; Build a formula ; Understanding Excel functions ; Add a function to a formula ; Add a row or column of numbers ; Build an AutoSum formula ; Add a range name to a formula ; Reference another worksheet range in a formula ; Move or copy a formula ; Switch to absolute cell references ; Toggle the formula bar on and off ; Troubleshoot formula errors -- 7. Manipulating Excel worksheets : Navigate a worksheet ; Rename a worksheet ; Create a new worksheet ; Move a worksheet ; Copy a worksheet ; Delete a worksheet ; Change the gridline color ; Toggle worksheet gridlines on or off ; Toggle worksheet headings on and off ; Set the worksheet tab color ; Set the worksheet background ; Zoom in on or out of a worksheet ; Split a worksheet into two panes ; Hide and unhide a worksheet -- 8. Dealing with Excel workbooks : Create a new blank workbook ; Create a new workbook from a template ; Save a workbook ; Open a workbook ; Arrange workbook windows ; Find text in a workbook ; Replace text in a workbook ; Check spelling and grammar ; Close a workbook -- 9. Formatting Excel workbooks : Modify the workbook colors ; Set the workbook fonts ; Choose workbook effects ; Apply a workbook theme ; Add a workbook header ; Add a workbook footer -- 10. Printing Excel workbooks : Adjust the workbook margins ; Change the page orientation ; Insert a page break ; Choose a paper size ; Set the print area ; Configure titles to print on each page ; Preview the printout ; Print a workbook.
|
| Abstract
|
:
|
Clear, step-by-step screen shots show you how to tackle more than 150 Excel 2010 tasks. Each task-based spread covers a single technique, sure to help you get up and running on Excel 2010 in no time.
|
| Subject
|
:
|
Business-- Computer programs.
|
| Subject
|
:
|
Electronic spreadsheets-- Computer programs.
|
| Subject
|
:
|
Business-- Computer programs.
|
| Subject
|
:
|
Electronic spreadsheets-- Computer programs.
|
| Subject
|
:
|
Microsoft Excel (Computer file)
|
|
|
:
|
Microsoft Excel (Computer file)
|
| Dewey Classification
|
:
|
005.54
|
| LC Classification
|
:
|
HF5548.4.M523M3759 2010
|
| NLM classification
|
:
|
005.54 M143t
|
|
|
:
|
COM054000bisacsh
|
| Parallel Title
|
:
|
Teach yourself visually Microsoft Excel 2010
|
| Spine Title
|
:
|
Microsoft Excel 2010
|