Filtering: AutoFilter, Filter by Colour and Text Filters
Criteria – contains, equal to, not equal to
Grouping & Subtotals
Using Sorting Options – Custom, ascending and descending, A-Z, Z-A
Using Name Range
Absolute Cell Referecing
Conditional Formulas and Formatting
Absolute Cell Referencing
Pivot Tables and Pivot Charts (Basic)
Working with Data Tables
Creation of Charts and the Various Chart types
Basic editing of charts
Resizing and Moving
Choices of Colour
Printing Charts with or without data
Switching Chart Location
Manipulating Chart titles, Chart Legend, Chart Data, and Chart labels
Handling and Controlling of Data
How to create a Combination Chart
Functioning with Sheets
Hide or Show Comments
Worksheet and Password Security Protection
Switching on the developer tab
Creation of macros
Switching the macro security settings
Recording and Executing macro
Sharing a workbook
Functioning with external data
Creating a formula to link workbooks
Handling between worksheets
Constructing 3-D formulas
Utilizing the Paste Link Option
Controlling link updates
Dealing with Broken Links
Pivot Tables and Pivot Charts (Advanced)
Advanced graphing and charting option that you can use to decorate your excel presentation
Documenting and Auditing
Determining Precedent and Dependents Cells
Revealing Formulas within the Sheet
Adding, Displaying, Editing, and Removing Comments
Realizing Formula Errors
Utilizing the Trace Error Commands
Running with Error Checking
Area and Volume
Investment and Loan
Time and Date
Relative Cell Reference
Please email firstname.lastname@example.org for training schedules.
International Plaza – Beside Tanjong Pagar MRT
We wish to highlight that dates may be subjected to changes without notice.
Classes will be postponed if there are less than 6 participants.
We can also arrange a close class specially for your company as long as you have a minimum of 6 participants.
We only accept payments transacted in Singapore Dollars and all payments are neither exchangeable nor refundable for other items.
Note: We conduct the training using MS Excel 2013.
Microsoft Excel Courses In Singapore(SkillsFuture Approved)
Excel remains as one of the most appealing software applications that the community around
the world relies on till this day. What makes Excel so appealing to users? Well, there are numerous advantages of Excel, which consists of its user-friendliness, effectiveness and easy entry to help users improve their efficiency using Excel. The course will also lead you through the basics of Microsoft Excel, and will help you acquaint to the numerous functions and formulas of Excel.
Excel Champion Bundle
Sign up for our Excel Champion Bundle (3 Days – Basic, Intermediate and Advanced Courses)
SkillsFuture Covers 100% of Course Fees (Self Sponsored)
The Excel Champion Bundle is a 3 in 1 deal comprising of our Basic, Intermediate and Advanced training courses. You can master all Excel functions and formulas within a short period of 3 days at an affordable price!