Call +65 6100 0613 Email: enquiry@tertiaryinfotech.com

Instructor-led Classroom Adult Training in Singapore - Modular Fast Track Skill-Based Trainings

Advanced Excel Essential Training

Start mastering Excel, the world's most popular and powerful spreadsheet program. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools.

Course Highlights

  • Creating pivot Tables
  • Creating formulas and functions
  • Finding and replacing data
  • Using power functions such as IF and VLOOKUP
  • Password-protecting worksheets and workbooks
  • Analyzing data with Goal Seek and Solver
  • Creating and running macros

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant Applications

Click the links below to apply. Note that you need to register the course first.

For Singaporeans: SkillsFuture Credit

For Company: SSG Training Grant

Course Code: CRS-N-0031885

Course Booking

$228.00 (GST-exclusive)
$243.96(GST-inclusive)

Course Date

Course Time

* Required Fields

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.


Course Details

Module 1 Pivot Table

  • Creating Pivot Tables
  • Sorting and Filtering Pivot Tables 
  • Formatting Pivot Tables
  • Creating PivotCharts

Module 2: Functions & Formulas

  • Formula Shortcut Keys
  • If and Related Functions
  • Lookup and Reference Functions
  • Power Functions
  • Statistical Functions
  • Math Functions
  • Date and Time Functions
  • Array Functions
  • Text Functions

Module 3: Advanced Charts

  • Creating Basic Charts
  • Style Charts with Design Tabs
  • Fine Tune Chart Elements
  • Format Tab

Module 4 Data Analysis

  • Installing Data Analysis Tool
  • Goal Seeker & Solver
  • Histogram
  • Linear Regression
  • Testing a Hypothesis
  • Covariance and Correlation
  • Bayesian Analysis

Course Admin

Nil

Who Should Attend

  • Office Executives
  • Office Administrators
  • Engineers

Trainers

Excel TrainerKen Hiong has over 20 years of work experience in the healthcare and pharmaceutical industry holding various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning.

He graduated with a degree in Pharmacy and holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide.

He is an expert Excel user and has a keen interest in scripting and web development with practical knowledge of HTML, Javascript, CSS, PHP, MySQL, WordPress, VBA, amongst others. Applying these tools at work, he had simplified many work methodologies, improved data analysis and business reporting processes, achieved higher productivity and enhanced quality outcomes. He is an advocate of lifelong learning.

Excel TrainerWesley Tan graduated with a Master of Business in IT from the RMIT (Australia). Currently, founder of technology service company based in Singapore catering e-commence, RFID-based, iOT and asset tracking and trace solutions, consulting and project delivery. He specializes in Excel for both basic and advance levels (ICDL certification from UK), conducting Joomla and e-commence (Virtue Mart) workshops.

Excel TrainerStephen Tan is a Supply Chain professional and practitioner with extensive experiences in End to End Supply Chain, Operations and Supply Management. His experience hails from his career at senior management level at MNC, SME and Non-Profit organisation with industries ranging from Electronic, Chemical, Healthcare, and Offshore & Marine including Oil & Gas industries. He graduated with a Bachelor of Business Administration with Distinction from RMIT University. Stephen also has an MBA from Macquarie University as well as a Certified Diploma in Accounting & Finance (ACCA, UK). He is awarded Life Time Certification in Supply Management from ISM, USA and the IE study award with Singapore Management University for Global Supply Chain Management.

He trains (ACTA certified), lecture and does adhoc consultancy project and had worked a philanthropic organization and currently Unilever Indonesia working on Supply Chain and Operations optimization after his stint with a Norwegian regional AP office working on ERP project.

Stephen is an ardent and enthusiastic user of MS Excel not only to simplify reporting for KPI but also as a tool for problem solving, decision making and cost optimization. He has also created various MS Excel tools that linked with ERP to create What-If scenario to solve problem and provide optimum solution. He believes in lifelong learning and has obtained a Specialist Diploma in Business Intelligence and Data Analytic in 2017. He desires to extend the Data Visualization capability of MS Excel, deepening his knowledge, simplifying it and sharing and teaching his knowledge to professional as well as layman.

He had worked previously with HP, CMB as Regional Procurement and handles End to End Supply Chain, Operations, Logistics with top European Flavor and Fragrance companies: Dragoco, Symrise. He also does IT projects, ERP implementations with various systems ranging from RenCS, SAP, IFS and as well as smaller SAGE-ACCPAC supply module systems which automates as well as optimize resources.

He has also developed business analytic system for Supply Chain, Order management, On-Time Delivery and Inventory Control system using combination of Excel, MS Access and other IT tools to leverage data from IT and ERP systems.

Excel TrainerKhoo Yong graduated from NTU with a bachelor degree in Mechanical and Production Engineering. Currently, working as a principal engineer in one of the top 3 Semiconductor Manufacturing Pure-Play Foundry in the world, he is a statistician support Operations and Engineering, driving the Statistical Process Control Program in the Fab. He specializes in Statistics , basic Excel and advance Excel, including excel macro coding. He regularly conduct Statistical Process Control Courses in the company. He is a certified ACTA Trainer ( Advance Certificate in Training and Accessing) as well as a certified Black Belt.

Excel TrainerBimala Mishra has Overall 13 years of IT experience, with strong exposure in Database, Business Intelligence and Analytics domains. She has extensively worked on implementation of Enterprise Datawarehouse and BI solutions. She is a Certified Business Intelligence Professional from ICCP, USA (2013). Bimala’s varied career includes Data Analysis, Design and development of enterprise solution. She has done Masters in Computer application from one of the pioneer institutes of India and have worked on MNC such as Hewlett Packard. She is an expert on SQL backend Query, Excel, QlikView, Qlik Sense, C Programming, Java, Python to name a few. She enjoys working with both adults and youngsters. Currently she is an active volunteer of NLB S.T.A.R program, where she teaches Seniors about NLB mobile Apps and assists secondary students in her children school on their computer project assignments.

