Beschreibung:
The book reflects the latest version of Excel and introduces Ribbon Bar Navigation. It features 2 new chapters on data management capabilities (connectivity to external databases, organization of data, sorting, filtering and data lookup across worksheets using functions like VLOOKUP and HLOOKUP) and Office 365 and integration with cloud resources.
Introduction. Miscellaneous Operations in Excel and Word. Charts and Graphs. Line Drawings, Embedded Objects, Equations and Symbols in Excel. Solution of Equations. Other Operations. Financial Functions and Calculations. Optimization Problems. Pivot Tables. Data Management Resources in Excel. Office 365 and Integration with Cloud Resources. References. Index