{"id":19926,"date":"2024-02-11T14:37:45","date_gmt":"2024-02-11T14:37:45","guid":{"rendered":"https:\/\/www.o365cloudexperts.com\/blog\/?p=19926"},"modified":"2024-02-11T14:41:06","modified_gmt":"2024-02-11T14:41:06","slug":"microsoft-copilot-excel-for-summarizing-enhancing-visual-content","status":"publish","type":"post","link":"https:\/\/www.o365cloudexperts.com\/blog\/microsoft-copilot-excel-for-summarizing-enhancing-visual-content\/","title":{"rendered":"Copilot for Microsoft 365 Adds Data and Summaries in Excel, Enhancing Visual Content"},"content":{"rendered":"<p>We have an Excel spreadsheet containing information about our company, including gender, age, ethnicity, and quarterly sales. Our goal is to:<\/p>\n<ul>\n<li style=\"margin-bottom: 10px;\">Add Quarterly Sales Figures<\/li>\n<li style=\"margin-bottom: 10px;\">Create a Chart for Revenue Growth<\/li>\n<\/ul>\n<ul>\n<li>\n<h2 style=\"font-size: 24px;\">Adding Quarterly Sales Numbers<\/h2>\n<p>Open the spreadsheet containing company personnel info. Launch Copilot and prompt it with &#8220;Add Quarterly sales.&#8221; Here&#8217;s the summary Copilot generates:<\/p>\n<p>&#8220;The sum of all Quarterly Sales in the table is $3,057,293.&#8221; See the attached screenshot.<br \/>\n<a href=\"https:\/\/www.o365cloudexperts.com\/blog\/wp-content\/uploads\/2024\/02\/Adding-Quarterly-Sales-Numbers-Excel-in-Copilot.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19927\" src=\"https:\/\/www.o365cloudexperts.com\/blog\/wp-content\/uploads\/2024\/02\/Adding-Quarterly-Sales-Numbers-Excel-in-Copilot.png\" alt=\"Adding Quarterly Sales Numbers - Excel in Copilot\" width=\"941\" height=\"529\" srcset=\"https:\/\/www.o365cloudexperts.com\/blog\/wp-content\/uploads\/2024\/02\/Adding-Quarterly-Sales-Numbers-Excel-in-Copilot.png 941w, https:\/\/www.o365cloudexperts.com\/blog\/wp-content\/uploads\/2024\/02\/Adding-Quarterly-Sales-Numbers-Excel-in-Copilot-300x169.png 300w, https:\/\/www.o365cloudexperts.com\/blog\/wp-content\/uploads\/2024\/02\/Adding-Quarterly-Sales-Numbers-Excel-in-Copilot-768x432.png 768w\" sizes=\"auto, (max-width: 941px) 100vw, 941px\" \/><\/a>Besides adding data in Copilot, we can also pose questions, such as requesting Quarterly sales data specific to gender (Male or Female).<\/li>\n<li>\n<h2 style=\"font-size: 24px;\">Enhancing Visual Content<\/h2>\n<p>Instruct <a href=\"https:\/\/www.o365cloudexperts.com\/blog\/microsoft-copilot-ai-in-excel\/\">Copilot in Excel<\/a> to create a chart depicting revenue growth over time. Use the prompt &#8220;To form a chart for the overall spreadsheet.&#8221; Copilot&#8217;s response is:<\/p>\n<p>&#8220;The result is a chart displaying total revenue growth for each department. Is there anything else you would like to know?&#8221; The visual outcome is presented below.<br \/>\n<a href=\"https:\/\/www.o365cloudexperts.com\/blog\/wp-content\/uploads\/2024\/02\/Enhancing-Visuals-Excel-in-Copilot.png.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19929\" src=\"https:\/\/www.o365cloudexperts.com\/blog\/wp-content\/uploads\/2024\/02\/Enhancing-Visuals-Excel-in-Copilot.png.png\" alt=\"Enhancing Visuals- Excel in Copilot.png\" width=\"293\" height=\"200\" \/><\/a><\/p>\n<p>Thus, the revenue graph offers valuable insights into a company&#8217;s financial performance over a specific period. It clearly illustrates revenue trends and variations, facilitating a quick and thorough assessment of the company&#8217;s financial health.<\/li>\n<\/ul>\n<p><style>.headtitle{color: #1a1b1c;font-size: 24px;font-weight: 600;}.ttlbtn a{font-size:18px;padding-top: 10px;padding-bottom: 10px;box-shadow: #ccc 1px 3px 2px;}.banner1{margin-top: 15px;width:15% !important; padding-left:15px !important;}.banner2 {padding-left: 0% !important;padding-right: 0% !important;width:66% !important;padding-left: 0px;padding-top: 4.6%;}.shadow {box-shadow: inset 1px -8px 7px 1px #31313129, 0px 6px 0px #505050, 0px 3px 3px rgba(0,0,0,.4);}.banner4 {margin-top: 4.8%;width:15% !important;padding-left: 0px;}@media only screen and (min-width:99px) and (max-width:767px){.banner1 {width:100% !important;padding-left: 10px;text-align: center;margin-top: 15px;}.banner2 {text-align: center;width:100% !important ;padding-left: 5% !important;padding-right: 5% !important;}.banner4 {margin-top: 8%;width:100% !important;padding-left: 10px;text-align: center;padding-bottom: 10px;}.headtitle{color: #1a1b1c;font-size: 31px;line-height: 40px; font-weight: 600;}}<\/style>\n<div style=\"margin-top:20px;background-image: linear-gradient(to bottom right, #bceef7cf,#f5f5f5ba); min-height: 115px;padding-top: 1%;\">\n<div class=\"col-md-3 banner1\" style=\"float:left;\"><img decoding=\"async\" src=\"https:\/\/www.o365cloudexperts.com\/blog\/wp-content\/uploads\/2024\/02\/microsoft-copilot-by-apps4rent.png\" style=\"height: auto; width:80px;\" alt=\"copilot for microsoft 365\"><\/div>\n<div class=\"col-md-3 banner2\" style=\"color: white;display: inline-block;\"><font class=\"headtitle\">Let AI Boost Your Productivity with Copilot 365<br \/>\n<\/font><\/div>\n<div class=\"col-md-3 banner4\" style=\"display: inline-block;margin-bottom:5%;\">\n<div class=\"ttlbtn\"><a href=\"\/\/billing.apps4rent.com\/cart.php?a=add&amp;pid=1740&amp;promocode=NCE_1stYear\" rel=\"nofollow noopener\" target=\"blank;\">Buy Now<\/a><\/div>\n<\/div>\n<\/div>\n<br \/>\n<a name=\"form\"><\/a><br \/>\n\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f15786-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"15786\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/blog\/wp-json\/wp\/v2\/posts\/19926#wpcf7-f15786-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"15786\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.1.5\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f15786-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_group_fields\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_visible_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_repeaters\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_steps\" value=\"{}\" \/><input type=\"hidden\" name=\"_wpcf7cf_options\" value=\"{&quot;form_id&quot;:15786,&quot;conditions&quot;:[],&quot;settings&quot;:{&quot;animation&quot;:&quot;yes&quot;,&quot;animation_intime&quot;:200,&quot;animation_outtime&quot;:200,&quot;conditions_ui&quot;:&quot;normal&quot;,&quot;notice_dismissed&quot;:false}}\" \/><input type=\"hidden\" name=\"_wpcf7_recaptcha_response\" value=\"\" \/>\n<\/fieldset>\n<style>\ntextarea {\n font: 16px 'Roboto';\n font-weight: normal;\n font-style: normal;\n line-height: 25px;\n color: #2A363F;\n padding: 10px 20px !important;\n font-size: 18px;\n border: 1px solid #e0e0e0 !important;\n width: 99%;\n box-sizing: border-box;\n border-radius: 3px !important;\n}select{font: 16px 'Roboto';font-weight: normal;font-style: normal;line-height: 25px;color: #2A363F;font-size: 18px;border: 1px solid #e0e0e0 !important;width: 98.5% !important;box-sizing: border-box;border-radius: 3px !important;}.inputt{float: left;margin-bottom: 20px;margin-right:20px;padding: 10px; width:30.8% ;}.inputt1{float: left;margin-bottom: 20px;padding: 10px; width:33% ;}.post input[type=\"submit\"]{width: 90px !important;background: orange;border: #9d9fa0 1px solid !important;}.blogf{width:auto;margin-left: 10px;margin-right: 10px;margin-bottom:15px;}.blogf1{width: 31%;margin-left: 10px;margin-bottom:15px;}.blogaf{width: 28.6%;margin-bottom:15px;}.textarea{font-size:13px;}.mail{width:100%;}@media only screen and (min-width:99px) and (max-width:767px){.blogf1{width:100%;margin: 0px;}.inputt{width:100% ;}.inputt1{width:100% ;}.blogf{width:100%;margin: 0px;}.blogaf{width:100%;margin: 0px;}}\n<\/style>\n<div class=\"clearfix divider_line9 lessm artciles-between\">\n<\/div>\n<div style=\"padding: 3%;background-color: #f9f9f9;margin-bottom: 15px;\">\n\t<div>\n\t\t<p style=\"text-align:center;color: #3183d7;font-size: 27px;font-weight: 500;margin-bottom: 40px;\">Submit Your Requirement\n\t\t<\/p>\n\t<\/div>\n\t<p><a name=\"mobform\" class=\"mobform\"><\/a>\n\t<\/p>\n\t<div >\n\t\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"Name\"><input size=\"39\" maxlength=\"60\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required inputt\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Name\" value=\"\" type=\"text\" name=\"Name\" \/><\/span><span class=\"wpcf7-form-control-wrap\" data-name=\"Email\"><input size=\"39\" maxlength=\"60\" class=\"wpcf7-form-control wpcf7-email wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-email inputt\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Email ID\" value=\"\" type=\"email\" name=\"Email\" \/><\/span><span class=\"wpcf7-form-control-wrap\" data-name=\"ContactNumber\"><input size=\"39\" maxlength=\"60\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required inputt1\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Contact Number\" value=\"\" type=\"text\" name=\"ContactNumber\" \/><\/span><br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"mailbox\"><input size=\"35\" maxlength=\"60\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required mail\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Number of Mailboxes*\" value=\"\" type=\"text\" name=\"mailbox\" \/><\/span>\n\t\t<\/p>\n\t\t<div style=\"margin-bottom:15px;\">\n\t\t\t<p><span class=\"wpcf7-form-control-wrap office365\"><select name=\"office365\" class=\"wpcf7-form-control wpcf7-select\" aria-invalid=\"false\" style=\"width: 100% !important;padding: 3px;width: 81.5%; padding: 10px 5px !important;border: solid 1px #e0e0e0;border-radius: 3px;;font-size: 13px;color: #656565;\"><option value=\"Select\">Migrating From?*<\/option><option value=\"Exchange\">Exchange<\/option><option value=\"POP3\/IMAP\">POP3\/IMAP<\/option><option value=\"G Suite\">G Suite<\/option><option value=\"Rackspace\">Rackspace<\/option><option value=\"Office 365\">Office 365<\/option><option value=\"Mozilla Thunderbird\">Mozilla Thunderbird<\/option><option value=\"Lotus Notes\">Lotus Notes<\/option><option value=\"Outlook.com\">Outlook.com<\/option><option value=\"Kerio\">Kerio<\/option><option value=\"GroupWise\">GroupWise<\/option><option value=\"SharePoint\">SharePoint<\/option><option value=\"Others\">Others<\/option><\/select><\/span>\n\t\t\t<\/p>\n\t\t<\/div>\n\t\t<p><span class=\"wpcf7-form-control-wrap your-message\"><textarea name=\"your-message\" cols=\"117\" rows=\"6\" class=\"wpcf7-form-control wpcf7-textarea\" maxlength = \"400\" aria-invalid=\"false\" placeholder=\"Your Message*\" style=\"\nwidth: 100%;font-size:13px;\"><\/textarea><\/span>\n\t\t<\/p>\n\t<span class=\"wpcf7-form-control-wrap recaptcha\" data-name=\"recaptcha\"><span data-sitekey=\"6Lc6Z9IUAAAAAGTl0gnruY5FQ7_3OHWPvUwul-Zo\" class=\"wpcf7-form-control wpcf7-recaptcha g-recaptcha\"><\/span>\r\n<noscript>\r\n\t<div class=\"grecaptcha-noscript\">\r\n\t\t<iframe loading=\"lazy\" src=\"https:\/\/www.google.com\/recaptcha\/api\/fallback?k=6Lc6Z9IUAAAAAGTl0gnruY5FQ7_3OHWPvUwul-Zo\" frameborder=\"0\" scrolling=\"no\" width=\"310\" height=\"430\">\r\n\t\t<\/iframe>\r\n\t\t<textarea name=\"g-recaptcha-response\" rows=\"3\" cols=\"40\" placeholder=\"reCaptcha Response Here\">\r\n\t\t<\/textarea>\r\n\t<\/div>\r\n<\/noscript>\r\n<\/span>\n\t\t<p>&nbsp;<br \/>\n<input class=\"wpcf7-form-control wpcf7-submit has-spinner button-co\" type=\"submit\" value=\"Send\" \/>\n\t\t<\/p>\n\t<\/div>\n<\/div><p style=\"display: none !important;\" class=\"akismet-fields-container\" data-prefix=\"_wpcf7_ak_\"><label>&#916;<textarea name=\"_wpcf7_ak_hp_textarea\" cols=\"45\" rows=\"8\" maxlength=\"100\"><\/textarea><\/label><input type=\"hidden\" id=\"ak_js_1\" name=\"_wpcf7_ak_js\" value=\"157\"\/><script>\ndocument.getElementById( \"ak_js_1\" ).setAttribute( \"value\", ( new Date() ).getTime() );\n<\/script>\n<\/p><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have an Excel spreadsheet containing information about our company, including gender, age, ethnicity, and quarterly sales. Our goal is to: Add Quarterly Sales Figures Create a Chart for Revenue Growth Adding Quarterly Sales Numbers Open the spreadsheet containing company personnel info. Launch Copilot and prompt it with &#8220;Add Quarterly sales.&#8221; Here&#8217;s the summary Copilot [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-19926","post","type-post","status-publish","format-standard","hentry","category-sales-and-billing"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/posts\/19926","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/comments?post=19926"}],"version-history":[{"count":4,"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/posts\/19926\/revisions"}],"predecessor-version":[{"id":19933,"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/posts\/19926\/revisions\/19933"}],"wp:attachment":[{"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/media?parent=19926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/categories?post=19926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.o365cloudexperts.com\/blog\/wp-json\/wp\/v2\/tags?post=19926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}