Thank you so much Mr Raju. 2 Days of Class is super, worth it! Learned so much in a super short period of time. ...
Autocad 2D Commencing on 25 February 2024 (Classroom Training)
VB.Net Programming Commencing on 26 February 2024 (Classroom Training)
MS Office Basic Commencing on 04 March 2024 (Classroom Training)
Please Call/Whatsapp 96503505 for more details.
MS Excel Expertise course is designed to provide an insight into some of the more advanced features of excel. This course deals with more detailed spread sheet concepts including Advanced lookups,functions,Logical functions and index, match functions of excel. Students will learn how to forecast the scenarios using data tools such as What if Analysis and to find solutions to complicated problems using advanced financial functions. At the end of the course students will have a complete understanding of the advanced functions of excel.
|MS Excel Expertise
|Excel (Basic to Intermediate)
- Automatic Rounding of Long Numbers
- Round Function
- Round Down Function
- Round Up Function
- Excel Text Functions
- Using Excel TEXT with other functions
- Separate Strings using text functions
- Logical IF Function
- Using multiple conditions
- AND function, OR Function
- NOT function with IF function
- Combining logical functions with other functions
- Financial Function
- PMT,IPMT,PPMT functions
- RATE, NPER Functions
- Calculating Present Value(PV)
- Calculating Future Value(FV)
- Calculating Payament per Periods (PMT)
- Loan Amortization Schedule
- Data Validation,Circle Invalid Data
- Clear Validation Circles
- Excel Goal seek function
- Data Table,Group, Outline
- Ungroup, Clear outlineSorting
- Using Subtotal, Removing subtotals
- Applying filters on subtotals
- Extract data using Advanced filtering
- Index Function,Match Function
- Combination of Index and Match Function
- VLOOKUP and match formulas in excel
- Indirect & Offset functions
- Using dynamic lookup tables
- Creating & Applying range names in formulas
- Combinations of lookup functions
- Informative functions,Iferror, Iserror
- Isn, Isnumber, Istext, Isblank
- Combinations of informative functions
- with other Functions
- Dashboard Design Tips
- Dashboard and Data Sources
- Using pivot table & chart for dashboard
- Visual Dashboarding Techniques
- Interactivity with Slicers
- Build a Sales Dashboard
- Writing a New Macro, Recording Macro
- Running a Macro, Using a Shortcut Key
- Using the Visual Basic Toolbar
- Using the Visual Basic Editor Window
- Assigning a Shortcut Key
- Using Relative References
- Assigning a Macro to a Menu
- Deleting a Macro from a Menu
- Deleting a Macro from work book
- Editing Macro Commands
- Creating a Custom Button
- Adding a Button to Quick Access Toolbar
- Assigning a Macro to a Button
- Changing a Button Image
No data found
|MS Excel Expertise
|Excel (Basic to Intermediate)
|Please call 63360244/96503505
mail to email@example.com
We also provides flexible timing to meet the customer's requirement
Request For Brochure
Frequently asked questions
MS Excel Expertise
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 ...