Advance excel 2016 training guide
Training guide
1st Edition
Published on 26. January 2016
88 pages
978-93-88176-39-2 (ISBN)
Description
No detailed description available for "Advance excel 2016 training guide".
More details
Other editions
Additional editions
Ritu Arora
Advance excel 2016 training guide
Book
01/2018
BPB Publications
€20.10
Article not available for order
Srinivas Mahankali
BlockChain- The Untold Story
Book
01/2018
BPB Publications
€34.20
Article not available for order
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
