Excel Tips and Tutorials

 
Download
Author
Date
Description
Size
Eng_Aquarium.zip
Jiri Cihar 26.8.2005 Do you think, data validation feature allows you text selection only? Let me convince you are mistaken.
You can donwnload the Excel file with live example extending data validation ability to work with embedded images list.
845kB/886kB
CF_Advanced1.zip
Jiri Cihar 21.9.2005 It might be a good idea to highlight important values with help of conditional formatting. What about a few examples of advanced approach...or not too basic at least.
You can download the Excel file with 3 detailed examples.
50kB/97kB
DCh_Advanced.zip
Jiri Cihar 27.9.2005 Looking for a new and cool chart display?
What about change the range of displayed values just by cursor movement?
34kB/103kB
MenuMaker.zip

MenuMaker.pdf
Jiri Cihar 27.2.2006 Do you develop applications in Excel? Would you like a developing enviroment for menu creation? Pasting your own pictures as button face? Enable or disable default items in main worksheets menu? What about adding combo boxes in your own menu? 72kB/164kB
aqua_animation.zip
Jiri Cihar 15.5.2006 How about shape and image animation in Excel? Mission impossible? Download this file and have a look at our aquarium...and then at VBA. 121kB/160kB
FilterAdvanced.zip

FilterAdvanced.pdf
Jiri Cihar 30.5.2006 The Advanced Filter enable you to create a more complex selection then AutoFilter based on different criteria in multiple columns. The workbook contains examples as follows:
  • random sampling
  • checking data integrity between original list and working list
  • selecting list of employees belonging to 20% best paid
  • set the list of employees with salary between 85% - 115% of average value
  • identify values missing in list A and occuring in list B
130kB/240kB
LifesMap.zip
Jiri Cihar 8.6.2006 I am very keen of reading articles at Kathy Sierras web http://headrush.typepad.com . Recently I have found an idea of "Calendar of Life" and was totaly hit and impressed. It was a challenge for me to "wrap" the idea in Excel world. And VBA is 100% at your disposal. 365kB/484kB