Excel private and group teaching from introductory to advanced with the presence of the instructor 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 at a reasonable price will be done in the shortest possible time, choosing the day and time of the class with your agreement and coordination
Choosing the topic and beginning of the chapter It is your responsibility and it will be taught according to your needs
Training of key and frequently used functions:
Functions related to summation and conditional counting
Countifs-Sumifs-Averageifs-Dsum-Dcount-D average\ r\nSearch and reference functions
Vlookup-Hlookup-lookup-match-index
Enter arguments in functions
Excel's widely used tool:
Draw a graph in Excel
Draw a Simple bar graph in Excel
Sorting and classifying tables
Row sorting of an information table
Column sorting of an information table
Sorting information table based on desired order
Filter and Categorizing with the help of textual and numerical filters
Using the filter for summarizing by the Subtotal function
Pivot Table and its applications
How to enter time and date information
Solar date in Excel
r\nMaking calculations and writing formulas on time and date cells
All these functions and formulas are taught in the format, solving exercises and examples, and if needed, according to your needs, in a project-oriented way
Example Such as creating a simple warehouse with Excel, registering the arrival and departure of goods and obtaining instant inventory and order point and others...
Creating a certain office
Fund sale report and salary....
Company | دانش افروز فردا |
---|---|
Tel | +98 26-3×××0316 |
Mobile | +98 911×××4378 |
Whatsapp link | |
Country | Iran |
Province | Alborz |
Address | عظیمیه میدان بهارستان |