Microsoft Excel 2007 Bible

Microsoft Excel 2007 Bible (Paperback)

By John Walkenbach 
Publisher: Wiley India Pvt Ltd
Edition: Paperback
Language: English
ISBN: 8126511427
EAN: 9788126511426
No. of Pages: 912
Publish Date: 2007-2-6
Binding: Paperback
Ships to India.

Description

About the Book :

Whether youre just discovering Excel or are already a power user, theres no better instructor than "Mr. Spreadsheet," John Walkenbach. From basic formulas, functions, and chart creation to data analysis, custom number formats, data validation, and Excel programming with VBA, this is the comprehensive resource for Excel 2007. No matter what your level of expertise, youll benefit from hundreds of examples, exercises, tips, techniques, and workarounds. Learn your way around cells, rows, columns, worksheets, workbooks, and rangesDiscover how to create charts and diagrams, organize lists, and simplify complex tasks using ExcelDevelop formulas that manipulate text, look up values, and perform financial applicationsAnalyze data using external database files and pivot tablesUse XML to facilitate data reporting, analysis, importing, and exportingExplore conditional formatting, link and consolidate worksheets, and use Excel in a workgroupUnderstand how Excel uses HTML in Internet applicationsProgram Excel using VBA, develop UserForms, and create custom add-ins

About the Author :

John Walkenbach principal of J-Walk and Associates, Inc. is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 30 books and 300 articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at www.j-walk.com/ss and promotes all his books at that site.

Interesting Facts :

HISTORIC BESTSELLER: Excel Bible is a perennial bestseller. The 2003 Edition has sold over 90,000 units.NAME RECOGNITION OF AUTHOR: John Walkenbachs name is synonymous with excellence in computer books that explain the complexities of the worlds leading digital business tool. John Walkenbach, known as Mr. Spreadsheet, is author of more than 30 books. His web site on Excel is the most frequently visited Excel site after Microsoft. The authors previous books, including Excel 2003 Bible, Excel 2003 Power Programming with VBA and Excel 2003 Formulas, consistently appear at the top of many bestseller lists.FULLY UPDATED: This edition of Excel Bible covers all the new features of Excel 2007, including how to navigate through the new user interface, how to maximize the advantages of the new file formats, and how to maximize all the new features of this revolutionary upgrade of Microsoft Office.DOMINANT SPREADSHEET TOOL: Microsoft Office Excel is the dominant spreadsheet application for the Windows platform. It is an indispensable business tool.VALUABLE CD: The CD contains all the templates and worksheets used in the book plus John Walkenbachs award-winning Power Utility Pak.

Contents :

AcknowledgmentsIntroductionPart I: Getting Started with ExcelChapter 1: Introducing ExcelChapter 2: Whats New in Excel 2007?Chapter 3: Entering and Editing Worksheet DataChapter 4: Essential Worksheet OperationsChapter 5: Working with Cells and RangesChapter 6: Introducing TablesChapter 7: Worksheet FormattingChapter 8: Understanding Excels FilesChapter 9: Using and Creating TemplatesChapter 10: Printing Your WorkPart II: Working with Formulas and FunctionsChapter 11: Introducing Formulas and FunctionsChapter 12: Creating Formulas That Manipulate TextChapter 13: Working with Dates and TimesChapter 14: Creating Formulas That Count and SumChapter 15: Creating Formulas That Look Up ValuesChapter 16: Creating Formulas for Financial ApplicationsChapter 17: Introducing Array FormulasChapter 18: Performing Magic with Array FormulasPart III: Creating Charts and GraphicsChapter 19: Getting Started Making ChartsChapter 20: Learning Advanced ChartingChapter 21: Visualizing Data Using Conditional FormattingChapter 22: Enhancing Your Work with Pictures and DrawingsPart IV: Using Advanced Excel FeaturesChapter 23: Customizing the Quick Access ToolbarChapter 24: Using Custom Number FormatsChapter 25: Using Data ValidationChapter 26: Creating and Using Worksheet OutlinesChapter 27: Linking and Consolidating WorksheetsChapter 28: Excel and the InternetChapter 29: Sharing Data with Other ApplicationsChapter 30: Using Excel in a WorkgroupChapter 31: Protecting Your WorkChapter 32: Making Your Worksheets Error-FreePart V: Analyzing Data with ExcelChapter 33: Using Microsoft Query with External Database FilesChapter 34: Introducing Pivot TablesChapter 35: Analyzing Data with Pivot TablesChapter 36: Performing Spreadsheet What-If AnalysisChapter 37: Analyzing Data Using Goal Seek and SolverChapter 38: Analyzing Data with the Analysis ToolPakPart VI: Programming Excel with VBAChapter 39: Introducing Visual Basic for ApplicationsChapter 40: Creating Custom Worksheet FunctionsChapter 41: Creating UserFormsChapter 42: Using UserForm Controls in a WorksheetChapter 43: Working with Excel EventsChapter 44: VBA ExamplesChapter 45: Creating Custom Excel Add-InsPart VII: AppendixesAppendix A: Worksheet Function ReferenceAppendix B: Whats on the CD-ROMAppendix C: Additional Excel ResourcesAppendix D: Excel Shortcut KeysIndex
show moreless

