226. *** EXCEL / Slot Date Of Births Into Age Groups Using VLOOKUP:-

Click here to download this file

225. WORD / WORD document in the form required by Indiana Court of Appeals (Added Aug 19/16):-

Click here to download this file

224. *** EXCEL / Calculate percentage of time where decision made in 2 hours or less using simple formula, careful formatting of cells and Conditional Formatting (Added Aug 7/16):-

Click here to download this file

223. *** EXCEL Conditional Formatting - Highlight cells that are Mondays, Saturdays or Sundays (Added Mar 26/16):-

Click here to download this file

222. *** EXCEL Conditional Formatting - Specific Colour If Date Is More Than 5 Days Prior To Current Date (Added Mar 26/16):-

Click here to download this file

221. *** EXCEL Conditional Formatting For WEEKDAY Function (Added Mar 26/16):-

Click here to download this file

220. EXCEL Conditional Formatting For Dates Related to TODAY (Added Mar 25/16):-

Click here to download this file

219. *** EXCEL VLOOKUP (Added Feb 20/16):-

Click here to download this file

218. EXCEL Conditional Formatting - Highlight Range If 1 Cell Contains Specific Text (Added Feb 14/16):-

Click here to download this file

217. EXCEL Calendar (Added Feb 14/16):-

Click here to download this file

216. *** EXCEL Vehicle Departure Peak Times Chart (Added Jan 29/16):-

Click here to download this file

215. *** EXCEL Bar Chart With Years On Vertical Axis (Added Dec 4/15):-

Click here to download this file

214. WORD Table (Added Aug 30/15):-

Click here to download this file

213. EXCEL Time Sheet (Added Jun 21/15):-

Click here to download this file

212. *** EXCEL Pivot Chart (Added Apr 26/15):-

Click here to download this file

211. *** EXCEL Scatter Chart X Axis Shows Year 1900 Dates Should Show Dates In The Format 01/01/2013 14:02:00 [European Date Conventions] (Added Mar 15/15):-

Click here to download this file

210. EXCEL Save Workbook As Macro Enabled / Insert Code / Get Code To Run (Added Mar 12/15):-

Click here to download this file

209. *** EXCEL Discount Table Three Bands (Added Dec 24/14):-

Click here to download this file

Click here to download this file

Click here to download this file

208. *** EXCEL Pivot Table (Added Dec 19/14):-

Click here to download this file

207. EXCEL RANK results (Added Dec 4/14):-

Click here to download this file

206. *** EXCEL Named Range (Added Nov 9/14):-

Click here to download this file

205. *** PowerPoint Presentation With Embedded WORD File Included (Added Nov 1/14):-

Click here to download this file

204. *** PowerPoint Animate Chart (Added Oct 18/14):-

Click here to download this file

203. *** EXCEL Pivot Sales By Weeks (Added Oct 12/14):-

Click here to download this file

Click here to download this file

202. *** EXCEL Pivot Chart By Day Of The Month (Added Oct 7/14):-

Click here to download this file

201. EXCEL Table And Pivot Chart (Added Jul 14/14):-

Click here to download this file

200. *** EXCEL Income By Client By Quarter By Year (Added Jun 24/14):-

Click here to download this file

199. EXCEL Breakdown Of Sales Figures (Added Jun 22/14):-

Click here to download this file

198. *** EXCEL Add Named Ranges And Use In Formulas (Added Jun 15/14):-

Click here to download this file

197. *** EXCEL Finances / Table / Pivot Table (Added Apr 23/14):-

Click here to download this file

196. *** EXCEL Bucket Cashflows (Added Apr 8/14):-

Click here to download this file

194. *** EXCEL Data Validation Lists (Added Mar 4/14):-

Click here to download this file

193. *** EXCEL Pivot Table Group Columns By Days Of The Week (Added Feb 23/14):-

Click here to download this file

192. *** EXCEL Data Validation Plus VLOOKUP (Added Feb 18/14):-

Click here to download this file

191. WORD Form - Combo Box Content Control Plus ActiveX Control (Added Feb 16/14):-

Click here to download this file

190. EXCEL IFERROR (Added Feb 3/14):-

Click here to download this file

189. EXCEL Pivot Table (Added Jan 30/14):-

Click here to download this file

188. WORD How To Sort A Table (Added Dec 20/13):-

Click here to download this file

187. *** EXCEL Pivot Table (Added Dec 16/13):-

Click here to download this file

186. *** EXCEL VLOOKUP (return 2 columns) and Data Validation List (Added Dec 11/13):-

Click here to download this file

185. EXCEL Pivot Table plus Calculated Field (Added Nov 23/13):-

Click here to download this file

184. *** EXCEL Table / Data Validation / VLOOKUP (Added Nov 20/13):-

Click here to download this file

183. EXCEL Pivot Table % Of Parent Row Total Setting (Added Oct 21/13):-

Click here to download this file

182. EXCEL Horizontal Axis Multi Line Chart (Added Oct 1/13):-

Click here to download this file

181. EXCEL XY Scatter Chart (Added Aug 16/13):-

Click here to download this file

180. EXCEL Pivot Table Per Cent Of Total (Added Aug 13/13):-

Click here to download this file

179. EXCEL Pivot Table Sort By Top 15 Then By Others (Added Jul 4/13):-

Click here to download this file

178. EXCEL Data Validation / List (Added Jun 14/13):-

