Excel - Excel in Depth 34 - Dynamic SmartArt - Episode 1211.134
6.3 هزار بار بازدید -
14 سال پیش
-
Microsoft Excel Tutorial: Excel in
Microsoft Excel Tutorial: Excel in Depth 34 - Dynamic SmartArt.
Welcome back to the MrExcel netcast! In this episode, we will be diving into the world of SmartArt in Excel. As we all know, Excel is a powerful tool for keeping track of data and information. But did you know that you can also use it to create visually appealing and dynamic SmartArt? That's right, with just a few simple steps, you can turn your boring data into a visually stunning masterpiece.
In this tutorial, I will show you how to use SmartArt to create shapes and add dynamic values to them. We will start by creating a simple formula to track the progress of our tasks. Then, we will insert a SmartArt and convert it into shapes. This will allow us to add dynamic values to the shapes, making them update automatically as we make changes to our data. This is a great way to motivate yourself or communicate important information to others.
But wait, you may be thinking, doesn't SmartArt only work in PowerPoint? Well, that's where the trick comes in. Microsoft has actually added a feature in Excel 2010 (after much complaining from yours truly) that allows you to convert SmartArt into shapes. This means that you can now add formulas to your SmartArt and make it dynamic, just like you would with AutoShapes. It's a game-changer for those of us who love using SmartArt in our Excel workbooks.
So join me as we explore the world of dynamic SmartArt in Excel. I will guide you through the process step by step and show you how to create a visually appealing and functional SmartArt that will impress your colleagues and make your data come to life. Don't forget to check out our sponsor, "MrExcel.com", for all your Excel needs. And as always, thank you for tuning in to the MrExcel netcast. See you in the next episode!
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-...
Table of Contents:
(00:00) Excel In Depth Chapter 34 - SmartArt to Shapes
(00:10) Tracking Progress in Excel
(00:20) Using Formulas to Calculate Progress
(00:35) Inserting SmartArt
(01:02) Formatting SmartArt
(01:56) Converting SmartArt to Shapes
(02:23) Using Formulas in Shapes
(03:14) Updating the Model
(03:56) Dynamic SmartArt with Convert to Shapes
(04:06) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
AutoShapes
Convert SmartArt to Shapes
Dynamic SmartArt
Excel formulas
Excel In Depth
Microsoft
Microsoft Excel
Motivational messages
SmartArt to Shapes
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Excel in Depth 34 - Dynamic SmartArt
Welcome back to the MrExcel netcast! In this episode, we will be diving into the world of SmartArt in Excel. As we all know, Excel is a powerful tool for keeping track of data and information. But did you know that you can also use it to create visually appealing and dynamic SmartArt? That's right, with just a few simple steps, you can turn your boring data into a visually stunning masterpiece.
In this tutorial, I will show you how to use SmartArt to create shapes and add dynamic values to them. We will start by creating a simple formula to track the progress of our tasks. Then, we will insert a SmartArt and convert it into shapes. This will allow us to add dynamic values to the shapes, making them update automatically as we make changes to our data. This is a great way to motivate yourself or communicate important information to others.
But wait, you may be thinking, doesn't SmartArt only work in PowerPoint? Well, that's where the trick comes in. Microsoft has actually added a feature in Excel 2010 (after much complaining from yours truly) that allows you to convert SmartArt into shapes. This means that you can now add formulas to your SmartArt and make it dynamic, just like you would with AutoShapes. It's a game-changer for those of us who love using SmartArt in our Excel workbooks.
So join me as we explore the world of dynamic SmartArt in Excel. I will guide you through the process step by step and show you how to create a visually appealing and functional SmartArt that will impress your colleagues and make your data come to life. Don't forget to check out our sponsor, "MrExcel.com", for all your Excel needs. And as always, thank you for tuning in to the MrExcel netcast. See you in the next episode!
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-...
Table of Contents:
(00:00) Excel In Depth Chapter 34 - SmartArt to Shapes
(00:10) Tracking Progress in Excel
(00:20) Using Formulas to Calculate Progress
(00:35) Inserting SmartArt
(01:02) Formatting SmartArt
(01:56) Converting SmartArt to Shapes
(02:23) Using Formulas in Shapes
(03:14) Updating the Model
(03:56) Dynamic SmartArt with Convert to Shapes
(04:06) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
AutoShapes
Convert SmartArt to Shapes
Dynamic SmartArt
Excel formulas
Excel In Depth
Microsoft
Microsoft Excel
Motivational messages
SmartArt to Shapes
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Excel in Depth 34 - Dynamic SmartArt
14 سال پیش
در تاریخ 1389/04/23 منتشر شده
است.
6,300
بـار بازدید شده