آموزش اکسل 2016

آموزش Excel 2016 (Package Name: com.learninweb.excel2016plight) is developed by Learninweb.com | انیاک and the latest version of آموزش اکسل 2016 4.0 was updated on September 23, 2018. آموزش اکسل 2016 is in the category of Education. You can check all apps from the developer of آموزش اکسل 2016 and find 32 alternative apps to آموزش اکسل 2016 on Android. Currently this app is for free. This app can be downloaded on Android 4.0+ on APKFab or Google Play. All APK/XAPK files on APKFab.com are original and 100% safe with fast download.

To use the rest of Excel training and educational files under Windows
https://www.learninweb.com/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%D8%A7%DA%A9%D8%B3%D9%84.php
See.
The following courses are taught in this course
Part One: Installing Office 2016 (Free)
Run the installation program
Determine how to install Office 2016
Remove and add the installed application
Part Two: Understanding Excel (Free)
Run Excel 2016 on Windows 10
How to open a workbook
Meet the Excel 2016 environment
Meet the Ribbon
How to display the work page
Zoom in and zoom out the page
Navigate the pages in Excel 2016
Save a book
Close a workbook
Open a recently used book
Use help
Exit Excel 2016
Part III: Working with Workbooks (Free)
Create Workbooks in Excel 2016
Data Entry Method
Introduction to Formulas
Add a new row or column
Sum function
Delete row or column
Move the row or column
Familiarize with Cut, Copy and Paste
Handover Undo and Redo
Find and Replace commands
Manage Pages (Sheets)
File storage in Excel 2016
Part IV: Configuration or Format Workbooks
Adjust the size of the rows and columns
Integration of cells in Excel 2016
How to display numbers (Number Format)
Configure the text in Excel 2016
Working with Style or Ready Format
Work with a Spell Checker
Introduction to Auto Correct (AutoCorrect)
Use the AutoFill tool
Work with Conditional formatting and Format Painter tools
Conditional formatting in Excel 2016
Work with Quick Analysis Tool
Section Five: Types of Views and Printing Pages
How to view worksheets in Excel 2016
Split command
Freeze command
Auto Filter Tool
Add header and footer
Setting Page with Page Setup
Adjustable print range
Print preview and its settings in Excel 2016
Part Six: Formulas and Functions (Part I)
Understanding Functions and Formulas in Excel 2016
Copy the formula
Connect to one cell's content
Use auto calculator (AutoCalculate)
Sum function
Operators in Excel 2016
Minimum, Max, Number, and Average Functions
AutoSUM tool
Work with Manual Calculation
Part VII: Formulas and Functions (Part II)
FV function
PMT function
Work with the IF conditional function
Use date in functions in Excel 2016
Work with statistical functions
T test function
Correct auto input function
Pearson function
Section 8: Charts, Images and Special Effects
Create a chart in Excel 2016
Determine the shape of the chart
Changing chart data
Changing the type of chart
Change the appearance of the chart
Chart headline
Help placement
Create special effect
Draw ready shapes
Insert image
Sparklines charts
Section 9: Macros and VBA
Create a New Macro in Excel 2016
Use macros
Macro window
Change the format of a column
Introduction to the Visual Basic Editor
Design Forms in VBA
Familiar with VBA commands
Use of structures and functions
Save as PDF in Excel 2016
https://www.learninweb.com

آموزش Excel 2016 4.0 Update

آموزش Excel 2016 - تعاملی و شبیه سازی شده با صدا و متن فارسی ( فصل اول تا سوم رایگان ) - بدون نیاز به اینترنت در زمان آموزش