Training Services
We teach the following course contents in tender preparation both public and private:
- Client and Service Provider
- What is tender
- Type of tenders
- Types of restricted tender
- Categories of tenders
- Tendering from the Buyer’s Point of View
- Tendering from the Bidder’s Point of View
- Where are Tenders Published ?
- What is an institution ?
- Type of Institutions ?
- tendering preparation process
- What is tender evaluation
- Purpose of tender evaluation
- Type of tender evaluation
- Reporting process and type of report
- Contract management
Practice
Duration 20days
- To upload a prepared tender
- To look for a tender notification
- Contract management.
Practice
Duration 2 days
We teach the following programming language:
- Python programming
- Java programming
We also teach front end development:
- React with html, css and java script.
Duration is 45 days.
We also teach back end development:
- Java and spring boot.
Duration is 45 days
script,php and database.
Duration is 45 days.
Advanced Microsoft ExcelShortcuts
- Excel customization (Quick Access Toolbar, Ribbon)
- Hidden features and lesser-known functions
- Troubleshooting common Excel errors
- Function keys
- Pivot keyboard shortcuts
- Data conversion,
Advanced Microsoft Excel Formulas and Functions
Logical Functions (IF AND NOT & OR FUNCTION KEYS)
- Lookup and reference functions (VLOOKUP, XLOOKUP, HLOOKUP, INDEX, MATCH)
- Text functions (CONCATENATE, LEFT, RIGHT, MID)
- Statistical functions (AVERAGE, AVERAGEIFS, COUNT, COUNTIFS, SUMIFS)
- Nested Functions
- Advanced conditional formatting techniques
- Array Formulas
- Rounddown, Roundup, Round
- Len
- Power Pivot
- Left, Right, Mid, Search, Find
- Now, Today, Time, Datedif, Month, Day, Weekday, Year
- Index, Match
-Workbook and Worksheet Protection
-Advanced Excel Data Entry, Cleaning, Analysis,
Visualization, and Reporting Techniques.
- Data entry technique
- PivotTables and Pivot Charts
- Data validation and data filtering
- Advanced sorting and filtering techniques
- Subtotal and summary functions
- What-If analysis with Scenario Manager and Goal Seek
- Using slicers to filter data through the pivot table
- Charts, Graphs & Visualizations in
Other Services
- Installation
- Configuration