BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//WhyExcel - ECPv4.6.23//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:WhyExcel
X-ORIGINAL-URL:http://whyexcel.com
X-WR-CALDESC:Events for WhyExcel
BEGIN:VEVENT
DTSTART;TZID=UTC+8:20160421T090000
DTEND;TZID=UTC+8:20160421T170000
DTSTAMP:20260429T105630
CREATED:20160411T072835Z
LAST-MODIFIED:20160411T073226Z
UID:427-1461229200-1461258000@whyexcel.com
SUMMARY:Intermediate (Intensive) Excel Workshop
DESCRIPTION:Overview\nIn today's fast-paced\, technical business environment world\, numbers meant everything. So it is of utmost importance that we the users\, are able to manage and consume the data - statistics\, planning\, reporting efficiently.  We learn how we are doing and discover our next course of action by studying and interpreting numbers. That explains why we need to master the incredibly powerful tool – Microsoft Excel. \nA solid understanding on Microsoft Excel prepare you in finding improvement via creative ways. With right skills and knowledge\, the time can be shorten and tasks are simplified. Tasks can be automated to lessen manual workload and minimize human errors. \nWith this objective in mind\, the course is designed to equip your with both know-how and find-how knowledge. Know-how is to equip you with firm foundation knowledge in Microsoft Excel. And\, find-how is to instil you with right skills to discover new solutions to new challenges after the training. The topics are delivered with simple examples\, and you are encouraged to explore and experiment alternate solutions in Microsoft Excel. \nPrerequisite\nThe participants are expected to have basic skills in Microsoft Excel\, such as manage multiple windows\, move around data\, enter data\, using basic functions and formulas\, handling file operations\, basic cells formatting\, working with multiple worksheets\, printing\, and set Excel options. \nDuration\n1 Day (usual: 2 days) \nOutline\nFormulas & FunctionsProtect Worksheet DataConsolidate DataFormulas & FunctionsProtect Worksheet DataConsolidate DataCondition and LookupDatabase (Excel Table)Pivot TableConditional FormattingChart\nStrategies to Search for Relevant Functions\nUsing Nested Functions (i.e. combination of multiple functions)\nText Functions\nDate Calculation\nRelative vs. Absolute References\nFunction Library\nInsert Function\nFunction Box\nFunction Argument Tool Tips\nCell References\nFill Handle\nCommon Functions\n\nProtection Tab\nUnlock Cells\nWorksheet Protection\nUnprotect Sheets\nView Worksheets Side By Side\nHide Windows\nWatch Window\n\nConsolidate Data within Same Workbook\nConsolidate Data from Multiple Workbooks\n\nStrategies to Search for Relevant Functions\nUsing Nested Functions (i.e. combination of multiple functions)\nText Functions\nDate Calculation\nRelative vs. Absolute References\nFunction Library\nInsert Function\nFunction Box\nFunction Argument Tool Tips\nCommon Functions\n\nProtection Tab\nUnlock Cells\nWorksheet Protection\nUnprotect Sheets\n\nConsolidate Data within Same Workbook\nConsolidate Data from Multiple Workbooks\n\nUsing IF\, AND\, OR\, NOT\nCOUNTIF vs. COUNTIFS\nSUMIF vs. SUMIFS\nUsing VLOOKUP\nReversed Lookup (MATCH & INDEX)\n\nSorting Database List\nFiltering Database List (Auto Filter)\nTransposing Data from Rows to Columns\nUsing the Text to Columns Feature\nChecking for Duplicates\nShowing & Copying Subtotal Data\nGrouping & Outlining Data\nViewing Grouped and Outlined Data\nUsing Advanced Filters\nUsing Slicers (Excel 2010 onward)\n\nInserting a PivotTable\nChoosing Fields and Grouping Data\nChanging the Data Displayed and Refreshing the PivotTable\nCreating a PivotChart from a PivotTable\nUsing Slicers (Excel 2013 onward)\nDelete PivotTable\n\nHighlight Top 10 Numbers\nUsing Data Bar\nUsing Icons Instead of Numbers\nAdding a Conditional Format\nChanging a Conditional Format\nCreating a Custom Format\nUsing Own Formula\nDelete a Conditional Format\n\nCreating Chart\nModifying a Chart\nMoving Charts to a Chart Sheet\nCombo Chart (e.g.: line chart inside a bar chart)\nAdding and Deleting Sparklines (Excel 2010 onward)\n\n
URL:http://whyexcel.com/event/intermediate-excel-2016-04-21/
LOCATION:Above Ace® Resources\, C-6-3\, Block C\, Viva Home Jalan Loke Yew\,\, Kuala Lumpur\, Kuala Lumpur\, 56100\, Malaysia
ORGANIZER;CN="WhyExcel%20PLT":MAILTO:ask@WhyExcel.com
END:VEVENT
END:VCALENDAR