Technology Help & FAQ's

Excel 2010

  1. Customizing
  2. Excel 2010: Business Contact Manager 2010 in Excel 2010
  3. Excel 2010: Install and activate the Analysis ToolPak and Solver (Video Tutorial)
  4. Excel 2010: Introduction to the Excel Options dialog box (Video Tutorial)
  1. Editing Data
  2. Excel 2010: Data: Find or replace text and numbers on a worksheet
  3. Excel 2010: Data: Quick Start: Edit and enter data in a worksheet
  4. Excel 2010: Data: Video Tutorial: Enter and edit data in a worksheet
  5. Excel 2010: Data: Change the column width and row height
  6. Excel 2010: Data: Merge cells or split merged cells
  1. Entering Data
  2. Excel 2010: Data: Fill data automatically in worksheet cells
  3. Excel 2010: Data: Distribute the contents of a cell into adjacent columns
  4. Excel 2010: Data: Enter data manually in worksheet cells
  5. Excel 2010: Data: Insert or delete cells, rows, and columns
  6. Excel 2010: Data: Wrap text in a cell
  7. More...
  1. File Conversion and Compatibility
  2. Excel 2010: Conversion/Compatibility: A file is in a different file format than its extension indicates
  3. Excel 2010: Conversion/Compatibility: Check your workbook for compatibility with earlier versions of Excel (Video Tutorial)
  4. Office 2010: Move from Microsoft Works to Microsoft Office 2010
  5. Excel 2010: Conversion/Compatibility: Save a workbook in another file format
  6. Excel 2010: Conversion/Compatibility: File formats that are supported in Excel
  1. File Management
  2. Excel 2010: File Management: Use Excel to open or save a worksheet in the OpenDocument Spreadsheet (.ods) format
  3. Excel 2010: File Management: Repairing a corrupted workbook
  4. Office 2010: File Management: Manually rename the Office Document Cache
  5. Excel 2010: File Management: Differences between the OpenDocument Spreadsheet (.ods) format and the Excel (.xlsx) format
  6. Office 2010: File Management: Resolve conflicts in the Upload Center
  7. More...
  1. Filtering & Sorting
  2. Excel 2010: Filtering/Sorting: Outline a list of data in a worksheet
  3. Excel 2010: Filtering/Sorting: Sort data in a range or table
  4. Excel 2010: Filtering/Sorting: Guidelines and examples for sorting and filtering data by color
  5. Excel 2010: Filtering/Sorting: Filter for unique values or remove duplicate values
  6. Excel 2010: Filtering/Sorting: Sort data in a worksheet (Video Tutorial)
  7. More...
  1. Formatting Data
  2. Excel 2010: Data: Apply shading to alternate rows in a worksheet
  3. Excel 2010: Data: Show or hide gridlines on a worksheet
  4. Excel 2010: Data: Apply or remove cell borders on a worksheet
  5. Excel 2010: Data: Reposition the data in a cell
  6. Excel 2010: Data: Format a worksheet
  7. More...
  1. Formatting Numbers
  2. Excel 2010: Numbers: Create or delete a custom number format
  3. Excel 2010: Numbers: Keep leading zeros in number codes
  4. Excel 2010: Numbers: Format numbers in a worksheet
  5. Excel 2010: Numbers: Format numbers as text
  6. Excel 2010: Numbers: Display numbers as postal codes
  7. More...
  1. Forms & Controls
  2. Excel 2010: Forms/Controls: Add a check box, option button, or toggle button to a worksheet
  3. Office 2010: Security/Privacy: Enable or disable ActiveX settings in Office files
  4. Office 2010: Security/Privacy: Embedded-object and ActiveX-control policy settings error
  5. Excel 2010: Data: Create a drop-down list from a range of cells
  6. Excel 2010: Forms/Controls: Overview of forms, form controls, and ActiveX controls on a worksheet
  7. More...
  1. Formulas
  2. Excel 2010: Formulas: Working with external links
  3. Excel 2010: Formulas: Examples
  4. Excel 2010: Formulas: Working with names and cell references
  5. Excel 2010: Formulas: Correcting formulas
  6. Excel 2010: Formulas: Calculating dates
  7. More...
  1. Function Reference
  2. Excel 2010: Functions: Go with the cash flow: Calculate NPV and IRR in Excel
  3. Excel 2010: Functions: What's New
  4. Excel 2010: Functions: Math and trigonometry functions (reference)
  5. Excel 2010: Functions: Lookup and reference functions (reference)
  6. Excel 2010: Functions: Date and time functions (reference)
  7. More...
  1. Graphics (Clip Art/Pictures/Shapes)
  2. Office 2010: Pictures/Graphics: Draw a curve or circle shape
  3. Office 2010: Pictures/Graphics: Turn the snap to grid and snap to object options on or off
  4. Office 2010: Pictures/Graphics: Add or delete a shape fill or shape effect
  5. Office 2010: Pictures/Graphics: Change the size of a picture, shape, text box, or WordArt
  6. Office 2010: Pictures/Graphics: Change the color of a shape, shape border, or entire SmartArt graphic
  7. More...
  1. Importing & Exporting Data
  2. Excel 2010: Data: Exchange (copy, import, export) data between Excel and Access
  3. Excel 2010: Data: Text Import Wizard
  4. Excel 2010: Data: Create, edit, and manage connections to external data
  5. Excel 2010: Data: Manage external data ranges and their properties
  6. Excel 2010: Data: Top ten ways to clean your data
  7. More...
  1. Macros
  2. Excel 2010: Macros: Working with Excel 4.0 macros
  3. Excel 2010: Macros: Edit a macro
  4. Excel 2010: Macros: Change macro security settings in Excel
  5. Excel 2010: Macros: Create or delete a macro
  6. Excel 2010: Macros: Create a macro (Quick Start)
  7. More...
  1. Saving & Printing
  2. Office 2010: Print/Save: Save a file
  3. Office 2010: Print/Save: Preview and print a file
  4. Office 2010: Print/Save: Save an Office file as an earlier version
  5. Office 2010: Print/Save: Save as PDF or XPS
  1. Security & Privacy
  2. Office 2010: Digital Signatures: Add or remove a digital signature in Office files
  3. Office 2010: Digital Signatures: Obtain a digital certificate to create a digital signature
  4. Office 2010: Digital Signatures: Digitally sign your macro project
  5. Office 2010: Digital Signatures: Digital signatures and certificates
  6. Office 2010: Digital Signatures: How to tell if a digital signature is trustworthy
  7. More...
  1. Selecting & Navigating
  2. Excel 2010: Selecting/Navigating: Select specific cells or ranges
  3. Excel 2010: Selecting/Navigating: To use the arrow keys to move between cells, turn off Scroll Lock
  4. Excel 2010: Selecting/Navigating: Hide or display scroll bars in a workbook
  5. Excel 2010: Selecting/Navigating: Select cells, ranges, rows, or columns on a worksheet
  6. Excel 2010: Selecting/Navigating: Find and select cells that meet specific conditions
  7. More...
  1. SmartArt Graphics
  2. Office 2010: SmartArt: Get message, "Anything above marked with a red X will not appear in this SmartArt graphic and will not be saved"
  3. Office 2010: SmartArt: Change the style and width of lines connecting SmartArt shapes
  4. Office 2010: SmartArt: Rotate text in a SmartArt graphic
  5. Office 2010: SmartArt: Create a SmartArt graphic
  1. Spelling & Grammar
  2. Office 2010: Spelling/Grammar: Automatically correct capitalization
  1. Tables
  2. Excel 2010: Tables: Using structured references with Excel tables
  3. Excel 2010: Tables: Create an Excel table (Quick Start)
  4. Excel 2010: Tables: Delete a table without losing the data or table formatting
  5. Excel 2010: Tables: Create an Excel table (Video Tutorial)
  6. Excel 2010: Tables: Create or delete an Excel table in a worksheet
  1. Validating Data
  2. Excel 2010: Data: Apply data validation (Video Tutorial)
  3. Excel 2010: Data: Apply data validation to cells
  4. Excel 2010: Data: Apply data validation (Quick Start)
  1. Viewing Data
  2. Excel 2010: Worksheets: Freeze or unfreeze rows and columns (Video Tutorial)
  3. Excel 2010: Data: Use sparklines to show data trends
  4. Excel 2010: Data: What are those buttons and triangles in my cells?
  5. Excel 2010: Data: Create, select, edit, or delete a hyperlink
  6. Excel 2010: Worksheets: Freeze or lock rows and columns
  7. More...
  1. Worksheets (Managing)
  2. Office 2010: Themes: Apply, customize, and save a document theme in Word or Excel
  3. Excel 2010: Worksheets: Consolidate data from multiple worksheets in a single worksheet
  4. Excel 2010: Worksheets: Insert or delete a worksheet
  5. Excel 2010: Worksheets: Create a new workbook
  6. Excel 2010: Worksheets: Change the default font in Excel
  7. More...
  1. XML
  2. Excel 2010: XML: Create an XML data file and XML schema file from worksheet data
Welcome Guest