Excel 2013 bible

John Walkenbach

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. Shares the invaluable insight of Excel guru and bestselling author "Mr. Spreadsheet" John Walkenbach as he guides you through every aspect of Excel 2013 Provides essential coverage of all the newest features of Excel 2013 Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience Features a website that includes downloadable templates and worksheets from the book Chart your path to fantastic formulas and stellar spreadsheets with Excel 2013 Bible!.

MoreLess

Alternative title:	Microsoft Excel 2013 bible
Year of publication:	2013 ; Online-Ausg.
Authors:	Walkenbach, John
Publisher:	Indianapolis : Wiley
Subject:	EXCEL

Extent:	Online-Ressource (xxxvii, 1012 p.) ill.
Series:	Bible Ser
Type of publication:	Book / Working Paper
Language:	English
Notes:	Includes index. - Electronic reproduction; Palo Alto, Calif; ebrary; 2013; Available via World Wide Web; Access may be limited to ebrary affiliated libraries Excel 2013 Bible; Contents; Introduction; Is This Book for You?; Software Versions; Conventions Used in This Book; How This Book Is Organized; How to Use This Book; What's on the Website; Part I: Getting Started with Excel; Chapter 1: Introducing Excel; Identifying What Excel Is Good For; Seeing What's New in Excel 2013; Understanding Workbooks and Worksheets; Moving Around a Worksheet; Using the Ribbon; Using Shortcut Menus; Customizing Your Quick Access Toolbar; Working with Dialog Boxes; Using Task Panes; Creating Your First Excel Workbook; Chapter 2: Entering and Editing Worksheet Data Exploring Data TypesEntering Text and Values into Your Worksheets; Entering Dates and Times into Your Worksheets; Modifying Cell Contents; Applying Number Formatting; Chapter 3: Essential Worksheet Operations; Learning the Fundamentals of Excel Worksheets; Controlling the Worksheet View; Working with Rows and Columns; Chapter 4: Working with Cells and Ranges; Understanding Cells and Ranges; Copying or Moving Ranges; Using Names to Work with Ranges; Adding Comments to Cells; Chapter 5: Introducing Tables; What Is a Table?; Creating a Table; Changing the Look of a Table; Working with Tables Chapter 6: Worksheet FormattingGetting to Know the Formatting Tools; Using Different Fonts to Format Your Worksheet; Changing Text Alignment; Using Colors and Shading; Adding Borders and Lines; Adding a Background Image to a Worksheet; Using Named Styles for Easier Formatting; Understanding Document Themes; Chapter 7: Understanding Excel Files; Creating a New Workbook; Opening an Existing Workbook; Saving a Workbook; Using AutoRecover; Password-Protecting a Workbook; Organizing Your Files; Other Workbook Info Options; Closing Workbooks; Safeguarding Your Work; Excel File Compatibility Chapter 8: Using and Creating TemplatesExploring Excel Templates; Understanding Custom Excel Templates; Chapter 9: Printing Your Work; Basic Printing; Changing Your Page View; Adjusting Common Page Setup Settings; Adding a Header or Footer to Your Reports; Copying Page Setup Settings across Sheets; Preventing Certain Cells from Being Printed; Preventing Objects from Being Printed; Creating Custom Views of Your Worksheet; Part II: Working with Formulas and Functions; Chapter 10: Introducing Formulas and Functions; Understanding Formula Basics; Entering Formulas into Your Worksheets Editing FormulasUsing Cell References in Formulas; Using Formulas in Tables; Correcting Common Formula Errors; Using Advanced Naming Techniques; Working with Formulas; Chapter 11: Creating Formulas That Manipulate Text; A Few Words about Text; Text Functions; Advanced Text Formulas; Chapter 12: Working with Dates and Times; How Excel Handles Dates and Times; Date-Related Worksheet Functions; Time-Related Functions; Chapter 13: Creating Formulas That Count and Sum; Counting and Summing Worksheet Cells; Basic Counting Formulas; Advanced Counting Formulas; Summing Formulas Conditional Sums Using a Single Criterion pt. 1. Getting started with Excel -- pt. 2. Working with formulas and functions -- pt. 3. Creating charts and graphics -- pt. 4. Using advanced Excel features -- pt. 5. Analyzing data with Excel -- pt. 6. Programming Excel with VBA -- pt. 7. Appendixes Microsoft Excel 2013 bible
ISBN:	978-1-118-49172-0 ; 978-1-118-49036-5 ; 1-118-49036-3
Source:	ECONIS - Online Catalogue of the ZBW

Persistent link: https://www.econbiz.de/10012600482