Call +65 6100 0613

Instructor-Led Classroom Adult Training in Singapore - Learn New Skills to Enhance Your Employability from our SkillsFuture Courses

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.
Topics include:

  • 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


Click here to submit SkillsFuture Credit for Individual

SSG WSG SkillsConnect WDA Absentee Payroll for Company

Course Code: CRS-N-0031885

Course Booking

$228.00

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.


Training Grant and Subsidy

All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses. Visit the SkillsFuture Credit website www.skillsfuture.sg/credit to choose from the courses available on the SkillsFuture Credit course directory

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

Who Should Attend

  • Office Executives
  • Office Administrators
  • Engineers

Prerequisite

Nil

Trainers

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 (4)

Will RecommendReview by Ma Thin Mar Win
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
Nil (Posted on 3/20/2018)
Will RecommendReview by fadhilah puteri
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
Nil (Posted on 10/9/2017)
Will RecommendReview by LEONG JIE SHENG
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
Apply more use case. (Posted on 7/25/2017)
Will recommendReview by Francis Wong Toon Hong
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
Providing more time for practices during class to get familiar formulas.

It will be difficult for basic excel learner to catch up since the course is intensive. It will be good if trainer can provide more ideas on how the formulas can be used during work. Reason is because students can use what they have learnt into real life practices in work. (Posted on 7/11/2016)

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

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