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!
Intermidiate Excel Training For Corporates | Singapore
Connect With Us
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.
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.
Intermediate Excel Training in Singapore Objective
The Excel Course Level 1 program introduces participants to working with Microsoft Excel, covering the basics such as creating and editing worksheets, formatting them for a professional look, working with formulas to manage routine tasks, etc.
Phase 1 - Intermediate Excel Training Syllabus
Download Course SyllabusFormulas and Functions
- Using AutoSum
- Using simple aggregate functions (Sum, Count, Average, Min, Max)
- Types of cell referencing: relative and absolute
Working with Large Worksheets
- Freezing and unfreezing panes
- Inserting page breaks for printing
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
More Functions
- Date and time functions
- Text functions
- Power Functions (CountIf, CountIFS, SumIF, SumIfS)
Relationships
- Working with multiple tables
- Diagram and Data views
- Defining relationships
- Editing and Handling Multiple Relationships
Working with Functions
- Using VLOOKUP function
- Protecting and un-protecting worksheets and cells
Working with Charts
- Creating different types of charts
- Including titles and values in charts
- Formatting of charts
- Using 3D Graphs
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
TOUCH
- +65 8951 7001
- training@mechamind.sg
Enquire About Our Programs
Training Images
training@mechamind.sg