{"id":1552,"date":"2019-06-10T23:36:51","date_gmt":"2019-06-10T15:36:51","guid":{"rendered":"http:\/\/kenfil.cradle.cloud\/?page_id=1552"},"modified":"2024-03-22T12:06:26","modified_gmt":"2024-03-22T04:06:26","slug":"ms-excel-working-with-data-spreadsheet","status":"publish","type":"page","link":"https:\/\/www.kenfil.com\/ms-excel-working-with-data-spreadsheet\/","title":{"rendered":"MS Excel (Working with Data – Spreadsheet)"},"content":{"rendered":"\t\t
Nowadays, data and information are playing a critical role in the businesses, making sense of these raw or semi-organized data can be tedious and technically obscured for the general users. However, with the advancing in computer power and sophistication of application functions and rich features, users can now go into corporate data repository, to retrieve and extract useful data and perform intended analysis within the ease of few mouse clicks. Programming is no longer an obstacle for users to act upon their needs. We will walk you through the whole process from data retrieval, manipulation to reports output and just-in-time analysis.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t Confirmed\u00a0\u00a0 Early Bird Offer\u00a0\u00a0 Promotion Offer<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t MS Excel (Working with Data – Spreadsheet) Nowadays, data and information are playing a critical role in the businesses, making sense of these raw or semi-organized data can be tedious and technically obscured for the general users. However, with the advancing in computer power and sophistication of application functions and rich features, users can now<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-left-sidebar.php","meta":{"footnotes":""},"acf":[],"yoast_head":"\n<\/th> COURSE CODE<\/th> Course Name<\/th> \nLEVEL<\/th> DAY<\/th> <\/th> EB\/PROMO (HK$)<\/th> STANDARD (HK$)<\/th><\/tr><\/thead> <\/td> EXL16I<\/td> MS Excel 2016 Essentials<\/a><\/u><\/td> I<\/td> 1<\/td> <\/a><\/td> 1,100<\/td> 1,200<\/td><\/tr> <\/td> EXLI<\/td> MS Excel 2019\/2021\/365 Essentials<\/a><\/u><\/td> I<\/td> 1<\/td> <\/a><\/td> 1,100<\/td> 1,200<\/td><\/tr> <\/td> EXL16A<\/td> MS Excel 2016 Power Features<\/a><\/u><\/td> II<\/td> 2<\/td> <\/a><\/td> 2,600<\/td> 2,900<\/td><\/tr> <\/td> EPDMR<\/td> MS Excel 2019\/2021\/365 Excel Proficiency: Data Management and Reporting<\/a><\/u><\/td> II<\/td> 1<\/td> <\/a><\/td> 1,800<\/td> 2,000<\/td><\/tr> <\/td> EPWAAC<\/td> MS Excel 2019\/2021\/365 Excel Proficiency: Work Smart, Analyze Data and Automate Task using\u00a0Cloud\u00a0Features<\/a><\/u><\/td> II<\/td> 1<\/td> <\/a><\/td> 1,800<\/td> 2,000<\/td><\/tr> <\/td> EPSTF<\/td> MS Excel 2019\/2021\/365 Excel Proficiency: Smart Tips and Common Formula Functions<\/a><\/u><\/td> II<\/td> 1<\/td> <\/a><\/td> 1,800<\/td> 2,000<\/td><\/tr> <\/td> EX101<\/td> Excel Data Preparation, Automation and AI Function - Intermediate<\/a><\/u><\/td> II<\/td> 1<\/td> <\/a><\/td> 1,800<\/td> 2,000<\/td><\/tr> <\/td> EX102<\/td> Excel Data Transformation, Consolidation and Automation - Advanced<\/a><\/u><\/td> III<\/td> 1<\/td> <\/a><\/td> 1,800<\/td> 2,000<\/td><\/tr> <\/td> FEXFF<\/td> Explore Practical Functions and Formula - I (MS Excel 2016\/2019\/2021\/365)<\/a><\/u><\/td> II<\/td> 1<\/td> <\/a><\/td> 1,800<\/td> 2,000<\/td><\/tr> <\/td> FEXFF21<\/td> Explore Practical Functions and Formula - II (For Excel 2021\/365 ONLY)<\/a><\/u><\/td> II<\/td> 1<\/td> <\/a><\/td> 1,800<\/td> 2,000<\/td><\/tr> <\/a><\/td> FDMEXPQ<\/td> Multi-tables Data Analysis Using Power Query and Power Pivot (MS Excel 2016\/2019\/2021\/365)<\/a><\/u><\/td> III<\/td> 1<\/td> <\/a><\/td> 1,800<\/td> 2,000<\/td><\/tr> <\/td> EXPP<\/td> Analyzing Mass Volume Data with PowerPivot usinbg MS Excel 2016\/2019\/2021\/365<\/a><\/u><\/td> III<\/td> 1<\/td> <\/a><\/td> 1,800<\/td> 2,000<\/td><\/tr> <\/td> FCFEX<\/td> Working with Complex Formula (MS Excel 2016\/2019\/2021\/365)<\/a><\/u><\/td> III<\/td> 1<\/td> <\/a><\/td> 1,800<\/td> 2,000<\/td><\/tr> <\/td> FCFXG<\/td> Working with Complex Formula - Next Generation (MS Excel 2021\/365)<\/a><\/u><\/td> III<\/td> 1<\/td> <\/a><\/td> 1,800<\/td> 2,000<\/td><\/tr> <\/a><\/td> FDREX<\/td> MS Excel 2016\/2019\/2021\/365 Building Impressive and Dynamic Excel Dashboard<\/a><\/u><\/td> III<\/td> 1<\/td> <\/a><\/td> 1,800<\/td> 2,000<\/td><\/tr> <\/td> FMCEX<\/td> Creating Sophisticated Charts (MS Excel 2016\/2019\/2021\/365)<\/a><\/u><\/td> III<\/td> 1<\/td> <\/a><\/td> 1,800<\/td> 2,000<\/td><\/tr><\/tbody><\/table><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"