Specification

Title: Microsoft Excel 2007 Bible
Publisher: Wiley India Pvt Ltd
Author: John Walkenbach
Edition: Paperback
Language: English
ISBN: 8126511427
EAN: 9788126511426
No. of Pages: 912
Publish Date: 2007-2-6
Binding: Paperback

Disclaimer

  • The book summary and image may be of a different edition or binding of the same title.
  • Book reviews are added by registered customers. They need not necessarily buy book.
  • These books are NOT available for reading online or for free download in PDF or ebook format.
  • Price can change due to reprinting, price change by publisher or sourcing cost change for imported books.
  • www.infibeam.com/Books is the biggest online bookstore in India for sale of books at best price - fiction, literature, audiobooks, study guides, novels, story books, rare books, textbooks and books by popular authors. These are available in various editions and bindings e.g. paperback and at best discount.
  • For the imported title, once the order gets placed ,it can’t be cancelled


Great Value

Safe Payment

Shop With
Confidence

Help Center

Free & Easy Return

Get Discounts & Offers
Stay Connected

Popular Searches on Infibeam.com

Online Shopping: Deal of The Day / Hot Deals / Best Deals / Offers

Apple iPhones: Iphone Xs Max / Iphone Xs / Iphone XR / iPhone 8 / iPhone 8 / iPhone 7 / iPhone 7 Plus / iPhone 6s / iPhone 5s

Mobile Phones:Unboxed Mobiles / Apple Mobiles / Samsung Mobiles / Micromax Mobiles / Sony Mobiles / Intex Mobiles / Latest Mobiles / Smartphones / 4G Phones / 3G Phones

Computers:Dell Laptops / Lenovo Laptops / Acer Laptops / HP Laptops / External Hard Disks / Pen Drives / Monitors / Softwares / Printers

Appliances:Air Conditioners / Air Coolers / Refrigerators / Geysers / Room Heaters / Immersion Rod / Water Purifiers / Washing Machines / Microwaves & OTG / Air Purifier

Electronics: Tablets / Cameras / Headphones / Power Bank / LED TVs / Gaming Consoles / Speakers / Tablet Accessories / Memory Cards

Men's Clothing: Shirts / T-Shirts / Tracksuits / Trousers / Ethnic Wear / Men's Denim / Cargo Shorts / Tees & Polos / Suits & Blazer

Women's Clothing: Dress Materials / Salwar Suits / Women Sarees / Kurtas & Kurtis / Leggings / Lingerie / Night Suits & Nighties / Women Shorts / Tops

Fashion:Men's Shoes / Women's Footwear / Fastrack Watches / Titan Watches / Timex Watches / Bags / Jewellery / Fastrack Sunglasses / Perfumes & Deodorants / Fashion Accessories

Online Book Store:Best Sellers Books / Business Books / History and Politics / Academic and Professional / Competitive Exams / Biographies and Autobiographies

Best Ecommerce Platform:Online Store Builder / Create Online Store / Best Ecommerce Solutions / Sell Online / Ecommerce Marketing Blog

Ecommerce Website Templates:Free Website Templates / Free Logo Design / SEO Audit Report / Theme Store / Wordpress Themes / Web & App Development Company

Copyright © 2007-2019 Infibeam.com and Affiliates
Site is up