Sale!

Guerilla Data Analysis Using Microsoft Excel 1st Edition by Bill Jelen ISBN 0972425802 9780972425803

Original price was: $50.00.Current price is: $35.00.

Guerilla Data Analysis Using Microsoft Excel 1st Edition Bill Jelen Digital Instant Download

Author(s): Bill Jelen
ISBN(s): 9780972425803, 0972425802
Edition: 1
File Details: PDF, 7.18 MB
Year: 2002
Language: english
SKU: EB-1809810 Category: Tag:

Guerilla Data Analysis Using Microsoft Excel 1st Edition by Bill Jelen – Ebook PDF Instant Download/Delivery: 0972425802, 9780972425803
Full download Guerilla Data Analysis Using Microsoft Excel 1st Edition after payment

Product details:

ISBN 10: 0972425802 
ISBN 13: 9780972425803
Author: Bill Jelen

This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, “MrExcel,” during his 10-year run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, and much more.

Guerilla Data Analysis Using Microsoft Excel 1st Table of contents:

  1. In the trenches
  2. Changing formulas to values
  3. Other uses for Paste Special
  4. Multiple customer names/single customer number
  5. VLOOKUP
  6. All sorts of sorts
  7. Sorting rules
  8. Comparing sort techniques
  9. Matching two lists of data
  10. Building a formula for forecast balance
  11. Eliminating rounding errors
  12. Calculating total expected
  13. Manually catching errors
  14. Automated error checking
  15. Conclusion
  16. Data→Consolidate
  17. Data→Subtotals and Go To Special
  18. Subtotaling data
  19. Go To Special
  20. To remove subtotals
  21. To add additional subtotals
  22. Subtotals bug in Excel 7.0 (95)
  23. Filtering Data
  24. Finding records quickly with AutoFilter
  25. Using Advanced Filter
  26. Conclusion
  27. SUMIF and COUNTIF
  28. SUMIF
  29. SUMIF with two criteria
  30. COUNTIF
  31. The keys to the kingdom: CSE
  32. Using array formulas
  33. Copying array formulas
  34. Advanced array formulas
  35. Finding CSE in the help files
  36. Array formulas and their impact on overhead
  37. Pivot tables
  38. Pivot table capabilities
  39. How to create a pivot table
  40. Things to note about pivot tables
  41. Intermediate tips, tricks, and troubleshooting
  42. Pivot table Q & A
  43. INDIRECT and OFFSET functions
  44. INDIRECT function
  45. Advanced INDIRECT
  46. Using INDIRECT with an array formula
  47. Using INDIRECT as an Argument for Another Function
  48. OFFSET Function
  49. Remedial reading
  50. Relative, absolute, and mixed references
  51. Use the End key to “ride the range”
  52. Nesting formulas
  53. IF functions
  54. Use Boolean logic facts
  55. Page Setup forces reports to fit
  56. Text manipulation formulas
  57. Date handling
  58. Quickly see Sum/Average of a range
  59. Customizing Any Chart Feature with a Right-Click
  60. Introduction to Excel functions
  61. Predict your car loan payment with PMT()
  62. Round prices up with CEILING()
  63. Convert between units of measurement with CONVERT()
  64. Present bad financial news in Roman numerals with ROMAN()
  65. Compare errors in absolute terms with ABS()
  66. Use random numbers to provide simulations with RAND()
  67. Get sales forecasts with =FORECAST()
  68. Figure out the slope of a line with LINEST()
  69. Rewrite the CSE chapter with SUMPRODUCT()
  70. Choose from a list with CHOOSE()
  71. Test to see if a case is full with ISEVEN()
  72. Put 7th grade math teachers out of a job with GCD(), LCM(), FACT()
  73. Impress your Lotus 1-2-3 friends with DAVERAGE()
  74. There are many more cool functions!

People also search for Guerilla Data Analysis Using Microsoft Excel 1st:

using excel for data analysis
    
using excel to analyse data
    
data analysis tools and techniques in excel
    
guerilla data analysis
    
guerrilla data analysis using microsoft excel

Tags: Bill Jelen, Guerilla Data, Microsoft Excel