Our Clients
Large MNCs, Local Companies & SMEs have selected Intellisoft Systems as their Training Provider.
Some of our clients are M1, Bayer, 3M, DSO National Labs, OLAM International, National Healthcare Group, HP, NUS, ITE, LTA, MOH, Richemont, BHP Billiton, Science Centre, American Express, Standard Chartered Bank, Estee Lauder, Amadeus and many more.
Advanced Microsoft Excel Training
Advanced Excel 2007 Tips & Techniques Training
SDF Funding is available to Singapore Companies (For company sponsored candidates). Call 6296-2995 for Details.
Advanced Excel Training Course Objectives:
- Understand how you can apply Advanced functions of Microsoft Excel to improve productivity, enhance spreadsheets with charts & formulas and streamline your work.
- Learn how you can automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify your day-to-day work.
"The Advanced Excel training will help me get my job done very quickly and easily. The things that I used to take many hours will now take only a few minutes with the use of formulas, macros and other tricks I learnt in the Excel workshop" - Carmen Leow, Pan Pacific Hotel, Singapore
Course Outline for Advanced Excel Tips & Techniques:
Day 1
Advanced Excel Lesson 1: Working with Custom and Conditional Formats
| 1.1 | Creating a Custom Format |
| Create a custom number format | |
| 1.2 | Conditional Formatting |
| Creating Conditional Formatting | |
| Editing Conditional Formatting | |
| Adding Conditional Formatting | |
| Deleting Conditional Formatting from the Selected Range |
Advanced Excel Lesson 2: Using Formulas and Functions
| 2.1 | Relative Cell Reference |
| 2.2 | Absolute Cell Reference |
| 2.3 | Using Text Functions |
| Left Function | |
| Upper Function | |
| Concatenating the text values | |
| 2.4 | Date Functions |
| Using Today Function | |
| Calculating using Date Function | |
| 2.5 | Using Sum Functions |
| 2.6 | Using CountA Functions |
Advanced Excel Lesson 3: Working with Range Names
| 3.1 | Using Range Names |
| 3.2 | Creating Range Names |
| 3.3 | Using Range Names in Formulas |
| 3.4 | Creating Range Names from Headings |
| 3.5 | Deleting Range Names |
| 3.6 | Creating 3-D Range Names |
Advanced Excel Lesson 4: Using Advanced Functions
| 4.1 | Using If Functions |
| 4.2 | Using Nested If Functions |
| 4.3 | Using Sum If Functions |
| 4.4 | Using Count If Functions |
| 4.5 | Using Vlookup Functions |
| 4.6 | Using HLOOKUP Functions |
Advanced Excel Lesson 5: Managing Tables
| 5.1 | Creating Tables |
| 5.2 | Naming the Table |
| 5.3 | Changing the Table Style |
| 5.4 | Creating a Total Row |
| 5.5 | Creating a calculated column |
| 5.6 | Using Filtering in Table |
| 5.7 | Removing the Duplicate Record |
Day 2
Advanced Excel Lesson 6: Using Auto Filter
| 6.1 | Sorting Data |
| 6.2 | Using AutoFilter |
| 6.3 | Creating a Custom AutoFilter |
| 6.4 | Using Advanced Filter |
| 6.5 | Using Database Functions |
Advanced Excel Lesson 7: Getting Most from your Data
| 7.1 | Creating Subtotal |
| 7.2 | Using Automatic Outline |
| 7.3 | Grouping Data Manually |
| 7.4 | Using Data Validation |
Advanced Excel Lesson 8: Working with Charts
| 8.1 | Creating a Chart |
| 8.2 | Formatting the Chart |
| 8.3 | Adding Labels |
| 8.4 | Changing the Chart Type |
| 8.5 | Changing the Data Source |
| 8.6 | Changing the Chart Location |
Advanced Excel Lesson 9: Working with Pivot Tables
| 9.1 | Creating Pivot Tables |
| 9.2 | Adding Pivot Table Report Fields |
| 9.3 | Refreshing Pivot Table Report |
| 9.4 | Changing the summary function |
| 9.5 | Changing the Layout |
| 9.6 | Creating report filter pages |
| 9.7 | Creating Pivot Chart |
Advanced Excel Lesson 10: Creating and Using Shared Workbooks
| 10.1 | Sharing a Workbook |
| 10.2 | Opening and Editing a Shared Workbook |
| 10.3 | Tracking Changes |
| 10.4 | Resolving Conflicts in a Shared Workbook |
Advanced Excel Lesson 11: Working with Worksheet Protection
| 11.1 | Protecting your Worksheets |
| 11.2 | Protecting range with password |
| 11.3 | Protecting your Workbook |
| 11.4 | Protecting your Excel Files |
Advanced Excel Lesson 12: Working with Multiple Workbooks
| 12.1 | Linking Workbooks |
| 12.2 | Editing the Link |
| 12.3 | Consolidating Workbooks |
Advanced Excel Lesson 13: Working with Macros
| 13.1 | Display the Developers Tab |
| 13.2 | Changing Macro Security Settings |
| 13.3 | Running a Macro |
| 13.4 | Recording a Macro |
| 13.5 | Deleting a Macro |
Advanced Excel Lesson 14: Scenarios in Excel 2007 (Optional)
| 14.1 | How to Create a Report from a Scenario (Optional) |
| 14.2 | Auditing Tools (Optional) |
Advanced Excel Training Course Prerequisites:
- This course is not for Excel beginners. If you do not know how to copy information from one Excel worksheet cell to another, then this course is not for you... join our Excel for Beginners / Intermediate training program first.
- Join the Advanced Microsoft Excel workshop only if you have been using Microsoft Excel for atleast 3 months, know the basics, and are ready to learn the more advanced functions, tricks and techniques of Microsoft Excel.
Register for the 2 Day Advanced Microsoft Excel Class Today.
Simply Register Online, and book your seat today. Or send an online enquiry if you have any questions. You can call us at 6296-2995.
To claim SDF Funding of $32 for this training, you must register for the training at the SkillsConnect website. This SDF funding is available to ALL companies registered in Singapore. The funding is not available to individuals - only available if you apply through your company.
Call Kamini at 9066-9991 or email to training@intellisoft.com.sg for any questions, or to register for the upcoming class.