I n 1989, Bill Jelen took a job in a finance department to maintain a very expensive reporting tool. When he discovered on day one that this new tool did not work, he began to learn how to use a $299 spreadsheet program in ways no sane person would ever think to use it. To the manager who hired him, he now wants to admit that all the reports that allegedly came out of the $50K 4th GL reporting tool from 1989 through 1994 really were actually produced with Lotus 1-2-3 and, later, Excel. Thinking he was the smartest spreadsheet guy he knew, Jelen launched in 1998 and. | LEARN EXCEL 2007 from MR EXCEL Revised and Expanded Second Edition Now Including Over 100 New Topics Convert Text Remove Data Consolidate What-If to Table Duplicates Validation Analysis . W v. Clear u Reapply Filter Advanced Sort Filter Data Tools East ABC 2010 29K 2011 S4ÛM From From From Froi Access Web Tert Sr innections ft to Files 20251 S42K Central XYZ 2027 S32K Central XYZ Central XYZ 20291 S28K Central XYZ BILL JELEN 22 Central XYZ 2026 21K 26 Central Total S330K 2030 S41K West ABC 20161 27K Sales Eljseplace gjrrent subtotals E Page break between groups 0 Summary below data Remove Al OK East XYZ East .X East XYZ East XYZ 2013 14K 2014 37K rr unction rSum Add subtotal to .Region S Product Invoice Al JL1213J 1 2 bwbI Mytodn 1 Ea t 2007 16kT 2018 41K 14 East Total MH 15 Central ABC 2019 S22K 16 Central ABC 2020 43K 17 Central ABC 2021 38K 18 Central ABC 2022 S41K 19 Central ABC 2023 S23K 20 Central ABC 2024 13K 28 west ABC 2031 16K 29 West ABC 2032 S19K 30 West XYZ 2033 22K 31 West XYZ 2034 S30K 32 West XYZ 2035 S16K 33 West Total S143K 34 Grand Total 825K 1 EB U Sort This ebook licensed to H D. Unauthorized reproduction or distribution of this ebook is illegal. LEflRIl SW 97 tTinuufi EXCEL 2007 FRON IHR EXCEL 377 Excel Mysteries Solved Bill Jelen Holy Macro Books 13386 Judy Ave NW Uniontown OH 44685 Learn Excel 97 through Excel 2007 from MrExcel 2008 by Bill Jelen All rights reserved. No part of this book may be reproduced or transmitted in any form or by any means electronic or mechanical including photocopying recording or by any information or storage retrieval system without written permission from the publisher. All terms known in this book known to be trademarks have been appropriately capitalized. Trademarks are the property of their respective owners and are not affiliated with Holy Macro Books Every effort has been made to make this book as complete and accurate as possible but no warranty or fitness is implied. The information is provided on an .
