11,99 €
inkl. MwSt.

Versandfertig in über 4 Wochen
payback
6 °P sammeln
  • Broschiertes Buch

*Includes tear-out QUICK REFERENCE with step-by-step instructions MICROSOFT EXCEL 2016 IN 90 PAGES guides you through the process of creating spreadsheets. With step-by-step instructions, screenshots, and tables detailing Excel commands and features, you will be immediately on track to analyzing data. Look inside to learn how to: 1. Create and format a spreadsheet using practices that optimize data analysis. 2. Ensure accurate data with data validation and Excel's AutoComplete, AutoCorrect, Auto Fill, and spelling checker features. 3. Produce the most impact through conditional formatting and…mehr

Produktbeschreibung
*Includes tear-out QUICK REFERENCE with step-by-step instructions MICROSOFT EXCEL 2016 IN 90 PAGES guides you through the process of creating spreadsheets. With step-by-step instructions, screenshots, and tables detailing Excel commands and features, you will be immediately on track to analyzing data. Look inside to learn how to: 1. Create and format a spreadsheet using practices that optimize data analysis. 2. Ensure accurate data with data validation and Excel's AutoComplete, AutoCorrect, Auto Fill, and spelling checker features. 3. Produce the most impact through conditional formatting and sparklines. 4. Organize related data into tables that sort, filter, use slicers, have a totals row, and use calculated columns to analyze data. 5. Visualize data relationships through charts, including pie, line, bar, treemap, waterfall, and stock charts. 6. Use formulas and functions to generate new information. 7. Perform What-If? analysis with scenarios, goal seek, and data tables. 8. Generate PivotTable and PivotChart reports for tables and Data Models. 9. Create Data Models by defining relationships between tables. 10. Work more effectively by using multiple sheets, inserting cell comments, creating macros, and designing custom templates. 11. Learn how to protect worksheet data and work collaboratively.
Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.
Autorenporträt
Beth Brown is the author of more than 40 books. An engineering graduate of Florida Atlantic University, Ms. Brown holds a B.S. in Computer Science. She has worked with students and educators worldwide to develop Microsoft Office curriculum materials in addition to her work in programming, research and development, technical writing, and business.