# Excel Workbook: 160 Exercises with Solutions and Comments

ePUB
• eBook:
Excel Workbook: 160 Exercises with Solutions and Comments
• Author:
Alberto Clerici, Davide Del Corno, Maurizio De Pra, Massimo Ballerini, Chiara Debernardi Maria
• Edition:
-
• Categories:
• Data:
April 1, 2021
• ISBN:
8831322087
• ISBN-13:
9788831322089
• Language:
English
• Pages:
434 pages
• Format:
ePUB

Book Description
Excel is the most popular and widely used productivity software in all business environments, and it is an irreplaceable companion in ordinary work as in the analysis of large amounts of complex data. Nevertheless, the majority of users knows and uses only a very limited number of features, often in an elementary way. This workbook shows in practice the use of a wide variety of formulas, func-tions and features (like charts, pivot tables, macros or the Solver add-in) that allow to effectively and professionally work with Excel. The workbook starts with the basics and gets progressively to deal with very com-plex cases. It is a valuable support for college students, professionals and manag-ers who want to learn the basics or to improve the knowledge of Excel up to an advanced level. DigitaBook format includes the digital edition of the book with all the initial and solved fi les available to carry out the exercises and check the solutions. Over 80 exercises are commented, to highlight the basic concepts and clarify the most complex ones.

#### Content

SECTION 1. EXERCISES
UNIT 1. EXCEL BASICS
UNIT 2. FROM SIMPLE FUNCTIONS TO NESTED FUNCTIONS
UNIT 3. MATH FUNCTIONS AND ADVANCED CHARTS
UNIT 4. FINANCIAL FUNCTIONS AND WHAT-IF ANALYSIS
UNIT 5. TEXT FUNCTIONS AND PIVOT TABLES
UNIT 6. MANAGING DATES AND TIMES
UNIT 7. LOOKUP & REFERENCE FUNCTIONS, DATA PROTECTION
UNIT 8. MACROS AND ELEMENTS OF VBA
UNIT 9. MORE FUNCTIONS AND SOLVER
UNIT 10. DATABASE FUNCTIONS AND CHART OPTIONS
UNIT 11. FINANCIAL APPLICATIONS
UNIT 12. DATA ANALYSIS AND REPORTING