Click here to download this file

177. EXCEL Pivot Table / Chart Month Averages (Added Jun 3/13):-

Click here to download this file

176. EXCEL Drug Administration Chart (Added May 29/13):-

Click here to download this file

175. EXCEL Area And Line Chart Combined (Added May 25/13):-

Click here to download this file

174. EXCEL Bar Chart With Dates Sorted By Months (Added May 22/13):-

Click here to download this file

173. Charts between EXCEL and PowerPoint (Added May 15/13):-

Click here to download this file

Click here to download this file

172. EXCEL Pivot Table / Chart (Added Apr 26/13):-

Click here to download this file

171. EXCEL Sort example (Added Apr 19/13):-

Click here to download this file

170. EXCEL Add Tick Symbol (Check Mark) to QAT And Create Shortcut For It (Added Apr 10/13):-

Click here to download this file

169. EXCEL Chart (Added Mar 24/13):-

Click here to download this file

168. EXCEL / PowerPoint link (Added Feb 7/13):-

Click here to download this file

Click here to download this file

167. Adding page numbers to a WORD document (Added Jan 29/13):-

Click here to download this file

166. *** WORD First Line Indentation Macro (Added Jan 12/13):-

Click here to download this file

165. WORD To PowerPoint (Added Nov 6/12):-

Click here to download this file

Click here to download this file

164. EXCEL Compare Data Between Years (Added Nov 5/12):-

Click here to download this file

162. EXCEL Zip Code CONCATENATE and retain leading zero (Added Oct 29/12):-

Click here to download this file

161. *** EXCEL Column Chart Comparing Years (Added Oct 26/12):-

Click here to download this file

160. EXCEL Calculating Elapsed Time Example (Added Oct 11/12):-

Click here to download this file

159. EXCEL Cond Formatting / Icon Sets / Percentages (Added Sep 20/12):-

Click here to download this file

Click here to download this file

158. EXCEL Pivot Table - Readings against a time of day (Added Aug 22/12):-

Click here to download this file

157. EXCEL Bar Chart (Added Aug 14/12):-

Click here to download this file

156. EXCEL XY Column Chart (Added Jun 28/12):-

Click here to download this file

155. EXCEL One dimensional array (Added Jun 6/12):-

Click here to download this file

154. EXCEL Cond Formatting (Added May 14/12):-

Click here to download this file

153. EXCEL Cond Formatting (Added May 14/12):-

Click here to download this file

152. EXCEL Personnel Dept Holiday (Vacation) Records For 3 Employees (Added Apr 29/12):-

Click here to download this file

Click here to download this file

Click here to download this file

Click here to download this file

151. EXCEL Consumer Reports type ratings (Added Mar 27/12):-

Click here to download this file

150. EXCEL Running Balance Cheque (Checking) Account (Amended Mar 14/12):-

Click here to download this file

149. EXCEL User Defined Function (Added Feb 5/12):-

Click here to download this file

Click here to download this file

148. EXCEL Pivot Person By Hours Worked And Percentage Time Spent On Activity (Added Jan 30/12):-

Click here to download this file

147. EXCEL Bond Yield To Maturity (Added Jan 30/12):-

Click here to download this file

146. EXCEL Most Expensive Employees Pivot (Added Nov 1/11):-

Click here to download this file

145. EXCEL Protection Products Workbook (Added Oct 22/11):-

Click here to download this file

144. EXCEL Pivot Chart (Added Oct 2/11):-

Click here to download this file

142. EXCEL Dynamic Update of EXCEL Chart (Added Sep 11/11):-

Click here to download this file

Click here to download this file

141. EXCEL Cond Formatting / Data Bar (Revised Sep 11/11):-

Click here to download this file

140. Track Overtime (Added Sep 5/11):-

Click here to download this file

139. Solver Problem (Improved Sep 24/11):-

Click here to download this file

Click here to download this file

138. Parenting Times (Added Aug 25/11):-

Click here to download this file

137. Column And Line Chart (Added Aug 18/11):-

Click here to download this file

136. Pivot Table Grouped By Name / Month / Count:-

Click here to download this file

135. Surface Chart:-

Click here to download this file

134. Conditional Formatting:-

Click here to download this file

133. Pivot Chart:-

Click here to download this file

132. Dates and times on horizontal axis:-

Click here to download this file

131. Radar (spider) chart:-

Click here to download this file

130. Tornado Chart:-

Click here to download this file

129. Office 2010 Licence Options:-

Click here to download this file

128. Trial Versions Potential Problems:-

Click here to download this file

127. Pivot Table (totals by date):-

Click here to download this file

126. Header on first 2 pages only of WORD 2007 document:-

Click here to download this file

125. 24 hours Gantt chart in EXCEL 2007:-

Click here to download this file

124. Stock Chart:-

Click here to download this file

123. COUNTIFS Find the number of stores in a city with zero sales:-

Click here to download this file

122. Sharing EXCEL 2007 files problems:-

Click here to download this file

121. Rolling Last 24 Months Of Data Chart:-

Click here to download this file

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 separate 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

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 (Improved Dec 17/14):-

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. EXCEL Pivot Table Calculated Item (Reviewed Jun 4/13):-

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 (Reviewed Sep 14/11):-

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(VLOOKUP)Updated Jan 25/11:-

Click here to download this file

22. 2 Pivot Tables (same source data) for KrispyData:-

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 Click here to download this file