Excel TrainerEric Goh is a seasoned Data Science Researcher and Software Engineer with years of experience in multiple industries. Eric Goh’s varied career includes data and text mining, intelligent systems development, IT project management, engineering product design and researches. During his free time, Eric teaches as an Adjunct Instructor at the University of the People. He also started SVBook.com, and developed his own data science software at DSTK.Tech. He holds a Master of Technology degree, Executive MBA degree, and a Graduate Diploma.

Excel TrainerTan Kian Meng is currently a part time statistics lecturer in polytechnics. He has more than 15 years of Quality Engineering and Quality Management experience with a global electronic manufacturing MNC, where there were opportunities to practice statistical and quality improvement methodologies. His area of specialty include SPC, SQC, Process Capability Improvement, DoE, FMEA, 6-Sigma, GD&T, GRR and Quality Systems.

He is graduated from NUS with a B.Sc. in Mechanical Engineering and M.Sc. in Industrial & System Engineering. He was also a Certified Quality Engineer with ASQ.

Excel TrainerScoot Wong Kam Seng Worked as Trainer for 3M products during sales career. Using Microsoft Excel to create quotations. Spent 5 years as a Buyer/Procurement at Flextronics and Venture Corporation. Using Microsoft Excel to keep track of purchased items. Possess few professional qualification such as Microsoft Office Excel Expert Specialist. Do possess Advance Certificate in Training Adult (ACTA). Have anticipated in Tiara Toastmaster event. Pursuing Digital Marketing and doing freelance market research for a foreign firm. Currently providing training for NTUCLearninghub as well as Skill Global Academy for Microsoft Excel.

Excel TrainerMartin Ng graduated with a Master of Business Administration (Distinction) from the Manchester Business School and a degree in Computing (Information Systems) from the National University of Singapore (Honours 2nd Upper). As Senior Lecturer in one of the local Polytechnics for 8 years, he developed and lectured on various Business-IT modules including data analytics, business intelligence, social media marketing, statistics and project management. He specializes in Excel, having overseen projects to create dashboards for presentation to management. Prior to lecturing, he was a senior systems analyst in charge of websites and e-commerce applications in the public sector.

Excel TrainerKen Hiong has over 20 years of work experience in the healthcare and pharmaceutical industry holding various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning.

He graduated with a degree in Pharmacy and holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide.

He is an expert Excel user and has a keen interest in scripting and web development with practical knowledge of HTML, Javascript, CSS, PHP, MySQL, WordPress, VBA, amongst others. Applying these tools at work, he had simplified many work methodologies, improved data analysis and business reporting processes, achieved higher productivity and enhanced quality outcomes. He is an advocate of lifelong learning.

Customer Reviews (25)

Great Teacher, Rich Materials Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Mr Ken is a very patient, helpful and friendly teacher who is also very passionate about sharing his knowledge. Throughout the 2 days, I've picked up a lot from him. This is not a course for beginners and there's really a lot of materials, but they're really very good stuff. Overall, it's a great course and I didn't regret picking this school. Thank you Mr Ken. (Posted on 12/23/2019)
will recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 11/19/2019)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 10/15/2019)
Very interesting course Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Too much materials to be covered in 2 days course. Would be good to use more layman terms as certain terms may be too technical for participants (who are non-tech trained).

Very interesting course as it gives an overview of Python to the participants. However, it can get a little fast paced and overwhelming for beginners.

(Posted on 10/14/2019)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 10/14/2019)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
The connection from computer to monitor flickered and was disrupted on many occasions. Please rectify this.

Mr Ken is exemplary in his approach to meeting the learner's need. He is incredibly patient, and demonstrated full commitment to and expertise par excellence at solving the issues that I grappled with. A highly recommended tutor that truly excel at teaching Excel! (Posted on 8/21/2019)
Might Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 6/18/2019)
Might Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Need to have at least two days. The Data Analysis portion was not covered , not enough time to cover properly and too rush

Trainer is good but I think the function portion can skip especially on date and text functions and focus on data analysis (Posted on 6/17/2019)
Might Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 6/17/2019)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 3/30/2019)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 3/29/2019)
Might Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 3/20/2019)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 2/18/2019)
Might Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Excel functions not often used such as covariance/correlation we do not have to go through it. More focus on what we use on a day to day basis

Good pacing (Posted on 12/17/2018)
Might Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 12/17/2018)
Might Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Increase the duration (Posted on 12/17/2018)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 12/17/2018)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Skip those functions that we seldom use. Focus and more on those frequently use.

Very noisy during lesson. (Posted on 12/17/2018)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Stephan is very patient and friendly.Knowledgeable,efficient and able to
understand and solve the students' queiries and issues.As for the room, due to the central aircon, it's very warm for learning.Hope can at least place a fan for better air ventilation (Posted on 8/6/2018)
Will Recommend Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
. (Posted on 7/21/2018)

Items 1 to 20 of 25 total

per page
Page:
  1. 1
  2. 2

Write Your Own Review

You're reviewing: Advanced Excel Essential Training

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
  • Reload captcha
    Attention: Captcha is case sensitive.

Tags

Other people marked this product with these Subjects:

Use spaces to separate Subjects. Use single quotes (') for phrases.

You May Be Interested In These Courses

Statistical Data Analysis Training with Excel

Statistical Data Analysis Training with Excel

31 Review(s)
$298.00 (GST-exclusive)
$318.86(GST-inclusive)