Menu

Excel Training In Singapore



Connect With Us


To Schedule a LIVE DEMO Class

About Mechamind

We are a Registered Singapore Based Company, offering LIVE Virtual Training in Advanced Excel to Companies in Singapore.

Our Trainers are Microsoft Certified with 17+ Years of Training Experience in Excel & Microsoft Applications.

All our training programs are conducted using Live Case Studies & Examples from real time corporate scenarios.

We urge the participants to apply what they have learnt to their Data, to get maximum benefit from the training program.

Microsoft Excel is an Application widely used across the globe, by employees at different levels of the corporate sector to analyse, organize and represent their data, in a concise and visually appealing manner.



Would you Like to Train Your TEAM & Empower them?

Our FREE ONLINE Demo Class, which can be scheduled at a time convenient to you, to give you a closer look at what the excel training program has to offer. This 90 Minutes Session would give your Team Members a Hand's on and practical experience of our training methodology, interactivity & participant engagement.



Looking for LIVE 1:1 Training Sessions ?

Why Join Groups, when you can learn as per your pace and at a time convenient to you.
A tailor made Microsoft Excel Program keeping in mind the requirements of the corporate sector which will empower you to get an edge above the rest.
Learn on your own DATA & practically apply what you have learnt in a STEP By STEP Manner.

Looking for LIVE 1:1 Training Sessions ?

Why Join Groups, when you can learn as per your pace and at a time convenient to you.
A tailor made Microsoft Excel Program keeping in mind the requirements of the corporate sector which will empower you to get an edge above the rest.
Learn on your own DATA & practically apply what you have learnt in a STEP By STEP Manner.



Excel Training in Singapore Objective


Microsoft Excel, Level 2 (Office 356, Office 2016) Participants should be using Excel, and the common formula’s like Min, Max, Sum, Average, functions such as Sort & Filter. Having additional knowledge of VLOOKUP & Pivot Table’s would be an advantage.

Audience Executives and managers who have already been using Microsoft Excel, but now feel the need for learning more powerful features and options of Excel, to manage their worksheet-related tasks more efficiently

Prerequisites Participants attending this training should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.


Day 1 - Excel Advanced Training Syllabus


Overview of the Basics

  • Customizing common options in Excel
  • Absolute and relative cells
  • Protecting and un-protecting worksheets and cells

Working with Functions

  • Writing conditional expressions (using IF, NESTED IF)
  • Using logical functions (AND, OR, NOT, COMPOUND IF)
  • Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH)
  • INDEX, NESTED VLOOKUP, VLOOKUP WITH APPROX MATCH & EXACT MATCH)


Data Validations

  • Specifying a list of valid values for a cell
  • Specifying custom validations based on formula for a cell
  • Specifying a valid range of values for a cell

Working with Templates

  • Using templates for standardization of worksheets


Sorting and Filtering Data

  • Sorting tables
  • Using multiple-level sorting
  • Using custom sorting Filtering data for selected view (AutoFilter)
  • Using advanced filter options



Day 2 - Excel Advanced Training Syllabus


Working with Functions

  • Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH)
  • INDEX
  • NESTED VLOOKUP
  • VLOOKUP WITH APPROX MATCH & EXACT MATCH

Designing the structure of a template

  • Creating subtotals
  • Multiple-level subtotals
  • Creating Pivot tables
  • Formatting and customizing Pivot tables
  • Using advanced options of Pivot tables
  • Pivot charts
  • Consolidating data from multiple sheets and files using Pivot tables
  • Using external data sources
  • Using data consolidation feature to consolidate data


More Functions

  • Date and time functions
  • Text functions
  • Database functions
  • CountA
  • CountIF
  • CountIFS
  • SUMIF
  • SUMIFS
  • Dmax
  • Dmin
  • DAverage
  • DSum

Macros

  • Recording a Macro
  • Assigning a macro to a button
  • Relative & Absolute reference for a macro

Formatting

  • Using auto formatting option for worksheets
  • Using conditional formatting option for rows, columns and cells





Mr. Faiyaz Khairaz

( Microsoft Certified Trainer
Experience : 17+ years )

Hi, my name is Faiyaz M Khairaz. I'm a Microsoft Certified Trainer & (Power BI DA-100 Certified) with 17+ Years of Training Experience.
I have Conducted training for Corporates such as Deloitte, PwC, Kuoni. Trained over 83k participants till date


Talk To The Trainer




GET IN
TOUCH
  • +65 8951 7001
  • training@mechamind.sg

Enquire About Our Programs












Training Images




Testimonials

I am a student of Xavier Institute of Communications and I undertook a course on Microsoft Excel by Faiyaz Khairaz sir and it was super interactive and fun! The content is very relevant and the teaching style made it easy to comprehend. Would recommend to anyone looking to grab similar skills!

Sonaali Malhotra

I have attended the advanced excel workshop on the 19th and 20th of December 2020. Everything you need to know about excel in two days, can be found through this workshop. Got a lot ideas and answers to age old doubts. Mr. Faiyaz is a very good teacher for the same. Every technical description was made so simple to understand with great examples. Thankyou sir.

Carol Monteiro

Did a Excel Workshop Course with Faiyaz M Khairaz sir. It was an excellent course for girl like me who had no prior experience with Excel. Sir cleared each and every doubt I had. Thank You Sir for the wonderful training.

Geeta Pansare

I have attended the Advanced Excel training sessions organised by Sealed Air Packaging Materials India LLP on 15th and 16th December 2020. The sessions conducted by Mr. Faiyaz were very informative, interactive and hand-on despite having a virtual training platform. I would highly recommended this for anybody who wants to enhance their excel skills.

Sampada Munj



Related Courses




Excel Dashboard

Duration : 2 Days
Type : Live Classes


Read More >>


VBA Macros

Duration : 2 Days
Type : Live Classes


Read More >>


Excel Power Query

Duration : 2 Days
Type : Live Classes


Read More >>

Enquire About Our Programs











Contact Us

+65 8951 7001

training@mechamind.sg