Date(s) - Infocan | Total 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:Microsoft Excel Formulas and Functions for Accounting & Financial Professionals (ACCA15B01)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 2010COURSE DURATION: 9 Hours (3 sessions – 3 hours per session)Microsoft Excel Advanced Formulas and Functions for Accounting and Financial Professionals (ACCA15B02)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 2010COURSE DURATION: 9 Hours (3 sessions – 3 hours per session)Microsoft Excel Essential Skills with the Smart Method for Intermediate Level (ACCA15B03)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 Workbooks Create and modify hyperlinksOrganise worksheets Preview 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 (ACCA15B04)KEY TOPICSSummarizing Data EffectivelyChart handling mechanismChart componentsSimple chart creationWork with chartsChoose 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 namingPlotting 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 2010SOFTWARE VERSION: Office 2010COURSE DURATION: 6 Hours (2 sessions – 3 hours per session)PowerPivot for Excel 2010 Users (Course Code: ACCA13B05)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 (ACCA15B06)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 2010COURSE DURATION: 18 Hours (6 sessions – 3 hours per session)Financial Budgeting and Analysis with Microsoft Excel (ACCA15B07)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)Effective Use of Microsoft Excel 2013 for Business Analysis (ACCA15B08)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 Position Consolidation 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 Word for Accountants (ACCA15B09)KEY TOPICSManaging document contentInsert External Information (Excel)Make use of Content ControlsReuse content by creating Quick Part Managing Format with Style and EffectCreate styleModify styleApply and clearing styleInspect style of selected textCompare selected text with a styleAdd text effectLayout Document ContentUse paragraph setting to control paginationControl picture layout with wrappingCreating ReferenceAdd Caption to pictures and tablesCreate Table of ContentCreate Table of FigureCreate an Index at the end of document Add Footnote and EndnoteCreate BibliographyUse Cross Reference Link Document and Database with Mail MergeCreate Mail Merge with step by step wizardUse button on Ribbon for Mail MergeMail Merge for creating labels and envelopCollaboration and SharingTrack changes by different usersCompare and Merge documentsIntroduce co-authoringSafely viewing document downloaded with Protected ViewShare on Web or SharePointManaging Document VersionsCreate a New Version of a DocumentCompare Document VersionsMerge Document VersionsSecuring a DocumentUpdate a Document's PropertiesHide TextRemove Personal Information from a DocumentSet Formatting and Editing RestrictionsAdd a Digital Signature to a DocumentSet a Password for a DocumentRestrict Document AccessPREREQUISITE: General knowledge of Windows and Word.SOFTWARE VERSION: Office 2010COURSE DURATION: 12 Hours (4 sessions – 3 hours per session)Microsoft Power BI - Transforms your Company's Data into Rich Visuals (ACCA15B10) [New Course]KEY TOPICSOverview Of Microsoft Power BI Introduction to DatabaseBenefits Of Power BISelf-Service BI In ExcelPower QueryPower PivotPower ViewPower MapOnline Portal And Report ToolPower BI PortalGet Started With Self-Service BI In ExcelDownload, Install And Configure Excel Com Add-InsData Acquisition With Power QueryPower Query Data SourcesTransform Data with Power QueryLoad Data to Worksheet or Data ModelRefresh QueriesData Modeling With Power PivotExplore and Understand the Data in PowerPivotDAX FundamentsCreate Custom Calculation Create a Time TableIntroduction to relationshipsData Visualization With PivotTable and Power ViewPivotTable Report and Power View Dashboard OverviewAggregating and Comparing over time OverviewConvert Pivot Table to formulasPREREQUISITE: General knowledge of Windows and Excel.SOFTWARE VERSION: Excel 2013COURSE DURATION: 6 Hours (2 sessions – 3 hours per session)Microsoft PowerPoint - Expert (ACCA15B11) [New Course]KEY TOPICSIncorporate Data From Existing FilesImport Outline From WordInsert Embedded Or Linked DocumentsManipulate PictureInsert PicturesCrop ImagesFormat ImagesRemove The BackgroundCompress PicturesInsert ScreenshotAdd And Format Clip ArtInsert A Clip ArtFind Clips At Office OnlineModify Clip ArtWork With ShapesInsert A ShapeChange A ShapeFormat A ShapeArrange Multiple ShapesGroup And Ungroup ShapesManipulate SmartArtInsert A SmartArt DiagramsAdd Text To A SmartArt DiagramAdd A ShapeModify The SmartArt DiagramConvert Selected Text To SmartArt DiagramConvert Selected SmartArt Diagram To A Bulleted ListWork With WordArtCreate WordArt TextAdd Special Effects To WordArt TextChange The Shape Of Selected WordArt TextRemove WordArt Styling From Selected TextEstablish PowerPoint For PresentationRehearse And Record Slide TimingsCreate Hyperlink To A Specific SlideSet Up Slide ShowCollaboration And Share PresentationManage CommentsCompress Media Before SharePackage For CDProtect PresentationsRemove Extraneous InformationAssign PasswordsMark As FinalBroadcast Slide ShowsPREREQUISITE: General knowledge of Windows and PowerPoint.SOFTWARE VERSION: Office 2010COURSE DURATION: 6 Hours (2 sessions – 3 hours per session)ACCA IT Training Course Schedule (Jul to Aug 2015)CourseCourse CodeDate(s)TimeFee (HK$) 1CPD UnitsMicrosoft Excel Formulas and Functions for Accounting and Financial ProfessionalsACCA15B0110, 12, 14 Aug18.30 - 21.30950 (M)/1,100 (AE)/1,500 (N)9Microsoft Excel Advanced Formulas and Functions for Accounting and Financial ProfessionalsACCA15B0224, 26, 28 Aug18.30 - 21.301,200 (M)/1,500 (AE)/2,000 (N)9Microsoft Excel Essential Skills with the Smart Method for Intermediate LevelACCA15B0310, 12, 14 Aug18.30 - 21.30950 (M)/1,100 (AE)/1,500 (N)9Presenting Business Data using Microsoft ExcelACCA15B0415 Aug09.30 - 16.30850 (M)/1,000 (AE)/1,400 (N)6PowerPivot for Excel 2010 UsersACCA15B0522 Aug09.30 - 16.30950 (M)/1,100 (AE)/1,500 (N)6Developing Business Applications using Microsoft Excel Macros and VBAACCA15B061, 8, 15 Aug09.30 - 16.302,000 (M)/2,300 (AE)/2,800 (N)18Financial Budgeting and Analysis with Microsoft ExcelACCA15B078, 15 Aug09.30 - 16.303,250 (M)/3,550 (AE)/3,850 (N)12Effective use of Microsoft Excel 2013 for Business AnalysisACCA15B0829 Aug09.30 - 16.30850 (M)/1,000 (AE)/1,400 (N)6Microsoft Word for AccountantsACCA15B091, 8 Aug09.30 - 16.301,600 (M)/1,900 (AE)/$2,400 (N)12Microsoft Power BI - Transforms your Company's Data into Rich Visuals [New Course]ACCA15B1029 Aug09.30 - 16.301,200 (M)/1,500 (AE)/2,000 (N)6Microsoft PowerPoint - Expert [New Course]ACCA15B1131 Jul, 4 Aug18.30 - 21.30950 (M)/1,100 (AE)/1,500 (N)6Venue:INFOCAN 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 July 2015*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 Oct to Nov 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