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. ...
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
