#Microsoft office excel 2013 advanced manual

To improve productivity, enhance spreadsheets with templates, charts, graphics, and advance excel formulas and streamline their operational work.

Participants will learn to use advanced excel functions of Excel® 2013.

A Quick Introduction to Macro Programming in Excel.

Placing a Macro on the Quick Access Toolbar.

Lesson 9: Protecting Your Worksheet and Workbook Lesson 8: Working with Multiple Workbooks Display Special Formatting for First or Last Column.Lesson 4: Managing, Sorting & Filtering Tables Viewing the Formulas (and not the results)Īdding and Counting only the Cells you Specify.Locating Cells with Conditional Formatting.Changing the Conditional Formatting Rules.Lesson 1: Using Custom & Conditional Formats To read more, pls visit Calculating CPF Contribution for Employees in Singapore The employer contributes 6.5 to 16% of the salary to the CPF Fund, depending on the age of the worker. In Singapore, all salaried employees need to contribute 5-20% of their salary, depending on age into their Central Provident Fund ( also called as CPF). It could be income tax – tax deducted at source,or it could be Provident Fund, or some other voluntary contribution. Most countries have some kind of mandatory deduction to the income. Recommended Reading: Calculating CPF Contribution for Employees in Singapore We also have Advanced Excel training on older versions of Microsoft like:Īttend the Advanced Excel 2013 Training in Singapore if you want to learn:Ĭourse Duration for Microsoft Excel 2013 Training: 2 days Practical hands-on training on excel pivot table, vlookups in excel, excel functions, advance excel formula & more… Absolutely essential training for every corporate user.” – Standard Chartered Bank

#Microsoft office excel 2013 advanced manual

Manual steps that used to take hours will now take only a few minutes with the use of advanced excel formulas, macros and other excel tricks I learnt in the Excel 2013 workshop. “ The Pivot Table techniques alone are priceless! The Advanced Excel training will help me get my job done very quickly and easily. SkillsFuture credits ready for Singaporeans. SDF Funding is available to Singapore Companies ( For company sponsored candidates).