How to Create an Awesome E-Commerce Dashboard in Google Sheets

Simple Tutorial to create a beautiful dashboard from Google Sheets
#googlesheets #exceldashboard #tasktracker #googlesheetstutorial

~~~~~~~~~~~
��Subscribe to the channel at ��https://bit.ly/3eB8Mmd
��Like, share and comment on the videos.
~~~~~~~~~~~
‘Excel Is Simple’ is an effort to make Excel & Google-Spreadsheets usage simple and teach the toughest concepts in the simplest ways possible. Here you will find Excel tips and tricks, Excel Task trackers, Excel Dashboards and different Excel keyboard shortcuts. We also cover various Excel formulas and functions and explain the real-life useability of each one of them. If you don’t find a relevant video for you, drop a comment on any particular video and we will try our best to make a new video to answer your query.
~~~~~~~~~~~
Check out some of your relevant content here:
�� Excel Task trackers and Dashboards: https://www.youtube.com/watch?v=MArcLLrQS1Q &list=PLRJY-_DDvSgIlLZuhQuwFFA6OPBjNyxvQ

�� Google Sheets Videos: https://www.youtube.com/watch?v=arNiyCysy-I &list=PLRJY-_DDvSgLoScx2PmQM7kK_zDuu4hvS

�� Excel tips and tricks for 2021: https://www.youtube.com/watch?v=soRkWtfhAf4 &list=PLRJY-_DDvSgJQzmJSR2eEv-wEsNMB2iqg

�� Excel Formulas and Functions: https://www.youtube.com/watch?v=njX0GsyO4T8 &list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401

�� How to Excel for Beginners: https://www.youtube.com/watch?v=VB8w1AoMT74 &list=PLRJY-_DDvSgLUOnfRBwVQYZVVzOxaVz76

�� Must Kow Excel Shortcuts: https://www.youtube.com/watch?v=npNdDvTpTNg &list=PLRJY-_DDvSgJyN7vTu2NQnzV0yPzU84IE

�� Time Saving Hacks in Excel: https://www.youtube.com/watch?v=JkO0tf_YjwM &list=PLRJY-_DDvSgKmdbr9DZDZWlOVut-kluNZ

�� VBA Macros: https://www.youtube.com/watch?v=D7jU3WIPBZ0 &list=PLRJY-_DDvSgK0O0V661KTt4t7I-duD3Op

�� Free Excel Templates to Download: https://www.youtube.com/watch?v=e-nylMU8xNg &list=PLRJY-_DDvSgIWTxC6yNkrpw8FvIJ8Cx38
~~~~~~~~~~~
#exceltutorial #exceltutorialforbeginners #exceltraining #excelvba #exceltemplates #exceldashboard #exceltv2020 #excelpayroll #excelapp #excelautoshape #excelautomation #excelamazingfeatures #excelattendance #excelandroid #excelaccounting #excelapplication #excelbill #excelbutton #excelbeginner #excelbhavcopy #excelchart #excelcalendar #excelcost #excelconference #exceldatefunction #exceldatepicker #exceldatarecovery #exceldateformula #exceldataentry #excelfunctions #excelformulaslist #excelforbeginners #excelformulas #excelforhr #excelformulasandfunctions #excelforbegineers #excelformulabasics #excelgstinvoice #excelhash #excelinvoice #excelinvesting #excelinfographics #excelinventory #excelinterviewquestions #exceljobinterview #excellearningseries #excelmacros #excelmining #excelonsmartphone #excelproject #excelpro #excelpivottables #excelpowerquery #excelquiz #excelquotation #excelquickandeasy #excelquestions #excelrevolution #excelsecurity #excelsheet #excelshortcutkeys #excelshorts #excelsior #excelshortcuts #excelshortcutkeysintamil #exceltricks #exceltasktracker #exceltowhatsapp #exceltopdf #excelutility #exceluserform #excelvisulization #excelvisualization #excelvbacode #excelvlookup #excelvbaforbeginners #excelvbatutorial #excelwhatsapp #excel10tutorial #excel2019 #excel2016 #excel2tally #excel4us
~~~~~~~~~~~

In this video, we are going to be looking at Store.link

It’s a one of a kind of product that helps you to create and manage your online store, just by using Google Sheets. You get a dedicated store website by the URL – “YourBusinessName.Store.LInk”, which you can share with your customers.

Features include:

1. Instant store creation from Google Sheets
2. Manage and update products right inside Sheets
3. Add product variants
4. Add payment options like Stripe and Paypal
5. No limit to items you can add to store.

Create your online store today at https://store.link

Here is a demo store �� https://demo.store.link/

╔══════════════╗
TIMESTAMPS
╚══════════════╝
0:00 – Intro
0:06 – The problem
1:00 – What is Store.Link?
03:56 – Start adding products to Google Sheet
06:29 – Configure Store Settings
10:00 – How to add Product Variants
13:07 – How to add links in NavBar
16:26 – How to integrate Payments in Store.link
19:28 – How to translate your Online Store
22:13 – How to add more product images

Song used – https://bit.ly/3dVNSj9

