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
