{"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
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"lrn-exam-excel-logo\"\t\t\t\t\t\t\t\t\t\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
\n\t\t\t
\n\t\t\t\t\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

MS Excel (Working with Data - Spreadsheet)<\/h2>\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\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

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\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
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

\"\" Confirmed\u00a0\u00a0 \"\"width=\"20\" 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

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
<\/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>
\"Confirmed<\/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>
\"Confirmed<\/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":"

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":"\nMS Excel (Working with Data - Spreadsheet) - Kenfil Hong Kong Limited<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.kenfil.com\/ms-excel-working-with-data-spreadsheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MS Excel (Working with Data - Spreadsheet) - Kenfil Hong Kong Limited\" \/>\n<meta property=\"og:description\" content=\"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\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.kenfil.com\/ms-excel-working-with-data-spreadsheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Kenfil Hong Kong Limited\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T04:06:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.kenfil.com\/wp-content\/uploads\/elementor\/thumbs\/lrn-exam-excel-logo-qesngggo7ax7qtx80wrbvmsg6bxmg38dxkqv4xee4g.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.kenfil.com\/ms-excel-working-with-data-spreadsheet\/\",\"url\":\"https:\/\/www.kenfil.com\/ms-excel-working-with-data-spreadsheet\/\",\"name\":\"MS Excel (Working with Data - Spreadsheet) - Kenfil Hong Kong Limited\",\"isPartOf\":{\"@id\":\"https:\/\/www.kenfil.com\/#website\"},\"datePublished\":\"2019-06-10T15:36:51+00:00\",\"dateModified\":\"2024-03-22T04:06:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.kenfil.com\/ms-excel-working-with-data-spreadsheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.kenfil.com\/ms-excel-working-with-data-spreadsheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.kenfil.com\/ms-excel-working-with-data-spreadsheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.kenfil.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MS Excel (Working with Data – Spreadsheet)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.kenfil.com\/#website\",\"url\":\"https:\/\/www.kenfil.com\/\",\"name\":\"Kenfil Hong Kong Limited\",\"description\":\"Accelerating The Cloud Transformation\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.kenfil.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MS Excel (Working with Data - Spreadsheet) - Kenfil Hong Kong Limited","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.kenfil.com\/ms-excel-working-with-data-spreadsheet\/","og_locale":"en_US","og_type":"article","og_title":"MS Excel (Working with Data - Spreadsheet) - Kenfil Hong Kong Limited","og_description":"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","og_url":"https:\/\/www.kenfil.com\/ms-excel-working-with-data-spreadsheet\/","og_site_name":"Kenfil Hong Kong Limited","article_modified_time":"2024-03-22T04:06:26+00:00","og_image":[{"url":"https:\/\/www.kenfil.com\/wp-content\/uploads\/elementor\/thumbs\/lrn-exam-excel-logo-qesngggo7ax7qtx80wrbvmsg6bxmg38dxkqv4xee4g.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.kenfil.com\/ms-excel-working-with-data-spreadsheet\/","url":"https:\/\/www.kenfil.com\/ms-excel-working-with-data-spreadsheet\/","name":"MS Excel (Working with Data - Spreadsheet) - Kenfil Hong Kong Limited","isPartOf":{"@id":"https:\/\/www.kenfil.com\/#website"},"datePublished":"2019-06-10T15:36:51+00:00","dateModified":"2024-03-22T04:06:26+00:00","breadcrumb":{"@id":"https:\/\/www.kenfil.com\/ms-excel-working-with-data-spreadsheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.kenfil.com\/ms-excel-working-with-data-spreadsheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.kenfil.com\/ms-excel-working-with-data-spreadsheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.kenfil.com\/"},{"@type":"ListItem","position":2,"name":"MS Excel (Working with Data – Spreadsheet)"}]},{"@type":"WebSite","@id":"https:\/\/www.kenfil.com\/#website","url":"https:\/\/www.kenfil.com\/","name":"Kenfil Hong Kong Limited","description":"Accelerating The Cloud Transformation","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.kenfil.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.kenfil.com\/wp-json\/wp\/v2\/pages\/1552"}],"collection":[{"href":"https:\/\/www.kenfil.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.kenfil.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.kenfil.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kenfil.com\/wp-json\/wp\/v2\/comments?post=1552"}],"version-history":[{"count":40,"href":"https:\/\/www.kenfil.com\/wp-json\/wp\/v2\/pages\/1552\/revisions"}],"predecessor-version":[{"id":36254,"href":"https:\/\/www.kenfil.com\/wp-json\/wp\/v2\/pages\/1552\/revisions\/36254"}],"wp:attachment":[{"href":"https:\/\/www.kenfil.com\/wp-json\/wp\/v2\/media?parent=1552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}