Excel 2010 Introduction: Part I Formulas, Functions and Formatting
Publisher: Bookboon.com
Published: 2013
ISBN-13: 9788776818043
Table of contents: title: Obsah; title: INTRODUCTION; title: How To Use This Guide; title: Objectives; title: Instructions; title: Appendices; title: SECTION 1 THE BASICS; title: WINDOWS CONCEPTS; title: Menus; title: Ribbons; title: Dialog Box; title: File Ribbon; title: Toolbars; title: Mini Toolbar; title: Name Box; title: Formula Bar; title: Worksheets; title: Status Bar; title: Task Pane; title: Smart Tags; title: GETTING HELP; title: MICROSOFT EXCEL HELP; title: SECTION 2 MOVE AROUND AND ENTER DATA; title: MOVING; title: Moving Around Workbook; title: Scrolling; title: USEFUL KEYS FOR MOVING; title: WORKBOOK SHEETS; title: Moving Around Sheet; title: DATA ENTRY; title: Enter Text And Numbers; title: Cancelling And Editing Data Entries; title: Enter Dates; title: Autocomplete; title: Pick From List; title: EDITING; title: Typing Replaces Selection; title: Use The Mouse To Edit; title: Using The Keyboard; title: Select Information; title: Select Multiple Sheets; title: Select Non-Adjacent Sheets; title: Clear Contents, Formats And Comments; title: The Fill Handle; title: USEFUL INFORMATION; title: Scrolling; title: Data Entry; title: Select Cells To Limit Data Entry; title: Select Cells For Multiple Entry; title: SECTION 3 EXCEL 2010 FORMULAS AND FUNCTIONS; title: FORMULAE; title: Typing Formulae; title: Entering Formulae By Pointing; title: Errors In Formulae; title: Filling Formulae; title: The Fill Handle And Formulae; title: Fill Formulae Using Keystrokes; title: BoDMAS With Formulae; title: EXCEL 2010 FUNCTIONS; title: Basic Sum Function; title: Autosum; title: Other Common Functions; title: Function Library; title: Insert Function; title: Function Box; title: Type Functions; title: Function Argument Tool Tips; title: Cell References; title: ABSOLUTE AND RELATIVE REFERENCES; title: Relative References; title: Absolute References; title: Fill Handle; title: Absolute References; title: SECTION 4 FILE OPERATIONS; title: Save Files; title: File Types And File Names; title: Saving Changes To Files; title: Saving As A Different Type Or Different Name; title: Close Files; title: Open Files; title: New Files; title: SECTION 5 MOVING AND COPYING DATA; title: Moving Items; title: Copying Items; title: Clipboard; title: Drag And Drop; title: Shortcut Menus; title: Moving And Copying Between Files; title: Insert Paste; title: Moving And Copying Between Worksheets; title: Paste Special; title: SECTION 6 EXCEL 2010 FORMATTING; title: QUICK FORMATS; title: Formatting Groups On Home Ribbon; title: Font; title: Point Size; title: Bold, Italic And Underline; title: Font Colour; title: Background Fill Colour; title: Borders; title: Alignment; title: Merge Cells; title: Indents; title: Number Formats; title: ADVANCED FORMATS; title: Format Cells Dialog; title: Custom Number Formats; title: FORMATTING COLUMNS AND ROWS; title: Column Width; title: Row Height; title: Hide Columns, Rows And Sheets; title: INSERT AND DELETE CELLS, ROWS, COLUMNS OR SHEETS; title: Add Cells; title: Delete Cells; title: Format Painter; title: Shortcut Keys For Formatting; title: SECTION 7 NAMES; title: NAMING CELLS AND RANGES; title: Rules When Naming Cells; title: Selecting Names (Navigation); title: Manage Names By Using The Name Manager.; title: Names In Functions; title: Paste List Of Names; title: Intersecting Names; title: Applying Names; title: Filtering out needed named ranges; title: SECTION 8 WORKING WITH SHEETS; title: MULTIPLE WORKSHEETS; title: Moving Between The Workbook Sheets; title: Worksheet Names; title: Move And Copy Worksheets; title: Insert And Delete Worksheets; title: ACTIVATE GROUP MODE; title: Group Adjacent Sheets; title: Group Non-Adjacent Sheets; title: Deactivate Group Mode; title: FILL DATA ACROSS WORKSHEETS; title: 3-D Formulae; title: References to other sheets; title: PROTECT WORKSHEET DATA; title: Unlock Cells; title: Worksheet Protection; title: Unprotect Sheets; title: View Worksheets Side By Side; title: Hide Windows; title: Watch Window; title: Change Colour Of Worksheet Tab; title: SECTION 9 PRINTING; title: PRINT PREVIEW; title: PAGE SETUP; title: page setup group on the page layout ribbon; title: PAGE TAB; title: Print preview options; title: MARGINS TAB; title: To change header and footer position; title: HEADER/FOOTER TAB; title: Header; title: Footer; title: New Methods For Headers And Footers In 2010; title: Insert Specific Elements In A Header Or Footer; title: Add A Predefined Header Or Footer; title: Choose The Header And Footer Options; title: Custom Header Or Footer For A Chart; title: SHEET TAB; title: Print Area; title: Print Titles; title: Print; title: To change Sheet tab Print settings:; title: Page Breaks; title: PRINT DATA; title: Copies; title: SECTION 10 MANIPULATING LARGE WORKSHEETS; title: USEFUL TOOLS FOR LARGE SHEETS; title: Split Screen; title: Freeze Panes; title: Zoom; title: NAVIGATION; title: Go To; title: Navigating with name box; title: SECTION 11 SORTING & SUBTOTALLING DATA; title: LISTS; title: Do; title: Do Not; title: SORTING LIST DATA; title: Quick Sort; title: Multi Level Sort; title: SUBTOTALS; title: Organising The List For Subtotals; title: Example; title: Summarising A Subtotalled List; title: Show And Hide By Level; title: Remove Subtotals; title: SECTION 12 CUSTOMISING EXCEL; title: SET EXCEL OPTIONS; title: General; title: Formulas Sheet; title: Proofing; title: Save; title: Language; title: Advanced Options; title: Customise Excel Ribbons; title: Customise Quick Access Toolbar