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$350 |
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, Naming Cells
- Working with excel workbook and sheets
Module 2: 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
Module 3: 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
No data found
| Course Name | Duration | Entry Requirement | Fee (SGD) |
|---|---|---|---|
| MS Excel | 15 hrs | Basic Computer Knowledge | S$350 |
| 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
