{"id":1488,"date":"2026-10-17T07:22:35","date_gmt":"2026-10-17T07:22:35","guid":{"rendered":"https:\/\/edvera.ayantheme.com\/demo\/course\/spreadsheets-for-everyday-productivity\/"},"modified":"2026-10-17T07:22:35","modified_gmt":"2026-10-17T07:22:35","slug":"spreadsheets-for-everyday-productivity","status":"publish","type":"edvera_course","link":"https:\/\/edvera.ayantheme.com\/demo\/course\/spreadsheets-for-everyday-productivity\/","title":{"rendered":"Spreadsheets for Everyday Productivity"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Spreadsheets save hours when the data is laid out well, and cost hours when it is not. This course starts with structure, then adds the formulas and summaries that come up in everyday office work.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What you will learn<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>How to lay out a table so formulas and filters keep working<\/li>\n\n<li>Ten formulas: SUM, AVERAGE, COUNTIF, SUMIF, IF, XLOOKUP and more<\/li>\n\n<li>How to turn a long list into a one-page summary<\/li>\n\n<li>How to check your numbers before you send them<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Software<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Every example works in Microsoft Excel, Google Sheets and LibreOffice Calc. Where the menus differ, the lesson shows both.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Build tidy tables, use the ten formulas you will actually need and turn raw lists into summaries you can share, in Excel, Google Sheets or LibreOffice Calc.<\/p>\n","protected":false},"author":64,"featured_media":1489,"menu_order":3,"template":"","edvera_demo_lang":[2],"edvera_course_cat":[114],"class_list":["post-1488","edvera_course","type-edvera_course","status-publish","has-post-thumbnail","hentry","edvera_course_cat-work"],"_links":{"self":[{"href":"https:\/\/edvera.ayantheme.com\/demo\/wp-json\/wp\/v2\/edvera_course\/1488","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/edvera.ayantheme.com\/demo\/wp-json\/wp\/v2\/edvera_course"}],"about":[{"href":"https:\/\/edvera.ayantheme.com\/demo\/wp-json\/wp\/v2\/types\/edvera_course"}],"author":[{"embeddable":true,"href":"https:\/\/edvera.ayantheme.com\/demo\/wp-json\/wp\/v2\/users\/64"}],"version-history":[{"count":0,"href":"https:\/\/edvera.ayantheme.com\/demo\/wp-json\/wp\/v2\/edvera_course\/1488\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/edvera.ayantheme.com\/demo\/wp-json\/wp\/v2\/media\/1489"}],"wp:attachment":[{"href":"https:\/\/edvera.ayantheme.com\/demo\/wp-json\/wp\/v2\/media?parent=1488"}],"wp:term":[{"taxonomy":"edvera_demo_lang","embeddable":true,"href":"https:\/\/edvera.ayantheme.com\/demo\/wp-json\/wp\/v2\/edvera_demo_lang?post=1488"},{"taxonomy":"edvera_course_cat","embeddable":true,"href":"https:\/\/edvera.ayantheme.com\/demo\/wp-json\/wp\/v2\/edvera_course_cat?post=1488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}