
Advance excel 2016 training guide
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions


Content
- Cover Page
- Title Page
- Copyright Page
- Table of Contents
- Preface
- Acknowledgement
- Chapter 1: Overview of Excel 2016
- About Excel
- Components of the Excel Window
- Back stage view
- Saving and Sharing Files online
- Interacting with Excel
- Working with Default Settings
- Personalize options
- Save option
- Customize the Ribbon
- Formatting of Table
- Paste Special Preview
- Flash fills
- Quick Data Analysis
- Chapter 2: Cell References and Range
- Why Use Different Types of References?
- Types of Cell Reference
- Named Range
- Exercise
- Chapter 3: Working with Formulas and Functions
- Using Formulas in a Worksheet
- Array Formula
- Using functions
- IF function
- Nested IF
- IF with AND
- IF with OR
- IF with NOT
- Lookup Functions
- V-lookup
- H-lookup
- Making V-Lookup Dynamic
- Index
- Index-Match
- Exercise
- Chapter 4: Data Validation
- Setting Data Validation Rules
- Methods of Data Validation
- Exercise
- Chapter 5: Protection
- Protecting a Worksheet by using Passwords
- Protecting a Workbook
- Protecting Part of a Worksheet
- Password Protecting a File
- Case Study
- Chapter 6: Sorting a Database
- Simple Sort
- Multilevel Sort
- Customized Sorting
- Chapter 7: Filtering a Database
- Auto Filter
- Number, Text or Date Filters
- Filtering a List using Advanced Filter
- Filtering Unique Records
- Exercise
- Chapter 8: Subtotals
- Display Subtotal at Single Level
- Displaying Nested Subtotals
- Chapter 9: Pivot Tables
- Examining PivotTables
- Recommended Pivot Table
- Format a PivotTable Report
- Calculate the Percentage of the Field
- Top/Bottom Report
- Group Items in a PivotTable
- Create a Graph using Pivot Data
- Slicer
- Timeline
- Power View
- Power Pivot
- Creating pivot table use power pivot
- Chapter 10: Conditional formatting
- Conditional Formatting using Cell Values (Column Based Conditional Formatting)
- Conditional Formatting using Formula (Record Based Conditional Formatting)
- Icon Set
- Formula with multiple conditions
- Apply Conditional Formula based on different sheet's cell reference
- Database Case Study
- Chapter 11: What-if-Analysis Tools
- Goal Seek
- Projecting Figures Using a Data Table
- What-If Scenarios
- Merge Scenarios from Another Worksheet
- Protecting Scenarios
- Chapter 12: Working with Multiple Worksheets, Workbooks and Applications
- Links between Different Worksheets
- Creating links between different software
- Workgroup collaboration
- Merging workbooks
- Tracking changes
- Creating Hyper Link
- Chapter 13: Working with Charts
- Creating Charts using Chart Tools
- Adding Titles and Values in Charts using Chart Tools
- Formatting charts
- Charts for My Data
- Chart Templates
- Recommendations
- Sparklines
- Customize Sparklines
- Change the Style of Sparklines
- Exercise
- Chapter 14: Macros
- Creating a macro
- Recording a Macro
- Running a Macro Using Menu Commands
- Writing a macro
- Assigning a Macro to a Button
- Functions Description
- Final Assignment
- Shortcuts keys in Excel
System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.