آموزش Excel 2019 به فارسی

Excel (Excel) a comprehensive software for working with spreadsheets (Spread Sheet) is. With Excel you can create a variety of tables containing texts and numbers and use mathematical, statistical and logical formulas and functions to calculate them. It is also possible to create diagrams of different values ​​in the tables. If you use professional features like macros and the VBA language, Excel can be a good solution for almost all financial and statistical software and applications.

The following are taught in this course

Part One: Installing Office 2019 and Getting to Know Excel 2019 (Free)

Run the installation program

Remove and add the installed program

How to Run Excel 2019

How to open a Workbook

Excel Excel

Introduction to Ribbon

Zoom in and out

Navigate the pages

Save a workbook

Close a workbook

Open a recently used workbook

Using Help

Exit Excel 2019

Part II: Methods of working with books (Workbook) (free)

Creating workbooks

How to enter data

Introduction to Formulas

Add a new row or column

Function sum

Remove row or column

Moving rows or columns

Introduction to Cut, Copy and Paste

Undo and Redo devices

Find and Replace commands

Manage Pages (Sheets)

Save file in Excel 2019

Section Three: Configuration or Format Workbooks

Adjust the size of rows and columns

Cell integration

How to Display a Number Format

Configure Text

Working with Style or Ready Formats

Working with the Spell (Spell Checker)

Introduction to AutoCorrect

Use the AutoFill tool

Conditional formatting Conditional formatting with tools

Working with Quick Analysis Tool

Section Four: Types of Views and Page Printing

How to view worksheets in Excel 2019

Split command

Freeze command

Auto Filter Tool

Add header and footer

Page Setup with Page Setup

Adjustable Print Range

Preview the print and its settings

How to Sort in Excel

Part Five: Formulas and Functions (Part I)

Introduction to functions and formulas

Copy the formula

Bind to the content of a cell

Using AutoCalculate

Function sum

Operators in Excel

Functions Min, Max, Count, and Average

AutoSUM tool

Working with Manual Calculation

Section Six: Formulas and Functions (Part Two)

FV function

PMT function

Working with IF conditional function

Use history in functions

Working with statistical functions

T test function

Automatic correction of input function

Pearson function

Section Seven: Charts, Pictures and Special Effects

Create a chart

Chart shape determination

Chart graph data

Change chart type

Change the appearance of the chart

Graph headline

Location of Help

Create special effects

Draw shapes ready

Insert Image

Sparklines Charts

Section Eight: Macros and the VBA

Create macros in Excel 2019

Use Macros

Macro window

Change the format of a column

Introduction to Visual Basic Editor

Designing Application Forms in VBA

Understanding VBA Commands

Save as PDF

Learn all versions of Excel

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

Excel 2010 Training

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

Excel Functions and Formula Training

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.php

Excel VBA Training

https://www.learninweb.com/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-vba-excel.php