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 Word course is offered by Symphony Digest. Whether you are looking for public courses or HR looking for in-house courses, Symphony has over 200 courses to suit your needs.
In this course, students will use PowerPoint 2016 to begin creating engaging, dynamic multimedia presentations.
MS Excel training is offered by Sekolah Perdagangan Dian for all skill level. Sekolah Perdagangan Dian is now having more than 300 students annually. The passing rate and number of students score an ‘A’ or Distinction in the subjects are encouraging and shows an upward trend from year to year.
Microsoft PowerPoint course is offered by Northernville Consulting Sdn Bhd. We have large pools of experienced consultants and trainers to tailor make your course content specifically according to your needs and expectations.
Microsoft Access course is offered by Centrilinc. User application software training has been one of our core business focus. Our application courses were developed, and are consistently updated to meet the current, and practical need of the local workforce.
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.
© 2024 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