Excel Publish Any Excel Logic As Web App Using Sheetcast While Protecting Your IP - Episode 2635
HTML-код
- Опубликовано: 4 июл 2024
- Microsoft Excel Tutorial: Embed any Excel Logic in a Web App Using www.sheetcast.com/
Try this web app now to search my videos: c07.sheetcast.com/view/c79f93...
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 RUclips 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. Until next time, this is Bill Jelen from MrExcel, signing off.
Buy Bill Jelen's latest Excel book: www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: www.mrexcel.com/like-mrexcel-...
Learn more about Sheetcast at www.sheetcast.com/
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 RUclips 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?
![Eminem - Tobey (feat. Big Sean & Babytron) [Official Audio]](http://i.ytimg.com/vi/9xn0OHEZZ8Q/mqdefault.jpg)
Cogratualtions, # 1 Excel Guy Ever, Bill Mr Excel Jelen!!!! The Exceler that started all of us out on videos!!! I still remember watching all your videos at iTunes!!!! Thanks for starting us all out and for helping me to be a better Exceller always!!! : ) : ) : ) : ) : ) : ) : ) : )
Congratulations on 25 years of Mr.Excel, Bill.
We Excel users owe you an immense debt of gratitude.
…and here’s to the next 25 years! :-)
Happy 25th Excel-Aniversary Bill Jelen! Thanks for all of your tips,
Thanks for this video Bill. Nice to know that Sheetcast lives up to its sales pitch!
Congratulations !!! 25 years of awesomeness!
I got my first Excel job in 2002 and benefited from the Mr. Excel message board too!
Happy Anniversary!!
Left a present at the forum 😉✌🎉🎉
Great video! CONGRATS on 25 years. 🥳🥳🥳
Thank you, Mr. Excel, for 25 years of sharing Excel expertise !! Best wishes!!
Congratulations on 25 years ! Your contributions to the Excel community have been incredible!
Congrats on 25 years! I know the feeling when I tell coworkers I've used Excel for 28 years!
Congratulations on 25 years and here is to 25 more years.
My first exposure to spreadsheets was VisiCalc on an Apple II, then Borland's Quattro Pro. Your videos have often pointed me toward approaches that solved business challenges and reduced my frustration. Thank you, thank you, thank you.
🎂🎉🥳 Happy Birthday to MrExcel. This is a fun video showcasing how to mix all those awesome functions :)
It is such a fun video! ✨
The Mr. Rogers of Excel
I loved how Bill took out his guitar and sang at the end!
Happy 25th Excel-iversary Bill Jelen! We love your database! Thanks for being such a great mentor to the Excel community! 🎉
Different topic: Wanted a single formula to spill a calendar month that would begin with blanks for the last few days of the previous month instead of hiding those dates with formatting. I came up with LET(x,C7,WRAPROWS(DROP(HSTACK(EXPAND({""},,WEEKDAY(x,1),""),SEQUENCE(,DAY(EOMONTH(x,0)),x)),,1),7,"")), where C7 is the 1st of the month (displayed as just the month). Not sure if there's a more efficient way, but the MS template used over a thousand IF functions (for backwards compatibility, I'm sure). Thanks again for all the great Excel videos!
Though it's off topic, I thought this was a neat calendar formula I posted. Was hoping someone would comment on it or maybe have an even better solution.
Wow - 25 years. Thanks for all of your tips, books, and videos over the years. Congrats🎉
Congrats. I see Sheetcast is
located in my city (Calgary) and they support World Vision.
Thank you for all your help over the years! You have save my a$$ more times than I can count.
Congrats! Thanks for all of the tips over the years and for letting us know about new functions.
Congrats on 25 years! You're amazing!
Congratulation !!!
Thanks for a long life contribution ro the world ❤❤❤
AWESOME feature. going to be using it from now on, need to save it to my favorites. I help many people online with excel questions and between you and Mike G.(XL is fun) you guys have the videos that explain it so well, its easy to send a link to someone. Thanks Bill (and Mike G.) for some of the best Excel content out there.
Congrats on 25 years Bill!!!! re: sheetcast ... "we TRIED to use the same colors you used" basically means they couldn't replicate the spreadsheet using sheetcast. I hate these marketing types like this. "we can publish any workbook to the web" ... "oh, but we don't replicate the colors, and we don't do x, y, z and a long laundry list of other things that we won't tell you. just buy our product."
Our BA's were able to successfully replicate the colors Bill used within his spreadsheet without any additional work! All style elements come directly from excel and are interpreted by our engine, there are no additional style elements outside of creating your workbook in Excel!
Congrats on 25 years
Congratulations Mr. Excel :)
Here is to another 25 years! 🍻
🎉
----------------ITS NOT WORKING? you type in something in the search, and nothing comes up??? -----------------------------