Microsoft Excel 2019 coursebook contains 393 pages. Ordered today, delivered tomorrow.
This coursebook provides a detailed overview of all the functions of the famous worksheet programme Microsoft® Excel ; it is prepared with version 2019 of Excel and includes all the new components as well as the differences with the Excel version of Office 365.It is intended for anyone who wants to get acquainted with the programme or deepen their knowledge.
After describing the working environment and the management of workbooks and worksheets, you will discover all about the different techniques for entering and modifying data (numbers, dates, data series, direct filling, equations...).
You will then see how to perform different calculations, from simple calculations (percentages, statistics) to complex calculations (conditional formula, calculation of data, search functions, calculation of loan repayment, table with double entry, consolidation of worksheets, matrix calculations...). Another section is devoted to the analysis options:running scenarios, calculation of target value, audit for worksheets and use of the Solver.
You can then delve into the many features the programme has to offer to design your table (characters, fonts, colours, borders, conditional formatting, styles...). You will learn how to Sort and filter data, how to organise a table into summaries and how to print these summaries.
Excel offers you excellent options for graphical display; you will be introduced to several available chart types in this book: line charts, histograms, pie charts, 2D and 3D charts, trend lines and Sparkline charts. You will also learn how to insert graphical objects into a worksheet (shapes, images, icons, 3D models, diagrams...).
But Excel also offers powerful data analysis capabilities, such as the creation and management of data tables or the implementation of pivot tables and pivot graphs that you can easily filter and/or sort.
A section of this book is dedicated to collaborative working on documents and contains a lot of information on workbook protection, data sharing and co-creation. The final chapters describe various techniques for optimising input (creating a custom data series, drop-down lists), importing data, running macro commands, saving workbooks as web pages and managing your user account.
