@bigexcelenergy: You should be using Excel more like PowerPoint. That might sound a bit weird but it's an absolute game changer for people that work on reports or presentations in Excel.  This whole thing is possible because Excel has layers. We can use pivot tables, charts and text boxes to pull data out of the cell grid and have waaay more flexibility to design your spreadsheets.  Layers: so the first thing to understand is that Excel has layers just like PowerPoint. You can insert shapes, text or images and then move them forward and backwards. When you start stacking those elements together you can make almost anything that you'd make in a slide deck.  Pivot Tables: if we use pivot tables and pivot charts we can process all our data, get the metrics we want, and then use them dynamically. So we can basically add data to our report and our pivot tables and pivot charts will update automatically.  Text boxes: instead of leaving your data in a cell, you can pull it and place it in a text box using the formula bar - I have a ton of tutorials showing how this is done.  #pivottables #microsoftambassador #betterspreadsheets #exceltutorial #exceldashboards

Big Excel Energy
Big Excel Energy
Open In TikTok:
Region: US
Thursday 21 September 2023 18:47:30 GMT
31787
891
23
50

Music

Download

Comments

mk.10815
🫶🏻 :
It’s embarrassing how excited I am to learn this is possible
2023-09-29 01:59:05
6
garyswaggins
gary :
Pls make google sheets videos too my work makes me use google sheets and I hate it☹️
2023-09-29 00:09:21
0
louiebrunno
Louie B. :
I teach a speech class at a community college. Any way you could open this video for download so I can show my class for visual aid lecture?
2023-10-07 00:22:35
0
marissa_bauer_
Marissa :
I work with Google sheets more than excel. Can sheets do the same/simlar designs?
2023-10-01 21:13:11
1
jesscornwall16
Jess Cornwall :
Are these on the same page as the plain non formatted table? Or separate pages?
2023-09-29 04:06:58
0
jenharrislegal
jenharrislegal :
I love the idea of this. Am watching all your videos as I need this in my life! Thank you!
2023-09-30 21:36:14
0
tania.shapter
Tania :
Do you ever have issues with how your dashboards look when sending to a client? I've had issues with overlapping text boxes and other graphics etc.
2023-09-21 21:27:25
0
taylor.pierce
Taylor Pierce :
Can I just buy a template from you?
2023-09-21 19:19:12
1
aymergentlecat
Aymer the (not so) Gentle Cat :
this is on Excel-point
2023-09-22 17:48:00
2
doubledeadghost
doubledeadghost :
This change in mindset really blew my mind. After following your email newsletter I never looked back!!
2023-09-21 19:23:56
1
iangarcia791
Ian Garcia :
why not using Power BI?
2023-09-21 19:42:15
0
rossbudhotmailcom
Cookies :
Where is The cat?
2023-09-21 19:39:03
1
cokie.b4
Cort :
🥰
2023-09-29 03:59:20
0
andre4646
Andre Alvarez :
How did you view all the layers in that 3D way? I see you clicked “Reorder Objects” but I don’t have that button??
2025-07-05 23:19:24
0
To see more videos from user @bigexcelenergy, please go to the Tikwm homepage.

Other Videos


About