SDF Funding, SkillsFuture Credit
NoticeOur Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.You may opt to bring along your laptop if you wish to use Excel 2013.Programme Objective Microsoft Excel 2016 is designed to help you get professional-looking results quickly. The new features let you get away from massive walls of numbers, allow you to draw a clearer pictures of your data, provide you with tools to create reports faster and enable you to make more effective decisions. The course will focus on new features such as Flash Fill, Quick Analysis, Recommended Charts, Recommended PivotTables, Slicer, Timelines, Power Map, Power View and so on. Power View provides users with an easy-to-use reporting tool to create interactive visual reports, whereas Timelines provides an easy way to filter Pivot Tables and Pivot Charts graphically by date or time-oriented options. Quick Analysis tools and Flash Fill provide a quick way to analyze data and to separate text from a column. This 2-days workshop will equip the participants with knowledge and skills to improve their experience in using Microsoft Excel 2016 data analysis and reporting tools.
Introducing Excel 2016 New FeaturesExcel New TemplatesQuick AnalysisRecommended ChartsNew Chart Formatting IconsEnhanced Chart LabelsStatistic and Hierarchy Chart TypesFlash fillRecommended PivotTablesTimeline filter for PivotTableCreate Relationships Between TablesSlicer filter for tablePower View and Power MapCustomizing Excel 2016 Program WindowMicrosoft Excel 2016 ScreenCustomizing Quick Access ToolbarCustomizing the RibbonResetting CustomizationsChanging User InterfaceDisplaying Underlying FormulasUsing Flash Fill to Manage DataTurn Flash Fill OnStart Flash Fill ManuallyFormat NumbersFormat DatesSplit NamesChange Text CasesCombine text from Two or More Cells into One CellSplit AddressesUsing the Quick Analysis ToolsThe Formatting Tab è Highlighting data with Conditional FormattingManaging Conditional Formatting RulesThe Charts Tab è Visualizing data with Recommended ChartsThe Totals Tab è Calculating Totals automaticallyThe Tables Tab è Summarizing data with TablesUsing the Table ToolsThe Sparklines Tab è Creating in-cell mini charts with Sparklines Customizing SparklinesUsing Recommended Charts and New Chart TypesLet Excel Recommend a Good ChartCreating Combo ChartCreating Waterfall ChartCreating Histogram ChartCreating Treemap ChartCreating Sunburst ChartUsing New Charting FeaturesCustomizing Chart using the Design TabFormatting Chart using the Format TabUsing the New Chart IconsUsing Enhance Chart LabelsUsing the New Format Task PaneFormatting Chart Values Axis Formatting Chart Category Axis Formatting LegendFormatting Data LabelsFormatting Data SeriesFormatting Chart AreaUsing Recommended PivotTables ToolLet Excel Recommend a PivotTableCreating PivotTable from Excel DataChanging Report LayoutCreating PivotChartCreating a Combo PivotChartUsing Timeline and Slicer FiltersCreating Excel Table from Source DataUsing Slicer to Filter Excel TableCreating PivotTable from Excel TableInserting Timeline to PivotTableUsing Slicer to Filter PivotTableFormatting Slicer and TimelineConnecting Multiple PivotTables to a SlicerConnecting Multiple PivotTables to a TimelineCreating Relationship Between Two TablesIntroducing Table RelationshipsCreating Excel TablesCreating Relationships Between Two TablesUsing Related Tables to Create a PivotTableCreating PivotChart from PivotTableAdding Slicer and TimelineCreating Power View ReportsIntroducing Power ViewInserting a Power View ReportCreating Table in Power ViewFormatting a Power View ReportRefreshing the Power View ReportUsing Matrix VisualizationUsing Card VisualizationUsing Chart VisualizationIntroducing Map in Power ViewAdding a Map to Power ViewAdding the Map LegendAdding Data Labels to MapChanging the Map LayoutChanging the Map BackgroundUsing the Power MapIntroducing Power MapDownload and Install the Power MapCreating Power MapCustomizing Power MapClosing the Power MapLaunching the Power MapCreating Video with Power MapPre-requisitesPlease take note of the following admission requirements:Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsoryMandatory for video camera to be turned on throughout the courseDisplay your official name (as per NRIC) in Zoom, to facilitate attendance takingTraining Methodology Lecture style, with hands-on exercises Closing Date for Registration1 week before programme or until full enrolment.
Pre-requisites
Please take note of the following admission requirements:
Training Methodology Lecture style, with hands-on exercises Closing Date for Registration1 week before programme or until full enrolment.
This workshop is for all existing Microsoft Excel users who intend to learn the powerful new features in Microsoft Excel 2016.
1] SkillsFuture Credit (SFC)Funding Period: Until 13 Sep 2023Course Reference Number: TGS-2020500778
All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. You may wish to use your SFC to pay for partial/full ISCA course fees.
On 1 Oct 2020, the Government provided a one-off SkillsFuture Credit Top-up of $500 for all eligible Singaporeans aged 25 or above by 31 Dec 2020. Singaporeans aged 40 to 60 by 31 Dec 2020 will also receive an Additional SkillsFuture Credit (Mid-Career Support) of $500 which can be used for courses under: (i) SGUnited Skills Programme, (ii) SGUnited Mid-Career Pathways Programme – Company Training, and (iii) Career Transition Programmes. This additional SFC (Mid-Career Support) is NOT applicable for use on ISCA courses. (For more information on the SFC scheme, please visit http://www.skillsfuture.sg/credit)
If you wish to enrol for the course with SFC Funding, please proceed with the following steps:
Failure to submit claim application and obtain necessary approval before the course start date will result in topping up of the SFC indicated for use. Please note that there will be an administrative fee of $42.80 for any revision of invoice.
2] WDA Training Grant - SDF FundingThis course is approved for SDF funding ($2 per training hour) for Company-sponsored participants only (Eligibility criteria apply).
Funding Period: Until 13 Sep 2023Funded Hours: 14 hoursCourse Reference Number: TGS-2020500778
If you wish to enrol participants with SDF Funding, please proceed with the following steps (For Corporate enrolments only) :
For course run start date before 1 Nov 2020, submit training grant application in SCN until 30 Nov 2020.
For course run start date on or after 1 Nov 2020, Enterprises/employers are NOT required to log into TPGateway/SCN to submit training grant.
Remarks
• Step 2: After receiving email that the programme status is confirmed, please proceed to submit the Training Grant application via SkillsConnect Portal (https://www.skillsconnect.gov.sg/).
Employers of company-sponsored participants must submit training grant via SkillsConnect to obtain training grant for course fees. You may submit the Training Grant application within the period from 30 days before the course start date to 30 days after course start date.
The employee’s enrolment, attendance and assessment recordswill be submitted by ISCA onto TPGateway.
Please note that there will be an administrative fee of $42.80 for any revision of invoice.
Eligibility Criteria:
You are about to leave ISCA eServices Portal and the registration link will be opened in a new tab. Do you wish to continue?
This course has been added successfully
Declaration to be provided by CPE
This Course is Intended for CA Singapore Users..
If you have an account with us, please sign-in first. If you do not have an account with us, create one now for free.
Do you wish to apply for SFC funding? (Singapore Citizenship Only)