This comprehensive reference guide includes step-by-step instructions and invaluable Excel 2013 techniques to help improve your ability to manage large amounts of data and create customized reports. It also provides techniques on how to manipulate data and create customized reports using B.I./inSight cubes.
Contents
This guide is composed of the following four sections and sub-sections:
Part 1: Excel 2013 - Foundation
- Layout
- Navigation
- Workbook Options
- Workbook Views
- Entering/Editing Data
- Cell References
- Cell Moving/Naming
- Tables
- Autofill
- Search/Wildcards
- Comments
- Formulas & Functions
Part 2: Excel 2013 - Advanced
- Conditional Formatting
- Sparklines
- Data Consolidation
- What-if Analysis
- Flashfill
- Data Validation
- Macros
- Look-up Formulas
- PivotTables
- PivotCharts, Slicers and Timelines
Part 3: insight and B.I. Cubes
- B.I. Cubes: Overview and Uses
- B.I. Cubes: Elements
- B.I. Cubes: Create & Save Views
- B.I. Cubes: PivotTables
Contact Details
Nicole Gonzalez, ngonzalez@unicef.org