- 42
- 120 525
Data Design Style
เข้าร่วมเมื่อ 5 ต.ค. 2023
Learn to create compelling and interesting data visualizations, with charts, graphs, shapes, images, maps and more!
Whether you have a message you want to convey, a story to tell, or complex information to explain … Data Design Style can help you hone your skills in presenting data of all kinds. I hope you find these tutorials helpful!
Catherine
Founder, Data Design Style
Website: datadesignstyle.com
Whether you have a message you want to convey, a story to tell, or complex information to explain … Data Design Style can help you hone your skills in presenting data of all kinds. I hope you find these tutorials helpful!
Catherine
Founder, Data Design Style
Website: datadesignstyle.com
How to calculate Percent Change in Excel - Step by Step tutorial
Learn to calculate the percent change of a quantity over time, such as sales from 2023 to 2024, using Microsoft Excel. This video shows you three variations of the same basic formula: first we break down the formula in two steps; then we combine the two steps in the same formula; and finally, we address the possibility of the first value starting at zero and how to avoid displaying the resulting error.
....................................................
PRACTICE FILE - click this link to download the Excel workbook used in the video to the default download directory on your computer:
datadesignstyle.com/wp-content/uploads/2024/12/Practice_PercentChangeFormula_byDataDesignStyle.xlsx
....................................................
TOPICS:
00:00 Introduction
00:11 Percent change formula
01:37 Division by zero error
03:05 Closing remarks
....................................................
Video is made using Filmora.
Website: www.DataDesignStyle.com
#ExcelFormulas #LearnExcel
....................................................
PRACTICE FILE - click this link to download the Excel workbook used in the video to the default download directory on your computer:
datadesignstyle.com/wp-content/uploads/2024/12/Practice_PercentChangeFormula_byDataDesignStyle.xlsx
....................................................
TOPICS:
00:00 Introduction
00:11 Percent change formula
01:37 Division by zero error
03:05 Closing remarks
....................................................
Video is made using Filmora.
Website: www.DataDesignStyle.com
#ExcelFormulas #LearnExcel
มุมมอง: 38
วีดีโอ
Actual vs Target (or Goal) chart in Excel - with individual target lines
มุมมอง 22914 วันที่ผ่านมา
Learn how to create an Actual vs. Target chart in Microsoft Excel. The actual values are displayed as columns. The targets (or goals) are horizontal lines that you can customize to appear wider than the bars. The chart also includes data labels and color coding. This design will help your audience to quickly compare the performance of actual values (such as sales) to targets. I hope this is hel...
Analyze Data to solve a Simple Business Problem Excel Tutorial
มุมมอง 209หลายเดือนก่อน
This Microsoft Excel tutorial demonstrates how to analyze data to help solve a simple business problem. It is divided into three steps: 1) Understand the business problem 2) Analyze the relevant data using pivot tables 3) Present your findings as a summary It is a good example of what it’s like to work as a data analyst in the real world. I hope you find it helpful! ...............................
Dynamically Change ANY Image based on Cell Value in Excel
มุมมอง 6052 หลายเดือนก่อน
This video shows you how to automatically display a different image, based on the value in another cell, using Microsoft Excel. You can do this using any image that you want - a picture, a photograph, an illustration, etc. In our example, we display one image if the value is greater than or equal to zero, and a different image if the value is less than zero. I hope you find it helpful! ...........
How to Convert a Pivot Table to a Regular Spreadsheet in Excel
มุมมอง 8372 หลายเดือนก่อน
This video shows you how to convert a Pivot Table to a regular spreadsheet in Microsoft Excel. This is useful when you want to send someone a report that is not connected to the underlying data source. Or if you just want to use the data yourself without it being in a pivot table. There are two different methods you can use. The first method keeps all of the formatting. The second method lets y...
How to use Filters and Slicers in Pivot Tables - Excel Tutorial
มุมมอง 7122 หลายเดือนก่อน
Learn how to filter data in a pivot table, using Microsoft Excel. We will look at 3 types of filters: (1) field filters, (2) report filters, and (3) slicers. I hope this is helpful! .................................................... Practice File - click this link to download the Excel workbook used in the video (it will download to the default download directory on your computer): datadesign...
How to create Pivot Tables in Excel - for beginners
มุมมอง 3152 หลายเดือนก่อน
This video takes you step by step through the process of creating pivot tables in Microsoft Excel. It explains how to group, summarize, sort, and format data. It also shows how to ensure that any changes to your data source are reflected in the pivot table. I hope this is helpful! .................................................... Practice File - click this link to download the Excel workbook...
Data Bars in Cells turn GREEN at 100% - Excel Tutorial
มุมมอง 5914 หลายเดือนก่อน
In Microsoft Excel, data bars can be assigned only one color. But there is a way to make the bars appear to automatically turn green (or whatever color you want) at 100%. This video explains how to do this, by using two conditional formatting rules. I hope it’s helpful! .................................................... CHAPTERS: 0:00 Introduction 0:19 Insert data bars 0:55 Turn green if 100%...
Top 10 plus All Other Subtotal in Pivot Table - Excel Tutorial
มุมมอง 1.1K4 หลายเดือนก่อน
Learn how to create a Top 10 list - PLUS a consolidated subtotal for “all other categories" - in an Excel pivot table. Our example reports the number of customers by state of residence, and the final table includes the sum, percent of total, and rank. I hope you find this helpful! .................................................... CHAPTERS: 0:00 Introduction 0:22 Create pivot table 0:59 Find ...
How to Create a Combination Chart (Combo Chart) in Excel
มุมมอง 4.3K4 หลายเดือนก่อน
Learn how to create Combination Charts (also called Combo Charts) in Microsoft Excel. We will look at two examples: (1) a simple chart that combines a bar chart and a line chart, plus another version of it that combines an area chart and line chart, and (2) a more complex example that combines a bar with two lines and requires a dual axis. .................................................... CH...
How to Format a Bar Chart in Canva
มุมมอง 8K5 หลายเดือนก่อน
In this video, we learn how to format a bar chart using the design tool Canva. We will look at the formatting options available on the Data panel, the Settings panel, and the Edit Toolbar. Topics include how to formta numbers on the chart as currency, and how to display years (data type number) on the chart as categories (data type text). I hope this is helpful! ...................................
How to Track Progress with a Gradient Color Scale in Excel - using Conditional Formatting
มุมมอง 1.4K5 หลายเดือนก่อน
In this Microsoft Excel tutorial, we create a data visualization to track which steps in a process are complete, using a gradient color scale from light yellow to dark green. Instead of creating a chart, we use the conditional formatting feature to add color highlighting directly in the cells. I hope this is helpful! .................................................... CHAPTERS: 0:00 Introducti...
Automatically change Bar Chart COLORS based on a condition - Excel tutorial
มุมมอง 2.2K6 หลายเดือนก่อน
In this Microsoft Excel tutorial, we create a bar chart that is dynamic: the colors of the bars change automatically based on a benchmark value. In the first half of the video we prepare the data using formulas. In the second half we create and format the chart. There is a bonus tip at the end where we add the benchmark line to the chart. .................................................... CHA...
How to show Actual and Forecast on a Single Line Chart in Excel
มุมมอง 6K6 หลายเดือนก่อน
If you have a dataset with actual values and forecasted (or projected) values, this video will show you how to display them together on the same line chart, using Microsoft Excel. There are different methods you could use, this video uses the strategy of (1) putting the Actual and Forecast numbers in two different columns, (2) creating a line chart, and then (3) using a work-around to connect t...
How to Create a Layered Pie Chart (Sunburst Chart) in Excel
มุมมอง 1.2K7 หลายเดือนก่อน
Learn to create a pie chart with multiple layers in Microsoft Excel. This type of chart is sometimes called a Sunburst Chart, Layered Pie Chart, or Nested Pie Chart. This design is great for data that can be grouped into broad categories, or data that has a natural hierarchy. .................................................... CHAPTERS: 0:00 Introduction 0:41 Prepare the Data 2:10 Format the C...
How to Add an Average Line and Shading to an Excel Chart
มุมมอง 3.8K8 หลายเดือนก่อน
How to Add an Average Line and Shading to an Excel Chart
Create Sparklines in Excel Step by Step Tutorial
มุมมอง 4009 หลายเดือนก่อน
Create Sparklines in Excel Step by Step Tutorial
How to Format a Basic Chart in Excel - Step by Step Tutorial
มุมมอง 5K9 หลายเดือนก่อน
How to Format a Basic Chart in Excel - Step by Step Tutorial
Visualizing Data - A Guide for Designing Bar, Line, and Pie Charts
มุมมอง 35210 หลายเดือนก่อน
Visualizing Data - A Guide for Designing Bar, Line, and Pie Charts
Formatting Text in Excel - Titles, Column Headers, Paragraphs (for beginners)
มุมมอง 46510 หลายเดือนก่อน
Formatting Text in Excel - Titles, Column Headers, Paragraphs (for beginners)
How to display Totals above a Stacked Column Chart in Excel
มุมมอง 10K11 หลายเดือนก่อน
How to display Totals above a Stacked Column Chart in Excel
How to display Totals on a Stacked ROW Chart in Excel - 2 Methods
มุมมอง 1.4K11 หลายเดือนก่อน
How to display Totals on a Stacked ROW Chart in Excel - 2 Methods
How to use the Pictogram Chart feature in Canva
มุมมอง 3.2K11 หลายเดือนก่อน
How to use the Pictogram Chart feature in Canva
How to manually make a Pictogram in Canva - step by step
มุมมอง 891ปีที่แล้ว
How to manually make a Pictogram in Canva - step by step
How to make an Infographic using a Donut Chart - Canva tutorial
มุมมอง 2.2Kปีที่แล้ว
How to make an Infographic using a Donut Chart - Canva tutorial
How to make a Staircase Infographic for a Step-by-Step Process
มุมมอง 301ปีที่แล้ว
How to make a Staircase Infographic for a Step-by-Step Process
Infographic Do's and Don'ts - page layout, graphics, colors
มุมมอง 125ปีที่แล้ว
Infographic Do's and Don'ts - page layout, graphics, colors
How to Create an Infographic with a Radial Design in Canva
มุมมอง 236ปีที่แล้ว
How to Create an Infographic with a Radial Design in Canva
Thank you! Was trying to format to dollars, and you made it easy.
That's great to hear! Thank you - Catherine
Thank you so much!
You're welcome! I am glad it was helpful - Catherine
❤ Nice
Thank you! - Catherine
thanks a lot!
I am glad this was helpful! - Catherine
Thanks a lot 😊, will use this graph for upcoming PPT😎
Great! Good luck with your PPT presentation! - Catherine
thank you!! super helpful :)
Great! I am glad it was helpful. - Catherine
Excellent. Thanks for this great lesson.
I am glad it was helpful! - Catherine
Very insightful and easy to follow! Thank you!
That's great to hear - thank you! - Catherine
Hi everyone, please let me know if you would like to see more videos like this about analyzing data in Excel, or if you have any suggestions for other types of videos about working with data. Thanks! 🙂Catherine
thank you. that was wonderful and saved my bacon.
LOL! Great, I am glad it was helpful! - Catherine
Thank you so much! You just saved my life. :)
I am glad this was helpful! 🙂 - Catherine
Thank you for more insights. Please, is it possible to format legends from top to bottom?
Thanks for your comment! I cannot find a way to display the legend vertically, listed from top to bottom. You could create the legend manually with boxes and text, but that is not an ideal solution. I will send Canva a suggestion to add this feature. Thanks again - Catherine
good one
Thanks! - Catherine
amazing, thank you
Thank you so much! - Catherine
crazy how fucked up excel charts are
I will admit, charts can sometimes be challenging. But overall I really enjoy working with Excel. Thanks for watching the video and taking time to comment! - Catherine
This is incredibly helpful, thank you!! I love your calm and clear style of teaching!
That's great to hear. Thank you! - Catherine
hi! thanks for your videos. Do you possibly know if I can put textures on the bars? I need to make them colorblind friendly (not only with colors)
Hi. This is a good question. I can not find a way to add texture (or patterns) to the bars on a chart in Canva, only solid colors. Your best choice is probably to create the chart in another app, like Excel, which allows texture on the bars. Then copy the Excel chart into Canva as an image. Sorry to not have a better answer! - Catherine
Awesome video, i love me a bit of excel and i just came across the splicer option on pivots to create a dashboard of information. Well done!
Thank you! That's great that you are creating a dashboard in Excel. - Catherine
If the number pak visitors of Jul and aug are the same, how should we edit it?
If I understand your question, how would the chart look if the number of park visitors in July and August are the same, meaning the Aviary opening (or closing) in August did NOT change the number of visitors? In this case, you could circle the data points for both July and August to emphasize this. In the first example, make the title for the New aviary something like “New Aviary Fails to Attract More Visitors” …. and for the second example, make the title for the Closed aviary “Aviary Closed but Park Still Popular”. Please let me know if this doesn’t answer your question. Thanks! - Catherine
thank's a lot
I'm glad this was helpful! - Catherine
U r Awesome Thanks
Thank you for your very nice comment! - Catherine
Thank you!
I'm glad it was helpful! - Catherine
Wow, yes, this is super helpful. Thanks!
I am so glad to hear that. Thank you! - Catherine
Nice❤
Thank you for your kind comment! 🙂- Catherine
❤nice
Thank you! - Catherine
There's no need to show percentage complete and data bars separately! Looks rookie and a bit unprofessional like me
LOL. If you mean showing the percentage complete and data bars in two separate columns, I included that option at the end of the video just in case it is needed. It probably doesn’t make sense when the value is percentage complete, but you never know when a client may request it that way. I do agree with you, it usually makes more sense to show the values in the same cells as the data bars. - Catherine
❤nice
Thank you! - Catherine
❤nice
Thank you for watching the video! - Catherine
Great. Thank you. Expecting more coming.
Thank you! I am trying to produce videos more often, so I appreciate your encouragement! - Catherine
Thank you for sharing the video. It was helpful. 😊
Great! I am really glad it was helpful. - Catherine
Nice❤
Thanks! - Catherine
Nice❤🌻
Thank you for your kind comment! - Catherine
Thanks a lot 👍
I'm glad it was helpful! - Catherine
Can we animate this chart like the circular type?
For some reason, the Progress Ring (example 3 in the video) does not come with built-in animation like the Donut Chart. You could add the "wipe" animation setting, but it's not as cool as the Donut where it looks like a circle is drawn on the screen. I hope this answers your question, if I misunderstood, please let me know. Thanks! - Catherine
If you want to download the Excel workbook used in this video, there is a link to the Practice File in the description above. This way, you can create the chart along with the video, or practice later on your own. I hope it’s helpful. - Catherine
Thank you! Got stuck and thanks to your tutorial i started from scratch and completed it.
Great! I'm glad it helped. - Catherine
how to show decimal numbers?
hi @AmlanMannagcad09103 to show numbers with decimals, I think you have to make sure the data you paste in for the chart already displays decimals to the precision you want. From there, you can set the number of decimals that show on the chart by using this method: Select the chart, and click on the Data tab on the left hand panel. In the data table, at the top of each column is a column heading that says “123” or “ABC” - click on the heading for the column you want to format, click on the 3 dots for “More” and then you'll see a dropdown menu where you can choose “123 Format”. A popup window will appear that allows you to specify the number of decimals, along with other settings. If you want to see this explained in a video, I recently posted one called How to Format a Bar Chart in Canva (the link is in the description above, and here th-cam.com/video/pLj615VUg-E/w-d-xo.html ). It covers number formats including decimals starting at 1:26. I hope this helps! - Catherine
❤ very nice
Thank you! - Catherine
❤nice
Thanks! - Catherine
❤nice
Thank you! - Catherine
Super helpful ! thanks!
That's great to hear. Thanks! - Catherine
brilliant, this is so different
Thank you for your kind comment! - Catherine
Great class teacher.
Thank you so much! - Catherine
I like the design and the idea as well, thanks! But, just one important issue -> typing the numbers into the table area to trigger COFO-> NO WAY! - it's just not the real-life case. I highly recommend to use an ID column as first column with a validation list to choose the ID quickly, and based on this column a dynamic formula can set the numbers automatically - I think, that's the a more advanced approach that I'd ask from my employee. -------------------------------------------------------------------------- so for example as a staging table: Process ID Process Step JD Job Description BR Budget Requested BA Budget Approved JA Job Advertised IS Interviews Scheduled IC Interviews Completed JO Job Offered CH Candidate Hired -------------------------------------------------------------------------- And an example formula to make the table area dynamic: > HiringStatusStaging=LAMBDA([statusid], LET(id, IF(ISOMITTED(statusid), "", statusid), seq, IFS( id = "JD", 1, id = "BR", 2, id = "BA", 3, id = "JA", 4, id = "IS", 5, id = "IC", 6, id = "JO", 7, id = "CH", 8, TRUE, ""), status, IFERROR(SEQUENCE(, seq), ""), status)) --------------------------------------------------------------------------
Thank you! And, thanks for sharing your idea - I like it! Your method would make the table easier to update and more dynamic. It's good to share ideas, so we can all help each other. 🙂 - Catherine
You're a kid 😊
Thanks for watching the video! 😊 - Catherine
So helpful Thank you sooooo much
Great! I am so glad it was helpful. - Catherine
amazing! tysm!
I'm so glad this was helpful! Thank you - Catherine
Amazing! I just learned 10 things I didn’t know that Canva offered! Thank you.
I am so glad you liked this video. Thank you! - Catherine
Thank you so much! I really enjoy your videos and look forward to seeing more. Keep up the great work
Thank you for such a nice comment! I really appreciate it. - Catherine
Thank you. I really enjoyed your videos.
That is so nice to hear. Thank you! - Catherine