{"id":23832,"date":"2022-10-31T00:00:00","date_gmt":"2022-10-30T22:00:00","guid":{"rendered":"https:\/\/www.nord-vest.ro\/achizitie-servicii-de-instruire-9-2\/"},"modified":"2022-12-05T22:02:39","modified_gmt":"2022-12-05T20:02:39","slug":"achizitie-servicii-de-instruire-9-2","status":"publish","type":"post","link":"https:\/\/www.nord-vest.ro\/en\/achizitie-servicii-de-instruire-9-2\/","title":{"rendered":"Purchase of training services"},"content":{"rendered":"<p><strong>Regarding the acquisition of:<\/strong> Training services aimed at improving the use of EXCEL AT INTERMEDIATE\/ADVANCED LEVEL<strong><\/strong><\/p>\n\n\n\n<p><strong>Purchase object:<\/strong> Professional training program;<\/p>\n\n\n\n<p><strong>CPV code: <\/strong>80530000-8 Vocational training services;<\/p>\n\n\n\n<p><strong>Purchase object description (technical specifications):<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>FORM \/ TYPE OF TRAINING: <\/strong>course with physical presence, with issuance of participation certificate<\/li><li><strong>NUMBER OF PARTICIPANTS:\u00a0 <\/strong>5<\/li><li><strong>PERIOD OF PERFORMANCE<\/strong> <strong>PROFESSIONAL TRAINING PROGRAM:<\/strong> during November 2022<\/li><li><strong>COURSE SUBJECTS\/ COMPETENCES CERTIFIED UPON GRADUATION:<\/strong><\/li><\/ul>\n\n\n\n<p><strong>1. Advanced Features Workshop:<\/strong><strong><\/strong><\/p>\n\n\n\n<p>\u2022 Grouping functions by precisely inserting them into each other to &quot;customize&quot; them<\/p>\n\n\n\n<p>\u2022 Exemplification of different functions, such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Category &quot;Logic&quot;: IF, IFERROR;<\/li><li>Category &quot;Text&quot;: Clean, Code, Concatenate, Exact, Find, Lower, Proper, T, Trim, Value,<\/li><li>Upper;<\/li><li>Category &quot;Date&quot;: Day, Days, Edate, Eomonth, Isoweeknum;<\/li><li>&quot;Look-up&quot; category: Vlookup, Index, Match, Transpose<\/li><li>Category &quot;Statistics&quot;: Large; Countifs, Sumifs, Sumifs; Averageif; Averageifs; Min; Max;<\/li><li>Using IFERROR to eliminate Excel errors.<\/li><li>Focus on Vlook-up \u2013 general mistakes and avoid them for maximum accuracy;<\/li><\/ul>\n\n\n\n<p><strong>2. Pivot tables<\/strong><\/p>\n\n\n\n<p>\u2022 Building and working with a Pivot table to analyze databases of any size;<\/p>\n\n\n\n<p>\u2022 Filtering by data area;<\/p>\n\n\n\n<p>\u2022 Use of table layout options; Changing subtotal generation options;<\/p>\n\n\n\n<p>\u2022 Use of different functions in the data area;<\/p>\n\n\n\n<p>\u2022 Using the &quot;Display data as&quot; option<\/p>\n\n\n\n<p>\u2022 Using &quot;Slicer&quot; and &quot;Timeline&quot;<\/p>\n\n\n\n<p>\u2022 Creation of Calculated Elements<\/p>\n\n\n\n<p>\u2022 Creation of a PivotChart report \u2013 Pivot Chart;<\/p>\n\n\n\n<p><strong>3. Advanced Data Validation Uses<\/strong><\/p>\n\n\n\n<p>\u2022 Preventing incorrect data from being entered into a cell (prohibiting entry, generating warning messages)<\/p>\n\n\n\n<p>\u2022 Creating selection lists in cells and using them in interactive graphics.<\/p>\n\n\n\n<p><strong>4. Using advanced conditional formatting<\/strong><\/p>\n\n\n\n<p>\u2022 Use conditional formatting to compare ranges of dates;<\/p>\n\n\n\n<p>\u2022 Use functions in conditional formatting to highlight important data more easily.<\/p>\n\n\n\n<p><strong>5. Creating Graphics<\/strong><\/p>\n\n\n\n<p>\u2022 Creating a graph to analyze information from a database;<\/p>\n\n\n\n<p>\u2022 Customizing graphics and creating templates;<\/p>\n\n\n\n<p>\u2022 Building a Chart by selecting the data source;<\/p>\n\n\n\n<p>\u2022 Creation of secondary axes;<\/p>\n\n\n\n<p><strong>6. Assigning names to selected Cells and Areas and their advanced use<\/strong><\/p>\n\n\n\n<p>\u2022 Creating named cells correctly and using names in formulas accurately.<\/p>\n\n\n\n<p>\u2022 Using names as &quot;constants&quot; in complex formulas and pivots;<\/p>\n\n\n\n<p>\u2022 Use of names to simplify formulas;<\/p>\n\n\n\n<p>\u2022 Editing and deleting names;<\/p>\n\n\n\n<p><strong>7. Data Consolidation<\/strong><\/p>\n\n\n\n<p>\u2022 Centralization of several tables from worksheets or from different files without manually copying them;<\/p>\n\n\n\n<p><strong>8. Transforming Text into columns<\/strong><\/p>\n\n\n\n<p>\u2022 Separating the contents of cells in a row into separate columns when copying data from .pdf files or web pages to bring the table to a form similar to the source.<\/p>\n\n\n\n<p>\u2022 Use of &quot;Text in columns&quot; to remove export-specific characters from ERP;<\/p>\n\n\n\n<p><strong>9. Protecting Worksheets and Workbooks<\/strong><\/p>\n\n\n\n<p>\u2022 Password work files for opening and editing;<\/p>\n\n\n\n<p>\u2022 Lock and unlock cells and worksheets to ensure the integrity of cells or formulas.<\/p>\n\n\n\n<p><strong>10. Mail Merge \u2013 Word + Excel<\/strong><\/p>\n\n\n\n<p>\u2022 Mass creation of customized documents (eg: letters for debt recovery, mass communications to suppliers\/customers, labels for envelopes, etc.) based on a WORD template and an EXCEL database;<\/p>\n\n\n\n<p>\u2022 Using an existing database vs. Creating a new database for automatic completion;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>DURATION OF THE PROFESSIONAL TRAINING PROGRAM<\/strong>: minimum 10 hours of practical training<\/li><li><strong>LOCATION OF THE PROFESSIONAL TRAINING PROGRAM<\/strong>: Cluj-Napoca<\/li><li><strong>SERVICE PRICE<\/strong>: Total unit price per professional training package\/student:<\/li><li><strong>Maximum 550 lei without VAT \/ student, <\/strong><\/li><li><strong>Contract \u2013<\/strong> <strong>NOT<\/strong><\/li><\/ul>\n\n\n\n<p>The criterion used for awarding the contract is <strong>The lowest price.<\/strong><\/p>\n\n\n\n<p>Additional information can be obtained from the Contracting Authority: ADR Nord-Vest, secondary office in Cluj-Napoca, Calea Dorobantilor no 3, code 400118, phone +40264431550, fax: +40 264439222, email <a href=\"mailto:achizitii@nord-vest.ro\">achizitii@nord-vest.ro<\/a>, to the attention of the Public Procurement Office.<\/p>\n\n\n\n<p>Deadline for submitting offers: 01.11.2022, 11 AM<\/p>","protected":false},"excerpt":{"rendered":"<p>Privind achizi\u0163ia de: Servicii instruire destinate perfec\u0163ion\u0103rii \u00een domeniul utiliz\u0103rii EXCEL LA NIVEL INTERMEDIAR\/ AVANSAT Obiect achizi\u0163ie: Program formare profesional\u0103; Cod CPV: 80530000-8 Servicii de formare profesional\u0103; Descriere obiect achizi\u0163ie (specifica\u0163ii tehnice): FORMA \/ TIPUL DE INSTRUIRE: curs cu prezen\u0163\u0103 fizic\u0103, cu emitere de certificat participare NUM\u0102R DE PARTICIPAN\u0162I:\u00a0 5 PERIOADA DESF\u0102\u0218UR\u0102RII PROGRAMULUI DE FORMARE&#8230;<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","beyondwords_generate_audio":"","beyondwords_project_id":"","beyondwords_content_id":"","beyondwords_preview_token":"","beyondwords_player_style":"","beyondwords_language_id":"","beyondwords_title_voice_id":"","beyondwords_body_voice_id":"","beyondwords_summary_voice_id":"","beyondwords_error_message":"","beyondwords_disabled":"","beyondwords_delete_content":"","beyondwords_podcast_id":"","beyondwords_hash":"","publish_post_to_speechkit":"","speechkit_hash":"","speechkit_generate_audio":"","speechkit_project_id":"","speechkit_podcast_id":"","speechkit_error_message":"","speechkit_disabled":"","speechkit_access_key":"","speechkit_error":"","speechkit_info":"","speechkit_response":"","speechkit_retries":"","speechkit_status":"","speechkit_updated_at":"","_speechkit_link":"","_speechkit_text":""},"categories":[119,271],"tags":[],"class_list":["post-23832","post","type-post","status-publish","format-standard","hentry","category-achizitii","category-achizitii-2"],"publishpress_future_action":{"enabled":false,"date":"2026-04-14 20:33:04","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category"},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/www.nord-vest.ro\/en\/wp-json\/wp\/v2\/posts\/23832","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nord-vest.ro\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nord-vest.ro\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nord-vest.ro\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nord-vest.ro\/en\/wp-json\/wp\/v2\/comments?post=23832"}],"version-history":[{"count":1,"href":"https:\/\/www.nord-vest.ro\/en\/wp-json\/wp\/v2\/posts\/23832\/revisions"}],"predecessor-version":[{"id":25660,"href":"https:\/\/www.nord-vest.ro\/en\/wp-json\/wp\/v2\/posts\/23832\/revisions\/25660"}],"wp:attachment":[{"href":"https:\/\/www.nord-vest.ro\/en\/wp-json\/wp\/v2\/media?parent=23832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nord-vest.ro\/en\/wp-json\/wp\/v2\/categories?post=23832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nord-vest.ro\/en\/wp-json\/wp\/v2\/tags?post=23832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}