Learn Excel 2016 for OS X

Microsoft Excel 2016 for Mac OS X is a powerful application, but many of its most impressive features can be difficult to find. Learn Excel 2016 for OS X by Guy Hart-Davis is a practical, hands-on approach to learning all of the details of Excel 2016 in order to get work done efficiently on OS X. Fr...

Full description

Bibliographic Details
Main Author: Hart-Davis, Guy
Format: eBook
Language:English
Published: [Berkeley, CA] Apress 2015
Edition:Second edition
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 05165nmm a2200577 u 4500
001 EB001930161
003 EBX01000000000000001093063
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
020 |a 9781484210192 
020 |a 1484210190 
050 4 |a HF5548.4.M525 
100 1 |a Hart-Davis, Guy 
245 0 0 |a Learn Excel 2016 for OS X  |c Guy Hart-Davis 
250 |a Second edition 
260 |a [Berkeley, CA]  |b Apress  |c 2015 
300 |a 1 online resource  |b color illustrations 
505 0 |a Setting Preferences for Creating and Saving Your Workbooks Creating Workbooks with the Number of Worksheets You Need; Choosing the Default Format for Saving Workbooks; Setting AutoRecover to Keep Backups of Your Workbooks for Safety; Making Excel Prompt You to Enter Workbook Properties; Creating Custom Keyboard Shortcuts; Opening One or More Workbooks Automatically with Excel; Summary; Chapter 3: Creating Effective Workbooks and Templates; Creating Workbooks from Scratch or from Templates; Creating a New Blank Workbook; Creating a New Workbook Based on a Template 
505 0 |a Freezing Rows and Columns So They Stay Onscreen Using Custom Views; Summary; Chapter 2: Configuring Excel to Suit the Way You Work; Opening the Excel Preferences Window; Controlling How the Excel Window Appears; Choosing Options in the Show in Workbook Area of View Preferences; Choosing How to Display Comments; Choosing How to Display Objects; Choosing Ribbon Options; Choosing Editing Options; Choosing Options in the Edit Options Area; Choosing Options in the Cut and Paste Options Area; Choosing Options in the Date Options Area 
505 0 |a Navigating Among Worksheets Changing the Active Cell; Selecting and Manipulating Cells; Tools for Entering Text and Formulas Quickly; Importing Data; Importing Data from a Comma-Separated Values File or a Text File; Importing Data from a FileMaker Pro Database; Importing Data from an HTML File; Connecting a Worksheet to External Data Sources; Entering Text Using AutoCorrect; Opening the AutoCorrect Preferences Pane; Choosing Options to Make AutoCorrect Work Your Way; Creating Replace-As-You-Type Entries; Creating AutoCorrect Entries; Using Your AutoCorrect Entries 
505 0 |a At a Glance; Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Part I: Becoming Proficient with Excel for Mac; Chapter 1: Learning the Secrets of the Excel for Mac Interface; Getting Ready to Learn Excel's Secrets; Three Ways to Control Excel; Secrets of the Ribbon; Understanding How the Ribbon's Tabs Work; Understanding How the Ribbon's Groups and Controls Work; Collapsing the Ribbon; Using the Menu Bar; Driving Excel with Keyboard Shortcuts; Navigating Quickly Through Worksheets and Workbooks; Elements of the Excel User Interface 
505 0 |a Entering Text with AutoFill and Custom ListsUsing AutoFill's Built-in Capabilities; Creating Your Own Custom AutoFill Lists; Entering Text Using Copy, Paste, and Paste Options; Switching Data from Rows to Columns; Pasting in a Table from Word; Getting Comma-Separated Data into a Worksheet; Entering Text with Find and Replace; Inserting Symbols in a Document; Viewing Your Workbooks; Splitting the Window to View Separate Parts of a Worksheet; Opening Extra Windows to Show Other Parts of a Workbook; Changing the Window and Arranging Open Windows; Zooming to Show the Data You Need to See 
653 |a Microsoft Office / http://id.loc.gov/authorities/names/n94101591 
653 |a Business / Computer programs / fast 
653 |a Mac OS. / http://id.loc.gov/authorities/names/n96060065 
653 |a COMPUTERS / Desktop Applications / Suites / bisacsh 
653 |a Computer networking & communications / bicssc 
653 |a Microsoft Office / fast 
653 |a Macintosh programming / bicssc 
653 |a Business / Computer programs / http://id.loc.gov/authorities/subjects/sh85018263 
653 |a Mac OS / fast 
653 |a Information technology: general issues / bicssc 
653 |a COMPUTERS / Hardware / Personal Computers / Macintosh / bisacsh 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
500 |a Includes index 
028 5 0 |a 10.1007/978-1-4842-1019-2 
015 |a GBB8M4390 
773 0 |t Springer eBooks 
776 |z 9781484210208 
776 |z 1484210190 
776 |z 1484210204 
776 |z 9781484210208 
776 |z 9781484210192 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781484210192/?ar  |x Verlag  |3 Volltext 
082 0 |a 331 
082 0 |a 384 
082 0 |a 005.5 
082 0 |a 330 
520 |a Microsoft Excel 2016 for Mac OS X is a powerful application, but many of its most impressive features can be difficult to find. Learn Excel 2016 for OS X by Guy Hart-Davis is a practical, hands-on approach to learning all of the details of Excel 2016 in order to get work done efficiently on OS X. From using formulas and functions to creating databases, from analyzing data to automating tasks, you'll learn everything you need to know to put this powerful application to use for a variety of tasks