Holden, Greg.
Excel 2010 In Simple Steps ebook. - 1st ed. - 1 online resource (257 pages)
Cover -- Microsoft� Excel 2010 -- Use Your Computer With Confidence -- Contents At a Glance -- Contents -- Top 10 Excel 2010 Tips -- Launch Excel -- Select a Cell -- Select a Worksheet -- Create a Basic Formula -- Create a Chart From All Chart Types -- Create a Table -- Draw a Shape -- Configure Page Size and Orientation -- Protect a Worksheet -- Share a Worksheet -- Chapter 1: Starting to Use Excel -- Launch Excel -- Create a New Workbook -- Create a Workbook From a Template -- Open An Existing Workbook -- Explore the Ribbon -- Select Menu Commands -- Work With the Quick Access Toolbar -- Select Dialogue Box Options -- Use the Status Bar -- Use Task and Window Panes -- Navigate a Workbook -- Manage Multiple Windows -- Save a Workbook -- Switch Views -- Change Workbook Properties -- Find Help While You'Re Working -- Update Excel -- Close a Workbook and Quit Excel -- Chapter 2: Learning Essential Workbook Techniques -- Select a Cell -- Select Multiple Rows or Columns -- Make Special Range Selections -- Select Multiple Worksheets -- Enter a Label -- Enter a Value -- Enter Data Using Autofill -- Insert or Delete Cells -- Clear Cell Contents -- Find Cell Contents -- Replace Cell Contents -- Move Cell Contents Using the Clipboard -- Move Data Using Drag-and-Drop -- Check Your Spelling -- Translate Text -- Change Proofing Options -- Chapter 3: Managing Workbooks and Worksheets -- Select a Worksheet -- Name or Rename a Worksheet -- Move a Worksheet -- Copy a Worksheet -- Insert a Column or Row -- Delete a Column or Row -- Hide or Display a Worksheet -- Hide or Display a Workbook -- Hide or Display a Column or Row -- Freeze or Unfreeze a Column or Row -- Adjust Column Width or Row Height -- Divide a Worksheet Into Panes -- Format Numbers -- Format Text -- Apply Conditional Formatting By Comparison. Apply Conditional Formatting Based on Ranking and Average -- Manage Conditional Formatting -- Add Colour to Cells -- Apply a Pattern to a Cell -- Chapter 4: Creating Formulas and Functions -- Create a Basic Formula -- Display Formulas -- Activate Formula Autocomplete -- Use Formula Autocomplete -- Edit a Formula -- Copy a Formula -- Use Absolute Cell References -- Use Mixed Cell References -- Name a Cell or Range With the Name Box -- Identify a Cell or Range With the New Name Dialogue Box -- Add a Named Cell or Range to a Formula -- Enter a Name With the Use in Formula Command -- Organise Names -- Simplify a Formula With Ranges -- Display Calculations With the Status Bar -- Calculate Totals With Autosum -- Convert Formulas to Values -- Create a Custom Calculation -- Chapter 5: Working With Charts -- Select the Type of Chart You Need -- Select From All Chart Types -- Select Parts of a Chart -- Edit a Chart -- Format Chart Elements -- Move a Chart -- Resize a Chart -- Edit a chart's Title -- Change Chart Labels -- Change a chart's Type -- Adjust Layout and Style -- Change a chart's Axis -- Work With Pie Charts -- Format Chart Text -- Change a chart's Background -- Create a Pivotchart From a Pivottable -- Customise a Pivotchart -- Modify a Pivotchart -- Chapter 6: Interpreting Worksheet Data With Tables -- Create a Table -- Apply a Style to a Table -- Modify a Table Style -- Show or Hide Parts of a Table -- Total Data in a Table -- Insert a Row or Column -- Resize a Table -- Delete Rows or Columns -- Enter Data With a Drop-Down List -- Create a Drop-Down List -- Sorting Table Data -- Analysing Data With a Pivottable or Pivotchart -- Update a Pivottable -- Convert Text to Columns -- Create An Outline -- Chapter 7: Creating and Modifying Graphics and Shapes -- Locate and Insert Clip Art -- Resize and Move An Image -- Find More Clip Art Online. Dividing Clip Art Into Categories -- Change Clip Art Properties -- Adding Artwork to the Clip Organizer -- Remove Artwork From the Clip Organizer -- Scale An Image -- Change Brightness and Contrast -- Draw a Shape -- Resize a Shape -- Add Text to a Shape -- Draw a Line or Arrow -- Apply a Quick Style to a Line -- Copy or Move An Object -- Fill An Object With Colour -- Distribute Objects -- Chapter 8: Publishing Workbooks and Worksheets -- Configure Page Size and Orientation -- Customise Page Size -- Adjust Page Margins -- Use the Ruler to Adjust Margins -- Customise Margin Settings -- Create Headers and Footers -- Insert a Page Break -- Specify the Print Area -- Preview a Worksheet Before Printing -- Print a Worksheet -- Create a Pdf File -- Create An Xps Document -- Save a Workbook As a Webpage -- Open a Workbook in Webpage Format -- Preview a Webpage -- Create a Hyperlink -- Format a Hyperlink -- Chapter 9: Protecting and Securing Your Data -- Protect a Worksheet -- Lock and Unlock Worksheet Cells -- Lock Other Worksheet Elements -- Encrypt a Workbook -- Password Protect a Workbook -- Set Add-in Security Options -- Add a Digital Signature -- View a Digital Signature -- Adjust Message Bar Security Options -- Set Privacy Options -- Make a Workbook Read-Only -- Adjust Macro Security Settings -- Chapter 10: Sharing Your Data With Your Colleagues -- Share a Worksheet -- Configure Sharing Options -- Create a Cell Comment -- Read a Comment -- Edit a Cell Comment -- Track Changes -- Review Tracked Changes -- Email a Workbook for Review -- Work With Xml -- Change Xml Properties -- Export Data in Xml -- Export Data -- Import a Text File -- Link Data -- Get External Data -- Manage Connections -- Top 10 Excel 2010 Problems Solved -- Excel Isn'T Working Properly. What Can I Do to Fix It? -- How Do I Enable Save Mode? -- How Do I Correct An Excel Formula?. I Can'T Send My Workbook Via Email. What Can I Do? -- How Do I Check An Excel Worksheet for Errors? -- How Do I Remove Comments From Worksheets? -- I Need to Adjust a Formula, How Do I Evaluate It First? -- How Do I Find a Missing Add-in? -- How Do I Troubleshoot Invalid Data? -- How Do I Ensure That Excel Opens and Displays a Workbook?.
9780273736783
Electronic spreadsheets.
Electronic books.
HF5548.4.M523
005.54
Excel 2010 In Simple Steps ebook. - 1st ed. - 1 online resource (257 pages)
Cover -- Microsoft� Excel 2010 -- Use Your Computer With Confidence -- Contents At a Glance -- Contents -- Top 10 Excel 2010 Tips -- Launch Excel -- Select a Cell -- Select a Worksheet -- Create a Basic Formula -- Create a Chart From All Chart Types -- Create a Table -- Draw a Shape -- Configure Page Size and Orientation -- Protect a Worksheet -- Share a Worksheet -- Chapter 1: Starting to Use Excel -- Launch Excel -- Create a New Workbook -- Create a Workbook From a Template -- Open An Existing Workbook -- Explore the Ribbon -- Select Menu Commands -- Work With the Quick Access Toolbar -- Select Dialogue Box Options -- Use the Status Bar -- Use Task and Window Panes -- Navigate a Workbook -- Manage Multiple Windows -- Save a Workbook -- Switch Views -- Change Workbook Properties -- Find Help While You'Re Working -- Update Excel -- Close a Workbook and Quit Excel -- Chapter 2: Learning Essential Workbook Techniques -- Select a Cell -- Select Multiple Rows or Columns -- Make Special Range Selections -- Select Multiple Worksheets -- Enter a Label -- Enter a Value -- Enter Data Using Autofill -- Insert or Delete Cells -- Clear Cell Contents -- Find Cell Contents -- Replace Cell Contents -- Move Cell Contents Using the Clipboard -- Move Data Using Drag-and-Drop -- Check Your Spelling -- Translate Text -- Change Proofing Options -- Chapter 3: Managing Workbooks and Worksheets -- Select a Worksheet -- Name or Rename a Worksheet -- Move a Worksheet -- Copy a Worksheet -- Insert a Column or Row -- Delete a Column or Row -- Hide or Display a Worksheet -- Hide or Display a Workbook -- Hide or Display a Column or Row -- Freeze or Unfreeze a Column or Row -- Adjust Column Width or Row Height -- Divide a Worksheet Into Panes -- Format Numbers -- Format Text -- Apply Conditional Formatting By Comparison. Apply Conditional Formatting Based on Ranking and Average -- Manage Conditional Formatting -- Add Colour to Cells -- Apply a Pattern to a Cell -- Chapter 4: Creating Formulas and Functions -- Create a Basic Formula -- Display Formulas -- Activate Formula Autocomplete -- Use Formula Autocomplete -- Edit a Formula -- Copy a Formula -- Use Absolute Cell References -- Use Mixed Cell References -- Name a Cell or Range With the Name Box -- Identify a Cell or Range With the New Name Dialogue Box -- Add a Named Cell or Range to a Formula -- Enter a Name With the Use in Formula Command -- Organise Names -- Simplify a Formula With Ranges -- Display Calculations With the Status Bar -- Calculate Totals With Autosum -- Convert Formulas to Values -- Create a Custom Calculation -- Chapter 5: Working With Charts -- Select the Type of Chart You Need -- Select From All Chart Types -- Select Parts of a Chart -- Edit a Chart -- Format Chart Elements -- Move a Chart -- Resize a Chart -- Edit a chart's Title -- Change Chart Labels -- Change a chart's Type -- Adjust Layout and Style -- Change a chart's Axis -- Work With Pie Charts -- Format Chart Text -- Change a chart's Background -- Create a Pivotchart From a Pivottable -- Customise a Pivotchart -- Modify a Pivotchart -- Chapter 6: Interpreting Worksheet Data With Tables -- Create a Table -- Apply a Style to a Table -- Modify a Table Style -- Show or Hide Parts of a Table -- Total Data in a Table -- Insert a Row or Column -- Resize a Table -- Delete Rows or Columns -- Enter Data With a Drop-Down List -- Create a Drop-Down List -- Sorting Table Data -- Analysing Data With a Pivottable or Pivotchart -- Update a Pivottable -- Convert Text to Columns -- Create An Outline -- Chapter 7: Creating and Modifying Graphics and Shapes -- Locate and Insert Clip Art -- Resize and Move An Image -- Find More Clip Art Online. Dividing Clip Art Into Categories -- Change Clip Art Properties -- Adding Artwork to the Clip Organizer -- Remove Artwork From the Clip Organizer -- Scale An Image -- Change Brightness and Contrast -- Draw a Shape -- Resize a Shape -- Add Text to a Shape -- Draw a Line or Arrow -- Apply a Quick Style to a Line -- Copy or Move An Object -- Fill An Object With Colour -- Distribute Objects -- Chapter 8: Publishing Workbooks and Worksheets -- Configure Page Size and Orientation -- Customise Page Size -- Adjust Page Margins -- Use the Ruler to Adjust Margins -- Customise Margin Settings -- Create Headers and Footers -- Insert a Page Break -- Specify the Print Area -- Preview a Worksheet Before Printing -- Print a Worksheet -- Create a Pdf File -- Create An Xps Document -- Save a Workbook As a Webpage -- Open a Workbook in Webpage Format -- Preview a Webpage -- Create a Hyperlink -- Format a Hyperlink -- Chapter 9: Protecting and Securing Your Data -- Protect a Worksheet -- Lock and Unlock Worksheet Cells -- Lock Other Worksheet Elements -- Encrypt a Workbook -- Password Protect a Workbook -- Set Add-in Security Options -- Add a Digital Signature -- View a Digital Signature -- Adjust Message Bar Security Options -- Set Privacy Options -- Make a Workbook Read-Only -- Adjust Macro Security Settings -- Chapter 10: Sharing Your Data With Your Colleagues -- Share a Worksheet -- Configure Sharing Options -- Create a Cell Comment -- Read a Comment -- Edit a Cell Comment -- Track Changes -- Review Tracked Changes -- Email a Workbook for Review -- Work With Xml -- Change Xml Properties -- Export Data in Xml -- Export Data -- Import a Text File -- Link Data -- Get External Data -- Manage Connections -- Top 10 Excel 2010 Problems Solved -- Excel Isn'T Working Properly. What Can I Do to Fix It? -- How Do I Enable Save Mode? -- How Do I Correct An Excel Formula?. I Can'T Send My Workbook Via Email. What Can I Do? -- How Do I Check An Excel Worksheet for Errors? -- How Do I Remove Comments From Worksheets? -- I Need to Adjust a Formula, How Do I Evaluate It First? -- How Do I Find a Missing Add-in? -- How Do I Troubleshoot Invalid Data? -- How Do I Ensure That Excel Opens and Displays a Workbook?.
9780273736783
Electronic spreadsheets.
Electronic books.
HF5548.4.M523
005.54
Hong Kong Nang Yan College of Higher Education
Lee Yan Fong Library
325-329 Lai Chi Kok Road, Shamshuipo, Kowloon, HONG KONG
Lee Yan Fong Library
325-329 Lai Chi Kok Road, Shamshuipo, Kowloon, HONG KONG