Private Excel training

Private Excel training

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 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 diagram 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... Staff entry and exit table and calculation of working hours and overtime and deduction of staff work Salary calculation Create a specific office Fund sales report and salary....