There are no comments for this product
Excel private and group teaching from introductory to advanced with the presence of the teacher at your workplace or home, teaching the most useful and key Excel points in 2 to 6 sessions, the number of sessions according to your needs and the day and time of the class according to your request.
With the timely presence of the instructor at your home or workplace
Private and group teaching is done at a reasonable price in the shortest time of choosing the day and time of the class with your agreement and coordination
It is up to you to choose the topic and chapter of the content and it will be taught according to your needs
Teaching key and frequently used functions:
Functions related to summation and conditional counting
Countifs-Sumifs-Averageifs-Dsum-Dcount-D average
Search and reference functions
Vlookup-Hlookup-lookup-match-index
Entering arguments in functions
Excel's most used tools:
Draw a graph in Excel
Draw a simple bar graph in Excel
Sort and classify tables
Row sorting of an information table
Column sorting of an information table
Sort the information table according to the desired order
Filter and categorize using textual and numerical filters
Using the filter for summarization by the Subtotal function
Pivot table and its applications
How to enter time and date information
Solar date in Excel
Performing calculations and writing formulas on time and date cells
All these functions and formulas are taught in the form of exercises and examples, and if needed, according to your needs, in a project-oriented way
Examples such as creating a simple warehouse with Excel, registering the arrival and departure of goods and obtaining instant stock and order point and others...
Entry and exit table of personnel and calculation of working hours and overtime and deduction of personnel work
Salary calculation
Create a specific office
Fund sales report and salary....
| Company | دانش افروز فردا |
|---|---|
| Tel | +98 26-3×××0316 |
| Mobile | +98 911×××4378 |
| Whatsapp link | |
| Country | Iran |
| Province | Alborz |
| Address | عظیمیه میدان بهارستان |
