HomePrivacy PolicyFeedbackLink to usSite Map

Welcome to Tech on the Net!

Tech on the Net is dedicated to providing helpful advice, how-to's and FAQs. We focus on technologies such as Microsoft Access, Microsoft Excel, Microsoft Word, SQL, and Oracle/PLSQL.

The information presented here is suitable for all programmers from beginner to expert. We hope you find this information useful and return to our site, as we expand our information base.


What's New

The latest Microsoft Word pages added to the site:

Indent text in Word 2011 for Mac

Make text appear like it was marked with a highlighter pen in Word 2011 for Mac

Change font color in Word 2011 for Mac

Center text in Word 2011 for Mac

Double space text in Word 2011 for Mac

Change the page margins in Word 2011 for Mac

Change the page orientation to portrait in Word 2011 for Mac

Change the page orientation to landscape in Word 2011 for Mac


The latest Oracle/PLSQL pages added to the site:

Practice Exercises for COUNT Function

Practice Exercises for ALTER TABLE Statement


The latest Microsoft Access pages added to the site:

Play a wav file (sound file) without using the API in Access 2003/XP/2000/97

Prevent a query from timing out in Access 2003


The latest Microsoft Excel pages added to the site:

Set up cell to only allow 10 characters in Excel 2011 for Mac | Excel 2010

Create hyperlinks to link cells in column E to their matching value in column C in Excel 2007

Automatically highlight highest and lowest values in a range of cells in Excel 2011 for Mac

Automatically highlight expired dates and dates that are 30 days from expiration in Excel 2010

Automatically highlight highest and lowest values in a range of cells in Excel 2010

Change the font color based on the value in the cell in Excel 2010

Change the font color based on the value in the cell in Excel 2011 for Mac

Remove subtotals on pivot table rows in Excel 2011 for Mac

Remove subtotals on pivot table columns in Excel 2011 for Mac

Sort pivot table results in Excel 2011 for Mac

Do not save data with table layout in a pivot table in Excel 2011 for Mac

Change pivot table name in Excel 2011 for Mac

Remove grand totals for rows in a pivot table in Excel 2011 for Mac

Remove grand totals for columns in a pivot table in Excel 2011 for Mac

Change how errors are displayed in a pivot table in Excel 2011 for Mac

Change how empty cells are displayed in a pivot table in Excel 2011 for Mac

Hide zero value lines within a pivot table in Excel 2011 for Mac

Hide empty cells in a pivot table in Excel 2011 for Mac

Hide a value in a pivot table in Excel 2011 for Mac

Display a hidden value in a pivot table in Excel 2011 for Mac

Display the fields in the Data/Values Section in a single column in a pivot table in Excel 2011 for Mac

Display the fields in the Data/Values Section in multiple columns in a pivot table in Excel 2011 for Mac

Show Top 10 results in a pivot table in Excel 2011 for Mac

Show Bottom 10 results in a pivot table in Excel 2011 for Mac

Automatically refresh pivot table when file is opened in Excel 2011 for Mac