A successful database is efficient, quick, accurate, and easy to use. This course covers how to create such a database with MS Excel.
A 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."
Avail the highly demanded Microsoft training rendered by the experts of our corporate training institute enabling you to pursue further Microsoft Certification exams to excel your career
Microsoft Access is a software for creating and managing databases, developed by Microsoft Corporation. Microsoft Access is equipped with Forms, Query and Relationship functionality.
A successful database is efficient, quick, accurate, and easy to use. This course covers how to create such a database with MS Word.
Effective Worksheet with MS Excel 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 Word training is offered by Plast Koncept Training & Konsultancy Plt. We provide highly customized In-house programs according to organizational requirements are available. We have served many companies and provided quality training to meet their company's training objectives.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy