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."
The Microsoft Visio (Basic to Expert) Program is offered by the International College of Management and Sports (ICMS)
This training is designed to enable participants to apply intermediate and advanced functions of Microsoft Excel to increase productivity, enhance spreadsheets with charts & formulas and streamline their work.
Microsoft Excel course is offered by Sendayan Training & Consultancy. STC is aiming at bringing only the best training programs with passionate trainers. We strongly believe that knowledgeable and passionate trainers will be able to deliver the best only.
This course is intended for participants who wish to gain more knowledge from the intermediate level of Excel.
Microsoft Excel Power Pivot & Power Query course is offered by Training Valley. Leave your employees in our hands and we will return them completely equipped with enriched skill set, fresher attitude, world-class knowledge and impressive competency.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy