This Home Page will be used to place MS Office 2007 worked examples on the site.
120. Line Chart (X dates / Y times 24 hour clock):-
Click here to download this file
119. Special Characters:-
Click here to download this file
118. Animate spearate elements of Bar Chart:-
Click here to download this file
Click here to download this file
117. Repeat EXCEL header rows in WORD doc:-
Click here to download this file
Click here to download this file
116. Get, "between date" in a Pivot Table:-
Click here to download this file
115. Horizontal Axis Multi Line Chart:-
Click here to download this file
114. How to add full path and file name in a footer and create template from it:-
Click here to download this file
Click here to download this file
Click here to download this file
Click here to download this file
113. XY (Scatter) Chart:-
Click here to download this file
112. Cond Form Example:-
Click here to download this file
111. Pivot Table and Pivot Chart:-
Click here to download this file
110. Further PowerPoint explanation:-
Click here to download this file
109. Bar Chart:-
Click here to download this file
108. Pivot Table:-
Click here to download this file
107. Column And Line Chart:-
Click here to download this file
106. Household budget:-
Click here to download this file
105. Floating Column Chart:-
Click here to download this file
104. Dynamic Range Chart:-
Click here to download this file
103. 2 charts side by side in PowerPoint 2007:-
Click here to download this file
102. Line Chart:-
Click here to download this file
101. Product Usage Chart:-
Click here to download this file
100. WORD 2007 Add Tick Symbol to Quick Access Toolbar:-
Click here to download this file
99. PowerPoint (inserting shape in text):-
Click here to download this file
98. Bar Chart / remove blanks / Pivot Table & Pivot Chart:-
Click here to download this file
97. Pivot Table & Chart:-
Click here to download this file
96. Bubble Chart (Elaborate):-
Click here to download this file
95. Pivot Table:-
Click here to download this file
94. Pivot Table By Month / Year:-
Click here to download this file
93. VLOOKUP:-
Click here to download this file
92. WORD Testing:-
Click here to download this file
Click here to download this file
91. PowerPoint One Column At A Time:-
Click here to download this file
90. Parts Per Hour Calculator:-
Click here to download this file
89. PowerPoint 5 Box At Top Hierarchy:-
Click here to download this file
88. Column Chart:-
Click here to download this file
87. How to set Slide Numbers in a PowerPoint 2007 Template:-
Click here to download this file
86. Pivot Table:-
Click here to download this file
85. Pie Chart:-
Click here to download this file
84. Copying data from one Worksheet to another:-
Click here to download this file
83. Column Chart:-
Click here to download this file
82. Pivot Table (Amounts By Days Of Week):-
Click here to download this file
81. How to create a hyperlink in PowerPoint 2007:-
Click here to download this file
80. Clustered Column Chart:-
Click here to download this file
79. XY (Scatter) Chart:-
Click here to download this file
78. Gantt Chart:-
Click here to download this file
77. Month End Dates On X Axis Chart:-
Click here to download this file
76. Sales Per Employee Pivot Table:-
Click here to download this file
75. Part Numbering Workbook:-
Click here to download this file
74. EXCEL 2007 Charts PowerPoint Presentation:-
Click here to download this file
73. Area Chart:-
Click here to download this file
72. Remove Empty Rows From Chart:-
Click here to download this file
71. Calculated Field WORD file:-
Click here to download this file
70. Calculated Field EXCEL file:-
Click here to download this file
69. Combined Line And Column Chart:-
Click here to download this file
68. Pivot Table Calculated Field:-
Click here to download this file
67. Pivot Table Calculated Item:-
Click here to download this file
66. Form:-
Click here to download this file
65. Gantt Chart:-
Click here to download this file
64. Scatter Chart:-
Click here to download this file
63. Stacked Column Chart:-
Click here to download this file
62. Scatter Chart:-
Click here to download this file
61. Combination Chart:-
Click here to download this file
60. Bubble Chart:-
Click here to download this file
59. Histogram Comparative:-
Click here to download this file
58. Column Chart (Data Labels Outside End):-
Click here to download this file
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
14. Data / Filter Example:-
Click here to download this file
13. VLOOKUP file for will gerrish:-
Click here to download this file
11. Get EXCEL to talk to you:-
Click here to download this file
7. 3-D Clustered Column Chart:-
Click here to download this file
6. Monthly Repayments / How Much Can I Borrow? / Value Of Savings:-
Click here to download this file