╔══════════════╗
ABOUT US
╚══════════════╝
Our channel is about No Code products. We make tutorials on how to solve day-to-day business problems without writing a single line of code. Many of your business problems can be solved without taking the help of a developer

Check out our channel here:
https://www.youtube.com/c/NoCodeSchool
Don’t forget to subscribe!

╔══════════════╗
OTHER VIDEOS
╚══════════════╝
Create WhatsApp forms – https://youtu.be/0mhTO2wGhOU
Add a StoreLocator to your website – https://youtu.be/y9uvjjoqwBw
Convert Google Form to Chatbot – https://youtu.be/uPtGD8AYlf8

╔══════════════╗
FOLLOW US
╚══════════════╝
Tell us what no-code products you are using and want a tutorial for.
Twitter: https://twitter.com/NocodeSchool

Spreadsheets like Excel and Google Sheets contain a lot of data. But what if you’d like to share those metrics and KPIs in a dashboard? In this video, Scott Friesen shows you how to create real-time dashboards in just minutes with Geckoboard.

Learn more about Geckoboard: https://www.geckoboard.com/

00:00 Problem with sharing spreadsheet data
01:48 Why Geckoboard is a better solution
03:13 Selecting key data to share on the dashboard
04:27 Adding goals to dashboard data
05:56 Moving and customizing widgets on the dashboard
06:58 Adding gauges to your visual dashboard
09:32 Spreadsheets sync with the dashboard
10:44 Connecting other data sources to the dashboard
11:19 Sharing dashboard via email, link or TV

MY FREE GUIDE:
✅ The 2-Do List Method – Build a better task list – https://www.simpletivity.com/free

MY FAVORITE SOFTWARE:
�� CRM for Gmail (NetHunt) – https://bit.ly/nethunt
�� Best book summaries (Shortform) – http://shortform.com/simpletivity
�� Powerful form builder (Jotform) – http://bit.ly/createjotform
�� Secure backups for Trello (Rewind) – https://rewind.com/scott-friesen

CONNECT WITH ME:
�� Sign up to my weekly email newsletter – https://www.simpletivity.com/free
�� My website – https://www.simpletivity.com
�� Facebook: https://www.facebook.com/simpletivity
�� Instagram: https://www.instagram.com/scottdfriesen
�� LinkedIn: https://www.linkedin.com/company/simpletivity
�� Twitter: https://twitter.com/simpletivity

ABOUT ME:
Scott Friesen is a productivity specialist and founder of Simpletivity Training Inc.. He is also a prolific public speaker, workshop leader, and time management coach. Scott helps people to focus more time on what they want to get done and to experience less stress by simplifying their technology.

Simpletivity shares productivity tips, technology apps, time management ideas, and more to help you get more done and enjoy less stress at the same time. If you’re an entrepreneur, business owner, or professional who wants to get more out of your day, make sure to subscribe for helpful training videos (http://www.youtube.com/channel/UCAp3b6zIvS8ct4yci-GwxIg?sub_confirmation=1).

​​Icons made by Freepik from www.flaticon.com
#simpletivity #dashboard #excel

This is an ecommerce dashboard made at google sheet, This provides around 40 types of information. If you want to use this or learn how to make this please contact with us.
Email : [email protected]

Report List:
All these reports can be date filtered by start date and end date. Full reports or information can be customized according to that duration.
In single Box:
1. Number of orders
2. Number of delivered orders.
3. Sales amount.
4. Delivered sales amount.
5. Gross Profit. (Sold products sales amount minus Sold products cost amount)
6. Average order value or basket value
7. Total number of sold products. (sum of Sku)
8. Current stock product quantity
9. Current stock products selling value.
10. Current stock products’ cost value.
11. Re-order needed item quantity. (Items stock quantity below pre-defined reorder value)
12. Stock out item quantity.
13. Unique count of the Number of customers.
14. Customer Life cycle total value
15. Average order per customer.
16. Returned customer % (More than one-time purchase)
17. Average customer life span. (Average duration of customer’s first and last order)
18. Maximum % of customer’s gender count with %
19. Due payment amount from the courier
20. Return pending parcel quantity from the courier
21. Inside Dhaka average delivery days.
22. Outside Dhaka average delivery days
23. Parcel returned from courier value amount.
24. Top cancel reason and %
In table list
1. Month wise sales amount, delivered amount, order qty and growth rate
2. Marketing campaign wise sales amount and order qty with %
3. Area-wise (inside dhk- outside dhk) order and sales amount.
4. Product stock in qty stock In method wise.
5. Product stock out qty stock out method-wise.
6. Top 10 products sold list with order count, sku count, sales amount and stock cost value of these products.
7. Lowest 10 products sold list with order count, sku count, sales amount and stock cost value of these products.
8. Area wise returned order qty and amount.
9. Top 10 returned product list with order qty, sku qty, sales amount and stock cost value.
10. Top 10 cancelled after shipping customer list with order count and value.
11. Top 10 cancelled reason order count and amount.
12. Bkash payment status wise order qty and order.
13. Week wise total and delivered order value line graph.