A successful database is efficient, quick, accurate, and easy to use. This course covers how to create such a database with MS Excel.
DurationA successful database is efficient, quick, accurate, and easy to use. This course covers how to create such a database with MS Excel.
Module 1:Introduction to Excel:
Introduction to Excel interface
Understanding rows and columns, Naming Cells
Working with excel workbook and sheets
Module2:Formatting an Excel Workbook
New, Open, Close, Save, Save As
Formatting Text: Font Size, Font Style
Font Color: Use Bold, Italic, and Underline
Wrap text, Merge and center
Module3: Perform Calculations with Functions
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
Module 4: Managing Tables
Creating Tables
Naming the Table
Changing the Table Style
Creating a Total Row
G-Tec Computer Education Sdn. Bhd. is among the largest in the world of its kind, with an unmatched network of more than 510 training centres all over the world. G-Tec Computer Education is a committed venture in IT services, led by a team of dedicated professionals with distinct experience in technical, management, and functional domains both domestically and internationally. G-TEC contributes significantly to the enrichment of higher-quality talent in skilled, developed human resources with an international benchmark.
Our vision is to provide professional education merging corporate culture globally to the youth through technology resourcing and knowledge consulting with emerging technologies.
Our aim is to make IT education affordable to all sections of society through various projects associated with governments, quasi-governments, and public and private companies in every corner of the globe.
G-Tec Computer Education is the only company in the IT field with such a vast network covering cities, towns, and villages. We have special teaching methodologies to train people in different categories, ranging from school level to corporate clients. We believe all these factors would help to achieve our ultimate goal – "100 percent computer literacy."
Microsoft Visio course is offered by MindMapper Solution Sdn Bhd. Our team has more than 15 years of experience in management and training. We have extensive skills in all aspects of implementation and operation to meet your requirements.
Microsoft Office course is offered by MAA Training & Consultany. MAA Training & Consultancy is a distinguished education, training, and consultancy company that offers services throughout Malaysia.
Microsoft Excel is a powerful spreadsheet and data analysis program with wide-ranging capabilities. Attending a live Excel course is a good way to quickly and efficiently learn Excel. There are 3 primary reasons why you should learn Excel and how learning Excel is helpful for your career.
In this course, students will use PowerPoint 2016 to begin creating engaging, dynamic multimedia presentations.
This workshop immerses participants in the art of persuasive presentations using PowerPoint.
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UAE, UK, USA, India and South Africa, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore
Saudi Arabia
Egypt
Jordan