|
Search Results for "Data"
284 results were found in the following tip categories:
Excel Keyboard Shortcuts
- Selecting the Current Region/List
- Creating Charts with F11 in Microsoft Excel
- Using the Keyboard to Select Chart Items in Microsoft Excel
- Changing the Layout of the Chart from Rows to Columns and Vice Versa in Microsoft Excel
- Adding a Linked Picture to a Chart in Microsoft Excel
- Updating Charts by Dragging and Dropping in Microsoft Excel
- Displaying Numbers in Thousands in a Chart in Microsoft Excel
- Copying/Moving a Cell(s) Between Sheets/Workbooks
- Adding Groups and Outlines Manually
- Selecting cells that only contain Text in Microsoft Excel
- Using the Validation Input Message as a Cell Comment
Excel General
- What's New in Excel 2002/2003: Menu, Cell Shortcut Menu and Keyboard Shortcuts
- What's New in Excel 2003
- PDF2XL Enterprise
- Copying Cell Content Across Sheets in Excel 2007
- Copying/Moving a Cell(s) Between Sheets/Workbooks in Excel 2007
- Whats New in Excel 2007
- Quickly Creating Links between Workbooks in Excel 2007
- Canceling the Update Links Message While Opening a Linked Workbook in Excel 2007
- Breaking Links between Workbooks in Excel 2007
- Changing the Source Link in Excel 2007
- Finding and Deleting Unwanted and Orphan Links in Excel 2007
- Import and Refresh External Data from a in Excel 2007
Excel Time
Excel Importing Text Files
- Problem: The Minus Sign Appears to the Right of the Number
- Problem: Date Formatting Cannot Be Changed
- Problem: Values Not Formatting as Numbers
- Deleting Empty Rows
- Importing a Text File in Excel 2007
- The Minus Sign Appears to the Right of the Number in Excel 2007
- Change font color based on Date using VBA in Microsoft Excel
- Validation list without empty cells using VBA in Microsoft Excel
- Create worksheets from a list of names using VBA in Microsoft Excel
- Open data in two dimensional array and save in sheet using VBA in Microsoft Excel
- Display AutoFilter criteria after filtering using VBA in Microsoft Excel
- Convert negative values treated as text using VBA in Microsoft Excel
- Using the Macro Recorder in Microsoft Excel
- Reducing the Used Area in a Sheet
- Creating Charts with F11 in Microsoft Excel
- E-mailing an Excel Workbook, Sheet, Data or Chart
- PDF2XL and PDF2XL OCR
- Copying Formulas and Pasting Them in a Transposed Direction Without Changing the Relative References
- Sum total stock value for any part in Microsoft Excel
- The Power Combination
- Validating Text Entries
- Preventing Duplicates While Entering Data
- Validating text entries in Microsoft Excel
- Extracting Characters from Text Without Using Formulas
- Separating First and Last Names Without Using Formulas
- Quickly Typing Dates into Cells
- Adding Data, Charts, or Other Information to a Cell Comment
- Inserting a Copied Cell(s) Without Overwriting Existing Data
- Add space between characters and numbers in Microsoft Excel
- Validating Number Entries
- Validating Date Entries
- Validating Number Entries in Excel 2007
- Validating Text Entries in Excel 2007
- Validating Date Entries in Excel 2007
- Preventing Duplicates While Entering Data in Excel 2007
- Allowing Multiple Users to Edit Specified Ranges in Excel 2007
- Protecting Data by Hiding a Row(s) and a Column(s) in Excel 2007
- Protecting Cells Containing Text or Formulas Only, in a Protected Sheet in Excel 2007
- Protecting Cells Containing Formulas in an Unprotected Sheet in Excel 2007
- Adding Data, Charts, or Other Information to a Cell Comment in Excel 2007
- Using the Validation Input Message as a Cell Comment in Excel 2007
Files, Workbook, and Worksheets in VBA
Excel Format
- Applying colors to Subtotal rows according to the Subtotal level in Microsoft Excel
- Values Not Formatted as Numbers in Excel 2007
Links between Worksheet and Workbooks
Excel Sorting
- Sorting Rules & List Structure
- How Excel Sorts Lists
- Sorting by Columns
- Sorting by Custom Lists
- Drawing Lines Between Sorted Groups
- Sort Ribbon in Excel 2007
- Sorting Rules in Excel 2007
- Sorting Options in Excel 2007
- Sorting by Cell Color, Font Color or Cell Icon in Excel 2007
- Sorting by Custom Lists in Excel 2007
- Use Sorting to Delete Blank Rows in Excel 2007
- Fast Summation
- Summing values in vertical and horizontal ranges in Microsoft Excel
- Summing data by selecting cells in Microsoft Excel
- Inserting Subtotals Quickly
- Summing data from a cell in a number of sheets in Microsoft Excel
- Summarize data according to criteria from the data table using Sumif formula, Offset formula and Combo Box in Microsoft Excel
- Summing using multiple criteria in Microsoft Excel
- Separating Positive and Negative numbers and add Running Balance column
- Validating Data To Be Unique In A Range
- Transposing an Entire Range of Data into a Single Column
- Transposing a Range in Ascending Order
- Excluding Exceptional Values when Calculating an Average
- Averaging Values that Correspond with the X Largest Values in a Dynamic Range
- Selecting a Set of Random Numbers, Avoiding Duplicates
- Copying Formulas and Pasting Them in a Transposed Direction without Changing the Relative References in Excel 2007
- Automatically Defining Names for Ranges in a List in Excel 2007
- Automatically Updating a Range Name Reference in Excel 2007
- Quick Filtering Using the AutoFilter Icon
- Filtering by the Date Field
- Filtering by More Than Two Criteria
- Filtering a Range into a List of Unique Records
- Filtering a List into Unique Records Using the COUNTIF Formula
- The Filter Ribbon in excel 2007
- Filtering by Data Type in Excel 2007
- Filtering by More Than Two Criteria in Excel 2007
Cells, Ranges, Rows, and Columns in VBA
- Copy a range with one Area to a Database sheet using VBA in Microsoft Excel
- Copy a range with more Areas to a Database sheet using VBA in Microsoft Excel
- Copy a Row or Rows to a Database sheet using VBA in Microsoft Excel
- Copy a Column or Columns to a Database sheet using VBA in Microsoft Excel
- Copy cells from the ActiveCell Row to a Database sheet using VBA in Microsoft Excel
- Copy Selection to a Database sheet using VBA in Microsoft Excel
- Copy Selection to a Database sheet using VBA in Microsoft Excel
- Copy a range on the place of the Activecell to a Database sheet using VBA in Microsoft Excel
- Copy from row till the last row with data into one sheet using VBA in Microsoft Excel
- Copy a Range from each workbook in a folder using VBA in Microsoft Excel
- Copy a row or rows from each workbook in a folder using VBA in Microsoft Excel
- Copy a column or columns from each workbook in a folder using VBA in Microsoft Excel
- Copy a sheet from each workbook into your workbook in a folder using VBA in Microsoft Excel
- Copy a range from each workbook with a file name starting with ? in a folder using VBA in Microsoft Excel
- Copy cells to all workbooks in a folder using VBA in Microsoft Excel
- Counting the Number of Cells Containing Text in a Range
- Count the number of blank cells in a range in Microsoft Excel
- Count the number of cells containing data in a range in Microsoft Excel
- Count the number of cells with numeric data in a range in Microsoft Excel
- Counting Unique Numeric Values or Unique Data in a List
- Adding the Subtotals Icon to the Menu Bar
- Quickly Removing Subtotals
- Adding Additional Functions to Subtotals
- Applying colors to Subtotal rows according to the Subtotal level in Microsoft Excel
- Applying Styles to Subtotal Rows
- Subtotal Ribbon in Excel 2007
- Creating Subtotals Summary in Excel 2007
- Adding Subtotals to Primary and Secondary Fields in Excel 2007
- Quickly Removing Subtotals in Excel 2007
- Applying Styles to Subtotal Rows in Excel 2007
- Find the maximum numerical value in a list based on a criteria in Microsoft Excel
- Find the minimum numerical value in a list based on a criteria in Microsoft Excel
Excel Macros and VBA
Excel Grouping and Outlining
- Adding the Auto Outline, Clear Outline, and Show Outline Symbols Icons to the Toolbar
- Copying or Applying Color to Groups and Outlines
- Add Group and Outline in Excel 2007
- Recovering Data from a Corrupted Workbook That Cannot Be Opened
- Reducing the Workbook Size for Quick Sending via E Mail
- E-mailing an Excel Workbook, Sheet, Data or Chart
- List of File Formats that are Supported in Excel 2007
- Opening/Closing a Workbook(s) in Excel 2007
- Recovering Data from a Corrupted Workbook That Cannot Be Opened in Excel 2007
Excel Formula
- Add space between characters and numbers in Microsoft Excel
- Watch Calculation Results Immediately in Excel 2007
- Consolidate with formulas if the row & column headers of all worksheets are identical in Microsoft Excel
- Consolidating Lists
- Comparing Lists
- Using Different Functions to Consolidate Lists
- Consolidating Lists While Adding Links to the Source Data
- Summing Stock Lists
- Summing Sales Quantities and Amounts for Several Lists, or Presenting the Figures Side-by-Side
- Summing Monthly Trial Balance Figures
- Using Different Functions to Consolidate Lists
- Consolidating Lists in Excel 2007
- Using Different Functions to Consolidate Lists in excel 2007
- Consolidating Lists While Adding Links to the Source Data in excel 2007
- Summing Stock Lists in Excel 2007
- Summing Sales Quantities and Amounts of Several Lists, or Presenting the Figures Side-by-Side in Excel 2007
Custom Functions
Formating in VBA
Excel Information
- Getting Continuously Refreshed Data from a Web Site in Excel 97
- Getting Continuously Refreshed Data from a Web Site in Excel 2000
- Getting Continuously Refreshed Data from a Web Site in Excel 2002 & 2003
- Creating a PivotTable Report
- Getting Drill-Down Details
- Grouping the Date Field by Number of Days
- Pivot Table - Grouping dates by weeks in Microsoft Excel
- Adding a Running Balance Calculation Column
- Adding a Calculated Percentage Field
- Adding Additional PivotTable Reports Using the Same Data Source
- Retrieving Data from a PivotTable Report
- Rules for Organizing the Source Data in Excel Sheets
- PivotTable Report Terminology
- Automatically Refreshing a PivotTable Report
- Adding/Deleting Subtotals
- Displaying the Top/Bottom Number of Items
- PivotTable report - Grouping Text Fields
- PivotTable report - Grouping the Date Field by Days, Months, Quarters, and Years
- PivotTable report - Grouping the Date Field by Week Number
- PivotTable report - Grouping the Date Field by Quarters in a Fiscal Reporting Year
- PivotTable report - Adding a Data Field That Calculates the Difference Between Two Data Fields
- Adding a Data Field That Calculates Percentages from One Item of the Row Field
- PivotTable report - Adding a Data Field That Calculates Percentage Difference from the Previous Item
- PivotTable report - Adding a Data Field That Calculates the Difference from the Previous Item
- Creating PivotTable in Excel 2007
- Creating a PivotTable Report in Excel 2007
- Formatting a Value Field in Excel 2007
- Grouping Text Fields in Excel 2007
- Grouping the Date Field by Number of Days in Excel 2007
- Grouping the Date Field by Days, Months, Quarters, and Years in Excel 2007
- Grouping a Date Field by a Week Number in Excel 2007
- Grouping a Date Field by Quarters in a Fiscal Reporting Year in Excel 2007
- Inserting a Field that Calculates the Difference between Two Fields in Excel 2007
- Inserting a Running Balance Column in Excel 2007
- Getting Drill-Down Details in Excel 2007
- Automatically Refreshing a PivotTable Report in Excel 2007
- Refreshing the Data in PivotTable Report while Opening a Workbook in Excel 2007
- Inserting a Chart in Excel 2007
- Create and Insert Additional PivotTable Reports Using the Same Data Source in Excel 2007
Excel Security - Protection
- Protecting Data by Hiding a Row(s) and Column(s)
- Preventing Movement in Protected Areas in Microsoft Excel
- Allowing Multiple Users to Edit Ranges in Microsoft Excel
- Limiting the Movement in an Unprotected Sheet
- Protecting Cells Containing Formulas in an Unprotected Sheet
Excel Printing
Excel Date & Time Formulas
- Combining Data from Separate Columns into a Single Date and Time Value
- Separating Dates and Times
- Creating a Date and Time Matrix
- Creating a Timesheet
- Replacing Data Markers with Pictures in Microsoft Excel
- Autoexpanding a Date Type Chart using Microsoft Excel
- Copying a series from one chart to another in Microsoft Excel
Lookup Formulas
- Combine the VLookup and Match formulas in Microsoft Excel
- Combine the Index and Match formulas in Microsoft Excel
- Vlookup Formula – Organizing the Data Table
- Vlookup Formula – Eliminating Errors
- Index Formula vs. Vlookup Formula
- Retrieve information from a range in another Excel File when the Path & File Name strings stored in various cells.
- Retrieving a Price Value By Looking at Two Difference Data Tables
- Retrieving A Value From A Reference Grid, Using Indexes Listed In Another Range
- Retrieving Sale Price Based On Item And Color Criteria
- Retrieving Values Using References Based on Row and Column Numbers
- Retrieving the Minimal / Maximal Values from a Filtered List
- Retrieving Smallest Nth Value Match Within a List
- Retrieving Sale Price Based on Item and Color Criteria
- Retrieving the Entire Row of a Matched Value
- Returning the Entire Contents of the Row Containing the Highest Math Grade
- Retrieving a Price Value by Looking at Two Difference Data Tables
- Retrieving a Value from a Reference Grid, Using Indexes Listed in another Range
- Export data from Excel to Access (ADO) using VBA in Microsoft Excel
- Export data from Excel to Access (DAO) using VBA in Microsoft Excel
- Import data from Access to Excel (ADO) using VBA in Microsoft Excel
- Import data from Access to Excel (DAO) using VBA in Microsoft Excel
- Import data from a closed workbook (ADO) using VBA in Microsoft Excel
- Import data from a text file (ADO) using VBA in Microsoft Excel
- Transfer data from a recordset to a worksheet (ADO) using VBA in Microsoft Excel
- Use a closed workbook as a database (ADO) using VBA in Microsoft Excel
- Use a closed workbook as a database (DAO) using VBA in Microsoft Excel
- Replace text in a text file using VBA in Microsoft Excel
- Restricting Cell Entries to Text Only
- Restricting the Number of Characters Entered into a Cell
- Preventing Duplicates When Entering Data
- Combining Text and Formatted Numbers into a Single Entity
- Distribute Data from a List of the day to day sheets using VBA
- Replace text in a text file using VBA in Microsoft Excel
- Add page breaks to sorted data using VBA in Microsoft Excel
Information Formulas
- How to eliminate N/A error result when using Vlookup formula in Microsoft Excel
- How to change error result calculation when using Vlookup formula to 0 or empty cell in Microsoft Excel
- Find the address of the max value in range in Microsoft Excel
Add-In in VBA
Modules, Class Modules in VBA
Using Loops
Other Q&A Formulas
- Find the maximum numerical value in a list based on a criteria in Microsoft Excel
- Find the minimum numerical value in a list based on a criteria in Microsoft Excel
- How to find the minimum value in range while ignoring 0 value in Microsoft Excel
- Find the value in the first non blank cell in range in Microsoft Excel
- Find the last numeric value in a range in Microsoft Excel
- Table Sorting Rules in Excel 2007
- Drawing Lines between Sorted Groups in Excel 2007
- Coloring Based on Text Criteria in Excel 2007
Sponsors:
 |
Book Store:
Recommended Books:
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
