Corporate Training
Project Training
Thank you so much Mr Raju. 2 Days of Class is super, worth it! Learned so much in a super short period of time. ...
Autocad Weekend Batch Commencing on 05 December 2021!
Diploma in Computer Science Part Time Batch Commencing in the month of December 2021!
Please call on 96503505 or email to info.sg@gteceducation.com for booking.
More Info
MS Excel
| Course Name | Duration | Entry Requirement | Fee (SGD) |
|---|---|---|---|
| MS Excel | 15 hrs | Basic Computer Knowledge | S$399 |
We also train Ms Excel 2010/2013 versions. For alternate time slots, please call 63360244/96503505
Course Content
Module 1: Introduction to Excel
- Introduction to Excel interface
- Understanding rows and columns
- Adding and deleting new worksheet
- Working with excel workbook and sheets
- Understanding cell referencing
- Introduction to Excel interface
- Understanding rows and columns
- Adding and deleting new worksheet
- Working with excel workbook and sheets
- Understanding cell referencing
Module 2: Formatting excel work book
- New, Open, Close, Save, Save As
- Formatting Text: Font Size, Font Style,
- Font Color, Use the Bold, Italic & Underline,
- Wrap text, Merge and Centre
- Currency, Accounting and other formats
- Modifying Columns, Rows & Cells.
Module 3: Perform Calculations with Functions
- Creating Simple Formulas
- Setting up your own formula
- Calculations between worksheets
- Mathematical Functions
- Statistical Functions
- Date and Time Functions
- Logical IF Function
- Logical functions with multiple conditions
- Lookup Functions (V-Lookup and H-Lookup)
- Using range names in formulas
- Conditional summary function
- Countif, Sumif, Averageif functions
Module 4: Cell referencing
- Relative cell referencing
- Absolute Cell referencing
- Using Cell references in formulas
- Doing quick calculations with Cell referencing
- Mixed cell referencing
Module 5: Sort and Filter Data with Excel
- Sort and filtering data
- Using number filter, Text filter
- Custom sort and filtering
- Removing filters from columns
- Using Conditional formatting
- Modifying and deleting rules
- Creating custom rules
Module 6: Working with Graphics andhyperlinks
- Adding Pictures into a Worksheet
- Customizing Pictures and Objects
- Adding Drawing Objects into a Worksheet
- Adding SmartArt into a Worksheet
- Creating Hyperlinks
- Hyperlinks to worksheet
- Hyperlinks to file
Module 7: 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 types
- Moving chart to a new worksheet
- Preparing combination chart
- Visualizing data with spark lines
- Editing and modifying sparklines
Module 8: Protecting and Sharing the work book
- Protecting a workbook with a password
- Allow user to edit ranges
- Tracking the changes
- Accepting and rejecting changes
- Working with Comments
- Editing and deleting comments
Module 9: Analyze Data Using Pivot Tables and Pivot Charts
- Understand PivotTables
- Understanding Row and columns
- Understanding pivot table field list
- Creating new field items
- Create Pivot Chart from pivot Table
- Creating Calculated fields
- Editing Calculated field
- Filtering pivot tables with slicers
- Moving pivot table and updating data
Module 10: Use Macros to Automate Tasks
- Creating and Recording Macros
- Assigning Macros to the work sheets
- Saving Macro enabled workbook
- Editing and deleting macros
- Assigning macro to a button
Module 11: Proofing and Printing
- Page setup, setting print area, Print titles
- Editing print area, add to print area
- Inserting custom Header and Footer
- Inserting objects in the header and footer
- Page Setup, setting margins, Print Preview
- Changing worksheet views
No data found
| Course Name | Duration | Entry Requirement | Fee (SGD) |
|---|---|---|---|
| MS Excel | 15 hrs | Basic Computer Knowledge | S$399 |
| Time Slot | |||
| Please call 63360244/96503505 or mail to info.sg@gteceducation.com We also provides flexible timing to meet the customer's requirement |
|||
Request For Brochure
Frequently asked questions
No data found
