Книга Excel  Formulas and Functions Nathan George

Excel Formulas and Functions

Автор: Nathan George
Език: Английски език
Корици: С твърди корици
Издател: GTech Publishing
Наличност: Външен склад
Изпращаме след 9-15 дни
25.18 49.25 лв
Leverage the full power of Excel functionsExcel Formulas and Functions provides clear, step-by-step...

Информация за книгата

Автор
Език
Английски език
Корици
Книга - С твърди корици
Издадена
2022
страници
300
EAN
9781915476081
ISBN
1915476089
Enbook ID
42591311
Издател
Теглоt
765
Размери
183 x 260 x 21

Пълно описание

Leverage the full power of Excel functions


Excel Formulas and Functions provides clear, step-by-step explanations on creating formulas with over 80 of the most useful Excel functions.

This book provides a detailed description of each function, its arguments, and practical examples relevant to real-world productivity tasks. Create powerful formulas with simpler syntax using modern functions like IFS, XLOOKUP, XMATCH, TEXTSPLIT, and FILTER. From simple calculations to building complex spreadsheets that require multiple formulas, knowing the right function to use can increase the accuracy and efficiency of your work.

Excel Formulas and Functions is a great reference guide for working with Excel in your job, business, studies, or home. This book has been organized to make it easier for you to quickly find answers to your questions.


Downloadable sample files for hands-on learning


All examples in this book are available online as downloadable Excel files. You can learn Excel formulas and functions faster with the sample files as you don't need to create the examples in the book from scratch. You can copy and adapt the tried and tested formulas for use in your own worksheets.


This book covers the latest version of Excel for Microsoft 365 (2022 update).


In this book, you'll learn how to:

  • Troubleshoot and fix formula errors.
  • Use the latest lookup and reference functions to find and reference values in your formulas.
  • Return rows and columns of data using dynamic array functions.
  • Sort and filter data without changing the source data.
  • Use logical functions to include decision branches in your formulas.
  • Deploy advanced logical functions in place of convoluted nested functions for more efficient and flexible solutions.
  • Use date and time functions to address a wide range of date calculations.
  • Manipulate text strings easily with new and more flexible text functions.
  • Perform a variety of aggregate and summary calculations using math and statistical functions.
  • Calculate loan payments, the value of investments, and depreciation using special financial functions.


Може също да ви хареса

19.63 38.38 лв

Excel Power Query

Adam Ramirez
9.11 17.82 лв

Excel 2023

Leonardo L. wright
15.27 29.86 лв
10.86 21.24 лв
8.51 16.64 лв
40.16 78.54 лв

Genre and the City

Michael Shapiro
55.68 108.90 лв

The Silmarillion

J. R. R. Tolkien
18.67 36.52 лв

Excel VBA

A. Williams David A. Williams
15.27 29.86 лв
16.12 31.53 лв
299.95 586.66 лв
19.02 37.21 лв
45.36 88.72 лв
21.23 41.52 лв
11.96 23.40 лв
26.64 52.09 лв
23.08 45.14 лв

Ian Fleming

Robert Harling
11.16 21.83 лв
16.92 33.09 лв

Doomwar

Jonathan Maberry
18.67 36.52 лв

Excel

Georgie Howell
15.27 29.86 лв

Клиенти, които купиха тази книга, купиха също

Helyesírás

Mártonfi Attila
24.58 48.08 лв

A magyar helyesírás szabályai

Magyar Tudományos Akadémia
15.17 29.67 лв
10.31 20.17 лв
9.36 18.31 лв
11.96 23.40 лв
13.72 26.83 лв
14.67 28.69 лв

Excel 2024

Ulrike Sprung
14.62 28.59 лв
11.06 21.64 лв
50.67 99.11 лв
6.71 13.11 лв
3.65 7.14 лв

Unsere Vögel

Peter Berthold
13.92 27.22 лв

Kalanlar

Tezer Özlü
12.46 24.38 лв
9.46 18.50 лв
16.87 33.00 лв
14.52 28.39 лв
13.47 26.34 лв