Date(s) - Infocan | IT Solutions



To enhance members’ knowledge and skills in contemporary application software, ACCA Hong Kong will be organising a series of IT training courses which will be delivered by experienced tutors of Infocan Training Limited. Details of the courses are as follows:Windows 8 – Perfect Start (ACCA14C01)KEY TOPICSFirst day with Windows 8faster boot uppicture passwordconnected to the cloud with account integrationlogin with Microsoft accountmailSkydriveuse start screen and Windows 8 style appscontrol your apps and multitasking switch or snapget new apps with windows storethe charms: search, share, start, devices, and settingsuse the touch keyboardSearch Informationsearch with start screenlibraryStart Menu and Desktop Customizationcustomize the start menu and desktoppin, snap and shake actionsnotification areaReinvented Tools Provided in Windows 8file explorertask managerWindows defenderWeb Browsingweb browsing in modern UIsmartscreen filterin-private browsingMaintaining Windows 8action centre and automatic maintenancefile historyrefresh and resetEncrypt your Drives with BitLockerBitLocker drive encryptionBitLocker to goExtended Featuresbring Windows with you by Windows to gobuild virtual desktop in Windows 8PREREQUISITE: Basic knowledge of Windows 2000, XP, Vista or Windows 7SOFTWARE VERSION: Windows 8COURSE DURATION: 6 Hours (2 sessions – 3 hours per session)What's New in Office 2013 (ACCA14C02)KEY TOPICSNew Era of Office ApplicationUser interfaceBackstageFile format compatibilityMore choice to get startTouch / mouse modeSign-in to, save and share on the cloudMicrosoft WordNew navigation paneAdd polish and styleMore comfortable reading experiencesCollaborationsPowerful edit optionsMicrosoft ExcelInstant data analysis with quick analysisFill columns of data with flash fillShare your spreadsheet onlineNew file format with higher capacityNew chart featureEnhanced sortingEnhanced filteringMore advanced analysing toolsNew add-ins to empower ExcelMicrosoft PowerPointBetter control when performing presentationHassle-free presenter’s viewWidescreen friendlyMore options to slide designImproved collaborationsMicrosoft OutlookPreview messages in the message listRespond faster with inline repliesUse commands in the message lists for quick actionSneak a peekPeople cardView weather in OutlookPREREQUISITE: General knowledge of Windows and previous experience on Microsoft OfficeSOFTWARE VERSION: Office 2013COURSE DURATION: 6 Hours (2 sessions – 3 hours per session)Microsoft Excel Formulas and Functions for Accounting & Financial Professionals (ACCA14C03)KEY TOPICSDate and Time FunctionsTODAY, NOW, DATE, TIME, YEAR, MONTH, DAY, HOUR, MINUTE, SECONDDatabase FunctionsDAVERAGE, DCOUNT, DCOUNTA, DMAX, DMIN, DPRODUCT, DSUMInformation FunctionsCOUNTBLANK, ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXTLogical FunctionsIF, AND, OR, NOT, TRUE, FALSELookup FunctionsHLOOKUP, VLOOKUP, LOOKUP, MATCHMath and Trigonometry FunctionsABS, COUNTIF, INT, MOD, RAND, PRODUCTSUMIF, SUMPRODUCT, ROUND, ROUNDUP, ROUNDDOWNStatistical FunctionsAVERAGEA, COUNTA, MODE, MEDIANText FunctionsEXACT, LEFT, RIGHT,MID, LEN, SUBSTITUTE, TEXT, VALUE, TRIM, UPPER, LOWER, PROPER, CONCATENATE, DOLLARAccounting FunctionsSLN, DDB, SYD, VDBFinancial Functions and FormulasPMT, IPMT, PPMT, PV, FVIntroduction to financial formulasUses of financial functions and formulasArray FormulasIntroduction to arraysUses of array formulasPREREQUISITE: A working knowledge of using PCs in the Microsoft Windows environment is required, and a familiarity with the Microsoft Excel interface would also be an advantageSOFTWARE VERSION: Office 2007COURSE DURATION: 9 Hours (3 sessions – 3 hours per session)Microsoft Excel Advanced Formulas and Functions for Accounting and Financial Professionals (ACCA14C04)KEY TOPICSReference FunctionsINDIRECT, OFFSET, INDEX, MATCHInformation FunctionsCELL, ISNADatabase Functions Review and MoreDSUM, DAVERAGE, DCOUNT, DCOUNTA, DMAX, DMIN, DGETIncorporate INDIRECT / OFFSET / DGET with other database and logical functionsCreating Framework for Data Manipulation from Multiple SourcesEnhance the usage of advanced filter with formula criteria Prevent inaccurate result by utilising sets of information functionSummarise data by combining use of functionsCombo formula techniqueUse functions to retrieve metadata for collaborationAttractive Dashboard PresentationVisualise performance data by DashboardMeter indicator Arrow indicator Colour bar indicatorMore Complicated Text Extraction with FunctionsFIND, SEARCHCreating an Aging Report with Date FunctionsDATEDIF, NETWORKDAYS, DAYS360Table Referencing Sample on Exchange RateGet data from Internet through Web QueryPREREQUISITE: Attended the “Excel Formulas and Functions for Accounting and Financial Professionals” courseSOFTWARE VERSION: Office 2007COURSE DURATION: 9 Hours (3 sessions – 3 hours per session)Microsoft Excel Essential Skills with the Smart Method for Intermediate Level (ACCA14C05)KEY TOPICSUsing Named Ranges in Financial Statements Add and delete a named rangeUse a named range in a formulaAuditing WorksheetsApply data validation rules and display user promptsWork with the auditing toolbarTrace and fix errorsTrace precedents and dependentsUse the formula error checker and formula evaluatorUse the watch window to view results in cellsDisplay formulas in worksheet cellsFormatting Data and ContentCreate and apply custom data formatsUse conditional formattingFormat and resize graphicsFormat charts and diagramsImporting and Exporting Financial DataImport data to ExcelExport data from ExcelUse Paste Special to import and manipulate dataWorkgroup Collaboration in Accounting EnvironmentsModify passwords, protections, and propertiesCreate a shared workbookTrack, accept and reject changes in financial reportReview a workbook using commentsMerge accounting and financial documentsManaging WorkbooksCreate and modify hyperlinksOrganise worksheetsPreview data in other viewsCustomise Window layout Setup pages for printingPrint dataWorking with Multiple WorkbooksSave different views of a workbookUse a workspace fileLink workbooksWorkbook Templates and Add-InsCreate, edit and apply accounting and financial templatesUse workgroup templatesLoad an Add-in programmeSorting and Filtering DataCreate TablePerform single and multi-level sortsApply a filter to a data listOrganising and Analysing DataUse subtotalsUse ScenariosCreate PivotTable and PivotChart reportsGoal SeekWhat is SolverUsing Macros in ExcelRecord a macroRun a macro from the menu or the keyboardAssign a macro to a toolbar button or a menuImplement macro virus file protectionPREREQUISITE: Experience of creating, formatting and printing worksheets with Microsoft Excel, with knowledge of basic functions such as SUM, AVERAGE, MAX and MINSOFTWARE VERSION: Office 2007COURSE DURATION: 9 Hours (3 sessions – 3 hours per session)Presenting Business Data using Microsoft Excel (ACCA14C06)KEY TOPICSSummarizing Data EffectivelyChart handling mechanismChart componentsSimple chart creationWork with chartsChoosing the Best Chart for Your PresentationUnderstand charting purposeChoose from different chart typesCombine chart typesCreate customized chart templateCapturing Attention to DataCreate data series for chartingAdd, delete, modify chart seriesSeries namingPlot orderDisplay partial data onlySource data from multiple worksheetsHandle missing dataHidden data seriesConvert data seriesMultiple axisCreating Vivid Charts with Charts Object OverviewFills and Borders Background and Titles Series and LegendAxes and GridlinesData Labels and Data TableEye-catching 3-D featuresForecasting with Trend Lines and Error BarsUnderstand trend linesLinear trend linesNon-linear trend linesMove average trend linesShow tolerance on error barTrend lines enhancementShaping Up Your ChartsAuto shapeSmart artsWord artsOther graphic typesDistinctive Showcases of Conditional FormattingKey Performance Indicators (KPIs)Signal on Strength and WeaknessTraffic LightArrowInserting Excel Charts into PowerPointEmbedded chartLinked chartPREREQUISITE: General knowledge of Windows and Excel 2007SOFTWARE VERSION: Office 2007COURSE DURATION: 6 Hours (2 sessions – 3 hours per session)PowerPivot for Excel 2010 Users (Course Code: ACCA13B07)KEY TOPICSCreating and Using DatabasesWhat is a Database? PowerPivot Introduction PowerPivot IntroductionNavigate the PowerPivot windowsPowerPivot Data Sources Supported Data SourcesLoad Data From SQL ServerLoad Data From Text FilesLoad Data via Copy and PasteCleaning data in PowerPivotCreate Relationship between Data SourcesPowerPivot FunctionsPowerPivot ExpressionsCreate a Time TableUse DATE Functions Use TIME INTELLIGENCE Functions Use STATISTICAL Functions Use VALUE Functions Use LOGICAL and INFORMATION Functions Use TEXT Functions Building Reports using PowerPivotPowerPivot ReportsUse PivotChartsUse SlicersUse SparklinesPREREQUISITE: General knowledge of Windows and ExcelSOFTWARE VERSION: Office 2010COURSE DURATION: 6 Hours (2 sessions – 3 hours per session)Developing Business Applications Using Microsoft Excel Macros and VBA (ACCA14C08)KEY TOPICSIntroduction to Excel MacrosWhat is a macro?Record a macroRun a macroRelative referencesAssign a macro to a button on a worksheetAssign a macro to a button on the Quick Access Toolbar Editing Excel MacrosThe Visual Basic editor The project explorer The code windowProcedures Insert comments Print Visual Basic moduleWorking with ObjectsIntroduction to objects and collections Control objects Use the object browserUse objects, properties and methodsThe Range ObjectWhat is the range object?The cells propertyThe range propertyFlexible rangesRange contentsExcel Workbooks and WorksheetsWork with common worksheet tasks / workbook tasksVBA CodesUsage of variables and different data typesUser Interaction, MsgBox and InputBoxConditions such as If…Then…ElseLogical Select Case Looping such as Do LoopStructure of ProceduresCall procedures Organise proceduresControls, Dialogue Boxes and FormsBuilt-in dialogue boxes Custom forms Add form controlsControl and dialogue box events Handle form controlsDebugging and Error TrappingUse debug windowBreak modeInstant watchStepping through code Error handlingPREREQUISITE: A thorough working knowledge of Microsoft Excel is required. No knowledge of Visual Basic is neededSOFTWARE VERSION: Office 2007COURSE DURATION: 18 Hours (6 sessions – 3 hours per session)Financial Budgeting and Analysis with Microsoft Excel (ACCA14C09)KEY TOPICSOverviewBudgetFinancial modelsBuilding Operating BudgetAssumptions and DashboardThe Sales and Collections BudgetThe Cost-of-Goods-Sold BudgetThe Inventory and Purchases BudgetThe Operating Expenses BudgetBudgeted Statement of IncomeEstablishing Financial BudgetThe Capital BudgetThe Cash BudgetBudgeted Balance SheetConsolidating Financial StatementsBalance SheetIncome StatementStatement of Cash FlowCalculating Free Cash FlowFree Cash Flow CalculationFinancial Statements Status Sensitivity Analysis Developing Dashboard in Microsoft ExcelCreating Data Tables in Microsoft ExcelContribution Margin AnalysisFixed and Variable CostsContribution MarginOperating LeverageBreakeven PointIntroducing Mathematical Functions In Microsoft ExcelFinancial Ratio AnalysisProfit MarginsInvestment ReturnsManagement EfficiencyUsing Financial Functions in Microsoft Excel Applying Macro in Microsoft Excel for Financial StatementPREREQUISITE: General knowledge of Windows and ExcelSOFTWARE VERSION: Excel 2007COURSE DURATION: 12 Hours (4 sessions – 3 hours per session)Cloud-based Applications for Business Users (ACCA14C10)KEY TOPICSNew Experience on using Outlook 2013Create an emailForward or reply to an emailAttach a file to a messageCollaborate with Colleagues using SharePoint OnlineSharePoint Online NavigationOrganize and Manage Files and InformationUse document libraries to store and share filesUse lists to store informationManage documents with version controlEnsure consistence with check in/ check out documentsUse and manage alerts to notify changes in SharePointShare and CollaborateUse social feeds to share ideas and informationUse a site mailbox to collaborate with your teamUse OneDrive pro to store and share your own filesEnhance Communication using Lync OnlineContacts and ConversationsManage Lync contactsStart a Lync IM or audio conversationEnterprise Voice Basics Place and receive calls from LyncOnline Meeting BasicsSchedule Lync online meetings in OutlookShare meeting contentOrganize a meetingPresent Like A ProShare presentable meeting contentEffectively manage meeting audio and videoManage meeting participantsUse collaborative toolsRecord and Download Meeting ElementsPREREQUISITE: General knowledge of WindowsSOFTWARE VERSION: Office 365COURSE DURATION: 6 Hours (2 sessions – 3 hours per session)Microsoft OneNote 2010 Core (ACCA14C11) [New Course]KEY TOPICSIntroduction to OneNoteWhat is OneNoteWhy Using OneNoteGetting StartedIntroduce User InterfaceCreate New Notebook, Section, Page and SubpageChange Page Color and LayoutAdding ContentWork with TextUse TablesInsert PicturesAdd Tags to Categorize and Prioritize NotesDraw and Sketch Notes Record Audio or Video NotesAdd File AttachmentAdd HyperlinkIntegrating Other ApplicationsOneNote Integration with Internet ExplorerOneNote Integration with OutlookOneNote Integration with WordOrganizing, Managing and Searching NotesOpen or Create NotebooksCreate, Modify and Delete Pages and SubpagesSelect, Move and Rearrange PagesWork with SectionsSearch InformationCollaboration with Shared NotebookShare NotebooksView Synchronization Status Managing InformationPage VersionsRecycle BinSaving And PrintingSave as PDF or XPSPreview and PrintPrint Documents into OneNoteCopy Text from A File PrintoutPREREQUISITE: General knowledge of Windows and OfficeSOFTWARE VERSION: OneNote 2010COURSE DURATION: 3 Hours (1 session – 3 hours per session)Effective Use of Microsoft Excel 2013 for Business Analysis (ACCA14C12) [New Course]KEY TOPICSPreprocessClean Up Your Data With Text FunctionsLEFT, RIGHT, MIDFIND, LENTRIMUPPER, LOWER, PROPERSUBSTITUTETEXT, VALUEFilteringUse Advanced Filter To Screen Your DataUnderstand Advanced FilterSet Up Criteria TableSet Complicated Criteria For FilteringUse Formula To Help FilteringLookup and ReferenceUse VLOOKUP Formula To Reference DataUnderstand The VLOOKUP FormulaVLOOKUP Reference Table SettingError Handling On VLOOKUPCompensate VLOOKUP With Other Reference FunctionsFix Source Data With Converting Data Between Text And Number Dynamic Data RangeIntroduce TableCreate And Use TableQuick Summary Using Total RowRemove Duplicate In TableNotation In Table When Writing FormulaData ValidationEnsure Data Correctness By ValidationDifferent Type Of Data ValidationCreate A Drop Down List For EntryProvide An Input MessageChange Alert Type For Allowing ExceptionData ConsolidationSummarize Similar Structured DataConsolidation By PositionConsolidation By CategoryPivotTablePivotTable FundamentalsIntroduce PivotTableUnderstand How The PivotTable Summarize DataCreate A Basic PivotTableClean Up Your Data Before Creating PivotTableInsert A PivotTableUnderstand Different Area In A PivotTableAdd Fields Into PivotTableExtract Data For Each Summarized EntryCustomize Fields In A PivotTableChange Summarizing Method On Data FieldChange Number Format Of Data FieldCreate Running Total Or Other RepresentationFormat Your PivotTable ReportChange The Layout Of The PivotTableApply Styles To The PivotTableControl The Way You View Your Pivot DataHide And Show Grand Totals And SubtotalsPerform Sorting And Rearranging Field OrdersApply Filter To Show Interested ItemsApply Slicer To Quickly Selected ItemsCreate New Grouping With Date And Numerical FieldsManual Grouping Fields To Create Meaningful AnalysisUpdate Data In PivotTableModification In Data SourceInsertion Of New DataCreate And Use PivotChartCreate PivotChartFormat The PivotChartFilter With PivotChart Filter PaneMacroRecord Macro For Daily RoutineMacro RecordingRun MacroPREREQUISITE: Basic to intermediate knowledge of Excel.SOFTWARE VERSION: Excel 2013COURSE DURATION: 6 Hours (2 sessions – 3 hours per session)Microsoft Access Introduction for Accounting and Financial Professionals (ACCA14C13)KEY TOPICSCreating and Using Databases for Accounting PurposeDatabase conceptDifferences between spreadsheet and databaseCreate Access databases for maintaining accounting recordsOpen database objects in multiple viewsViewing and Organising InformationEnter, edit and delete recordsFormat datasheets Filter and sort recordsCreating and Modifying TablesCreate tables for storing transactions, customer accounts and assetsSet field properties (default value, required, allow zero length) Add predefined input masks to a fieldCreate lookup fields using lookup wizardDefining RelationshipsUnderstand data relationshipsAssign relationships among tablesEnforce referential integrityCreating and Modifying QueriesCreate and modify select queriesAction queriesPerform calculations in queriesCreating and Modifying FormsCreate and display forms for data entryModify form properties List boxes and combo boxesCreating and Modifying ReportsCreate reportsReport design Report sectionsGroup records Page setup and header/footerAdd calculated controls to reportsPrint reportsIntegrating with other ApplicationsImport data to AccessExport data from AccessPREREQUISITE: General knowledge of WindowsSOFTWARE VERSION: Office 2007COURSE DURATION: 12 Hours (4 sessions – 3 hours per session)ACCA IT Training Course Schedule (Nov to Dec 2014)CourseCourse CodeDate(s)TimeFee (HK$) 1CPD UnitsWindows 8 – Perfect StartACCA14C01-A11, 13 Nov18.30 – 21.30780 (M)/930 (AE)/1,080 (N)6What's New in Office 2013ACCA14C02-A25, 27 Nov18.30 – 21.30780 (M)/930 (AE)/1,080 (N)6Microsoft Excel Formulas and Functions for Accounting and Financial ProfessionalsACCA14C03-K1, 8(am) Nov09.30 – 16.30(09.30 – 12.30)930 (M)/1,080 (AE)/1,440 (N)9Microsoft Excel Advanced Formulas and Functions for Accounting and Financial ProfessionalsACCA14C04-K8(pm), 22 Nov(13.30 – 16.30)09.30 – 16.301,150 (M)/1,300 (AE)/1,680 (N)9Microsoft Excel Essential Skills with the Smart Method for Intermediate LevelACCA14C05-K1, 8(am) Nov09.30 –16.30(09.30 – 12.30)930 (M)/1,080 (AE)/1,440 (N)9Presenting Business Data using Microsoft ExcelACCA14C06-A4, 7 Nov18.30 – 21.30850 (M)/990 (AE)/1,200 (N)6PowerPivot for Excel 2010 UsersACCA14C07-A11, 13 Nov18.30 –21.30930 (M)/1,080 (AE)/1,440 (N)6Developing Business Applications using Microsoft Excel Macros and VBAACCA14C08-K8, 22 Nov, 6 Dec09.30 – 16.301,850 (M)/2,200 (AE)/2,700 (N)18Financial Budgeting and Analysis with Microsoft ExcelACCA14C09-K22 Nov, 6 Dec09.30 –16.303,200 (M)/3,500 (AE)/3,800 (N)12Cloud-based Applications for Business UsersACCA14C10-A4, 7 Nov18.30 –21.30850 (M)/990 (AE)/1,200 (N)6Microsoft OneNote 2010 Core [New Course]ACCA14C11-K8(am) Nov09.30 –12.30400 (M)/500 (AE)/700 (N)3Effective use of Microsoft Excel 2013 for Business Analysis [New Course]ACCA14C12-A18, 20 Nov18.30 –21.30930 (M)/1,080 (AE)/1,440 (N)6Microsoft Access Introduction for Accounting and Financial ProfessionalsACCA14C13-A18, 20, 25, 27 Nov18.30 – 21.301,500 (M)/1,650 (AE)/$1,800 (N)12Venue:Course codes ending in A: INFOCAN Hong Kong Centre, 8/F, Greenwich Centre, 260 King’s Road, Fortress Hill, Hong Kong.Course codes ending in K: INFOCAN Kowloon Centre, 8/F, Yen Sheng Centre, 64 Hoi Yuen Road, Kwun Tong, Kowloon.1 M – Fee for Member/ AffiliateAE – Fee for Staff of Approved EmployerN – Fee for Non-memberLanguage:Cantonese (supplemented with English terminology), unless otherwise specified.Deadline: 22 Oct 2014*Participants will be awarded certificates of attendance/ CPD certificates if their attendance reaches 75% or above.Please note that NO RE-RUN CLASSES will be arranged for this series of IT training courses and reservation is on a FIRST-COME-FIRST-SERVED basis. The next round of the series is tentatively scheduled to be held from Mar to Apr 2015. Please watch out for future member circular for details. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download