SumProduct
SumProduct
  • Видео 142
  • Просмотров 138 526

Видео

39 TALIA CAO Solving Problems with Modern Excel & ChatGPT
Просмотров 1,6 тыс.8 месяцев назад
In the latest versions of Excel, Microsoft has introduced a range of new functions and features that enhance our ability to address complex problems. In this session, we’ll explore how these Excel enhancements such as Dynamic Arrays, LET and (recursive) LAMBDA with the assistance of ChatGPT can empower us in two practical examples: Solving Math Equations: Discover how Excel can make maths easie...
38 KEN PULS Boost your Excel efficiency with Monkey Tools
Просмотров 2278 месяцев назад
In this session Ken will introduce you to his Monkey Tools add-in and show you how it can help boost your Excel efficiency, whether you are using the free or pro versions of the tool. From storing your favourite Excel formulas and Power Queries to building Power Query backed data models with ease, this tool has something to offer every Excel analyst.
37 STEVE KRAYNAK Can I do real work in Excel for Mac
Просмотров 508 месяцев назад
The number of people using Mac computers has been steadily growing and shows no signs of slowing. We’ll take a deep dive into the differences between Excel for Mac and Excel for Windows. If you’re deciding on a new computer, or if you’re helping someone using a Mac, it’s important to be aware of the capabilities and limitations.
36 CRISTIANO GALVAO Real time Stocks Data in Microsoft Excel with RTD
Просмотров 2308 месяцев назад
Modern versions of Microsoft Excel come with a Stocks feature available in the Data tab. However, sometimes you need faster updates to help you make better decisions about certain investments. In this session, Cristiano Galvao will discuss DDE and go through a demonstration on how to use RTD to track real-time data directly from a homebroker software into a spreadsheet. If you are a trader or a...
35 MARKUS EHRENMUELLER Advanced Data Modelling in Power BI, AAS
Просмотров 618 месяцев назад
While it is a good practice to model your data as a star schema, there are challenges where you have to reach out to more advanced concepts. In this 50 min we will discuss the following challenges and how to overcome them: Multi-Fact model Many-to-many relationships Detached table Key-value-pair model
34 PAULA GARCIA ESTEBAN Visualización de datos, eligiendo visual en Excel o Power BI
Просмотров 1168 месяцев назад
¿Qué visual es más adecuado? ¿Cómo elegir entre tantas alternativas? En esta sesión revisaremos a fondo los visuales básicos para entender las diferencias. Basar tus elecciones de visual en un razonamiento lógico es posible y te lo voy a demostrar en esta sesión.
33 GEORGE MOUNT Modern Data Analytics in Excel
Просмотров 3218 месяцев назад
If you haven’t modernized your reporting and analysis in Excel, it may be time! In this free one-hour webinar, we’ll be looking at some new features for powerful analysis: Make first impressions with the data using Power Query profiling Conduct ad-hoc analysis with PivotTables and Charts Pull data fast with dynamic arrays
32 TONY DE JONKER The Best Excel Tips & Tricks to speed up your Reporting and Analysis
Просмотров 1138 месяцев назад
As a financial professional, you spend a lot of time crunching the numbers to build all kind of different reports. In this session you will discover solutions to practical questions I have encountered using existing and new features in Excel: Create self-updating charts using dynamic array formulas Allocate budget amounts to remaining months Applications of using range names in Power Query Allo...
31 GASPER KAMENSEK Query folding, what it is and why it matters
Просмотров 958 месяцев назад
Query Folding is a big part of Power Query, and in certain scenarios, it is the difference between a great and a bad Power BI solution. In this session, we will discuss what Query folding is and why you should pay attention to it.
30 CHRIS GROSS Python in Excel
Просмотров 748 месяцев назад
Python is one of the most popular programming languages today, loved by business and students alike - used for data analysis, visualization, machine learning and more. Python in Excel makes it possible to natively combine Python and Excel analytics in the same workbook - with no setup required. With Python in Excel, you can type Python directly into a cell, the Python calculations run in the Mi...
29 BEN HOWARD Synchronise Planner Plans into Power BI using Power Automate
Просмотров 1968 месяцев назад
Microsoft Planner is a fantastic tool to help track and manage projects, unfortunately it is a reporting black hole; this frustrates enterprises and organisations worldwide. To solve this problem we can use Power Automate, SharePoint and Power BI to create a unique solution that not only provides a rich reporting solution that enables organisations to see the status of the tasks in all of their...
27 KATHRYN NEWITT Power Query Online
Просмотров 418 месяцев назад
In this session, we will look at how to access Power Query Online, and look at the interface, which is arguably a big improvement on the desktop interface to Power Query.
28 BERNAT AGULLO Power BI Field Parameters, Calculation Groups and Dynamic Format Measures
Просмотров 4298 месяцев назад
Field Parameters, Calculation Groups and Dynamic Format Measures are three features of Power BI that often go unnoticed, but offer very powerful functionalities for your reports. In some use cases more than one can be used, so in this session we’ll dive in to their nature, advantages, disadvantages, similarities and differences by looking at different use cases. www.esbrina-ba.com/blog/ twitter...
26 CARLOS BARBOZA Interactive Charts with Python in Excel
Просмотров 1568 месяцев назад
26 CARLOS BARBOZA Interactive Charts with Python in Excel
25 TONY ROBERTS PYXLL compared with Python in Excel
Просмотров 1738 месяцев назад
25 TONY ROBERTS PYXLL compared with Python in Excel
24 SAM NGO Building VBA tools using ChatGPT
Просмотров 528 месяцев назад
24 SAM NGO Building VBA tools using ChatGPT
23 JAN KAREL PIETERSE Excel add ins that make your life easier
Просмотров 948 месяцев назад
23 JAN KAREL PIETERSE Excel add ins that make your life easier
22 MIKE THOMAS Building an Excel Based Soccer Dashboard
Просмотров 3618 месяцев назад
22 MIKE THOMAS Building an Excel Based Soccer Dashboard
21 MYLES KUAH An Introduction to Excel and ChatGPT
Просмотров 378 месяцев назад
21 MYLES KUAH An Introduction to Excel and ChatGPT
20 INDIRA BANDARI Power BI Tips and Tricks 2023
Просмотров 958 месяцев назад
20 INDIRA BANDARI Power BI Tips and Tricks 2023
19 ALEJANDRA HORVATH Power Query Transforming nested tables
Просмотров 598 месяцев назад
19 ALEJANDRA HORVATH Power Query Transforming nested tables
18 RUI CARVALHO Build Your Data Pipeline with Fabric Data Factory
Просмотров 968 месяцев назад
18 RUI CARVALHO Build Your Data Pipeline with Fabric Data Factory
17 GLENNA SHAW Accessibility
Просмотров 168 месяцев назад
17 GLENNA SHAW Accessibility
16 TIM HENG 10 things you’re not doing to make the most of Excel
Просмотров 668 месяцев назад
16 TIM HENG 10 things you’re not doing to make the most of Excel
15 CELIA ALVES The SPILL effect can't live without it
Просмотров 2668 месяцев назад
15 CELIA ALVES The SPILL effect can't live without it
14 NABIL MOURAD Enhance Data Visualisation with Form Controls
Просмотров 618 месяцев назад
14 NABIL MOURAD Enhance Data Visualisation with Form Controls
13 CHARLES WILLIAMS How Excel formulas interact with Python formulas
Просмотров 898 месяцев назад
13 CHARLES WILLIAMS How Excel formulas interact with Python formulas
12 ABIOLA DAVID Single Cell Advanced Formulas and Python in Excel
Просмотров 438 месяцев назад
12 ABIOLA DAVID Single Cell Advanced Formulas and Python in Excel
11 BERNARD OBENG BOATENG Actual v Budget Dashboard with Dynamic Arrays in Excel
Просмотров 6188 месяцев назад
11 BERNARD OBENG BOATENG Actual v Budget Dashboard with Dynamic Arrays in Excel

