Advance excel 2016 training guide

Name: Advance excel 2016 training guide | Training guide
Brand: De Gruyter
Price: 43.49 EUR
Availability: OnlineOnly

Training guide

Ritu Arora(Autor*in)

De Gruyter (Verlag)

1. Auflage

Erschienen am 26. Januar 2016

88 Seiten

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-93-88176-39-2 (ISBN)

43,49 €inkl. 7% MwSt.

Systemvoraussetzungen

für PDF mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

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

Systemvoraussetzungen

Als PDF speichern Als Link merken