Please be informed that in view of the current COVID-19 situation, we will be changing the format of this course into a Live Webinar. A detailed set of instructions on the Live Webinar will also be sent to you closer to date. Please sign up for a Zoom account (https://zoom.us/) if you currently do not have an account.
Notice
This programme is formerly known as “Advanced Excel Spreadsheet Skills”
Laptop: As this class places strong emphasis on the hands-on experience, you will be working with data for the majority of the time in the class. To optimize the learning experience, it is mandatory for all participants to be equipped with a laptop, pre-installed with either Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version. Kindly note that Mac Excel version has limited Excel functionality. Use of dual monitor is encouraged as you will be using 2 applications concurrently.
Programme Objective
It has been said that the 95/5 rule applies in the Excel spreadsheet world. 95% of the users used only 5% of its power. Most users realized that they could further harness the power of Excel if they could have a better handle of its structure, formulas and functions. This is much complicated by the incomprehensive jargon and procedures.
Nothing is more powerful than having clear and accurate data to make meaningful and useful decisions about your company, business units, product cycles, sales projections and operating requirements in order to forecast your business futures. This programme is directed at the businessperson who needs to use Excel in their everyday job to improve decision-making and productivity.
Programme Outline
- Spreadsheet Concept & Structure
- Effective spreadsheet structure
- Designing input & output areas
- Macro designing & the use of subroutines
- Setting up data test plan Building Basic Formulas
- Understanding formula basics
- Controlling the order of precedence
- Controlling worksheet calculation
- Working with range names & links in formulas Creating Advanced Formulas
- Working with arrays
- Applying data validation rules to cells
- Using dialog box controls on a worksheet Spreadsheet Calculation Techniques
- Working with Excel’s functions
- Building megaformulas with function nesting
- Using Lookup tables & the If functions
- Understanding & using NPV, IRR, SPB, DPB, NFV, MIRR, etc
- Solving circular references Spreadsheet Consolidation & Linking
- Linking data between worksheets
- Working with Consolidate interface
- Interfacing with other applications
- Working with Pivot Tables & Scenarios Charting Techniques & Presentation
- Representing data in charts
- Plotting data interactively
- Controlling graphic objects Auditing & Debugging
- Understanding Error values
- Testing the cell logic
- Auditing a worksheet
To view our full list of Infocomm courses, please click here.Training MethodologyLecture style, with computer hands-on Exercises Closing Date for Registration 1 Week before Programme or Until Full Enrolment
Intended For
Business analysts, financial modellers, accountants, bankers, finance managers, financial analysts, financial controllers, financial advisers and others who wish to add spreadsheet design, spreadsheet security and advanced modelling to their skill sets. It appeals especially to those who need to build skills and confidence in complex spreadsheet systems in the area of finance and business, accounting, banking, and insurance.
Schedule & Fees
Testimonial
Funding
1] NTUC Union Training Assistance Programme (UTAP)
UTAP (Union Training Assistance Programme) is an individual skills upgrading account for NTUC members.
NTUC members enjoy 50% *unfunded course fee support for up to $250 each year when you sign up for courses supported under UTAP. NTUC members aged 40 and above can enjoy higher funding support up to $500 per individual each year, capped at 50% of unfunded course fees, for courses attended between 1 July 2020 to 31 December 2022. *This excludes miscellaneous fees such as GST and registration fee etc.
This course is approved for UTAP support for intakes conducted between 01 April 2021 – 31 March 2022
As UTAP is given on calendar year basis, and calculated based on year of training taken, it cannot be accumulated.
- Maintained paid-up NTUC membership before course, throughout course duration and at the point of claim and;
- Course by training provider must be supported under UTAP and training must commence within the supported period and;
- Unfunded course fee must not be fully sponsored by company or other types of funding
- Unfunded course fee must be S$20.00 and above, and;
- Member must achieve a minimum of 75% attendance for each application and sat for all prescribed examination(s), if any and;
- UTAP application must be made within 6 months after course ends.
To submit for UTAP claims, please visit http://skillsupgrade.ntuc.org.sg/. Terms and conditions apply.
Should you have queries on the funding scheme, you can email to UTAP@e2i.com.sg or call NTUC Membership Hotline at 6213-8008
Programme Facilitator(s)
Please be informed that in view of the current COVID-19 situation, we will be changing the format of this course into a Live Webinar. A detailed set of instructions on the Live Webinar will also be sent to you closer to date. Please sign up for a Zoom account (https://zoom.us/) if you currently do not have an account.
Notice
This programme is formerly known as “Advanced Excel Spreadsheet Skills”
Laptop: As this class places strong emphasis on the hands-on experience, you will be working with data for the majority of the time in the class. To optimize the learning experience, it is mandatory for all participants to be equipped with a laptop, pre-installed with either Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version. Kindly note that Mac Excel version has limited Excel functionality. Use of dual monitor is encouraged as you will be using 2 applications concurrently.
Programme Objective
It has been said that the 95/5 rule applies in the Excel spreadsheet world. 95% of the users used only 5% of its power. Most users realized that they could further harness the power of Excel if they could have a better handle of its structure, formulas and functions. This is much complicated by the incomprehensive jargon and procedures.
Nothing is more powerful than having clear and accurate data to make meaningful and useful decisions about your company, business units, product cycles, sales projections and operating requirements in order to forecast your business futures. This programme is directed at the businessperson who needs to use Excel in their everyday job to improve decision-making and productivity.
Programme Outline
- Spreadsheet Concept & Structure
- Effective spreadsheet structure
- Designing input & output areas
- Macro designing & the use of subroutines
- Setting up data test plan Building Basic Formulas
- Understanding formula basics
- Controlling the order of precedence
- Controlling worksheet calculation
- Working with range names & links in formulas Creating Advanced Formulas
- Working with arrays
- Applying data validation rules to cells
- Using dialog box controls on a worksheet Spreadsheet Calculation Techniques
- Working with Excel’s functions
- Building megaformulas with function nesting
- Using Lookup tables & the If functions
- Understanding & using NPV, IRR, SPB, DPB, NFV, MIRR, etc
- Solving circular references Spreadsheet Consolidation & Linking
- Linking data between worksheets
- Working with Consolidate interface
- Interfacing with other applications
- Working with Pivot Tables & Scenarios Charting Techniques & Presentation
- Representing data in charts
- Plotting data interactively
- Controlling graphic objects Auditing & Debugging
- Understanding Error values
- Testing the cell logic
- Auditing a worksheet
To view our full list of Infocomm courses, please click here.Training MethodologyLecture style, with computer hands-on Exercises Closing Date for Registration 1 Week before Programme or Until Full Enrolment
Intended For
Business analysts, financial modellers, accountants, bankers, finance managers, financial analysts, financial controllers, financial advisers and others who wish to add spreadsheet design, spreadsheet security and advanced modelling to their skill sets. It appeals especially to those who need to build skills and confidence in complex spreadsheet systems in the area of finance and business, accounting, banking, and insurance.
Programme Facilitator(s)
