Sale!

Excel Workbook 3rd Edition by M Ballerini, A Clerici, MC Debernardi, D Del Corno, M De Pra ISBN 8831322095 9788831322089

Name: Excel Workbook 3rd Edition by M Ballerini, A Clerici, MC Debernardi, D Del Corno, M De Pra ISBN 8831322095 9788831322089
SKU: EB-50588624
Availability: InStock

Original price was: $50.00.Current price is: $25.00.

Excel Workbook 3rd Edition Clerici Alberto Del Corno Davide Digital Instant Download

Author(s): Clerici Alberto Del Corno Davide

Edition: 3

File Details: PDF, 2.31 MB

Year: 2021

Language: english

SKU: EB-50588624 Category: Computers - Programming Tag: Clerici Alberto Del Corno Davide

Description

Excel Workbook 3rd Edition by M Ballerini, A Clerici, MC Debernardi, D Del Corno, M De Pra – Ebook PDF Instant Download/Delivery: 8831322095 ,9788831322089
Full download Excel Workbook 3rd Edition after payment

Product details:
ISBN 10: 8831322095
ISBN 13: 9788831322089
Author: M Ballerini, A Clerici, MC Debernardi, D Del Corno, M De Pra

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.

Excel Workbook 3rd Edition Table of contents:

Excel Basics
- Simple formulas (addition, subtraction, multiplication, division)
- Using absolute and mixed references
- Calculating percentages and percentage variations
- Functions: SUM, AVERAGE, MAX, MIN, COUNTA, COUNT, IF, ABS
- Formatting
- Simple sorting
- Creating and customizing simple charts
From Simple Functions to Nested Functions
- Importing data
- Functions: TRIM, AND, OR, COUNTBLANK
- Nested functions
- Conditional formatting
- Sorting on multiple levels
- Filters
- Paste command options (Values)
Math Functions and Advanced Charts
- Functions: SUMPRODUCT, COUNTIF, AVERAGEIF, SUMIF
- Conditional formatting with formulas
- Subtotal
- Remove Duplicates command
- Linking cells
- Creating charts with trend lines
- Mixed charts and charts with two axesFinancial Functions and What-If Analysis
- Functions: PMT, FV
- Naming cells or ranges
- Paste command options (Transpose)
- Scenarios
- Goal SeekText Functions and Pivot Tables
- Functions: RIGHT, LEFT, MID, CONCATENATE, UPPER, LOWER, PROPER, LENGTH, SEARCH
- Functions: COUNTIFS, SUMIFS, AVERAGEIFS
- Pivot tables and pivot charts
- Data validation
Managing Dates and Times
- Formulas with dates and times
- Normalization of time units
- Functions: DAY, MONTH, YEAR, HOUR, MINUTE, SECOND, WEEKDAY, DAYS, TODAY, NOW, DATE, DATEDIF, IFERROR
Lookup & Reference Functions, Data Protection
- Functions: VLOOKUP, MATCH
- Function: RANK.EQ
- Worksheet protection
- Workbook protection
- File protection and encryption
Macros and Elements of Visual Basic for Applications (VBA)
- Recording a macro in Excel
- Assigning a macro to a shape or a button
- Simple VBA editing

People also search for Excel Workbook 3rd Edition:

excel workbook will not open

what keyboard shortcut is used to save an excel workbook

what is an excel workbook

what is the default file extension for an excel workbook

which file extension indicates an excel workbook

Tags: M Ballerini, A Clerici, MC Debernardi, D Del Corno, M De Pra, Excel Workbook