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