There are no comments for this product
Advanced Excel training topics in accounting
Introduce some practical properties of Excel
Working with patterns in Excel
Various methods of data protection
Familiarity with the concept of OLE and working with it - Communicating Excel files with other files
Automatic formatting - Defining formats and numeric formats
Creating a named block for different ranges and referencing it
Conditional Formatting
Important Formulation Tips
How to Address and Name Methods
Introduce Reference Operators - Working with Complex Computational Formulas
3D Formula Writing and Combined References
Working with Formula Auditing and Error Checking
Working with some of the most widely used mathematical, reference, date and time, logical, textual, financial, database, etc. functions. Introducing the IF
Text Formulas, Date
Text Formulas
Date Formulas
Excel Search Functions
Lookup tools
Index & match tools
Select tools
Introduce table & subtotal tools
Introduce database formulas
Combining functions with formulas - Using Nested functions
Working with different types of filters: AutoFilter and Advanced Filter
Working with data analysis tools What if Analysis
Scenarios scenario analysis to estimate future financial conditions
Financial ratio scenario formation
Dopon ratio sensitivity analysis
Using the Goal Seek tool to estimate future financial objectives
Analysis of types of bank facilities and their installments
Validation Validation
Category Group & Outline
Use Subtotals tool to calculate subtotals
Consolidation and one Consolidate information
Analyze financial functions in Excel
How to use financial functions in calculating the time value of money
Examining methods for depreciation of assets
Data table
Using financial functions in evaluating economic plans and industrial projects
The logic of time in Excel
Payment system
Legit file
A tax analysis in the system Salary
Preparation of personnel entry and exit reporting software case study
Warehousing calculations
No empty Financial statements
Preparation of balance sheet
Preparation of profit and loss statement
Preparation of payroll system program in the form of Excel software format
Introduction of various types of charts in Excel) Charts Bubble - Dispersion in Accounting (
Combination Charts and Chart Details
Draw professional charts and work with the Trend line and obtain the equivalent function of the lines
Professional settings in the chart
Iv Pivot Table and PivotChart
Table charts and diagrams \ d Doing repetitive tasks by creating Macro and programming preliminaries
For more information on in-person and out-of-class classes, contact the following number: (At the bottom of the ad)136018430 School hours 8 am to 5 pm
| Company | موسسه پژوهش و آموزش همکاران سیستم |
|---|---|
| Tel | +98 51-3×××3930 |
| Mobile | +98 935×××6495 |
| Whatsapp link | |
| Instagram page | |
| Telegram | Telegram link |
| Country | Iran |
| Province | Khorasan Razavi |
| Address | مشهد- حاشیه بلوار وکیل آباد، بین 21 و 23 بعد از پل سید رضی پلاک 429 |
