✔ Are you stuck with calculating Bonus, CPF, Tax, Leave Records, Overtime etc. for your company manually?
✔Struggling to maintain HR records with people joining & leaving all the time?
✔ Spending WAAAY Too Long to manage & track all this HR data?
✔ Are you worried about meeting the Salary & Tax deadlines due to complex calculations?
Having a Strong Foundation in Microsoft Excel Helps in Managing Large Amounts of HR / Accounts data Quickly & Easily
In this practical training, you will Learn to Manage Large amount of data easily with the help of Formulas, Functions, Vlookup, Pivot Tables, Charts, Macros & more Advanced Techniques.
Lesson 1: How to use formula fundamentals
Lesson 2: Specific text functions for HR applications
Lesson 3: How to use pivot table and charts
Lesson 4: Learn Lookup Functions for Easy Referencing
Lesson 5: Avoiding invalid data entry errors
Lesson 6: Combining several workbooks to create a summary
Lesson 7: Securing and reviewing your worksheet
Lesson 8: Creating a quick chart to display HR data
You are able to manipulate charts and diagrams, use logical functions and link your spreadsheets to other worksheets and applications.
You will learn to automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.
