Stringfest Analytics
Stringfest Analytics
  • 35
  • 7 068
First steps with dynamic arrays in Excel REPLAY 20241211
Thanks all for attending today’s session on dynamic arrays and dynamic array functions for Excel. The recording is now available, and you can download the exercise files from github.com/stringfestdata/modern-analytics-excel-book/archive/refs/heads/main.zip
I’d appreciate your feedback on today’s session. Feel free to share what you enjoyed, what you'd like to see differently, or any additional topics you'd like me to cover. You can also leave a testimonial if you found the session valuable: stringfestanalytics.com/event-feedback .
Lastly, if you're looking to elevate your finance or operations teams to operate like data analysts and engineers using Excel-without the need for costly software or IT delays-check out my services at stringfestanalytics.com/consulting .
I also offer specialized workshops and training for research, procurement, and supply chain teams, both onsite and online. My goal is to build lasting partnerships that enhance your analytics capabilities for the long term.
Thanks again for attending, and I hope to see you at future events! You can sign up for upcoming sessions here: eventbrite.com/o/stringfest-analytics-34157163075
มุมมอง: 19

วีดีโอ

First Steps with Power Pivot for Excel REPLAY 12042024
มุมมอง 8719 ชั่วโมงที่ผ่านมา
Thanks all for attending today’s session on Power Pivot for Excel. The recording is now available at th-cam.com/video/tVbsTVSqUbw/w-d-xo.html, and you can download the exercise files from github.com/stringfestdata/modern-analytics-excel-book/archive/refs/heads/main.zip. I’d appreciate your feedback on today’s session. Feel free to share what you enjoyed, what you'd like to see differently, or a...
First steps with Power Automate for Excel users REPLAY 11202024
มุมมอง 20421 วันที่ผ่านมา
Thanks all for attending today’s session on Power Automate for Excel. The recording is now available, and you can download the exercise files from github.com/stringfestdata/first-steps-power-automate/archive/refs/heads/main.zip. I’d appreciate your feedback on today’s session. Feel free to share what you enjoyed, what you'd like to see differently, or any additional topics you'd like me to cove...
Transforming rows with Power Query in Excel REPLAY 11062024
มุมมอง 118หลายเดือนก่อน
Thanks all for attending today’s session on transforming rows with Power Query in Excel. The recording is now available, and you can download the exercise files from github.com/stringfestdata/modern-analytics-excel-book/archive/refs/heads/main.zip I’d appreciate your feedback on today’s session. Feel free to share what you enjoyed, what you'd like to see differently, or any additional topics yo...
First steps with Copilot for Excel REPLAY 10252024
มุมมอง 88หลายเดือนก่อน
Thanks all for attending today’s session on Office Scripts in Excel. The recording is now available at th-cam.com/video/sXyd6dhK59Q/w-d-xo.html, and you can download the exercise files from github.com/stringfestdata/first-steps-copilot-in-excel/archive/refs/heads/main.zip I’d appreciate your feedback on today’s session. Feel free to share what you enjoyed, what you'd like to see differently, or...
First Steps with Office Scripts for Excel REPLAY 10162024
มุมมอง 86หลายเดือนก่อน
Thanks all for attending today’s session The recording is now available, and you can download the exercise files from github.com/stringfestdata/first-steps-office-scripts/archive/refs/heads/main.zip. I’d appreciate your feedback on today’s session. Feel free to share what you enjoyed, what you'd like to see differently, or any additional topics you'd like me to cover. You can also leave a testi...
AI for Excel 101 REPLAY 09272024
มุมมอง 1362 หลายเดือนก่อน
Thanks all for attending today’s session on AI for Excel 101. The recording is now available, and you can download the exercise files from github.com/stringfestdata/ai-for-excel-101/archive/refs/heads/main.zip. I’d appreciate your feedback on today’s session. Feel free to share what you enjoyed, what you'd like to see differently, or any additional topics you'd like me to cover. You can also le...
Python in Excel crash course REPLAY 09252024
มุมมอง 3312 หลายเดือนก่อน
Thank you for attending today’s introductory overview of Python in Excel. The recording is now posted at th-cam.com/video/0Qe-7afhJB0/w-d-xo.html. You can download the exercise files for this workbook at github.com/stringfestdata/python-in-excel-crash-course. Such is the nature of live training that I did have some technical difficulties at the beginning of the session. My apologies. I’d apprec...
First steps with Advanced Analysis in Python with Copilot for Excel REPLAY 09/20/2024
มุมมอง 8672 หลายเดือนก่อน
Hi all, Thank you for attending today’s session on Advanced Analytics with Python for Copilot in Excel. You can download the exercise files from github.com/stringfestdata/python-excel-advanced-analysis-demos/archive/refs/heads/main.zip . To learn more about Python in Excel, head to support.microsoft.com/en-us/office/get-started-with-python-in-excel-a33fbcbe-065b-41d3-82cf-23d05397f53d For more ...
Tables: The Portal to Modern Excel REPLAY
มุมมอง 1863 หลายเดือนก่อน
Thank you for attending today’s session on Excel Tables! The recording is now available at th-cam.com/video/rz9I38Qp8pg/w-d-xo.html, and you can download the exercise files from github.com/stringfestdata/modern-analytics-excel-book. This workshop is based on my book Modern Data Analytics in Excel. If you're interested in learning more or getting a copy, visit stringfestanalytics.com/maxl. I’d a...
Sigma Rule #1,048,576: Never underestimate Excel #SHORTS
มุมมอง 2262 ปีที่แล้ว
If you've heard that Excel can only analyze 1,048,576 rows, then you may want to hear about Power Query. Break your team past the million-row limit with my Power Query workshop: stringfestanalytics.com/click-and-clean-pq-workshop/
30 Days to Data Analyst #Shorts
มุมมอง 203 ปีที่แล้ว
Get your copy: stringfestanalytics.com/30-days-data-analyst/ I’ve assembled “30 Days to Data Analyst,” a free checklist providing 30 resources and activities to perform across the web. Some days you’ll be on my blog, others you’ll visit others’ blogs, yet others you’ll be reading documentation, downloading software, and more.
From liberal arts to data business owner: Interview with Megan Peitz, Founder of Numerious`
มุมมอง 673 ปีที่แล้ว
Skip to sections: 1:18 Origin story and founding of Numerous 7:05 Using a liberal arts education to run a data business 9:56 Advice for those looking to gain data literacy 14:09 Advice for those interested in running a data business 17:14 Last words/close Do you feel like fear of math is holding back your data literacy and career efforts? Or are you interested in taking your data career to the ...
Five ways to get help in Python
มุมมอง 1213 ปีที่แล้ว
Use these five techniques to get unblocked when coding in Python. Get the notebook and other resources used in this video at the blog: georgejmount.com/?p=7439 Want more help learning about Python and Jupyter Notebooks? Check out my book, Advancing into Analytics: From Excel to Python and R at georgejmount.com/book/. Great if you are coming from a spreadsheet background!
Zero-based indexing: What it is and when you've seen it already
มุมมอง 4913 ปีที่แล้ว
Zero-based indexing: What it is and when you've seen it already
A tour of Python + Jupyter Notebooks
มุมมอง 733 ปีที่แล้ว
A tour of Python Jupyter Notebooks
Demo guide: The empirical rule, visualized in Excel
มุมมอง 664 ปีที่แล้ว
Demo guide: The empirical rule, visualized in Excel
The Monty Hall problem visualized in Excel
มุมมอง 4564 ปีที่แล้ว
The Monty Hall problem visualized in Excel
The margin of error, visualized in Excel
มุมมอง 944 ปีที่แล้ว
The margin of error, visualized in Excel
Course sequence: Data analytics for the liberal arts
มุมมอง 794 ปีที่แล้ว
Course sequence: Data analytics for the liberal arts
Learning guide: Introduction to R, one-day workshop
มุมมอง 2794 ปีที่แล้ว
Learning guide: Introduction to R, one-day workshop
Teaching coding: The PRIMM method
มุมมอง 5284 ปีที่แล้ว
Teaching coding: The PRIMM method
Teaching coding: What is a Parsons problem?
มุมมอง 4984 ปีที่แล้ว
Teaching coding: What is a Parsons problem?
Learning guide: Statistics in Excel, half-day workshop
มุมมอง 294 ปีที่แล้ว
Learning guide: Statistics in Excel, half-day workshop
Demo guide: The central limit theorem, visualized in Excel
มุมมอง 2024 ปีที่แล้ว
Demo guide: The central limit theorem, visualized in Excel
Learning guide: Power Query in Excel, half-day workshop
มุมมอง 104 ปีที่แล้ว
Learning guide: Power Query in Excel, half-day workshop
What makes a good analytics course?
มุมมอง 144 ปีที่แล้ว
What makes a good analytics course?
Learning guide: Excel for nurses, half-day workshop
มุมมอง 5524 ปีที่แล้ว
Learning guide: Excel for nurses, half-day workshop
Demo guide: Coin toss in Excel
มุมมอง 6194 ปีที่แล้ว
Demo guide: Coin toss in Excel
Resource guide: Data storytelling with PowerPoint, one-day workshop
มุมมอง 494 ปีที่แล้ว
Resource guide: Data storytelling with PowerPoint, one-day workshop

ความคิดเห็น

  • @undrgrndhp
    @undrgrndhp หลายเดือนก่อน

    Great video. Thank you!

  • @azouaouaitfella5092
    @azouaouaitfella5092 2 หลายเดือนก่อน

    Hi . Thank you for sharing

  • @3345dbshockwave
    @3345dbshockwave 2 หลายเดือนก่อน

    Where XFE?

  • @phantrungai8585
    @phantrungai8585 2 หลายเดือนก่อน

    there is no python in my excel (microsoft 365)

    • @stringfestanalytics8205
      @stringfestanalytics8205 2 หลายเดือนก่อน

      Hi, please see the details on Python in at support.microsoft.com/en-us/office/get-started-with-python-in-excel-a33fbcbe-065b-41d3-82cf-23d05397f53d

  • @JohnAdair-k7j
    @JohnAdair-k7j 2 หลายเดือนก่อน

    It's a great book.

  • @stevecollins3496
    @stevecollins3496 ปีที่แล้ว

    I missed the part where you accounted for the host revealing a goat after the initial pick. How would you program that in?

    • @LeksiW
      @LeksiW 9 หลายเดือนก่อน

      I was wondering the same thing myself. That is quite more difficult to program.

  • @metaalgotradingtools7367
    @metaalgotradingtools7367 ปีที่แล้ว

    Interesting and fun way to understand the Monty hall problem. Thanks and keep up the good work.❤

  • @PaulaWeb3andCrypto
    @PaulaWeb3andCrypto 4 ปีที่แล้ว

    great video

  • @sandeepkothari5000
    @sandeepkothari5000 4 ปีที่แล้ว

    There is a problem with the audio.Hardly audible.

  • @sandeepkothari5000
    @sandeepkothari5000 4 ปีที่แล้ว

    Is the workshop free to attend?