Комментарии

  • @73kittyb
    @73kittyb 2 дня назад

    i want to give you a thousand thumbs up. thanks so much for this.

  • @abderrahmaneazibi8056
    @abderrahmaneazibi8056 20 дней назад

    Very clear, useful, and to the point. Thank you so much.

  • @zxccxz164
    @zxccxz164 21 день назад

    what company would want DUMMY to be in a chart. FAIL

  • @zxccxz164
    @zxccxz164 21 день назад

    do you have link to sample file?? that would be very helpful

  • @zxccxz164
    @zxccxz164 21 день назад

    this is not geared to people who can't use field paramaters with ssas

  • @TheNoodlepip
    @TheNoodlepip Месяц назад

    This is great, such a time saver and so simple!

  • @georgefandamu5115
    @georgefandamu5115 Месяц назад

    Hi have been watching your videos about reconciliation using power query, you have really helped me. Now how can you match the positive(debt) and negative(credit) amounts not references. Let's say if the ledger references(using voucher number to payments) are different from bank references in excel power query suppliers reconciliation

    • @vincentlacomme
      @vincentlacomme Месяц назад

      Thank you for your interest ! I am not sure how it could be fully automated unless there would be at least one column with a common property (Voucher number). The property could be an equal match or partial match.

  • @workstuff5253
    @workstuff5253 Месяц назад

    For the LET function, I always like to have my final name labelled "result" so the final calculation returns "result".

  • @dmytro_korolkov
    @dmytro_korolkov Месяц назад

    Just want to add that together with Total commander (copy/paste selection from/to buffer) this is a brilliant combination when you need to delete or leave every Nth file in the folder.

  • @JamesKoford
    @JamesKoford Месяц назад

    3:06 "This is why this is such a cool trick, because nice people, it doesn't occur to them" 🤣🤣🤣

  • @meowmeowgaming3
    @meowmeowgaming3 2 месяца назад

    If how can i get multi columns how. Thank You,

  • @dmytro_korolkov
    @dmytro_korolkov 2 месяца назад

    Thank you!

  • @joshuaknight1748
    @joshuaknight1748 5 месяцев назад

    Everyone else does this with enormously long formulae

  • @farkadbarri1114
    @farkadbarri1114 6 месяцев назад

    Thank you for such an outstanding dashboard planning and executing. I found the data preparation very clean and clear and the model you built is sustainable.

  • @rchsuccesspartnersllc155
    @rchsuccesspartnersllc155 6 месяцев назад

    Really great!- Thank you

  • @nanthaSN
    @nanthaSN 7 месяцев назад

    Really like .❤

  • @s1ngularityxd64
    @s1ngularityxd64 7 месяцев назад

    pur excellence ☺

  • @kebincui
    @kebincui 7 месяцев назад

    👍💗

  • @Lyriks_
    @Lyriks_ 8 месяцев назад

    Great stuff Mr Thomas ! Two hidden gems in cube functions and camera tool !

  • @benoymammenmathew825
    @benoymammenmathew825 8 месяцев назад

    Thank you Ben, How did you get the Task URL?

  • @dr.vaibhavhase5979
    @dr.vaibhavhase5979 8 месяцев назад

    Great 👍

  • @peace-is-happy7046
    @peace-is-happy7046 8 месяцев назад

    Are you still on RUclips, I have a question?

  • @ensysconsultores
    @ensysconsultores 8 месяцев назад

    Muy interesante!

  • @spilledgraphics
    @spilledgraphics 8 месяцев назад

    Huge thanks for the opportunity, Liam and Team!

  • @spilledgraphics
    @spilledgraphics 8 месяцев назад

    Huge thanks for the opportunity, Liam and Team!

  • @huebui4978
    @huebui4978 8 месяцев назад

    Talia Cao’s workshop was great❤

  • @Lyriks_
    @Lyriks_ 8 месяцев назад

    I love talia cao's workshops, can't wait to see this one

  • @CeliaAlvesSolveExcel
    @CeliaAlvesSolveExcel 8 месяцев назад

    💚 Thank you to everyone watching my presentation. If you have any questions or comments, please don't hesitate to let me know. At 49:40 of the video, you will find a discount coupon for my training about automation reporting procedures in Excel and my contact info right after that.

  • @CeliaAlvesSolveExcel
    @CeliaAlvesSolveExcel 8 месяцев назад

    Thank you, Sumproduct team for organizing and posting the session recordings.

  • @SumProductOnline
    @SumProductOnline 8 месяцев назад

    www.sumproduct.com/assets/EVG2023/liam-bastick-evg2023-files.zip

  • @SumProductOnline
    @SumProductOnline 8 месяцев назад

    www.sumproduct.com/assets/EVG2023/boost-excel-efficiency-with-monkey-tools.pdf

  • @SumProductOnline
    @SumProductOnline 8 месяцев назад

    www.sumproduct.com/assets/EVG2023/talia-cao-solving-problems-with-modern-excel---chatgpt---starter.xlsx

  • @SumProductOnline
    @SumProductOnline 8 месяцев назад

    sqlederhose-my.sharepoint.com/:b:/g/personal/markus_ehrenmueller-jensen_savorydata_com/EZS-RnHIOWhHnUGJB-AnsrcBr6T6JKAgbEtS5qGDiwP1YQ?e=6qLPQA

  • @SumProductOnline
    @SumProductOnline 8 месяцев назад

    www.sumproduct.com/assets/EVG2023/george-mount-evg2023-files.zip

  • @SumProductOnline
    @SumProductOnline 8 месяцев назад

    www.sumproduct.com/assets/EVG2023/myles-kuah-evg2023-files.zip

  • @SumProductOnline
    @SumProductOnline 8 месяцев назад

    www.sumproduct.com/assets/EVG2023/alejandra-horvath-evg2023-files.zip

  • @SumProductOnline
    @SumProductOnline 8 месяцев назад

    www.sumproduct.com/assets/EVG2023/glenna-shaw-evg-2023-files.zip

  • @SumProductOnline
    @SumProductOnline 8 месяцев назад

    www.sumproduct.com/assets/EVG2023/evg23---celia-alves---shared-files.zip

  • @SumProductOnline
    @SumProductOnline 8 месяцев назад

    www.sumproduct.com/assets/EVG2023/charles-williams-evg-2023-files.zip

  • @SumProductOnline
    @SumProductOnline 8 месяцев назад

    www.sumproduct.com/assets/EVG2023/abiola-david-python-excel-virtually-conference.xlsx

  • @SumProductOnline
    @SumProductOnline 8 месяцев назад

    www.sumproduct.com/assets/EVG2023/bernard-obeng-boateng-excel-virtually-global-2023_start.xlsx

  • @SumProductOnline
    @SumProductOnline 8 месяцев назад

    www.sumproduct.com/assets/EVG2023/jon-peltier-interactive-charts-in-excel.xlsx

  • @SumProductOnline
    @SumProductOnline 8 месяцев назад

    sqlederhose-my.sharepoint.com/:b:/g/personal/markus_ehrenmueller-jensen_savorydata_com/EeIi7Nl4WFVHhn62HOB54poB1HsZJs7zt_viZrsDysKaRw?e=MTBd0o

  • @SumProductOnline
    @SumProductOnline 8 месяцев назад

    www.sumproduct.com/assets/EVG2023/miguelfelixthinkinsidebox.pbix

  • @misdrevenous
    @misdrevenous 9 месяцев назад

    OMG you saved my life

  • @rogerdiazb
    @rogerdiazb 9 месяцев назад

    Excelente explicacion de la tecnica. Muchas gracias.

  • @tkralik
    @tkralik 9 месяцев назад

    This is next level mate. Great job. Thx

  • @user-pj3wv6uh3t
    @user-pj3wv6uh3t 9 месяцев назад

    Dear Obeng, This is so much helpful! I tried creating the same but I hit a roadblock. I added an additional slicer, say a sub-Department. When I converted the table to formulas, the link between Department and sub-Department was lost. How can I correct this?

    • @FinexSkillsHub
      @FinexSkillsHub 9 месяцев назад

      You may need to add the name of the new slicer in the CUBEVALUE formula so that it can slice those values. New slicers can be added as an extra expression in existing formulas.

  • @Soulenergy31
    @Soulenergy31 9 месяцев назад

    Thank you Ben for sharing this awesome project!!!!!!!!!!!!!! 6:00 adding task 8:27 dont not export to excel 8:45 create a flow instead 23:45 running the automate scrip within Excel online 39:21 The star Schema 43:56 schedule refresh

  • @arjunyelawade1999
    @arjunyelawade1999 9 месяцев назад

    Hi nice explain can you provide pbi file sir