Archives
Email This Page to a Friend
March 2010
Detailed Monthly Archive
- 07: Count unique distinct numbers across multiple sheets (3D range) in excel
- 04: Return unique and duplicate numerical data entries from multiple sheets (3D range) in excel
- 03: Split data across multiple sheets in excel (vba)
February 2010
Detailed Monthly Archive
- 28: Combine data from multiple sheets in excel
- 26: Calendar with scheduling in excel 2007 (vba)
- 21: Dynamic stock chart in excel – Add date ranges
- 18: Create unique distinct year and months from a long date listing in excel
- 16: Create a dynamic stock chart using a web query and a drop down list in excel
- 11: Match two criteria and return multiple rows in excel
- 10: Create a unique distinct list of a long list without sacrificing performance using vba in excel
- 07: Scan stock markets in excel
- 02: Extract negative values and adjacent cells in excel
January 2010
Detailed Monthly Archive
- 30: Stock alerts in excel
- 27: Quickly select a range of values in excel
- 24: Create number sequences in excel 2007
- 20: Excel formula to count cells between two values
- 19: Return multiple values if above frequency criterion in excel
- 16: Filter unique distinct values using “contain” condition of a column in excel
- 14: Return multiple values if in range in excel
- 13: Return value if in range in excel
- 12: Sort values in parallel (array formula)
- 10: Vlookup of three columns to pull a single record
- 08: Using Excel Solver to schedule employees
- 07: Find positive and negative amounts that net to zero in excel
- 05: Identify numbers in sum using solver in excel
- 04: Sequencing and numbering of batches in excel
- 03: Sum adjacent values from a range using multiple lookup values in excel
- 03: Lookup values in a range using two or more criteria and return multiple matches in excel
December 2009
Detailed Monthly Archive
- 31: Sum adjacent values using multiple lookup text values in a column in excel
- 29: Vlookup with 2 or more lookup criteria and return multiple matches in excel
- 27: Filter duplicate values in a range using “contain” condition in excel
- 23: Filter unique text values in a range using “contain” condition in excel
- 21: Filter unique distinct text values in a range using “contain” condition in excel
- 17: Filter duplicate text values in a range using “begins with” criterion in excel
- 17: Filter unique text values using “begins with” criterion in a range in excel
- 14: Filter unique distinct text values using “begins with” criterion in a range using array formula in excel
- 13: Formula for matching a date within a date range in excel
- 10: Count unique values in two lists combined in excel
- 10: Count matching values in one or more columns in excel
- 07: Find records using two numerical criteria in excel
- 05: Lookup a value and find max date in excel
- 04: Filter unique distinct values where adjacent cells contain search string in excel
- 02: Validate duplicates in excel
November 2009
Detailed Monthly Archive
- 30: Validate unique distinct list in excel
- 30: Validate unique list in excel
- 26: Sum values in a range where adjacent cell value equals a criterion in excel
- 25: Search for multiple text strings in multiple cells and use in data validation in excel
- 23: Highlight odd/even months using conditional formatting in excel 2007
- 22: Lookup a value in a list and return multiple matches in excel
- 21: How to calculate missing months in a given date range in excel
- 18: Count date records between two dates in a range in excel
- 16: Sum values between two dates with criteria in excel
- 15: Most common value between two dates in a range in excel
- 14: Most common value between two dates in excel
- 14: Count unique distinct values using date criteria in a range in excel
- 12: Largest value in a range using date criteria in excel
- 11: Lookup min max values within a date range in excel
- 09: Lookup two index columns using min max values and a date range as criteria
- 08: Lookup two index columns returning multiple matches in excel
- 07: Text to be on top of column in excel
- 07: Lookup two index columns in excel
- 04: Count matching cell values in two columns in excel
- 04: Create a custom date range in excel
- 02: Create a quartely date range in excel
- 01: Create a monthly date range in excel
- 01: Extract unique values from a range using array formula in excel
October 2009
Detailed Monthly Archive
- 29: Count unique text values in a range containing both numerical and text values
- 26: Extract and sort text cells from a range containing both numerical and text values
- 25: How to return multiple values using vlookup in excel
- 23: Extract cell values in a range using a criterion in excel
- 20: Filter common text values in range 1 and in range 2 using array formula in excel
- 19: Filter text values existing in range 1 but not in range 2 using array formula in excel
- 17: Filter unique distinct list sorted based on sum of adjacent values using array formula in excel
- 15: Filter unique values from a range using array formula in excel
- 13: Filter a column and create a new unique list sorted from A to Z using array formula in excel
- 12: Filter unique text values from a range containing both numerical and text values in excel
- 10: Extract duplicate text values from a range containing both numerical and text values in excel
- 09: Extract dates and adjacent value in a range using a date critera in excel
- 07: Create a list with most recent data available in excel
- 05: Count unique distinct text values in a range in excel
- 04: Create a unique distinct text list from a range containing both numerical and text values in excel
- 02: Website optimization
- 01: Lookup with multiple criteria and display multiple search results using excel formula, part 4
September 2009
Detailed Monthly Archive
- 29: Extract numbers and text from a range using array formula in excel
- 28: Extract all rows from a range that meet criteria in one column in excel
- 28: Identify largest text value in a column using array formula in excel
- 27: Sort text values by length using array formula in excel
- 26: Create unique distinct list sorted based on text length using array formula in excel
- 24: Unique distinct list sorted based on occurrance in a column in excel
- 22: Unique distinct list from a column sorted A to Z using array formula in excel
- 20: Identify missing numbers in a range in excel
- 18: Create a list of all numbers or text in a column in excel
- 16: Extract a unique distinct list sorted alphabetically removing blanks from a range in excel
- 15: Count unique distinct records in a date range and a numeric range in excel
- 14: Create a list of dates with blanks between quarters in excel
- 13: Count unique records by date in excel
- 09: Highlight duplicates where adjacent cell value meets criteria using conditional formatting in excel part 2
- 08: How to highlight max and min value in every month in excel
- 06: Count unique distinct months in excel
- 04: Identify missing three character alpha code numbers in excel
- 02: Filter duplicates from two columns combined and sort from A to Z using array formula in excel
August 2009
Detailed Monthly Archive
- 31: Min and max unique and duplicate values using array formula in excel
- 30: Count duplicate distinct values in a column in excel
- 29: Invert a list ignoring blanks in excel
- 26: List names whos date has past in excel
- 26: Calculate occurences the past 90 days in excel
- 24: Search and display all cells that contain all search strings in excel
- 23: Sum text cells using criteria in excel
- 21: Highlight more than once taken online course in any given day in excel
- 19: Sort a range by occurence using array formula in excel
- 17: Comparing two columns and sum unique values using array formula in excel
- 16: Search and display a range of values in excel
- 13: Lookup with multiple criteria and display multiple search results using excel formula, part 3
- 12: Filter common values between two ranges using array formula in excel
- 12: Filter values existing in range 1 but not in range 2 using array formula in excel
- 10: Filter common values from three columns in excel
- 09: Filter unique distinct values from two ranges combined in excel 2007
- 06: Filter duplicate rows and sort by date using array formula in excel
- 05: Filter unique rows and sort by date using array formula in excel
- 04: Advanced custom date filter in Excel 2007
- 02: How to filter values between 0.5 and 1.5 from two columns in excel 2007
- 01: Sort a range from A to Z using array formula in excel
July 2009
Detailed Monthly Archive
- 30: Highlight unique distinct values in two ranges combined using conditional formatting in excel
- 28: Extract a unique distinct list sorted from A-Z from range in excel
- 26: Highlight duplicate values in two ranges combined using conditional formatting in excel
- 25: Exact word in string without using vba in excel
- 23: Highlight smallest duplicate value in a column using conditional formatting in excel
- 21: Extract a list of alphabetically sorted duplicates from a column in excel
- 20: Highlight duplicate values in a range using conditional formatting in excel
- 19: Highlight unique values and unique distinct values in a range using conditional formatting in excel
- 17: Extract largest values from two columns using array formula in excel
- 15: Search for multiple text strings in multiple cells in excel, part 2
- 14: Count unique values and unique distinct values in three ranges combined in excel
- 13: Extract duplicates from a range using excel array formula
- 11: Count unique values and unique distinct values in two ranges combined
- 11: Count occurences of a specific text string in a column in excel
- 09: Search for a text string in an excel table
- 09: Search for a cell value in an excel table
- 07: Count unique and unique distinct values in a multicolumn range in excel
- 06: Count text that occurs multiple times in excel cell
- 05: Count unique distinct values in two columns with date criteria in excel
- 03: How to create a random list of unique numbers in excel
- 03: Web statistics and most popular articles in June
- 01: Sort text cells alphabetically from two columns using excel array formula
June 2009
Detailed Monthly Archive
- 29: Merge two columns into one list in excel
- 28: Merge three columns into one list in excel
- 27: How to create a unique distinct list where other columns meet two criteria
- 25: Sum only if unique value in another column in excel
- 24: Looking up data in a cross reference table in excel
- 23: Extract a list of duplicates from three columns combined using array formula in excel
- 22: Extract a list of duplicates from a column using array formula in excel
- 22: Extract a list of duplicates from two columns combined using array formula in excel
- 21: Lookup with multiple criteria and display multiple search results using excel formula, part 2
- 20: Extract a unique distinct list from three columns in excel
- 16: Extract a unique distinct list from two columns using excel 2007 array formula
- 16: Create a date range using excel formula
- 15: Identify missing values in two columns using excel formula
- 13: Identify missing values in a column using excel formula
- 11: Count unique distinct values in three columns combined in excel
- 10: Count unique distinct values in two columns in excel
- 09: Count unique distinct values in a column in excel
- 08: Most popular excel articles in May
- 06: Sorting numbers and text cells descending also removing blanks using array formula in excel
- 06: Sorting numbers and text cells also removing blanks using array formula in excel
- 04: Highlight the second or more duplicates in two lists using conditional formatting in excel
- 03: Highlight common values in two lists using conditional formatting in excel
- 02: Sort dates within a date range using excel array formula
May 2009
Detailed Monthly Archive
- 31: Extract dates using a drop down list in excel
- 31: Extract distinct unique sorted year and month list from a date series in excel
- 27: Create a dynamic border to your list using excel conditional formatting
- 26: Split values equally into groups using excel array formula
- 25: Create a drop down list containing only unique distinct alphabetically sorted text values using excel array formula
- 22: Find the largest number in a dynamic column using excel formula
- 21: Lookup between two lists of data to highlight missing data using conditional formatting in excel
- 20: Highlight duplicates using conditional formatting in excel
- 19: How to filter out every second row using excel formula
- 18: Finding the nearest date in a range of dates using excel formula
- 17: Color every second row using dynamic conditional formatting in excel
- 17: Prevent duplicates using dynamic conditional formatting in excel
- 14: Lookup with multiple criteria and display multiple search results using excel formula
- 13: Highlight duplicates where an adjacent column is in a date interval using conditional formatting in excel
- 12: Create a unique distinct list from a date range in excel
- 10: Highlight dates within a date range using conditional formatting
- 09: Create a repeating list of numbers from 1 to Nth value
- 08: Identify duplicate invoice records using conditional formatting in excel
- 07: Identify duplicate invoice records in excel
- 06: How to color every cell in excel
- 05: Invert a list using named ranges
- 04: Invert a list using cell references in excel
- 03: Unique list to be created from a column where an adjacent column has text cell values
- 03: Create a list of distinct values from a list where an adjacent cell value meets a criteria in excel
- 01: Create a list of duplicates where adjacent cell value meets a condition in excel
April 2009
Detailed Monthly Archive
- 30: Highlight duplicates where adjacent cell value meets criteria using conditional formatting in excel
- 28: Group similar cell values on same row in excel
- 27: How to create excel macro to color every second row
- 26: How to rank uniquely with criteria in excel
- 25: How to rank text uniquely in excel
- 24: Create a unique distinct list and sort by occurrances from large to small
- 23: How to create an array of uniquely ranked duplicate values in excel
- 21: Search for multiple text strings in multiple cells in excel
- 20: Sum unique values in excel
- 19: How to create a unique list using conditional formatting in excel 2007
- 17: Create and sort distinct list by adjacent cell value size
- 16: Create unique distinct list from column where an adjacent column meets criteria
- 15: Insert a new row at the top every time a value has been entered
- 14: Create a unique distinct alphabetically sorted list, extracted from a column in excel
- 13: Max or min out of two columns
- 11: How to automatically fill all blanks with missing data or formula
- 10: Create unique list from two columns
- 08: Merge two lists
- 07: Sorting date ranges in excel
- 06: Conditional formatting highlights more than 10 if there are duplicates
- 05: Determine the sum between a range of dates for a specific currency
- 04: Sort cell values into categories, part 2
- 03: Sort cell values into categories
- 02: Count records between two dates in excel
- 01: Split first and last names in excel and then sort them alphabetically
March 2009
Detailed Monthly Archive
- 31: How to extract a list of duplicates of a column in excel
- 30: How to extract a unique distinct list of a column in excel
- 29: Return row reference of largest to smallest
- 28: Next upcoming date from list
- 27: Sorting text cells using array formula in excel
- 26: How to sort text cells filtered by two dates, part 2
- 25: Extract all rows that contain a value between this and that
- 24: How to sort cells filtered by two dates
- 23: How to find out if a number is between two dates
- 20: Delete blanks and errors in a list
- 19: Search three columns on three sheets, part 2
- 18: Search three columns on three sheets
- 17: Find missing numbers in a range from multiple columns
- 16: Unique distinct values from multiple columns using array formula
- 13: Count number of times a string exist in multiple cells using excel formula
- 12: A more userfriendly version of: Automatically filter unique row records from multiple columns
- 11: Excel template: Calculate machine utilization
- 10: How to automatically create a unique distinct list and remove blanks
- 09: Filter records between two dates
- 06: How to count unique distinct records in a date range
- 05: How many common cell values are there in list 1 and 2?
- 04: How to automatically calculate a specific day of a month
- 03: Excel template: School attendance register
- 02: merge two sheets with array formula
February 2009
Detailed Monthly Archive
- 27: How to remove common values between two columns
- 25: excel find weekday in period
- 23: Categorize numbers in excel
- 20: How to identify two consecutive dates in a list
- 18: How to find duplicates in a range spanning multiple columns?
- 16: Finding values in an excel list
- 13: How to find common values from two lists
- 12: How to navigate quickly in a complex excel workbook using hyperlinks
- 09: Coordinates of cells that are not empty in a range
- 07: Get data from same cell references of every sheet in workbook
- 05: Excel 2007: How do i remove errors from a cell formula?
- 03: How to count unique combined column values
- 02: Lookup Unique based on Multiple Conditions
January 2009
Detailed Monthly Archive
- 31: Using array formula to look up multiple values in a list
- 30: How to extract email addresses from a excel sheet
- 29: How to sum different rates with a date criteria
- 15: How to create a useful search formula
- 14: Automatically filter unique row records from multiple columns
- 13: What values are missing in List 1 that exists i List 2?
- 13: Multiple cells in a new row
- 12: Show duplicates and their adjacent values
December 2008
Detailed Monthly Archive
November 2008
Detailed Monthly Archive
May 2008
Detailed Monthly Archive
April 2008
Detailed Monthly Archive
- 23: Excel: How to automatically summarize preceding month and year
- 09: Search and replace with formatted words
- 08: How to efficiently summarize data by category and month
March 2008
Detailed Monthly Archive
February 2008
Detailed Monthly Archive
January 2008
Detailed Monthly Archive
- 17: Excel: Efficiently navigate cells and do fast selections
- 16: Windows xp: Remove unsigned driver warning message
- 15: Internet explorer 7: Powerful timesaving keyboard shortcuts
- 11: Excel: Count cells
- 08: Windows xp: How to find out physical memory
- 08: Enable “File and printer sharing” in windows xp firewall
December 2007
Detailed Monthly Archive
- 17: Windows xp: How to include network drives into your filesearch
- 17: Windows xp: How to search for multiple filenames at once
- 11: Excel: How to evaluate a complex formula
- 10: Excel: Create a random list of specific text values
- 10: Excel: Find the smallest difference between the two closest values
- 07: Excel: Dynamic summation through numeric named sheets
- 05: Windows xp: Modify default search settings
- 05: Excel: Find closest value
- 05: Windows xp: How to disable passport balloon notification
- 04: Outlook 2007: How to hide Outlook in system tray
- 04: Excel: Vlookup with text and date formatting
- 04: Excel: Average but exclude zeros
- 03: Excel: Percentage of total number
- 03: Excel: Using lookup to categorize numbers
- 01: Office: Display all commands in menu
November 2007
Detailed Monthly Archive
- 30: Windows xp: How to manually delete index.dat files
- 30: Windows xp: How to remove an unwanted background
- 30: Windows xp: How to disable screensaver at welcome screen
- 30: Windows xp home: How to disable simple filesharing
- 29: Windows xp: Make your user subfolders private
- 29: Windows xp: Enable filesharing on network
- 29: Windows xp: Disable file and printer sharing for network
- 28: Windows xp: Edit registry to use classic logon
- 28: Windows xp: How to hide a user account on welcome screen
- 27: Excel 2007: Color unique values using conditional formatting
- 27: Excel 2007: Color cells that meet criteria using conditional formatting
- 23: Windows Media Center 2005: Backup series and settings data
- 23: Excel 2007: Create a template and save time
- 22: Windows media center 2005: Keyboard shortcuts
- 20: Excel: Remove rows containing specific dates
- 20: Software: Can your computer run that game?
- 20: Windows Media Center 2005: Fix Low Volume output through spdif
- 19: Windows xp: Hide desktop icons
- 19: Windows xp: How to customize notification area
- 19: Windows xp: How to increase icon font size on desktop
- 19: Windows xp: How to avoid users from using task manager
- 19: Windows xp: Force applications to exit without user intervention at shutdown
- 19: Windows xp: How to disable a cd/dvd
- 19: Excel 2007: Delete duplicate cell values
- 15: Windows xp: How to turn off windows animation
- 15: Windows xp: How to remove balloon tips in notification area
- 15: Excel: Dynamic charting with drop list
- 14: Excel: How to rank by two columns
- 14: Windows xp: Force mouse pointer to jump to default button of any window that opens
- 14: Windows xp: How to show Internet Explorer icon on desktop
- 13: Internet Explorer: Change default download folder
- 12: Windows xp: What updates, hotfixes and patches are installed on your computer
- 12: Windows xp: How to find out what process makes your computer slow
- 12: Excel and Word 2007: Increase workspace by minimizing the ribbon
- 10: Outlook Express: Remove messenger from being started in outlook express
- 10: Windows media player: Remove update notification
- 10: Windows xp: How to exclude a program permanently from most frequently used programs on start menu
- 10: Windows xp: Do not save desktop settings on exit
- 09: Excel 2007: How to freeze first row/column and scroll the others
- 09: Excel: Add screentip to your hyperlink
- 08: Windows xp: Folder customizations are incorrect
- 08: Excel: Regional settings
- 07: Excel 2007: How to find errors in a large sheet
- 07: Excel 2007: How to not display the formula in the formula bar
- 05: Excel: How to invert a list
- 05: Excel: Dynamically sum a column
- 05: Windows xp: How to turn off system sounds
- 05: Windows xp: How to turn off “My recent documents”
- 04: How to change owner and organization
- 04: Windows xp: How to burn a data cd/dvd in windows explorer
- 03: Microsoft Office 2003/2007: How to turn on/off clipboard
- 03: Excel 2007: How to create a dynamic chart
- 02: Windows xp: Change hard disk icons, visible in windows explorer
- 01: Windows media center 2005: How to adjust sound volume when using spdif
- 01: Excel: How to remove spaces
- 01: ‘Windows xp: Change word start in start button
- 01: Excel: Count rows between two values in a list
October 2007
Detailed Monthly Archive
- 31: Windows xp: Delete faulty entries in Add/Remove Programs
- 30: Excel: Notify if expired
- 29: Windows xp: How to uninstall Windows Picture and Fax Viewer
- 28: How to show status bar in windows explorer and internet explorer
- 28: Excel: Holidays and networkdays
- 28: Windows xp: Show content in system folder
- 28: Windows xp: How to scale and move taskbar
- 27: Windows xp: Restore values by looking at registry template
- 27: Windows xp: Change the way windows explorer displays uppercase files
- 26: Internet Explorer: Change font
- 26: Excel 2007: Collect unique values from several columns
- 24: Excel: Upcoming date
- 24: How to remove windows xp built-in zip support
- 23: Windows xp: How to run a program as an other user
- 23: Windows xp: Create shortcut to open a folder with windows explorer
- 22: Windows xp: Start your favourite programs fast
- 22: Excel: Count the number of a specific weekday in a range
- 21: Outlook Express: How to remove cleartype
- 21: Internet Explorer: Open multiple websites with one click
- 21: Internet Explorer: Create website thumbnails
- 20: Internet Explorer: Fastest way to open a website
- 19: Internet Explorer: Sort website favourites
- 19: Internet Explorer: Multiple startpages
- 18: How to start windows xp faster
- 18: Windows xp: Change default program installation folder
- 17: Windows xp: How to use your computer on daily basis with user accounts
- 17: How to save usernames and passwords on forms in Internet Explorer
- 16: Windows xp: How to remove low diskspace notification
- 16: Windows xp: How to change appearance of task manager
- 15: Windows xp: Configure system to show “blue screen of death” or a system restart
- 15: Windows xp: Disable windows from reading media info in windows explorer
- 15: Windows xp: Search window opens when doubleclicking on folder in windows explorer
- 14: Internet Explorer: Download webpages for offline viewing
- 13: Excel: Select only visible cells
- 13: Excel: How to convert to hexadecimal
- 12: Troubleshoot with event viewer
- 12: Windows xp restarts or hangs while loading
- 12: Windows xp: Recommended hardware
- 11: Windows xp: Customize shortcut icon with no arrow
- 11: Internet Explorer: Change window header title
- 10: Internet Explorer: Change icons on links field
- 10: Windows xp: Identify processes in command prompt
- 09: Windows xp: Copy and move files faster in windows explorer
- 09: Create shortcut to connect faster to remote computer
- 08: Remote assistance with several computers connected to a router
- 08: Windows xp: Remote assistance
- 07: Windows xp: How to create a shortcut to lock your computer
- 07: Windows xp: How to find out your computer name
- 07: Windows xp: How to abort going into hibernation
- 06: Windows xp: What camera model?
- 06: How to automatically download pictures from Canon camera
- 06: Disable preview image of avi file
- 06: Excel: Count time
- 05: Windows xp: How to turn off CD autorun
- 05: How to identify codec required to play an avi file
- 04: Windows xp: How to use mouse pointer without mouse
- 04: Windows xp: Categorize your pictures
- 04: Excel 2007: How to install analysis toolpack
- 03: Find out your ip address
- 03: Firefox: Uninstall or block Macromedia Flash
- 02: Windows xp: On screen keyboard
- 02: Google: How to search a forum
- 01: Win xp: Remove highlight of newly installed programs
September 2007
Detailed Monthly Archive
- 30: Win xp: Create a secure ssh tunnel with putty to a linux server
- 29: Windows xp: Customize “Send to”
- 28: Windows xp: Easily create a vpn
- 27: IE 7: Enable menu bar
- 26: Azureus: How to download specific files in a torrent
- 25: Win xp: Start menu in alphabetical order
- 23: Create a playlist in start menu
- 23: Win xp: Remove most used software in start menu
- 23: Autostart USB memory
- 22: Firefox: Surf the web with bigger firefox window
- 22: Excel: Convert word address list to excel
- 21: How to unpack a rar file
- 21: Windows xp: Increase log in security
- 20: Word 2007: Insert comments
- 20: Firefox: Surf web faster with site keywords
- 19: WMP: Allow screensaver during music playback
- 19: Acrobat Reader: Save pdf as a text file
- 18: Win xp: Free antivirus software
- 18: Win xp: Desktop Cleanup wizard
- 17: Win xp: Show desktop items
- 17: Excel: Offset explained
- 16: Authorize external programs
- 16: Excel: Remove blank cells
- 15: WMC 2005: Slow down DVD-ROM to quiet mode
- 15: Remove sound effects and customize video background color
- 14: Win xp: List all offline files and folders
- 14: Excel:Calculate the difference between two dates
- 13: Win xp: How to select a network folder to synchronize
- 13: Excel: Calculate last date of a specific month
- 12: Windows xp: Synchronize folders
- 12: Excel: Count the number of occurances an integer is in a list
- 11: Win xp: Make My Documents only accessible to owner
- 11: WMC 2005: How to burn tv shows on a dvd
- 10: Excel: How to create a matrix
- 10: Windows media center 2005 requirements
- 09: Excel: Convert text to integer in formula
- 09: Win xp: How to password protect a zip file
- 08: My Computer with folder list
- 08: Excel: Count unique values in a list
- 07: Excel: Count and sum values between specific ranges in a column
- 07: Customize album cover
- 06: Windows xp: How to remove notification icon when connected
- 05: Start Windows media center 2005 automatically at boot
- 05: Windows xp: How to add programs to start menu
- 04: Excel: Autosum when a row is inserted
- 04: How to remove Windows xp messenger
- 03: Update windows media center 2005
- 03: Adjust process priority in Windows task manager
- 02: How to search for hidden files in windows xp
- 02: Windows xp: How to analyze dump file
- 01: Excel: Find latest date in a list
- 01: Excel: Interactive summation
August 2007
Detailed Monthly Archive
- 31: Excel: Sum automatically specific posts in a list
- 30: Excel: Count the number of cells within a range that meet the given condition
- 30: How to capture screenshots from windows media player
- 29: Excel: Find the smallest value in a list but bigger than 10.
- 29: Excel: Automatically create a numbered list
- 29: Windows xp: Hide previous logged on user name
- 28: Automatically adjust column width in windows explorer
- 27: Windows xp: Smart search
- 27: Excel 2007:How to remove empty cells
- 25: Windows xp: One program column in start menu
- 24: Print webpage and add information to footer or header
- 23: Internet explorer: Smart and fast webnavigation
- 22: Windows vista: How to remove old win xp folders
- 21: Word 2007: Change default font to times new roman
- 20: Excel:Advanced search between two tables
- 19: Excel 2007: Find names and their references in a sheet
- 18: Windows xp: Customize taskbar and startmenu
- 17: Excel: Refer to the same cell regardless of whether the row above the cell is deleted or the cell is moved
- 16: Excel: Effectively search and replace specific characters
- 15: Are you and your computer up to Windows Vista?
- 14: Excel:Print consecutive pagenumbers from several sheets
- 13: Top list of useful wordpress plugins
- 12: How to burn wma or mp3 to a cd in windows media player
- 10: Sum a filtered column
- 09: How to create a pdf
- 08: Excel: Count cells in a specific area
- 07: Excel: Find last input value
- 06: Excel: Find largest value in a table and return adjacent cell value
- 05: Hardware: How to connect a wireless router to an existing router
- 04: Hardware: Save electricity
- 03: When and how to use hibernate and standby mode
- 02: Windows xp: Schedule shutdown
- 01: How to share Recorded tv through your home network
July 2007
Detailed Monthly Archive
- 31: Windows xp: How to print on both sides of a paper
- 30: Excel:Print headers on every page
- 29: Win xp: Deleting a file or folder:Access denied error
- 28: Outlook Express: Share adressbook
- 10: Excel:Rotate text to save space
- 09: Windows xp:How to start your computer with mouse or keyboard
- 06: Html:How to display an email address on a webpage without receiving spam
- 04: Create a webpage within word 2007
- 04: Get a better overview within word 2007 and excel 2007
- 04: Windows xp:How to enable an alarm sound when Caps Lock is activiated
June 2007
Detailed Monthly Archive
April 2007
Detailed Monthly Archive
- 22: How to: Optimize USB flash drive for quick removal
- 09: Prevent background colors and images from printing
- 03: How to turn off Windows xp indexing service
- 01: How to turn off AutoComplete function in Internet Explorer
February 2007
Detailed Monthly Archive
January 2007
Detailed Monthly Archive
- 30: Disable thumbnail file “thumbs.db” being created
- 29: How to automatically clear pagefile.sys when shutting down your computer
- 26: Excel 2003: How to format numbers as text
- 23: Let Azureus monitor a folder and automatically import torrents
- 22: How to sort program list alphabetically in start menu
- 19: How to configure windows media player on top of other windows
- 18: How to configure start menu links
- 17: How to get the classic start menu in windows xp
- 16: Open submenus when i pause on them with my mouse
- 15: Delete files without moving them to recycle bin
- 12: How to find out your windows xp
- 11: How to automatically delete temporary internet files in Internet Explorer 6 browser
- 10: How to restore Outlook Express backup
- 09: Backup Outlook Express settings and mail
- 08: Configure internet explorer cache
- 05: How to correct album artist in windows media player library
- 04: How to schedule a task to run only when computer is idle
- 03: How to backup windows xp registry
- 02: Why use Pivot table and pivot chart?
- 01: Work smarter with the Internet Explorer address bar
- 01: Components of a excel chart
December 2006
Detailed Monthly Archive
- 30: How to remove index.dat file in your temporary internet folder
- 30: Sort windows explorer files and folders in groups
- 29: Where does Windows media player save the library information?
- 28: How to search for music on your computer in windows media player
- 28: How to rate music in windows media player
- 26: Customize windows explorer details view
- 26: Quick access to recently used files
- 17: Windows xp calculator explained
- 17: How to copy command prompt text
- 13: Identify your windows dvd decoder
- 10: Why use R1C1?
- 10: Configure windows xp security alerts
- 06: Create a email shortcut on your windows xp quick launch toolbar
- 03: Rename files with one command in windows explorer
- 02: Creating transparent bars in excel 2003 and excel 2007 charts
- 02: Problem with low volume while playing a divx/xvid clip/movie with ac3 sound
November 2006
Detailed Monthly Archive
- 03: Remove email notification at welcome screen in windows xp
- 03: Speed up Windows XP start menu
- 03: Transpose a column of values to values in a row
October 2006
Detailed Monthly Archive
- 31: Shortcut to create a folder in windows xp
- 31: Powerful way to search an excel list automatically
- 09: How to: Clearing prefetch cache shortens windows xp boot time
- 08: How to convert mp3 to wave using winamp
- 02: Long icon filenames on windows xp desktop
September 2006
Detailed Monthly Archive
- 30: Remove grey labels from desktop icon text
- 28: Change thumbnail size in windows xp explorer.
- 24: Enable windows xp screensaver password
- 23: Remove windows xp error reporting
- 18: Shortcuts in windows xp
- 15: How to find duplicates in a Microsoft Excel list
- 13: Remove windows xp boot screen
- 12: How to configure windows media center autologon
- 11: Increase Windows xp performance
- 10: Remove username from windows xp start-menu
- 10: Configure Windows xp startup
- 03: Convert your windows media center files to save storage
- 01: Increase sheet readability in excel
August 2006
Detailed Monthly Archive
Plugin by GeekWithLaptop.com
