{"id":18701,"date":"2025-08-11T16:03:28","date_gmt":"2025-08-11T13:03:28","guid":{"rendered":"https:\/\/trainrisetrainingcenter.com\/?post_type=courses&#038;p=18701"},"modified":"2025-08-11T13:03:28","modified_gmt":"2025-08-11T13:03:28","slug":"microsoft-excel-mos-excel-associate-expert","status":"publish","type":"courses","link":"https:\/\/trainrisetrainingcenter.com\/en\/courses\/microsoft-excel-mos-excel-associate-expert\/","title":{"rendered":"Microsoft Excel (MOS Excel Associate \/ Expert)"},"content":{"rendered":"<p>Objective: To master organizing and analyzing data and creating graphs.<\/p>\n<p><strong>Excel Basics:<\/strong><br \/>Create, open, and save workbooks.<br \/>User interface (cells, sheets, ribbon).<br \/>Data entry (text, numbers, dates).<br \/><strong>Manage cells and sheets:<\/strong><br \/>Copy, cut, and paste data (with special paste options).<br \/>Format cells (numbers, dates, currency).<br \/>Manage sheets (add, delete, rename).<\/p>\n<p><strong>Basic Formulas and Functions:<\/strong><br \/>Creating simple formulas (addition, subtraction, multiplication, division).<br \/>Using common functions (SUM, AVERAGE, MIN, MAX, COUNT).<br \/>Relative, absolute, and mixed references.<br \/><strong>Data Analysis:<\/strong><br \/>Sort and Filter.<br \/>Conditional Formatting.<br \/>Data Validation.<\/p>\n<p><strong>Charts:<\/strong><br \/>Create different types of charts (bar, pie, line).<br \/>Format and customize charts.<br \/>Advanced features (Expert level):<br \/>Logical functions (IF, AND, OR).<br \/>Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP).<br \/>Work with large spreadsheets (PivotTables &amp; PivotCharts).<br \/>Analyze data using What-If Analysis.<br \/>Collaborate on and protect workbooks.<br \/>Create simple macros using the Recorder.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Objective: To master organizing and analyzing data and creating graphs. Excel Basics:Create, open, and save workbooks.User interface (cells, sheets, ribbon).Data entry (text, numbers, dates).Manage cells and sheets:Copy, cut, and paste data (with special paste options).Format cells (numbers, dates, currency).Manage sheets (add, delete, rename). Basic Formulas and Functions:Creating simple formulas (addition, subtraction, multiplication, division).Using common functions&#8230;<\/p>\n","protected":false},"author":1,"featured_media":18713,"template":"","tutor_course_language":[],"course-category":[],"course-tag":[],"class_list":["post-18701","courses","type-courses","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/trainrisetrainingcenter.com\/en\/wp-json\/wp\/v2\/courses\/18701","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trainrisetrainingcenter.com\/en\/wp-json\/wp\/v2\/courses"}],"about":[{"href":"https:\/\/trainrisetrainingcenter.com\/en\/wp-json\/wp\/v2\/types\/courses"}],"author":[{"embeddable":true,"href":"https:\/\/trainrisetrainingcenter.com\/en\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":2,"href":"https:\/\/trainrisetrainingcenter.com\/en\/wp-json\/wp\/v2\/courses\/18701\/revisions"}],"predecessor-version":[{"id":19392,"href":"https:\/\/trainrisetrainingcenter.com\/en\/wp-json\/wp\/v2\/courses\/18701\/revisions\/19392"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trainrisetrainingcenter.com\/en\/wp-json\/wp\/v2\/media\/18713"}],"wp:attachment":[{"href":"https:\/\/trainrisetrainingcenter.com\/en\/wp-json\/wp\/v2\/media?parent=18701"}],"wp:term":[{"taxonomy":"tutor_course_language","embeddable":true,"href":"https:\/\/trainrisetrainingcenter.com\/en\/wp-json\/wp\/v2\/tutor_course_language?post=18701"},{"taxonomy":"course-category","embeddable":true,"href":"https:\/\/trainrisetrainingcenter.com\/en\/wp-json\/wp\/v2\/course-category?post=18701"},{"taxonomy":"course-tag","embeddable":true,"href":"https:\/\/trainrisetrainingcenter.com\/en\/wp-json\/wp\/v2\/course-tag?post=18701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}