<<Convert Excel Spreadsheets to Web Pages | Trading Software That Operates Within Excel | Convert Excel, Access & Other Databases | Merge Excel Files>>
Ozgrid, Experts in Microsoft Excel Spreadsheets

Microsoft Excel Tips and Tricks Index

TRY OUT: Smart-VBA | Code-VBA | Analyzer-XL | Downloader-XL | Trader-XL| More Free Downloads.. Best Value: Finance Templates Bundle

The links below will lead to some great and useful Tips and Tricks for Microsoft Excel. You can even contribute your own tips and tricks. Many have Excel Workbooks which you can download.

Current Special! Complete Excel Excel Training Course for Excel 97 - Excel 2003, only $145.00. $59.95 Instant Buy/Download,30 Day Money Back Guarantee & Free Excel Help for LIFE!

Got any Excel Questions? Free Excel Help

A bit of fun VBA CommandButtoms [toolbox] 
A cool usage of PPMT for an amort sched. 
Active Cell Tricks 
Adding Comments To Formulas 
Buttons on toolbars have two functions available 
Cells Comment.Text to cell formula 
Chart Application I ( with Attachment this time ) 
Charts: Load BMP image into chart - with a twist 
Choice of coffee cup holder 
Close all open workbooks in one go 
Comments in VBA 
Conditional Formatting based on Text in the cell 
Conditional Formatting: Check List (clients) 
Controlling Office Assitant from Excel 
Cool "Secrets" About Microsoft Excel from Microsoft Excel Technical Support 
Corrupt Files? 
Counting Specific Characters in a Cell 
Create chart with one button 
Creating Hyperlinks using numbers in the excel sheet. 
Creating View out of different Named Ranges 
Custom Formats 
Custom Schedule - Gantt Chart 
Custom Schedule - Gantt Chart (2) 
Data Table Demonstrator 
Decision making aid? 
drilldown in pivot table 
Editting a formula 
Enter data to multiple sheets 
Enter military time without colon 
Evaluate parts of longer formulas 
Event Macro triggered by DDE Link update 
Export XL-chart to MS Word - Automation �I 
Fanning in and fanning out 
Filters 
Financial Application 
Financial Application II 
Formulas: Adj Journal Entry Processing 
Formulas: Automatic list numbering 
Formulas: Explode formulas easily! 
Formulas: How to SUM a range with Errors 
Formulas: Iterating Beer Formula (aka 99 bottles of beer...) 
Formulas: Perpetual Weekly Calendar 
Formulas: Summing the digits of a number 
Formulas: Tip to the forum -ve to +ve 
Formulas: Working with times in Excel 
Get Data from Pivot Tables 
Getting data to XL from Lotus Notes-database 
Hide & Show Help Shapes 
Hierarchical Listbox 
Importing Data from Websites... Simple method 
Importing large textfiles > 65536 rows 
Importing: How to show a waiting prompt in Excel without importing a picture 
Increment by row when copying across columns 
Increment by row when copying across columns (alternative method) 
Military Time 
Mouse-overs 
Multi-Lingual Formula Addin 
My Controls 
Name dialog box 
Named ranges onscreen with <40% zoom 
Naming ranges with the same name 
Nesting Functions 
New Cell Highlighter Technique 
NON-VBA conditional format >3 colours 
Pi 
pictures as hyperlinks 
Pivot Tables: Consolidate Ranges 
Pivot Tables: Consolidated Ranges (2) 
Please Wait for lengthy Macros 
Please wait! Macro at work 
Progress meters on steriods ! 
Properties in posted files 
Protect worksheets without any password 
Quick Charts 
quick intersect 
range name intersection 
Rebooting 
Remove object for printing 
Removing formula error displays (Version 2) 
Right Click for more than just a 'SUM' on the bottom taskbar 
Sending Email w/OutlookXP and ExcelXP 
Sheets Selection 
Shell32.Dll 
Simple Online Excel Tutorials 
Small Excel Application for You all to analyse 
Special Range Names 
SuperScript 
System profile 
Take a picture of a range. 
TaskList with Date Picker 
Template Sample 
Thanks, and help! 
The joy of conditional compiling 
Time-caclulation 
Trace Cell Precedents 
Two Monitors 
UDF Crop characters left or right VBA 
UserForm Shapes - Changing the shape 
Using fractions to your advantage 
VBA: Attempt at secure workbook 
VBA: Cell references 
VBA: Getting UserName 
VBA: Restrict access to workbook 
VBA: Select all sheet 
VBA: Updated Merged Cell Finder File 
View all toolbars 
Waterfall Chart 
WinZip - Using via VBA 
workday function in VB 
Working With Folders using VB Script - Rating: Advanced 
Working with sheets as forms 

Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALLpurchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.


Instant Download and Money Back Guarantee on Most Software

Try out:Analyzer XL |Downloader XL |Smart VBA |Trader XL Pro (best value) |ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader PackageTechnical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates