Excel 2016 Core Part One
Publisher: Bookboon
Published: 2015
ISBN-13: 9788740311747
Table of contents: title: Content; title: First things first; title: Starting Excel; title: The Excel Window; title: The Ribbon; title: Customizing the Quick Access toolbar; title: Customizing the Ribbon; title: Using Zoom; title: Assigning shortcut keys using The Alt Key; title: Adding values to workbook properties; title: The Advanced Properties Dialogue box; title: Saving; title: Saving a Workbook for the First Time; title: Saving Your Workbook Once It Has A Name; title: Save as different file formats; title: Saving Files to remote locations; title: Maintaining backward compatibility; title: Backstage view; title: The Backstage View; title: Excel Options; title: Share the workbook with others; title: Share with People; title: Share with People via File Menu; title: Share with People from within the workbook; title: Share Via Email; title: Open a Shared Workbook; title: Create Worksheets and Workbooks; title: Creating new blank workbooks; title: Creating New Workbooks Using Templates; title: Changing worksheet order; title: Move or copy to a different workbook; title: Set how many worksheets you start with; title: Importing a .CSV file; title: Adding data; title: Adding Text; title: Adding Numbers; title: Moving Around a Spreadsheet; title: Cursor Shapes (Mouse Shapes); title: Selecting Data in a Worksheet; title: Navigating your Workbook; title: Searching for data within a workbook; title: Inserting hyperlinks; title: Using Go To; title: Using the Name Box to Navigate; title: Workbook Views; title: Introduction to Views; title: Page Breaks; title: Creating Custom Views; title: Working with Data; title: Cut and Paste; title: Using Paste Special; title: Formatting Cells and Worksheets; title: The Font Group; title: The Alignment Group; title: The Number Group; title: Wrapping Text in a Cell; title: Format Painter; title: Merge or Split Cells; title: Merging Cells; title: Merge Across; title: Un merge Cells; title: Headers and Footers; title: Headers and Footers; title: Printing Headings; title: Print Titles; title: Hide and Unhide Rows and Columns; title: Hiding Columns; title: Un hide Columns; title: Hiding Rows; title: Unhide Rows; title: Page Setup Options for Worksheets; title: Page Orientation; title: Changing the Header and Footer Size; title: Setting Print Scaling; title: Print a Worksheet or a Workbook; title: Printing; title: Printing individual worksheets; title: Cell Styles; title: Apply Cell Styles; title: Create Cell Styles; title: Autofill; title: Copy Data using Autofill; title: Fill Series using Autofill; title: Copy Formatting using Autofill; title: Flash Fill; title: Flash Fill; title: Formulas; title: Formulas Introduction; title: How is a formula made up?; title: Create Formulas; title: Add, Subtract, Multiply, Divide; title: Make Changes to Formulas in a Cell; title: Make Changes to Formulas in the Formula Bar; title: Using Autofill to Copy Formulas; title: Enforce Precedence; title: Order of Evaluation (Order of Precedence) (BODMAS); title: Absolute Cell References; title: Absolute Cell References; title: How to Create an Absolute Cell Reference; title: Relative Cell References; title: Basic Functions; title: Basic Functions; title: Using Basic functions via the Auto sum Button; title: Managing Worksheets and Workbooks; title: Introduction Worksheets; title: Create and format worksheets; title: Adding worksheets to existing workbooks; title: Delete Worksheets; title: Copying and moving worksheets; title: Rename a Worksheet; title: Grouping Worksheets; title: Changing worksheet tab colour; title: Hiding worksheets; title: Sum across Worksheets; title: Manipulate window views; title: Splitting the window; title: Open Two Copies of the Same Workbook