Welcome to G-TEC EDUCATION SDN. BHD

  • +60377730654

REGISTRATION NOW

MS Excel

Course Content:

Module1:Introduction to Excel:
♦ Introduction to Excel interface
♦ Understanding rows and columns, Naming Cells
♦ Working with excel workbook and sheets
Module2:Formatting excel work book
♦ New, Open, Close, Save, Save As
♦ Formatting Text: Font Size, Font Style
♦ Font Color, Use the Bold, Italic, and Underline
♦ Wrap text, Merge and Centre
♦ Currency, Accounting and other formats
♦ Modifying Columns, Rows, & Cells
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
♦ Mathematical Functions
♦ Statistical Functions, Text Functions
♦ Working with Templates
Module 4: Managing Tables
♦ Creating Tables
♦ Naming the Table
♦ Changing the Table Style
♦ Creating a Total Row
♦ Creating a calculated column
♦ Using Filtering in Table
♦ Removing the Duplicate Record
Module 5: Sort and Filter Data with Excel
♦ Sort and filtering data
♦ Using number filter, Text filter
♦ Custom filtering
♦ Removing filters from columns
♦ Conditional formating
Module 6: Create Effective Charts to Present Data Visually
♦ Inserting Column, Pie chart etc.
♦ Create an effective chart with Chart Tool
♦ Design, Format, and Layout options
♦ Adding chart title
♦ Changing layouts
♦ Chart styles
♦ Editing chart data range
♦ Editing data series
♦ Changing chart
♦ Saving chart as template
♦ Summarizing data using spark line
Module 7: Analyze Data Using Pivot Tables and Pivot Charts
♦ Understand PivotTables, Create a PivotTable
♦ Framework Using the PivotTable and PivotChart
♦ Create Pivot Chart from pivot Table
♦ Inserting slicer
♦ Creating Calculated fields
Module 8: Protecting and Sharing the work book
♦ Protecting a workbook with a password
♦ Allow user to edit ranges
♦ Track changes
♦ Working with Comments
♦ Insert Excel Objects and Charts in Word Document and Power point Presentation
Module 9: Use Macros to Automate Tasks
♦ Creating and Recording Macros
♦ Assigning Macros to the work sheets
♦ Saving Macro enabled workbook.
Module 10: proofing and Printing
♦ Page setup, Setting print area, Print titles
♦ Inserting custom Header and Footer
♦ Inserting objects in the header and footer
♦ Page Setup, Setting margins, Print Preview, Print
♦ Enable back ground error checking
♦ Setting AutoCorrect Options
♦ Remove the appropriate check marks to disable any unwanted features
Course Name Duration Entry requirement Fee(SGD)
MS Excel 15 hrs Basic Computer Knowledge s$280
Time Slot

Please call 63360244/96503505

or

mail to info.my@gteceducation.com.

We also provides flexible timing to meet the customer's requirement,

Brochure Request