{"id":43440,"date":"2021-03-19T22:56:48","date_gmt":"2021-03-19T21:56:48","guid":{"rendered":"https:\/\/www.trucnet.com\/?p=43440"},"modified":"2021-03-19T23:51:31","modified_gmt":"2021-03-19T22:51:31","slug":"devenir-un-expert-dexcel-la-formation-excel","status":"publish","type":"post","link":"https:\/\/www.trucnet.com\/en\/devenir-un-expert-dexcel-la-formation-excel\/","title":{"rendered":"Become an Excel expert \u2013 Excel training"},"content":{"rendered":"

Becoming an Excel expert is the goal of this series of educational videos that offer in-depth training on all Excel-related topics. Regardless of your current Excel level, if you want to advance your skills in a specialized way, this Excel course is for you. You can also download Mastering Excel through practice<\/a>.<\/p>\n

Most Excel users don't actually utilize the program's full capabilities, but thanks to this comprehensive course covering all Excel-related topics, your skills will develop progressively and be validated through regular practical exercises. This complete Excel training covers a wide range of elements. The course is very thorough, covering key concepts and going beyond a simple list of features to extend into related topics such as data visualization and the fundamentals of statistics.<\/p>\n

This Excel training course includes several main sections, over 305 videos, and more than 18 hours of instruction.<\/strong><\/p>\n

\u2013 Basic principles of Excel: how the workbook works, autofill, functions, cell style, handling of malformed files.
\n\u2013 Data exploration: advanced sorting, advanced filters, conditional formatting, pivot tables.
\n\u2013 Functions in Excel: changing the type, reprocessing text or dates, search functions, logical functions, error handling, locating dependencies.
\n\u2013 DATAViz: data visualization: choose the right visualization, run each perception, customize one.
\n\u2013 Pivot tables: create your own pivot tables, modify metric calculations, add a slicer and create a pivot chart.
\n\u2013 Perform analyses of your data: statistical reminders, use of numerical functions.
\n\u2013 Use Power Query and Power Pivot: import external data, reformulate, create relationships and use them in the spreadsheet.
\n\u2013 Learn to program in VBA: how to record a macro, introduction to VBA, table manipulation, create a dynamic model, automate tasks, create your own jobs.
\n\u2013 Each major section will include a DIY workshop allowing you to validate your knowledge!
\n\u2013 In addition, a multiple-choice questionnaire will be presented to you at the end of the training and will allow you to validate the theoretical part acquired during the training.<\/p>\n

\n

Format:<\/strong><\/span>\u00a0MP4 \/XLSX
\nSize :<\/strong><\/span> 2.63 GB
\nLanguage :<\/strong><\/span>\u00a0French
\nDuration :<\/strong><\/span> 6 PM<\/p>\n

\n

Become an Excel expert \u2013 Excel training<\/strong><\/p>\n

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

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

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

Devenir un expert d’Excel, c’est un ensemble de vid\u00e9os \u00e9ducatives qui vous offrent une formation approfondie sur tous les sujets li\u00e9s \u00e0 Excel. Quel que soit votre niveau d\u2019Excel, si vous souhaitez faire progresser votre utilisation de mani\u00e8re sp\u00e9cialis\u00e9e, ce cours Excel est fait pour vous. Vous pouvez aussi t\u00e9l\u00e9charger Ma\u00eetriser Excel par la pratique. […]<\/p>","protected":false},"author":1,"featured_media":43443,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"no","_lmt_disable":"no","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[25],"tags":[9194,9193,9178,9195,9192],"class_list":["post-43440","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-astuces-infos","tag-cours-excel","tag-expert-excel","tag-formation-excel","tag-formation-excel-complete","tag-videos-educatives-excel"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t