Everyone

Learninweb.com | انیاک

Ice Cream Sandwich

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

Interactive Excel 2019 tutorial, Persian audio and text, first few sections free of charge with no internet

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

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