MS Excel

by G-Tec Computer Education Sdn. Bhd Claim Listing

A successful database is efficient, quick, accurate, and easy to use. This course covers how to create such a database with MS Excel.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

G-Tec Computer Education Sdn. Bhd Logo

img Duration

Please Enquire

Course Details

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

  • Johor Bahru Branch

    City Square Office Tower, level 28, 28th Floor, Johor Bahru

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy