This Home Page will be used to place EXCEL worked examples on the site.
57. VLOOKUP:-
Click here to download this file
56. Subtotals Workbook:-
Click here to download this file
55. Line Chart:-
Click here to download this file
54. Conditional Formatting Workbook:-
Click here to download this file
53. 2 Series Line Chart:-
Click here to download this file
52. Pivot Chart with mmm-yy date consistency:-
Click here to download this file
51. Chart with Secondary Axis:-
Click here to download this file
50. Conditional Formatting (blank cells):-
Click here to download this file
49. Column Chart and Line Chart:-
Click here to download this file
48. Line Chart:-
Click here to download this file
47. 2 Linked Workbooks:-
Click here to download this file
Click here to download this file
46. RANK & Filter:-
Click here to download this file
45. Conditional Formatting:-
Click here to download this file
44. Stacked Line chart:-
Click here to download this file
43. Stacked Column chart:-
Click here to download this file
42. How to set up and use a Form:-
Click here to download this file
41. VLOOKUP:-
Click here to download this file
40. File for GEO:-
Click here to download this file
39. RANK example:-
Click here to download this file
38. Hotel Rates Pivot Chart:-
Click here to download this file
37. VLOOKUP:-
Click here to download this file
36. Pivot Table:-
Click here to download this file
35. Simple Sort:-
Click here to download this file
34. Whose available for the match?
Click here to download this file
33. Average Values Based On Time Period Pivot Table:-
Click here to download this file
32. Percentage Traffic Light System WORD file:-
Click here to download this file
31. Percentage Traffic Light System EXCEL file:-
Click here to download this file
30. Pivot Top Ten:-
Click here to download this file
29. Time calculations:-
Click here to download this file
28. Chart addition of Axis Titles and Data Labels:-
Click here to download this file
27. VLOOK up:-
Click here to download this file
26. Secondary Y axis example:-
Click here to download this file
25. Funds Collection Chart:-
Click here to download this file
24. Number of days people work for LEG (using COUNTA):-
Click here to download this file
23. US Zip Codes for powlaz (VLOOKUP):-
Click here to download this file
22. 2 Pivot Tables (same source data) for KrispyData:-
Click here to download this file
21. Ken Newberger file:-
Click here to download this file
20. School attendance Workbook:-
Click here to download this file
19. Proposed solution for Nelson:-
Click here to download this file
18. Clustered Bar Chart Example
Click here to download this file
17. Data Label In Front Of Graph Object Example
Click here to download this file
16. Stacked Column Chart (3rd version Fri Oct 9/9for Mark):-
Click here to download this file
15. File for Melanie (Thu Oct 1/9):-
Click here to download this file
14. Proposed solution for Khal (goods / cities):-
Click here to download this file
13. VLOOKUP file for will gerrish:-
Click here to download this file
12. Gill Sans MT file for nick:-
Click here to download this file
11. Get EXCEL to talk to you! (live worked example that talks):-
Click here to download this file
10. File for NGO (graph / chart):-
Click here to download this file
9. 2 Files for dalmon:-
Click here to download this file Click here to download this file
8. Stacked Bar Chart example:-
Click here to download this file
7. File for Cason (3-D shapes):-
Click here to download this file
6. File for Help I need the answer . . .
Click here to download this file
5. File For Hemant:-
Click here to download this file
4. PROPOSED PIVOT TABLE SOLUTION FOR RICH:-
Click here to download this file
3. PROPOSED SOLUTION FOR JANEASH TUE SEP 15/9:-
Click here to download this file
2. PROPOSED PIVOT TABLE SOLUTION FOR bfont:-
Click here to download this file
1. PROPOSED PIVOT TABLE SOLUTION FOR ART:-
Click here to download this file