{"id":51846,"date":"2023-01-30T20:50:46","date_gmt":"2023-01-30T19:50:46","guid":{"rendered":"https:\/\/www.trucnet.com\/?p=51846"},"modified":"2023-01-30T20:50:46","modified_gmt":"2023-01-30T19:50:46","slug":"creez-tableau-de-bord-excel-power-query-a-a-z","status":"publish","type":"post","link":"https:\/\/www.trucnet.com\/en\/creez-tableau-de-bord-excel-power-query-a-a-z\/","title":{"rendered":"Create Excel + Power Query dashboards from scratch"},"content":{"rendered":"

In this course, you will learn how to create a complete and customized dashboard using Excel and Power Query. You will discover how to extract and clean data, and then how to transform it into useful visual information through the dashboard. You can also use Office 2019 Training<\/a><\/p>\n

You will also learn how to use charts, pivot tables, and simple tables to display complex data clearly and easily. This course covers the fundamentals of dashboard creation and provides advanced tips and techniques to enhance the look and functionality of your dashboard. It is suitable for Excel beginners and those who want to improve their dashboard creation skills.<\/p>\n

Improve your skills with this video training on the following topics:<\/strong>
\n\u2013 Raw data processing
\n\u2013 Excel integration
\n\u2013 Merging data files
\n\u2013 Loading data with Power Query
\n\u2013 Data analysis using pivot tables
\n\u2013 Information visualization (dataviz)
\n\u2013 Performance indicators
\n\u2013 Dashboard layout
\n\u2013 Graphic stylization
\n\u2013 Interaction with dashboard.
\nAnd more<\/p>\n

\n

Format:<\/strong><\/span> MP4 (40 Files)
\nLanguage :<\/strong><\/span>\u00a0French
\nDuration :<\/strong><\/span> 3 hours 31 minutes
\nSize :<\/strong><\/span> 424.62 MB<\/p>\n

\n

Create Excel + Power Query dashboards from scratch<\/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":"

Dans cette formation, vous apprendrez \u00e0 cr\u00e9er un tableau de bord complet et personnalis\u00e9 \u00e0 l’aide d’Excel et de Power Query. Vous d\u00e9couvrirez comment extraire et nettoyer des donn\u00e9es, puis comment les transformer en informations visuelles utiles \u00e0 travers le tableau de bord. Vous pouvez \u00e9galement utiliser Formation Office 2019 Vous apprendrez \u00e9galement \u00e0 utiliser […]<\/p>","protected":false},"author":1,"featured_media":51848,"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":[9675,456,2442,9673,9672,9671,9674],"class_list":["post-51846","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-astuces-infos","tag-debutants-en-excel","tag-excel","tag-formation","tag-graphiques","tag-power-query","tag-tableau-de-bord","tag-tableaux-croises-dynamiques"],"aioseo_notices":[],"modified_by":"Auteur","_links":{"self":[{"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/posts\/51846","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=51846"}],"version-history":[{"count":0,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/posts\/51846\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/media\/51848"}],"wp:attachment":[{"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/media?parent=51846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/categories?post=51846"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.trucnet.com\/en\/wp-json\/wp\/v2\/tags?post=51846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}