{"id":51620,"date":"2023-01-15T21:15:56","date_gmt":"2023-01-15T20:15:56","guid":{"rendered":"https:\/\/www.trucnet.com\/?p=51620"},"modified":"2023-01-15T21:15:56","modified_gmt":"2023-01-15T20:15:56","slug":"formulaires-sous-excel-fonctions-avancees","status":"publish","type":"post","link":"https:\/\/www.trucnet.com\/en\/formulaires-sous-excel-fonctions-avancees\/","title":{"rendered":"Forms in Excel \u2013 Advanced Functions"},"content":{"rendered":"

The "Forms in Excel" training course is designed to teach participants the skills needed to effectively create, use, and manage forms in Excel. You can also use The essentials of Excel<\/a>.<\/p>\n

Participants will learn to use basic mathematical formulas to perform simple calculations, to use predefined functions to perform more complex calculations, to create pivot tables to analyze data, to use forms to enter and validate data, and to use tools to automate common tasks. The training includes practical demonstrations and exercises to allow participants to apply the skills learned.<\/p>\n

Key points of this Excel Forms training<\/strong>
\n- Introduction
\n\u2013 Revisions
\n\u2013 The multiline textbox
\n\u2013 The calendar
\n\u2013 Editable list areas \u2013 combobox
\n\u2013 Global label and variable
\n\u2013 Modules and macros
\n– R\u00e9visions des conditions – Les %22Si%22 et les %22If%22
\n\u2013 Textbox verification
\n\u2013 A number in the postal code \u2013 Isnumeric
\n\u2013 Checking comboboxes (editable list area)
\n\u2013 Checkbox verification
\n\u2013 Scrollbar \u2013 presentation of a scroll bar
\n\u2013 Define the maximum number of scrollbars
\n\u2013 Navigate using a scrollbar
\n\u2013 Checkboxes \u2013 To be included in the navigation
\n\u2013 Add a line via the form
\n\u2013 Modify data via the form
\n\u2013 Delete a row via the form
\n\u2013 Reaching the last line of a table<\/p>\n

\n

Format:<\/strong><\/span> MP4 (24 Files)
\nLanguage :<\/strong><\/span>\u00a0French
\nDuration :<\/strong><\/span> 2 hours 19 minutes
\nSize :<\/strong><\/span> 272.51 MB<\/p>\n

\n

Forms in Excel \u2013 Advanced Functions<\/strong><\/h4>\n

<\/i> DOWNLOAD Uptobox server<\/small><\/span><\/a><\/p>\n

<\/i> DOWNLOAD Server 1File<\/small><\/span><\/a><\/p>\n

<\/i> DOWNLOAD Krakenfiles Server<\/small><\/span><\/a><\/p>\n

<\/i> DOWNLOAD Rapidgator Server<\/small><\/span><\/a><\/p>","protected":false},"excerpt":{"rendered":"

La formation \u00ab\u00a0Les formulaires sous Excel\u00a0\u00bb est con\u00e7ue pour enseigner aux participants les comp\u00e9tences n\u00e9cessaires pour cr\u00e9er, utiliser et g\u00e9rer efficacement les formulaires dans le logiciel Excel. Vous pouvez \u00e9galement utiliser L\u2019essentiel de Excel. Les participants apprendront \u00e0 utiliser des formules math\u00e9matiques de base pour effectuer des calculs simples, \u00e0 utiliser des fonctions pr\u00e9d\u00e9finies pour […]<\/p>","protected":false},"author":1,"featured_media":51621,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[25],"tags":[9641,9178,9640,9639],"class_list":["post-51620","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-astuces-infos","tag-excel-fonctions-avancees","tag-formation-excel","tag-formation-formulaire","tag-formulaires-sous-excel"],"aioseo_notices":[],"modified_by":"Auteur","_links":{"self":[{"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/posts\/51620","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/comments?post=51620"}],"version-history":[{"count":0,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/posts\/51620\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/media\/51621"}],"wp:attachment":[{"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/media?parent=51620"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/categories?post=51620"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/tags?post=51620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}