"Student teacher ratio is very good. Explanation and doubt clearing was very good and understandable".
|Course Name||Duration||Entry Requirement||Fee (SGD)|
|MS Excel Advanced||15 hrs||Basic Excel Knowledge||S$320|
- Understand Functions, Understand the Components of a Function
- Enter Functions in Worksheets, Type a Function Directly into a Cell
- Use the AutoSum Drop-Down Menu Use the Insert Function Dialog Box
- Nest One Function Inside Another Function, Date and Time Functions
- Financial Functions
- Logical Functions
- Lookup and Reference Functions (V-Lookup and H-Lookup)
- Mathematical Functions
- Statistical Functions
- Text Functions
- Refer to Cells and Ranges in Formulas
- Refer to Other Worksheets and Other Workbooks in Formulas
- Use Range Names and Labels in Formulas
- Troubleshoot Formulas
- Understand and Fix Basic Errors in Formulas
- Sort, Perform a Quick Sort by a Single Field
- Perform a Multi field Sort for Finer Sorting
- Sort by a Custom Sort Order
- Filter a to Find Records That Match Criteria
- Perform Quick Filtering with AutoFilter Create Custom Filters
- Using Advanced filter
- Understand the Basics of Excel Charts
- Create a Chart with the Chart Wizard
- Choose the Right Type of Chart for Your Data
- Use the Chart Toolbar, Select Objects in a Chart
- Configure Chart Options, Change the Chart Type
- Change a Chart's Source Data
- Change the Format ,the Chart Area, Plot area
- Configure and Change the Scale of an Axis
- Liven Up Charts with Patterns, Fills, and Pictures
- Format Individual Chart Elements, Print Charts
- Editing Chart data series
- Using Range Names
- Creating Range Names
- Using Range Names in Formulas
- Creating Range Names from Headings
- Deleting Range Names
- Creating 3-D Range Names
- Understand PivotTables
- Create a PivotTable Framework Using the PivotTable and PivotChart Wizard
- Create the PivotTable on the Framework
- Choose PivotTable Options to Configure a PivotTable
- Create Pivot Charts from PivotTables
- Create a Conventional Chart from PivotTable Data
- Creating Calculated fields
- Inserting Slicer
- Linking Workbooks
- Editing the Link
- Consolidating Workbook & worksheets
- Restrict Data and Protect Workbooks
- Check Data Entry for Invalid Entries
- Protect Cells, a Worksheet, or a Workbook
- Protect a Workbook with Passwords
- Work with Comments and Add a Comment to Cell
- Display and Hide the Comments in a Worksheet
- Edit and Format Comments, Delete a Comment
- Insert Excel Objects in Word Documents
- Insert a Chart in a Word Document
- Insert Excel Objects in PowerPoint Presentations
- Insert Word Objects in Worksheets
- Insert PowerPoint Objects in Worksheets
- Display the Developers Tab
- Changing Macro Security Setting
- Running a Macro
- Recording a Macro
- Deleting a Macro
- Assigning a Macro to an Object
- 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 Advanced
"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 ...