آموزش توابع اکسل 2019 به فارسی

In Excel's Functions and Formulation Tutorial, let's look at the formula and how to use functions in Excel 2019. In the Function Guide and Formula Writing in Excel 2019 the following functions are reviewed. For a list of functions see the site address at the end of the headings. After installation, a list of functions is displayed in the program menu.

Chapter One: Working with Text in Excel (Free)
Introduction
What is the function?
Additional characters removal functions
Uppercase and lowercase conversion functions
Convert letters to numbers
Replacing part of a text string
Access Functions Part of a string
Information functions
Excel data conversion functions

Chapter Two: Logical Functions (Free)
Boolean Function Functions
Conditional Functions
Functions that return logical constant values

Chapter Three: Information Functions (Free)
Error information functions
Numerical information functions
Other functions of data types
General Information Function
Constant value return functions

Chapter Four: Date and Time Functions
Date and Time Functions
Current date and time functions
Time constructor functions
Date constructor functions
Computational Functions of History

Chapter Five: Addressing and Search Functions
Cell addressing functions
Row, column and range information
Data search functions

Chapter Six: Mathematical Functions in Excel Part I
Basic numbers information
Mathematical operators
Rounding Functions

Chapter Seven: Mathematical Functions in Excel Part II
Conditional sum
Advanced math operations
Matrix functions
Factorial calculation
Miscellaneous functions

Chapter Eight: Mathematical Functions in Excel Part III
random numbers
Trigonometric functions

Chapter 9: Statistical Functions 1
The functions of finding the largest and smallest values
Other functions
Cell count

Chapter 10: Statistical Functions 2 in Excel
Average, Frequency and Ranking

Chapter 11: Statistical Functions 3
Deviation and variance
Trendline Functions

Chapter Twelve: Statistical Functions 4
Distribution Functions and Probability Tests

Chapter 13: Database Functions
Database functions

Chapter 14: Financial Functions
Investment Value Functions
Payment functions
Duration Functions
Calculate Internal Return Rate
Depreciation calculation functions

Chapter 15: Engineering Functions
Complex Number Functions
Conversion functions of units of measurement
Baseline conversion functions
Error functions
Testing numerical values

https://www.learninweb.com/ excel-training-functions-php

https://www.learninweb.com/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%D8%AA%D9%88%D8%A7%D8%A B9-% D8% A7% DA% A9% D8% B3% D9% 84-2019.php