BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Academy Malaysia - HRD Corp Approved Training Provider - ECPv6.16.5.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://www.excelacademy.my
X-WR-CALDESC:Events for Excel Academy Malaysia - HRD Corp Approved Training Provider
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Asia/Kuala_Lumpur
BEGIN:STANDARD
TZOFFSETFROM:+0800
TZOFFSETTO:+0800
TZNAME:+08
DTSTART:20220101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231213T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231214T170000
DTSTAMP:20231102T080127Z
CREATED:20231102T080127Z
LAST-MODIFIED:20231102T080127Z
UID:10298-1702458000-1702573200@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Intermediate and Advanced Level
DESCRIPTION:In this course\, the participants will be introduced to the more intermediate features of Microsoft Excel. The participant will learn how to generate reports from Excel data. The course also shows the participant how to highlight important data using conditional formats\, prevent date entry errors using Data Validation. At the end of the course\, the participant will be able to demonstrate the ability to manage data efficiently with Microsoft Excel. \nWhat will you learn in this Microsoft Excel Intermediate and Advanced Level?\n• Apply proper formula and function\n• Troubleshooting errors\n• Link and Embed Data from other sources\n• Applying Conditional Formatting and Validation Rules\n• Build upon the essential Microsoft Office Excel knowledge and skills\n• Learn to create advanced workbooks and worksheets\, including\nadvanced formulas\, tables\, and data analyzing tools \nCourse Outline\nDATA MANAGEMENT\n• Sorting\n• Sorting Multiple Columns\n• Finding Data\n• Replacing Data\n• Finding and Replacing Cell Format\n• Practice – Data Management \nWORKING WITH DATABASES \n• Creating Subtotals in a List\n• Removing Subtotals from a List\n• Sorting Data by Multiple Levels\n• Using Custom Sort\n• Using Data Validation\n• Validating Data using a List\n• Creating a Custom Error Message\n• Removing Data Validation \nUSING TEMPLATES\n• Copying Worksheets\n• Hiding Columns and Rows\n• Unhiding Columns and Rows\n• Saving a Workbook as a Template\n• Using a Template\n• Editing a Template\n• Inserting a New Worksheet\n• Hiding/Unhiding a Worksheet\n• Deleting a Template\n• Finding Online Templates \nCREATING CHARTS\n• Inserting a column chart\n• Inserting a line chart\n• Inserting a bar chart\n• Inserting a pie chart\n• Resizing a chart\n• Deleting a chart\n• Adding a Chart Title\n• Changing the Chart Background\n• Changing a column\, bar\, line\, or pie slice colours\n• Changing the chart type\n• Adding a Data Table\n• Changing the Chart Layout\n• Copying and moving charts\n• Creating a 3-D Chart\n• Adjusting 3-D View\n• Inserting Sparklines\n• Practice – Creating Charts \nREVISING CHARTING FEATURES\n• Formatting an Axis\n• Changing the Axis Scaling\n• Formatting the Data Series\n• Adding Data from Different Worksheets\n• Using a Secondary Axis\n• Changing Data Series Chart Types\n• Changing Source Data Range \nWORKING WITH ADVANCED FILTERS \n• Creating a Criteria Range\n• Using a Criteria Range\n• Showing All Records\n• Using an Advanced and Condition\n• Using an Advanced or Condition\n• Copying Filtered Records\n• Using Database Functions \nUSING CONDITIONAL AND CUSTOM FORMATS \n• Applying Conditional Formats\n• Changing a Conditional Format\n• Adding a Conditional Format\n• Creating a Custom Conditional Format\n• Using Data Bars\n• Deleting a Conditional Format\n• Creating a Custom Number Format \nUSING WORKSHEET PROTECTION \n• Unlocking Cells in a Worksheet\n• Protecting a Worksheet\n• Unprotecting a Worksheet\n• Creating Allow-Editing Ranges\n• Deleting Allow-Editing Ranges\n• Protecting Workbook Windows\n• Unprotecting Workbook Windows\n• Assigning a Password\n• Opening a Password-protected File\n• Removing a Password \nUSING AUDITING TOOLS AND RANGE NAMES \n• Jumping to a Named Range\n• Assigning Names\n• Using Range Names in Formulas\n• Creating Range Names from Headings\n• Applying Range Names\n• Deleting Range Names\n• Using Range Names in 3-D Formulas\n• Displaying/Removing Dependent Arrows\n• Displaying/Removing Precedent Arrows\n• Showing Formulas \nEXPORTING AND IMPORTING DATA \n• Importing Data from Text Files\n• Changing External Data Range Properties\n• Removing the Query Definition\n• Creating a Hyperlink\n• Editing a Hyperlink \nUSING ADVANCED FUNCTIONS \n• Using the VLOOKUP Function\n• Using the HLOOKUP Function\n• Using the IF Function\n• Using Nested IF Functions\n• Using the ISERROR Function\n• Using an AND Condition with IF\n• Using an OR Condition with IF\n• Using the ROUND Function\n• Using COUNTIF Function\n• Using RANK Function\n• Using Financial Functions\n• Using Text Functions \nCREATING/REVISING PIVOT TABLES \n• Creating a PivotTable Report\n• Adding PivotTable Report Fields\n• Selecting a Page Field Item\n• Refreshing a PivotTable Report\n• Changing the Summary Function\n• Adding New Fields to a PivotTable Report\n• Moving PivotTable Report Fields\n• Hiding/Unhiding PivotTable Report Items\n• Deleting PivotTable Report Fields\n• Creating a Page Field Report\n• Formatting a PivotTable Report\n• Creating a PivotChart Report\n• Grouping Data Manually \nUSING SCENARIOS\n• Creating a Scenario\n• Displaying a Scenario\n• Editing a Scenario\n• Creating a Scenario Summary Report\n• Working with Data Tables\n• Placing Formulas in Data Tables\n• Creating a One-Variable Table\n• Creating a Two-Variable Table \nTRACKING AND MERGING WORKBOOKS \n• Saving a Shared Workbook\n• Viewing Users Sharing a Workbook\n• Viewing Shared Workbook Changes\n• Changing the Update Frequency\n• Highlighting Changes\n• Managing Conflicting Changes\n• Resolving Conflicting Changes\n• Setting Change History Options\n• Adding a History Worksheet\n• Reviewing Tracked Changes\n• Merging Shared Workbook Files \nRECORDING MACROS \n• Recording a Macro\n• Saving a Macro-Enabled Workbook\n• Running a Macro\n• Assigning a Shortcut Key\n• Using a Shortcut Key\n• Deleting a Macro\n• Adding a Macro to Quick Access Toolbar\n• Deleting a Macro Button from QAT \n 
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-intermediate-and-advanced-level-2/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2023/11/HRDCorpClaimableCourse-Microsoft-Excel-Intermediate-Advanced-Level-DEC.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20231215T090000
DTEND;TZID=Asia/Kuala_Lumpur:20231215T170000
DTSTAMP:20231102T081459Z
CREATED:20231102T081459Z
LAST-MODIFIED:20231102T081459Z
UID:10301-1702630800-1702659600@www.excelacademy.my
SUMMARY:HRD Corp Claimable - Microsoft Excel Basic Level
DESCRIPTION:The course empowers the trainee to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer. He or she will understand and be able to accomplish basic operations associated with developing\, formatting\, and using a spreadsheet. \nWhat will you learn in this Microsoft Excel Basic Level Training?\n• The course empowers the trainee to understand the basic concepts of spreadsheets and to\ndemonstrate the ability to use a spreadsheet application on a personal computer.\n• He or she will understand and be able to accomplish basic operations associated with developing\,\nformatting\, and using a spreadsheet.\n• Additionally\, trainees will be able to accomplish standard mathematical operations using\nbasic formulas and functions.\n• The trainee will be able to demonstrate competence in using some of the features of Excel such\nas filtering\, managing data and creating charts. \nCourse Outline\nOFFICE WORKSPACE BASICS \n• Basic Window Elements\n• Exploring Office Backstage\n• Working with the Ribbon\n• Customizing the Quick Access Toolbar\n• Working with Key Tips\n• Using the Status Bar \nINTRODUCTION TO EXCEL \n• What is Excel?\n• Getting to Know the Excel Window\n• Moving the Cell Selector\n• Opening a Workbook\n• Navigating a Workbook\n• Selecting Cells\n• Creating Workbooks\n• Saving a Workbook\n• Closing a Workbook \nENTERING AND EDITING DATA \n• Entering Text\, Numbers\, and Dates\n• Editing Data\n• Using AutoComplete and AutoFill\n• Copying Data\n• Moving and Clearing Data\n• Using Undo and Redo\n• Finding and Replacing Data \nFORMATTING DATA\n• Introduction to Formatting\n• Applying Number Formats\n• Applying Font Formats\n• Changing Cell Alignment\n• Applying Cell Styles\n• Copying Formats\n• Clearing Formats\n• Finding and Replacing Formats \nFORMATTING WORKSHEETS\n• Inserting and Deleting Rows and Columns\n• Inserting and Deleting Cells\n• Adjusting Column and Row Sizes\n• Hiding Worksheet Components\n• Inserting and Deleting Worksheets\n• Copying and Moving Worksheets\n• Customizing Sheet Tabs\n• Adding a Worksheet Background \nKICK START WITH BASIC FORMULAS AND FUNCTIONS \n• What are Formulas and Functions?\n• Entering Formulas\n• Entering Functions\n• Using the Insert Function Tools\n• Using AutoSum\n• Copying and Moving Formulas \nADDING CHARTS AND GRAPHICS\n• Creating a Chart\n• Enhancing a Chart\n• Modifying Chart\n• Data Changing Chart\n• Types Drawing\n• Shapes Inserting\n• Pictures Creating\n• SmartArt \nVIEWING AND PRINTING WORKBOOKS \n• Changing View Options\n• Splitting and Freezing a Worksheet\n• Sorting and Filtering Data\n• Customizing the Page Layout\n• Adding Headers and Footers\n• Modifying Page Breaks\n• Previewing and Printing the Worksheet
URL:https://www.excelacademy.my/event/hrd-corp-claimable-microsoft-excel-basic-level-3/
LOCATION:Armada Hotel\, Lot 6\, Lorong Utara C\, Section 52\, Petaling Jaya\, Selangor\, 46200\, Malaysia
CATEGORIES:Microsoft Excel
ATTACH;FMTTYPE=image/png:https://www.excelacademy.my/wp/wp-content/uploads/2023/11/HRDCorpClaimableCourse-Microsoft-Excel-Basic-Level-DEC.png
ORGANIZER;CN="Excel Academy":MAILTO:training@excelacademy.my
END:VEVENT
END:VCALENDAR