1. Home
  2. Detail

@payalsharmaa0415:

payalsharmaa
payalsharmaa
Open In TikTok:
Region: IN
Tuesday 30 June 2020 02:28:20 GMT
331
30
0
0

Music

Download

No Watermark .mp4 (1.5MB) No Watermark(HD) .mp4 (1.5MB) Watermark .mp4 (0MB) Music .mp3

Comments

There are no more comments for this video.
To see more videos from user @payalsharmaa0415, please go to the Tikwm homepage.

Other Videos

Dốc Lết - Ninh Hoà, vẻ đẹp thiên nhiên bất tận. #chill #viraltiktok #dulichnhatrang #nhatrang #biendep
Dốc Lết - Ninh Hoà, vẻ đẹp thiên nhiên bất tận. #chill #viraltiktok #dulichnhatrang #nhatrang #biendep
Create dynamic progress chart using icons in #Excel #ExcelTips #LearnOnTikTok #Automation #corporate Its key features include: Conditional Formatting Icons: Swap raw numbers for clean visual indicators. Automated Tracking: Live formula using COUNTIF to calculate weekly task progress. Pro-Level Doughnut Chart: Custom 65% hole size for a modern, sleek layout. Neon Gradient Border: Advanced radial gradient outline (Red to Orange) to make the progress bar pop. Transparent Dashboard UI: Clean look with no backgrounds, borders, or chart clutter. Dynamic Center KPI: Connected text box that updates percentages automatically in real-time. The complete process: Phase 1: Setup Conditional Formatting IconsSelect Data: Highlight your task data cells.Open Rules: Go to Home > Conditional Formatting > New Rule.Format Style: Change the Format Style dropdown to Icon Sets.Icon Style: Choose your preferred icon shapes (like checkmarks or circles).Rule Type: Change the Type dropdown for your rules from Percent to Number.Value Threshold: Set the Value to 1 for the top icon condition.Hide Numbers: Check the box that says Show Icon Only.Apply: Click OK and format the icons to align nicely in your cells. Phase 2: Create the Progress FormulasCalculate Progress: In your progress summary cell, enter =COUNTIF(your_task_range, 1)/70 to count completed tasks and divide by your 70 weekly tasks.Format Metric: Select that cell and change the formatting style to Percentage.Calculate Gap: In the adjacent cell below it, enter =1 - your_progress_cell_reference to find the remaining gap percentage. Phase 3: Insert and Format the Doughnut ChartInsert Chart: Select both your progress and gap percentage values, then go to Insert > Doughnut Chart.Clean Layout: Click the chart elements and delete the Chart Title and Legend.Adjust Size: Right-click the chart ring, choose Format Data Series, and change the Doughnut Hole Size to 65%.Color Gap: Click specifically on the gap slice and change its solid fill color to Light Grey.Color Progress: Click specifically on the progress slice and change its solid fill color to Black. Phase 4: Apply the Neon Gradient BorderActivate Border: Select the progress series ring slice, look under the formatting pane, and choose Gradient Line.Clean Stops: Remove the middle gradient stops so only two outer stops remain.Left Stop: Apply a vibrant Red color to the leftmost gradient stop.Right Stop: Apply a bright Orange color to the rightmost gradient stop.Gradient Type: Change the Type dropdown setting to Radial.Line Weight: Increase the border width property to exactly 10pt. Phase 5: Build the Center KPI InterfaceTransparency: Select the outer chart container, go to format options, and set Fill to No Fill and Border to No Line.Position Canvas: Resize and move the transparent chart container over your dashboard space.Add Text: Go to Insert > Text Box and draw a box directly in the open center hole of your chart.Clear Styling: Set the text box fill to No Fill and border outline to No Line.Link Data: Click the outer frame of the text box, click inside the Formula Bar at the top of Excel, type =, click your progress percentage cell, and hit Enter.Final Text Polish: Make the text font bold, increase the size, and center align it inside the box.
Create dynamic progress chart using icons in #Excel #ExcelTips #LearnOnTikTok #Automation #corporate Its key features include: Conditional Formatting Icons: Swap raw numbers for clean visual indicators. Automated Tracking: Live formula using COUNTIF to calculate weekly task progress. Pro-Level Doughnut Chart: Custom 65% hole size for a modern, sleek layout. Neon Gradient Border: Advanced radial gradient outline (Red to Orange) to make the progress bar pop. Transparent Dashboard UI: Clean look with no backgrounds, borders, or chart clutter. Dynamic Center KPI: Connected text box that updates percentages automatically in real-time. The complete process: Phase 1: Setup Conditional Formatting IconsSelect Data: Highlight your task data cells.Open Rules: Go to Home > Conditional Formatting > New Rule.Format Style: Change the Format Style dropdown to Icon Sets.Icon Style: Choose your preferred icon shapes (like checkmarks or circles).Rule Type: Change the Type dropdown for your rules from Percent to Number.Value Threshold: Set the Value to 1 for the top icon condition.Hide Numbers: Check the box that says Show Icon Only.Apply: Click OK and format the icons to align nicely in your cells. Phase 2: Create the Progress FormulasCalculate Progress: In your progress summary cell, enter =COUNTIF(your_task_range, 1)/70 to count completed tasks and divide by your 70 weekly tasks.Format Metric: Select that cell and change the formatting style to Percentage.Calculate Gap: In the adjacent cell below it, enter =1 - your_progress_cell_reference to find the remaining gap percentage. Phase 3: Insert and Format the Doughnut ChartInsert Chart: Select both your progress and gap percentage values, then go to Insert > Doughnut Chart.Clean Layout: Click the chart elements and delete the Chart Title and Legend.Adjust Size: Right-click the chart ring, choose Format Data Series, and change the Doughnut Hole Size to 65%.Color Gap: Click specifically on the gap slice and change its solid fill color to Light Grey.Color Progress: Click specifically on the progress slice and change its solid fill color to Black. Phase 4: Apply the Neon Gradient BorderActivate Border: Select the progress series ring slice, look under the formatting pane, and choose Gradient Line.Clean Stops: Remove the middle gradient stops so only two outer stops remain.Left Stop: Apply a vibrant Red color to the leftmost gradient stop.Right Stop: Apply a bright Orange color to the rightmost gradient stop.Gradient Type: Change the Type dropdown setting to Radial.Line Weight: Increase the border width property to exactly 10pt. Phase 5: Build the Center KPI InterfaceTransparency: Select the outer chart container, go to format options, and set Fill to No Fill and Border to No Line.Position Canvas: Resize and move the transparent chart container over your dashboard space.Add Text: Go to Insert > Text Box and draw a box directly in the open center hole of your chart.Clear Styling: Set the text box fill to No Fill and border outline to No Line.Link Data: Click the outer frame of the text box, click inside the Formula Bar at the top of Excel, type =, click your progress percentage cell, and hit Enter.Final Text Polish: Make the text font bold, increase the size, and center align it inside the box.
Khi gặp đúng người, mọi thứ đều trở nên ý nghĩa hơn ❤️ #7years #annyversary
Khi gặp đúng người, mọi thứ đều trở nên ý nghĩa hơn ❤️ #7years #annyversary
புதிய சட்டம்_பழைய காதலன் காதலிக்கு புதிய காதலன் காதலி வழங்கப்படும் பழைய கணவன் மனைவிக்கு புதிய கணவன் மனைவி வழங்கப்படும்.sri Lanka news#lankanews #breakingnews #virulnews #fypシ゚ #foryourpage #tiktokviral #tiktokindia #jaffna #tamilnews #nksiva5
புதிய சட்டம்_பழைய காதலன் காதலிக்கு புதிய காதலன் காதலி வழங்கப்படும் பழைய கணவன் மனைவிக்கு புதிய கணவன் மனைவி வழங்கப்படும்.sri Lanka news#lankanews #breakingnews #virulnews #fypシ゚ #foryourpage #tiktokviral #tiktokindia #jaffna #tamilnews #nksiva5
just for 😁 😂 😀 😁 😂 😀 #funnyvideos #fun
just for 😁 😂 😀 😁 😂 😀 #funnyvideos #fun
Miếng dán trắng răng #tranngan1369 #miengdantrangrang
Miếng dán trắng răng #tranngan1369 #miengdantrangrang

About

Legal