{"product_id":"microsoft-excel-workplace-online","title":"Microsoft Excel for Workplace Data Management and Reporting Online (E-learning)","description":"\u003ch2\u003eUse Excel with More Confidence for Everyday Data and Reports\u003c\/h2\u003e\u003cp\u003eThis beginner-level online course gives a step-by-step introduction to Microsoft Excel in the workplace, from navigating spreadsheets and managing data to using formulas, building reports and producing business documents. It focuses on real workplace applications rather than theory alone.\u003c\/p\u003e\u003cp\u003eNo prior Excel knowledge is needed. The course also covers spreadsheet accuracy, version control and GDPR principles for workplace data.\u003c\/p\u003e\u003ch3\u003eWho Is This Course For?\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eBeginners and people with limited Excel experience\u003c\/li\u003e\n\u003cli\u003eAdministration and HR staff\u003c\/li\u003e\n\u003cli\u003eFinance staff\u003c\/li\u003e\n\u003cli\u003eHealthcare, education and retail staff\u003c\/li\u003e\n\u003cli\u003eCustomer service, construction and management roles\u003c\/li\u003e\n\u003cli\u003eAnyone who uses spreadsheets at work\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eDelivery Method\u003c\/h3\u003e\u003cp\u003eOnline e-learning, self-paced, with about 2 hours of video. Study on desktop or mobile, with lifetime access.\u003c\/p\u003e\u003ch3\u003eWhat the Course Covers\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eExcel basics\u003c\/strong\u003e – the Excel interface, workbooks, worksheets, rows, columns and cells\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eManaging data\u003c\/strong\u003e – entering, editing and organising data, sorting and filtering records, and professional formatting\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eFormulas and functions\u003c\/strong\u003e – totals, averages, percentages and counts, including SUM, AVERAGE, COUNTA, IF, SUMIF, COUNTIF, MIN, MAX and TODAY\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eReports and KPIs\u003c\/strong\u003e – building workplace reports and KPI tracking spreadsheets\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eCharts\u003c\/strong\u003e – producing charts and visual reports for management\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAccuracy and file management\u003c\/strong\u003e – validation and auditing, file management and version control\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eGDPR awareness\u003c\/strong\u003e – GDPR principles relevant to workplace spreadsheets and data security\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eLearning Outcomes\u003c\/h3\u003e\u003cp\u003eBy the end of the course, learners will be able to:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eWork efficiently across workbooks and worksheets\u003c\/li\u003e\n\u003cli\u003eStructure, sort and filter business data\u003c\/li\u003e\n\u003cli\u003eApply common formulas to calculate business metrics\u003c\/li\u003e\n\u003cli\u003eCreate charts and reports to support decisions\u003c\/li\u003e\n\u003cli\u003eApply quality control and version control to spreadsheets\u003c\/li\u003e\n\u003cli\u003eFollow GDPR awareness principles when handling workplace data\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eAssessment and Certification\u003c\/h3\u003e\u003cp\u003eThe course includes a final assessment. Learners receive a Certificate of Completion. The course carries 3 CPD points.\u003c\/p\u003e\u003ch2\u003eFAQ\u003c\/h2\u003e\u003ch3\u003eIs this Excel course suitable for beginners?\u003c\/h3\u003e\u003cp\u003eYes. It is designed for beginners and those with limited Excel experience, and needs no prior knowledge.\u003c\/p\u003e\u003ch3\u003eWhich formulas does the course cover?\u003c\/h3\u003e\u003cp\u003eFormulas and functions including SUM, AVERAGE, COUNTA, IF, SUMIF, COUNTIF, MIN, MAX and TODAY.\u003c\/p\u003e\u003ch3\u003eDoes it cover reports and KPIs?\u003c\/h3\u003e\u003cp\u003eYes. It covers building reports, analysing workplace data and creating KPI tracking spreadsheets.\u003c\/p\u003e\u003ch3\u003eDoes the course cover GDPR?\u003c\/h3\u003e\u003cp\u003eYes. It covers GDPR principles relevant to workplace spreadsheets and data security.\u003c\/p\u003e\u003ch3\u003eHow long does the course take?\u003c\/h3\u003e\u003cp\u003eThere is about 2 hours of video, and you can study at your own pace on desktop or mobile.\u003c\/p\u003e\u003ch3\u003eDoes the course carry CPD points?\u003c\/h3\u003e\u003cp\u003eYes. It carries 3 CPD points, and learners receive a Certificate of Completion.\u003c\/p\u003e\u003ch2\u003eRelated Content\u003c\/h2\u003e\n\u003cul\u003e\n\u003cli\u003e\u003ca href=\"\/collections\/microsoft-courses\"\u003eMicrosoft courses\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca href=\"\/collections\/it-analytics-courses\"\u003eIT and analytics courses\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca href=\"\/collections\/e-learning\"\u003eE-learning courses\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca href=\"\/collections\/trainifyhub\"\u003eTrainifyHUB courses\u003c\/a\u003e\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TrainifyHUB","offers":[{"title":"Default Title","offer_id":58810258817368,"sku":null,"price":20.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0780\/7126\/7672\/files\/trainifyhub-logo.png?v=1792147910","url":"https:\/\/www.envicourse.com\/products\/microsoft-excel-workplace-online","provider":"envicourse.com","version":"1.0","type":"link"}