Excel at Excel with the help of this bestselling spreadsheet guide
John Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more.
Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this latest edition provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else.
Chart your path to fantastic formulas and stellar spreadsheets with Excel 2013 Bible!
"synopsis" may belong to another edition of this title.
Q & A with John Walkenbach, author of Excel 2013 BibleJohn Walkenbach How long have you been using Excel?
My first spreadsheet experience was using VisiCalc, running on an Apple II computer owned by my employer. I eventually saved up and bought my own IBM-PC, and started using Lotus 1-2-3. At some point, probably around 1988, I tried out Excel, which included a run-time version of Windows. I thought the graphic user interface was just a gimmick, and I much preferred 1-2-3. But by Version 4 (released in 1992), I was hooked on Excel, and preferred it to the competitors. So, to answer your question . . . about 25 years.How has Excel changed the way people do business?
Among other ways, it puts data in the hands of users, and makes it easy to slice and dice information. People can run their own ad-hoc reports, and not have to rely on others to provide information.Any advice for new Excel users?
Be curious and don't be afraid to experiment. The Ribbon has hundreds of commands, and it's worth the time to dig around and see what they do. If you find something that seems useful, just work with it until you understand how it works. And, master the art of searching the web. There are countless Excel questions that have already been asked and answered.What is your favorite Excel 2013 feature?
Well, my favorite Excel feature, by far, is pivot tables. But if you're asking about features new to Excel 2013, it would have to be Flash Fill. It uses pattern recognition to transform a column of data (no formulas required). For example, you can use Flash Fill to extract last names from a column of names. It also works in the opposite direction, so you can combine multiple columns using Flash Fill. It’s not perfect, and it sometimes fails to identify some patterns so you need to check the results carefully. But, I expect to see this feature improved in future versions.What do you like most about writing about Excel?
It's when I first install the beta of a new version. It's always fun to see what's new and different. And, of course, I like the fact that I get very long vacations in between revisions.What is your all-time best Excel tip?
It's impossible to come up with one, but if forced to reply, I'd have to say it's the multi-cell array formula that I developed. This formula is entered into a 6-row x 7-column range of cells and displays a monthly calendar. The formula uses a cell that contains a date and updates when that date cell is changed.What can you do with Excel that might surprise people?
You can actually earn a living by writing about it!
But seriously, Excel is such a flexible product, there is almost no limit to what it can do. Even I'm surprised by some of the things I see. For example, I've seen some amazing games that run in Excel. And I've also seen some charts that I would have thought to be impossible. As the saying goes, it's limited only by your creativity--and there are some very creative Excel users out there.From the Back Cover:
Excel at Excel with this ultimate guide
Whether you want to create charts, import and clean data, automate tasks with VBA macros, or work in the cloud—however you want to use Excel, John Walkenbach can show you how. Fully updated for the latest features in Excel 2013, this perennial bestseller is packed with information, techniques, helpful notes, and tips to take your spreadsheet skills to the next level. Beginner, power user, or somewhere in between, this is the ultimate Excel resource you'll turn to again and again.
Use formulas and functions to create useful forms
Learn which chart is most suitable for your data
Pivot table slicers make it easy to filter data
"About this title" may belong to another edition of this title.
Book Description Wiley, 2013. Soft cover. Book Condition: New. International Edition. 1056pp. Book cover and ISBN different from US edition. Territorial Restrictions maybe printed on the book. This is an international edition. Bookseller Inventory # 327801
Book Description Wiley, 2013. Paperback. Book Condition: New. Ships from CA, USA with Tracking. Brand New. Bookseller Inventory # mon0000322439
Book Description Wiley. Book Condition: New. 1118490363 This is an International Edition. Brand New, Paperback, Delivery within 6-14 business days, Similar Contents as U.S Edition, ISBN and Cover design may differ, printed in Black & White. Choose Expedited shipping for delivery within 3-8 business days. We do not ship to PO Box, APO , FPO Address. In some instances, subjects such as Management, Accounting, Finance may have different end chapter case studies and exercises. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" and "Content may different from U.S. Edition" - printed only to discourage U.S. students from obtaining an affordable copy. The U.S. Supreme Court has asserted your right to purchase international editions, and ruled on this issue. Access code/CD is not provided with these editions , unless specified. We may ship the books from multiple warehouses across the globe, including India depending upon the availability of inventory storage. Customer satisfaction guaranteed. Bookseller Inventory # HU_9781118490365
Book Description Paperback. Book Condition: New. Softcover Book, New Condition, Fast Shipping. Ready in Stock. 1st Edition. [Please Read Carefully Before Buying], This Is An International Edition. Printed In Black and White. 1056 Pages, Book Cover And ISBN No May Be Different From US Edition. Restricted Sales Disclaimer Wordings Not For Sales In USA And Canada May Be Printed On The Cover Of The Book. Standard Shipping 7-14 Business Days. Expedited Shiping 4-8 Business Days. ***WE DO NOT ENTERTAIN BULK ORDERS.*** The Books May Be Ship From Overseas For Inventory Purpose. Bookseller Inventory # 367252
Book Description Wiley. PAPERBACK. Book Condition: New. 1118490363 We ship from India. PAPERBACK INTERNATIONAL EDITION Brand New Copy. The ISBN-13 or Cover might be different but content is extactly same. We deliver in 5 - 9 days and actively resolve customer issues. Bookseller Inventory # 1118490363-ABAB
Book Description Paperback. Book Condition: New. New, Softcover International Edition, Printed in Black and White, Only USPS Media mail Shipping ONLY, Different ISBN, Same Content As US edition, Book Cover may be Different, in English Language. Bookseller Inventory # 23284
Book Description Paperback. Book Condition: New. New condition. Softcover book, 1st Edition. (Read Description Before Buying), This is an international Edition. Black and White Book. ISBN or covers May Be Different From US Edition. Book may have Restricted Sales Disclaimer Wordings printed on cover. Books May Be Shipped From Overseas as per stock status. Bookseller Inventory # 758873
Book Description John Wiley and Sons. Book Condition: New. Brand New. Bookseller Inventory # 1118490363
Book Description 2013. PAP. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Bookseller Inventory # KB-9781118490365
Book Description Paperback. Book Condition: NEW. This is an International Edition. Brand New Paperback- Same Title Author and Edition as listed. ISBN and Cover design differs. Similar Contents as U.S Edition. Delivery within 3-7 business days ACROSS THE GLOBE. We can ship to PO Box address in US. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" or "For sale in Asia only" or similar restrictions- printed only to discourage students from obtaining an affordable copy. US Court has asserted your right to buy and use International edition. Access code/CD may not provided with these editions. We may ship the books from multiple warehouses across the globe including Asia depending upon the availability of inventory. Printed in English. Customer satisfaction guaranteed. Choose expedited shipping for Express delivery. Tracking number provided for every order. Bookseller Inventory # RU_9781118490365