This certificate is administered by ICDL Singapore. ICDL Advanced Certification in Microsoft Excel: Successful trainees will receive the internationally recognized ICDL Certificate upon completion of the course. Advanced Excel Course Participants should have completed the Basic Excel training, or demonstrate the basic proficiency in using Spreadsheets – things like basic formatting, copying cells, opening spreadsheets, moving, renaming sheets, writing simple formulas to do basic arithmetic.We look for participants with Secondary education as a pre-requisite.Any learner with a basic proficiency in reading, writing, and understanding English can pick up the Advanced Excel Skills easily.Pre-requisites: Advanced Excel Training Course Singapore Module 11: Record & Run Excel VBA Macros Easily Embed Excel Data in Microsoft Word, with automatic updating options. ![]() Linking & Embedding Data & Hyperlinks in Files.Working With Multiple Sheets & Excel Workbooks.Module 9: Linking, Embedding & Importing Data Adding Sub-Totals & Viewing Grand Totals.Creating Custom Lists & Sorting Patterns.Sorting Multiple Levels of Columns easily.Module 7: Enhance Productivity With Microsoft Excel Adding Custom Messages for Error Handling.How to only allow Valid Data to avoid errors.Module 6: Validating and Auditing Excel Data Visualize Summarized Data for Deeper Insights using Microsoft Tools.Summarizing Information With Pivot Tables. ![]() ![]() Automatic & Manual Grouping of Pivot Data.Module 5: Master Pivot Table Creation & Analysis Creating Outlines with Automatic Grouping of Data in Microsoft Office.Scenario Analysis to Understand various situations & Play What-If using Excel.Create 2 Axis Combination Charts in Excel.Creating & Formatting Simple & Advanced Charts.Master Lookup Functions like Vlookup & Hlookup.Copying & Moving Sheets Within Multiple Workbooks.Introducing Intellisoft Training To You. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |