| Titre : | Excel voor professionals |
| Auteurs : | Wim De groot |
| Type de document : | Books |
| Editeur : | Culemborg : Van Duuren Informatica, 2016 |
| Article en page(s) : | XXXVII, 1091 p. |
| ISBN/ISSN/EAN : | 978-90-5940-890-6 |
| Langues: | Néerlandais |
| Index. décimale : | 005.54 |
| Catégories : | |
| Tags : | Microsoft Excel (Computer file)--Handbooks, manuals, etc. ; Microsoft Excel (Computer file) |
| Résumé : |
More and more companies in Microsoft Excel performs an important role in the daily office work. With the programme to gain a lot of time, especially if you can work with. The more possibilities of Excel you know, the better you can take advantage of the power of this versatile program. On the basis of this book will help you make the most out of Excel. You will learn not only what you need to do, but above all how it works. You will find in this book 1750 examples of formulas that are so accessible are explained so that you can customize for your own work. After in the first chapter be given to work faster with Excel tips, the book goes into depth. Be evaluated include: -Lists, sorting, filtering and de-duplication -Financial functions for yield, depreciation and scenarios -Logical: IF, and IF. ERROR -Functions for text -Calculating with date and time -Search and replace Functions -Mathematical functions if rounding, sums. AS RAND and -Statistical functions as number, grade, median and percentile -Technical features like convert and imaginary numbers -Information functions as cell, ISERROR and ISNA -Database functions like DCOUNT and DSUM -Array formulas -Working with PivotTables -Conditional formatting, and data bars -Create, modify and format all chart types: -New chart types: treemap, Sunbeam, histogram, box and whisker and waterfall -Special charts: boxplot, Gantt chart and speedometer -Build in list boxes and other controls -Present Results in a dashboard -Interact with Word and Powerpoint -Record macros, customize and programming in VBA -Troubleshoot error messages |
-
Professionnels de la défense
Connexion via Azure-AD -
Autres
University library of Defense Belgium
Bibliothèque universitaire de la Défense
Se connecter
Accueil
Sélection de la langue
Adresse
University library of Defense Belgium+3224414139
contact
