Excel - How to Embed Excel Sheet in Website - Episode 2012

Microsoft Excel Tutorial: Publish your Excel workbook as a web-app dashboard.

Welcome to the MrExcel podcast, episode 2012, where we will be discussing how to create a web dashboard in Excel. If you haven't already, make sure to subscribe to the playlist in the top-right hand corner to catch all of our podcast episodes. I'm your host, Bill Jelen, and I'm excited to show you how to take your Excel skills to the next level.

In this episode, we will be focusing on making our dashboard look less like Excel before publishing it to the web. This will give it a more professional and polished appearance. To do this, we will select all cells on the dashboard and use a light fill color to get rid of the gridlines. Then, on the View tab, we will turn off the formula bar, headings, and gridlines. We will also use the ^ indicator to hide the ribbon and use the arrow keys to hide the active cell behind a chart or slicer.

Next, we will hide all sheets except for the dashboard sheet. To make this process easier, we will create a custom view called "ShowAllWorksheets" before hiding the sheets. This way, we can easily unhide all sheets if needed. Then, we will create another custom view called "OnlyDashboard" to easily switch back to just the dashboard sheet. This will give our dashboard a clean and professional look.

Before publishing our dashboard to the web, we will create a range name for our dashboard and use the Browser View Options to only show that named range. This will ensure that only the dashboard is visible when we share the file. We will then save the file to the OneDrive and get a view-only sharing link to share with our manager. This will allow them to view the dashboard without having access to the entire workbook.

Impress your boss by creating a beautiful web app using Excel. This is a great way to showcase your skills and take your Excel game to the next level. And don't forget, this is just one of the many tips and tricks you can learn from my book "MrExcel XL". Click the "i" in the top-right hand corner to purchase the book and continue improving your Excel skills.

To recap, before publishing your dashboard to the web, make sure to make it look less like Excel by using a light fill color, hiding unnecessary elements, and creating custom views. Then, use the Browser View Options to only show the named range of your dashboard. Save the file to the OneDrive and get a view-only sharing link to impress your boss with your professional and polished web app. Thank you for tuning in to this episode of the MrExcel podcast, and we'll see you next time for more Excel tips and tricks.

Table of Contents:
(00:00) Publishing workbook as a web dashboard
(00:14) Making the dashboard look less like Excel
(01:02) Hiding all sheets except for the dashboard sheet
(01:42) Creating custom views for showing all worksheets or only the dashboard
(02:25) Saving the dashboard to the OneDrive and getting a view-only sharing link
(03:23) Viewing the dashboard on the web and updating data through slicers
(04:14) Potential concerns about sharing data on the web
(04:25) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #microsoft365 #walkthrough #excelnew #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #publishtoweb

This video answers these common search terms:
how to convert excel to web application
how do i open an excel spreadsheet on the web
how to embed live excel chart onto website
how to publish excel to web
how to save excel file to web page
can you create a website in excel
can you design websites in excel
create a website using excel
how to embed excel sheet in webisite
how to publish an excel spreadsheet on the web

Episode recap:
Before going to the web, make your dashboard look less like Excel
Select all cells and apply a light fill color to get rid of the gridlines.
On the View tab, uncheck Formula Bar, Headings, and Gridlines.
At the right edge of the ribbon, use the ^ to collapse the Ribbon.
Use the arrow keys to move the active cell so it is hidden behind a chart or slicer.
Hide all sheets except for the dashboard sheet.
I use Custom Views so I can later Unhide All Worksheets
In Excel Options, Advanced, you can hide the scrollbars and sheet tabs.
Create a range name around your dashboard
File, Info, Browser View Options (used to be File, Export)
Save to the One Drive
Get a sharing link

[excelisfun]

Thanks for the many cool tricks for this web app!!!

[PedroCabraldaCamara]

fantastic video!!! Thank you very much Bill

[wangzig]

Thanks for this video, very nice effort and easy to follow. wish you are well

[alirezamogharabi]

wow! that's amazing, thanks a lot mrexcel!

[johng]

Thanks in a million. I'm definitely buying you book.

[Thunderin]

The "Browser View Options" For Excel 2010: File >>> Save & Send >>> Save to Web (Then you have to sign with Windows Live ID). This is even before the "File >>> Export" which Bill mentioned in the video.

[Bruhfinally]

Excel and Sheets are so close to being an actual Web App development tool.

[NoShadowOfDoubt]

Amazing. thank you! some bosses however still prefer the report on 04:18

[nightfire]

Very informative video, thanks! Any idea how you could save and host this on a local server or intranet instead of onedrive?

[Rice]

4:13 I'm not a boss, but i'm impressed with them. 😍😂

[mohmmadabdo]

Thank you, but I have a question. How I can publishe dashboard report as *powerpoint show* with active slicers and dynamic data?

[drabhijeetghosh]

That's great. But doesn't work with data validation cells and the filtering process from those drop downs..

[LukaszKawalec]

Great video! Can I embed this kind of calculators on my website? And is it possible that people could enter some values?

[rahulkalingeri]

Hello,
Thanks for the video. Its very helpful to present my Excel Dashboard in a cool way :-)
I have a issue though, Named Range doesn't appear in the selection items for me
only Pivot tables and charts appear.
If I select other region in the excel sheet without the chart, that particular named range appears in selection but not the named range which has charts.
Could you please tell me the reason for this ?

[sharadmoktan]

My query is:
If the stock level falls below the minimum level we can do a conditional formatting in excel and show the present stock as red color or set ut to blink.
And in the same way what would be the VBA code to show the same minimum stock level in listbox .

[shankarbheema]

Is it possible to use/share calculation based desktop version of excel spreadsheet over html using xampp server (without internet)

[uLu_MuLu]

Your dashboard would look even better if you would have used the alt-key while arranging (changing size, moving) the slicers, graphics, etc.
This would force excel to fit these items right within the cell-frames... :-)

[AshishKumarDoda]

Hey,
My Question is how we can use excel form as Web App and do the entries by using that excel web app...
Please help out...

[ismaeelkrayyan]

when data change in excel, did this change saved on web dashboard

[aynsouli]

Hi MrExcel,
I liked what you present, but unfortunately doesn't work for me since all my excel works having table query, now the question how to resolve the display of dashboard having its data from table queries?