Harnessing the Power of Formulas and Functions in Excel (2016)IT Short Courses
Duration | One day |
Course Dates | 12 Oct 2022 9:00am - 12 Oct 2022 5:00pm 31 Mar 2023 9:00am - 31 Mar 2023 5:00pm 07 Jun 2023 9:00am - 07 Jun 2023 5:00pm 05 Sep 2023 9:00am - 05 Sep 2023 5:00pm 12 Dec 2023 9:00am - 12 Dec 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-2020502563
- 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.
Introduction
One of Excel’s key strengths is its power of formulas and functions where it can display data in a format that is suitable for reporting.
Key Takeaways
This course takes the Excel user to a realm where he/she will be introduced to cell manipulation as well as discover techniques of fine-tuning formulas and the introduction of some Advanced Excel functions relating to text, logical and information that assist in providing the necessary information or changing the representation of how data is presented.
Who Should Attend
Those needing to extract information from their worksheet models as well as how to tidy up their data in a format that is acceptable for reporting are especially encouraged to attend.
Programme Outline
Module 1: Cell Manipulation in Excel
- Applying Conditional Formatting to a Range
- Filling a Range by using the Fill Handle & Flash-filling a range
- Creating a Series using Excel Series command
- Using the Go To Special Dialog Box
- Displaying Worksheet Formulas using Ribbon command & using a function
- Printing Worksheet Formulas
- Converting a Formula to a Value
- Apply Paste Special Function
Module 2: Building Basic Formulas and Functions in Excel
- Understanding Excel Formulas
- Creating an Excel Formula
- Understanding Relative, Absolute and Mixed Cell Referencing
- Using Relative, Absolute and Mixed Cell Referencing in Formulas
- Understanding Excel Functions
- Creating an Excel Function through various methods
- Using the AutoSum
- Using some common Excel Functions
- Understanding Excel’s Formula-Related Errors
- Apply Automatic Checking for Possible Errors in Formula Usage
Module 3: Working with some Advanced Excel Functions
- Logical and Information Functions
- Applying a Logical Function in Excel
- Getting Data with Information Functions
- Text Functions
- Working with Characters and Codes
- Converting Text
- Formatting Text
- Removing Unwanted Characters from a String
- Extracting a Substring
- Searching for Substrings
- Substituting One Substring for Another
Methodologies
Not only a good foundation in Excel is essential for this course but learners preferably should have attended the Level 3 Beyond Advanced course before enrolling for this course. Having attended the Level 2 Advanced course is advantageous.
A combination of lectures, explicit teaching, practical demonstrations and peer teaching is applied for 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
One of Excel's key strengths is its power of formulas and functions where it is able to display data in a format that is suitable for reporting.Contact Details
+65 6842 6666
mdc@mdis.edu.sg