GO! with Microsoft Excel 2016 Comprehensive (GO! for Office 2016 Series) 1st Edition – Ebook PDF Version – Digital Instant Dowload.
Product details:
- ISBN-10 : 0134443926
- ISBN-13 : 978-0134443928
- Author: Shelley Gaskin, Alicia Vargas
In today’s fast-moving, mobile environment, the GO! with Office 2016 series focuses on the job skills needed to succeed in the workforce. With job-related projects that put Microsoft Office into context, students learn the how and why at the moment they need to know, all in the appropriate Microsoft procedural syntax.
Table contents:
1. Creating a Worksheet and Charting Data
2. Using Functions, Creating Tables, and Managing Large Workbooks.
3. Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools
4. Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets
5. Managing Large Workbooks and Using Advanced Sorting and Filtering
6. Creating Charts, Diagrams, and Templates
7. Creating PivotTables and PivotCharts
8. Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas
9. Using Macros and Visual Basic for Applications
10. External Data, Database Functions, and Side-by-Side Tables
11. Collaborating with Others and Preparing a Workbook for Distribution