Thank you so much Mr Raju. 2 Days of Class is super, worth it! Learned so much in a super short period of time. ...
Diploma in Computer Science New Batch Commencing on February 07 2021! Please contact us on 96503505/63360244 for more details.
More Info
Course Name | Duration | Entry Requirement | Fee (SGD) |
---|---|---|---|
MS Excel | 15 hrs | Basic Computer Knowledge | S$350 |
Course Content
- Introduction to Excel interface
- Understanding rows and columns, Naming Cells
- Working with excel workbook and sheets
- New, Open, Close, Save, Save As
- Formatting Text: Font Size, Font Style
- Font Color, Use the Bold, Italic, and Underline
- Wrap text, Merge and Centre
- Currency, Accounting and other formats
- Modifying Columns, Rows, & Cells
- Creating Simple Formulas
- Setting up your own formula
- Date and Time Functions, Financial Functions
- Logical Functions
- Lookup(V-Lookup and H-Lookup) and Reference Functions
- Mathematical Functions
- Statistical Functions, Text Functions
- Working with Templates
- Creating Tables
- Naming the Table
- Changing the Table Style
- Creating a Total Row
- Creating a calculated column
- Using Filtering in Table
- Removing the Duplicate Record
- Sort and filtering data
- Using number filter, Text filter
- Custom filtering
- Removing filters from columns
- Conditional formating
- Inserting Column, Pie chart etc
- Create an effective chart with Chart Tool
- Design, Format, and Layout options
- Adding chart title
- Changing layouts
- Chart styles
- Editing chart data range
- Editing data series
- Changing chart
- Saving chart as template
- Summarizing data using spark line
- Understand PivotTables, Create a PivotTable
- Framework Using the PivotTable and PivotChart
- Create Pivot Chart from pivot Table
- Inserting slicer
- Creating Calculated fields
- Protecting a workbook with a password
- Allow user to edit ranges
- Track changes
- Working with Comments
- Insert Excel Objects and Charts in Word Document and Power point Presentation
- Creating and Recording Macros
- Assigning Macros to the work sheets
- Saving Macro enabled workbook
- Page setup, Setting print area, Print titles
- Inserting custom Header and Footer
- Inserting objects in the header and footer
- Page Setup, Setting margins, Print Preview, Print
- Enable back ground error checking
- Setting AutoCorrect Options
- Remove the appropriate check marks to disable any unwanted features
No data found
Request For Brochure

Frequently asked questions
MS Excel
- MS Excel Register now for this training
Testimonials
Fantastic Course, Fantastic Education Centre & very friendly and supportive trainers. Would highly recommend G-TEC for the next course.
Excellent and well planned training program. The Instructor was able to answer the queries confidently. One of the best Java Programming training and ...
"Student teacher ratio is very good. Explanation and doubt clearing was very good and understandable".
"The instructor is friendly and approachable. The course is taught in a detailed and structured way".
"The institution is well organized and show good response. C advance course covered all the relevant topics well".
"The trainer was patient and willing to pass his knowledge on other area as well".
"Next time I want to do another computer course I will definitely consider G-tec".
"The trainer is very patient. He doesn’t mind to keep repeating the same step. I am total new to the Autocad and ...
"The course is great and the trainer is having good knowledge in the topic. It will help me a lot in my upcoming ...
"My experience here was good. I hope that when I will have training I will come here."
"It is interesting for everyone to join the class .Good environment for learning."
"Patient teacher and staff great learning environment with sufficient facilities. Managed to have a thorough knowledge of Java".
"Other institutes don’t co-operate so much if somehow a student is unable to complete the course. But G-TEC has a very co –...
"Easy to understand concise . Friendly staff would recommend joining the course at G-TEC".
"Comprehensive course and cost effective".
"Contents in the Web designing course is detailed and benefited to me in my learning journey. The teachers are nice and helpful. G-TEC ...
" It is easy to follow and help you familiar with the fundamentals of C#.NET".
"G-TEC provides a good trainer qualified. It was a good learning experience in G-TEC for C#.net".
"The Java/J2ee course material was well presented and very helpful for my work. I really got a great amount out of ...
“I will encourage everyone to come for the Ms Office Basic course as the lessons are relevant to work. Teachers are willing to ...
"This is the best institution I found in Singapore. Because here the trainer as well as training was good. The trainers are very ...
"The VB.Net advanced training form G-TEC is very detailed and interesting training. The trainer is patient and willing to share her knowledge. ...
"Singapore is a great place to study and to work.And I'm glad, I came here through G-TEC COMPUTER EDUCATION CENTRE.Apart from ...
"G-TEC Computer Education Centre has provided me a golden opportunity to learn programming in depth and at my own pace. My trainers have ...