Microsoft Excel Tutorial: Embed any Excel Logic in a Web App Using Sheetcast.com.
Try this web app now to search my videos: https://c07.sheetcast.com/view/c79f93d2-0dcf-441f-97ac-b0c100f02a4f/~/d174333f-e3fe-4b14-a13b-ef6e384af5bb?embed=True&expand=true&showTitle=true
Welcome to episode 2635 of the MrExcel podcast! It’s been 25 years since I started sharing my Excel tips and tricks with all of you, and I couldn’t be more grateful for your support. Today, I have something truly amazing to show you – how to publish any Excel logic as a web app using Sheetcast while protecting your intellectual property. Plus, I’ll also be sharing how you can search through 25 years of MrExcel content using just 18 Excel functions. Let’s dive in!
Have you ever wondered how to create a web app from your Excel workbook without giving away your intellectual property? Well, I recently met with the team at Sheetcast and they showed me how it can be done in just minutes. All you need is your Excel workbook and the ability to build logic in Excel. Sheetcast takes care of the rest, giving you a fully functional web app. And the best part? You can protect your IP while still having all the calculations work seamlessly.
To put Sheetcast to the test, I challenged them to create a web app using some of the most complex Excel functions, such as IMAGE, HSTACK, and FILTER. And to my surprise, they were able to deliver a fully functional web app in just a few days. This is truly mind-blowing and a game-changer for anyone looking to share their Excel work without compromising their intellectual property.
But that’s not all. Sheetcast also allows you to search through 25 years of MrExcel content using just 18 Excel functions. No more scrolling through endless YouTube videos or trying to remember which video had the information you need. With Sheetcast, you can easily search for specific phrases and find the exact video you’re looking for. It’s like having your own personal Excel search engine!
I’m truly amazed by the capabilities of Sheetcast and I’m excited to share it with all of you. In honor of the 25th anniversary of MrExcel, Sheetcast has created a special URL where you can try out the web app for yourself. Just click the link in the description below and see for yourself how easy it is to create a web app from your Excel workbook. And don’t forget to use the coupon code “25years” for 25% off all Excel eBooks at the MrExcel store.
I also want to take this opportunity to thank the amazing community at MrExcel. Your support and participation in the MrExcel message board has been invaluable over the years. Together, we have created a community of smart and talented individuals who can solve any Excel problem. Thank you for being a part of this journey and here’s to many more years of Excel success! Don’t forget to like, subscribe, and ring the bell for more Excel tips and tricks. And as always, feel free to leave any questions or comments down below. Until next time, this is Bill Jelen from MrExcel, signing off.
Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/
Table of Contents
(0:00) Welcome to 25th anniversary of MrExcel
(0:45) Ctrl+; for Current Date
(1:05) YEARFRAC function in Excel
(1:25) First articles at MrExcel.com in 1998-1999
(1:54) Publish Excel logic to web app using Sheetcast
(2:17) Create a challenge for Sheetcast with 18 functions
(2:44) Workbook to search MrExcel YouTube content
(3:17) Testing the Video Search in Excel
(3:53) Excluding stop words from search
(4:31) How many times is pivot mentioned in a video
(4:58) Hash as array operator
(5:08) Seeing results of subformula in tooltip
(6:00) What match score is 5th largest
(6:14) FILTER and HSTACK the top 5
(6:35) IMAGE function
(7:34) Sheetcast Version of my Excel Workbook
(8:24) You can try it
(9:30) 25% Off E-books at MrExcel
(10:00) Thanks to MrExcel Board
(10:27) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #microsoftmvp #walkthrough #evergreen #spreadsheetskills #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelsort #excelfilter #exceldatafiltering #filter #filterfunction #advancedfilter #publishtoweb
This video answers these common search terms:
how to embed excel sheet in website
how to embed live excel chart onto website
create a website using excel
how to make website mockup using excel
can you design websites in excel
can you create a website in excel
how to use excel in web
how to publish excel to web
how to save excel file to web page
how to embed excel sheet in website
how to embed live excel chart onto website
how do i open an excel spreadsheet on the web
how to publish an excel spreadsheet on the web
is there a way to turn excel macros into a website instead?