
Lesson 9: Protecting Your Worksheet and Workbook Lesson 8: Working with Multiple Workbooks Using The New Pareto Chart Functionality.Lesson 5: Working with Charts in Excel 2016 Quick Analysis With New Features of Excel 2016.Display Special Formatting for First/Last Column.Lesson 4: Managing, Sorting & Filtering Tables Viewing the Formulas (and not the results).Locating Cells with Conditional Formatting.Changing the Conditional Formatting Rules.SkillsFuture credits ready for Individual Singaporeans upgrading their skills in Excel Formulas and Functions.ĭetailed Course Outline for Advanced Excel Training Lesson 1: Using Custom & Conditional Formats Call +65 6296-2995 for Details on the Training Fee funding available to companies. SDF Funding is available to Singapore Companies ( For company sponsored candidates).

#HOW TO USE VLOOKUP IN EXCEL 2016 YOUTUBE HOW TO#
Practical hands-on training on how to use pivot table in excel, perform VLOOKUP in Excel, In-built Excel functions, Advanced Excel formula & more… Absolutely must for every Excel warrior” – Marina Bay Sands

I’d definitely recommend it to all my colleagues to attend their Microsoft training at Intellisoft in Singapore. The trainers are professional, patient, and the staff is very helpful. The Advance Excel Formulas, Named Ranges, and keyboard shortcut tips are well worth the time and money spent training at Intellisoft for the Advanced Excel Class.

Advanced Excel 2016 Training at Intellisoft Singapore
#HOW TO USE VLOOKUP IN EXCEL 2016 YOUTUBE MANUAL#
With automation using Excel Macros, manual steps have been reduced to a couple of keystrokes only. “ The VLookup & Pivot Table techniques I learned in Advanced Excel 2016 training have helped me in my work immensely.
