Microsoft Excel 2016 – Level 2 AdvancedIT Short Courses
Duration | Two days |
Course Dates | 20 Oct 2022 9:00am - 21 Oct 2022 5:00pm 12 Dec 2022 9:00am - 13 Dec 2022 5:00pm 09 Feb 2023 9:00am - 10 Feb 2023 5:00pm 18 May 2023 9:00am - 19 May 2023 5:00pm 22 Aug 2023 9:00am - 23 Aug 2023 5:00pm 09 Nov 2023 9:00am - 10 Nov 2023 5:00pm |
Course Fee
Member | $275.40 |
Non-Member | $324.00 |
- Members enjoy a 15% discount before GST
- Group Discount (5 or more participants) - 10%
- All
fees are inclusive of 8% GST
Funding Available
- COMPANY-SPONSORED PARTICIPANT
SDF GRANT REIMBURSEMENT (Non-WSQ)
SDF Grant Amount: S$28.00
Course Reference No.: TGS-2020501726
- INDIVIDUAL PARTICIPANT
SkillsFuture Credit - (Individual Singaporean aged 25 and above)
Pre-approved SkillsFuture funding of S$500.00
Click HERE for more info on SkillsFuture.
Advanced Microsoft Excel Course
Microsoft’s Excel programme has progressed from being just a simple online spreadsheet, with its uses covering a wide range – from simple data entry to complicated financial models and analysis. For those seeking to develop an advanced understanding of Microsoft’s Excel program, this course will definitely be of great use to you. After attending our advanced Excel course here in Singapore, participants will be able to use complex functions to model their data as well as generate a variety of reports.
If you are looking to attend this advanced Excel course, a good foundation in Excel is essential. Participants should be familiar with the program and be able to create basic Excel formulas. Having attended an essentials Excel course is definitely advantageous. A combination of lectures and demonstrations is applied to this course.
Key Takeaways
Upon completion of this workshop, participants will be able to;
- Learn how to use complex functions to model their data
- Learn to generate a variety of answers and reports.
Who Should Attend
Those seeking to further their knowledge of Excel would benefit from this course. Those needing to create spreadsheet models & data analysis are especially encouraged to attend.
Programme Outline
Module 1: Using Range Names
- Assigning Names
- Jumping to Named Ranges
- Create Range Names from Headings
Module 2: Database/List Operations
- Introduction to Excel Database
- Using Tables
- Removing Duplicates
- Database Functions
- Summarize Data using Subtotals
- Grouping & Outlining Data
Module 3: Data Validation
- Setting Data Validation
- Displaying Input Message & Error Alert
- Circling Invalid Data
Module 4: Data Consolidation
- 3D Formulae: Using Multi-Dimension Worksheets & Workbooks
- Consolidating Data
Module 5: Auditing Worksheets
- Tracking Errors in Excel
- Understanding Precedents & Dependencies
- Viewing & Hiding Tracer arrows
- Resolving Circular References<
- Using the Watch Window
- Evaluate Formulas
Module 6: Advanced Functions
- Nesting of Functions
- Lookups & Referencing
- Combining Functions
Module 7: Data Analysis
- What-If Analysis
- Using Goal Seek
- Solver
- Using the Scenario Manager
Module 8: Pivot Tables
- Understanding Pivot Tables
- Building a Pivot Table
- Pivot Table Formatting
- Creating Pivot Charts
- Printing a Pivot Report
Module 9: Collaborating
- Sharing Workbooks
- Merging Workbooks
Methodologies
A good foundation in Excel is essential for this course. Participants should be familiar with the program and be able to write basic formulae. Having attended an essentials course is advantageous. A combination of lectures, explicit teaching, practical demonstrations and peer teaching is applied to this course.
Experiential learning approach is adopted where the learners will be required to consider the experience as a learning process joined with critical reflection which further qualifies for this theory to be applied for this course because, at each segment, the learners are introduced to some form of experience after which they are asked to reflect on these experiences before sharing and putting ideas into practice.
Quick Information
Excel has become very much more than just a simple spreadsheet. Although its roots are still in number management, today Excel's uses cover a wide gamut - from simple data entry to complicated financial models and analysis.Contact Details
+65 6842 6666
mdc@mdis.edu.sg