Excel for Payroll, Tax and Bookkeeping
Details
Excel for Payroll, Tax and Bookkeeping
Saturday October 22, 2022
8:00 AM – 5:00 PM
Unit 3C Marsk Bldg., Aurora Boulevard corner Balete Drive, Barangay Kaunlaran, Quezon City 1111 (near UnionBank and Robinsons Magnolia)
No. slots: 13
Who can join?
-
Business Owners, Entrepreneurs, Finance and Accounting Professionals, Bookkeepers, Supervisor, Managers, and Heads
Requirements:
-
Bring your Windows laptop
-
Must have MS Excel installed.
-
Basic skill in Accounting and spreadsheet is required
Inclusions:
-
Light snacks and meal
-
Softcopies of Handouts and Excel templates
-
Certificate
Objective:
-
Walkthrough with Excel functions required for the process
-
Learn dynamic data, structured references, and more Excel functions and tools
-
Calculate payroll using Excel functions
-
Create dynamic tax reports to be able to record and summarize financial data in Excel
Outline
-
Excel tools for the process
Understanding Functions
Name Ranges and Formula -
Payroll Preparation in Excel
Payroll Sheet preparation
Working with Tax Table and SSS Table
Accounting Entries of payroll
Producing Pay slip -
Preparation of Dynamic Tax Reports in Excel
Working with 1601C
Working with 2307, 0619E, 1601EQ -
Accounting in Excel
Working with Double entry records
Techniques in Summarizing Data
Speaker/s
Jaicon Ruedas has been conducting on-site and online training for several years.
- He received certification from Asian College for training in Microsoft Excel.
- He is a Certified Microsoft Office Specialist - Excel Expert
- He develops programs using VBA, and Python and manages business data SQL and Access and other ETL and data modeling and visualization in Power BI
- He already trained hundreds of professionals, entrepreneurs, and employees from various companies such DITO Telecommunity, Frontier Towers, Froneri Philippines, ZARA Philippines, DSLU Dasmarinas, PetWarehouse etc.
- JTR Training Consultancy Services owned by him is awarded as Best Reliable Microsoft Training Service Provider at the 15th Golden Globe Award for Business Excellence
Special Offer
Schedules
| Sat | 08:00 AM — 05:00 PM |
| No. of Days: | 1 |
| Total Hours: | 8 |
| No. of Participants: | 13 |
Providing training for MS Excel, MS Access and Power BI for individual, group and company. Inquire now to request details and schedules.
We cater tutorial services and online and onsite training conducted by expert and certified Microsoft trainer. Upskill and invest an in-demand skill. We ensure that you acquire the required efficiency and productivity in data management , analysis and visualization through Excel and other Microsoft Offices.
Related Courses
