آموزش اکسل 2016

Excel 2016 training as interactive voice and text Farsi - first, second and third chapters - free

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