BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//AMAZE Technologies - ECPv5.6.0//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:AMAZE Technologies
X-ORIGINAL-URL:http://www.amazetech.com.my
X-WR-CALDESC:Events for AMAZE Technologies
BEGIN:VTIMEZONE
TZID:Asia/Shanghai
BEGIN:STANDARD
TZOFFSETFROM:+0800
TZOFFSETTO:+0800
TZNAME:CST
DTSTART:20140101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Shanghai:20140212T090000
DTEND;TZID=Asia/Shanghai:20140213T170000
DTSTAMP:20260605T190450
CREATED:20140211T225658Z
LAST-MODIFIED:20140211T225658Z
UID:871-1392195600-1392310800@www.amazetech.com.my
SUMMARY:Analyzing and Charting with MS Excel
DESCRIPTION:This course is designed to help the participants :- \n\nTo understand and apply the basic concept of spreadsheet\, graphics and database facility in Microsoft Excel.\nTo explore the intermediate functions of Microsoft Excel program.\n\nAmong the topic that would be discussed are \nDATABASE AND LIST MANAGEMENT \n\nUsing Databases ( Using the Excel database features\, Using database terminology )\nCreating And Editing A Database ( Creating an Excel database\, Working with an Excel database\, Assigning a database list\, Creating an assigned list\, Adding summary formulas to an assigned list )\nSorting Database ( Sorting data within a database\, Adding other sorting criteria )\nUsing Autofilters ( Filtering data\, Filtering data with AutoFilter\, Specifying a conditional filter with AutoFilter\, Using the Top 10 AutoFilter\, Removing all AutoFilters )\nAdvanced Filters ( Using Advanced Filters\, Removing all Advanced Filters )\nWorking With Filtered Data ( Manipulating Filtered Data\, Totalling fields within a filtered database list\, Creating Subtotals\, Remove Subtotals )\nUsing Data Forms ( Using a Data Form\, Adding a new record\, Moving between records\, Finding records\, Editing a record\, Deleting a record\, Closing a Data Form )\n\nCHARTS \n\nChart Wizard ( Using the Chart Wizard\, Selecting the Chart Type\, Specifying the Data Source\, Customising the Chart\, Defining the Chart Location )\nChart Toolbar ( Displaying the Chart toolbar\, Using the Chart toolbar\, Selecting a Chart\, Selecting Chart objects )\nWorking With Charts ( Changing the Chart Type\, Adding data to a Chart\, Removing data from a Chart\, Moving a Chart\, Resizing a Chart\, Deleting a Chart )\nFormatting The Chart ( Formatting the Chart Area\, Formatting the Chart Title\, Formatting the Plot Area\, Formatting the Axis\, Formatting the Axis Title\, Formatting the Legend\, Formatting the Gridlines\, Formatting the Data Series )
URL:http://www.amazetech.com.my/event/analyzing-and-charting-with-ms-excel-2/
LOCATION:Shah Alam\, Block 2\, Worldwide Business Park  Jalan Tinju13/50\, Seksyen 13\, \, Shah Alam\, Selangor\, 40100\, Malaysia
END:VEVENT
END:VCALENDAR