Learn Excel 2016 for OS X. ([2015])

• Record Type: Book
• Further Information: Note: Guy Hart-Davis.
• Authors: Hart-Davis, Guy
• Contents: 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. 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. 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. 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. 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.
• Edition: Second edition
• Publisher Details: Berkeley, CA : Apress
• Publication Date: 2015
• Copyright Date: 2015
• Extent: 1 online resource, color illustrations
• Subjects: 005.5; Computer science; Business -- Computer programs; COMPUTERS -- Desktop Applications -- Suites; COMPUTERS -- Hardware -- Personal Computers -- Macintosh; Business -- Computer programs; Computer Science; Computer Science, general; Computer Applications; Computers -- Online Services -- General; Computers -- Data Processing; Computer networking & communications; Information technology: general issues; Apple computer; Information systems; Computers -- Programming -- Apple Programming; Macintosh programming; Electronic books
• Languages: English
• ISBNs: 9781484210192; 1484210190
• Related ISBNs: 9781484210208; 1484210204; 9781484210208
• Notes: Note: Online resource; title from PDF title page (EBSCO, viewed November 10, 2015).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.