Extract Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/extract/ Bestselling Excel and Power BI Courses Mon, 24 Apr 2023 16:11:14 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Extract Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/extract/ 32 32 How to Work with Time in Excel Power Query https://www.xelplus.com/power-query-time-calculations/ Thu, 20 Aug 2020 09:00:00 +0000 https://www.xelplus.com/?p=10801 Working with time in Excel - for example calculating hours worked or summing or subtracting time can get tricky with Excel formulas. Let me show you how Power Query can easily do these for you.

The post How to Work with Time in Excel Power Query appeared first on Xelplus - Leila Gharani.

]]> Create Excel Filled Map Charts with Power Query https://www.xelplus.com/excel-filled-map-chart-using-power-query/ Thu, 02 Jul 2020 17:51:00 +0000 https://www.xelplus.com/?p=10886 Go from raw data to a filled map chart in Excel. Power Query will help summarize the data and make the whole process dynamic. Use Excel filled maps to create an impressive visualization for your reports.

The post Create Excel Filled Map Charts with Power Query appeared first on Xelplus - Leila Gharani.

]]>