[ CoursePig.com ] Udemy - Excel Automating HR Payroll Reports with Power Query
~Get Your Files Here !/1. Data Cleansing & Manipulations/1. Course Summary.mp4 9.5 MB ~Get Your Files Here !/1. Data Cleansing & Manipulations/1. Course Summary.srt 3.1 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/1.1 Course Syllabus.JPG 110.3 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/2. Load and Transform Data.mp4 93 MB ~Get Your Files Here !/1. Data Cleansing & Manipulations/2. Load and Transform Data.srt 14.7 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/3. Managing Mapping Tables 1.mp4 116.5 MB ~Get Your Files Here !/1. Data Cleansing & Manipulations/3. Managing Mapping Tables 1.srt 23.1 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/3.1 Training Flow.JPG 121.2 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/4. Managing Mapping Tables 2.mp4 142.5 MB ~Get Your Files Here !/1. Data Cleansing & Manipulations/4. Managing Mapping Tables 2.srt 19.5 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/01. Data/01. Staff List/StaffList_0121.xlsx 19.6 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/01. Data/01. Staff List/StaffList_0221.xlsx 19.7 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/01. Data/01. Staff List/StaffList_0321.xlsx 20.7 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/01. Data/01. Staff List/StaffList_0421.xlsx 19.7 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/01. Data/01. Staff List/StaffList_0521.xlsx 19.7 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/01. Data/01. Staff List/StaffList_0621.xlsx 20 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/01. Data/01. Staff List/StaffList_0721.xlsx 20.2 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/01. Data/01. Staff List/StaffList_0821.xlsx 20.3 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/01. Data/01. Staff List/StaffList_0921.xlsx 20.4 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/01. Data/01. Staff List/StaffList_1021.xlsx 20.4 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/01. Data/01. Staff List/StaffList_1121.xlsx 21.5 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/01. Data/01. Staff List/StaffList_1221.xlsx 20.6 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/01. Data/03. Others/Consol Payroll 2021.xlsx 2.3 MB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/01. Data/03. Others/Consol Payroll 2021_test.xlsx 2.3 MB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/01. Data/04. Forecast/Forecast 2022.xlsx 58.7 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/02. Map/Award List.xlsx 11.2 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/02. Map/CC List.xlsx 9.9 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/02. Map/Company.xlsx 8.8 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/02. Map/Payroll Calc Info.xlsx 21.4 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/02. Map/Rank List.xlsx 8.9 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/02. Map/Referral List.xlsx 10.4 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/02. Map/Salary List.xlsx 19.3 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/01. New/~$Payroll Calc test.xlsx 165 B ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/01. Staff List/StaffList_0121.xlsx 19.6 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/01. Staff List/StaffList_0221.xlsx 19.6 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/01. Staff List/StaffList_0321.xlsx 20.7 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/01. Staff List/StaffList_0421.xlsx 19.7 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/01. Staff List/StaffList_0521.xlsx 19.7 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/01. Staff List/StaffList_0621.xlsx 20 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/01. Staff List/StaffList_0721.xlsx 20.2 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/01. Staff List/StaffList_0821.xlsx 20.2 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/01. Staff List/StaffList_0921.xlsx 20.3 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/01. Staff List/StaffList_1021.xlsx 20.4 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/01. Staff List/StaffList_1121.xlsx 21.5 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/01. Staff List/StaffList_1221.xlsx 20.6 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/02. Payroll Data/Payroll Calculator_0121.xlsx 257.4 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/02. Payroll Data/Payroll Calculator_0221.xlsx 258.4 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/02. Payroll Data/Payroll Calculator_0321.xlsx 260.1 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/02. Payroll Data/Payroll Calculator_0421.xlsx 260.7 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/02. Payroll Data/Payroll Calculator_0521.xlsx 260.3 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/02. Payroll Data/Payroll Calculator_0621.xlsx 265.2 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/02. Payroll Data/Payroll Calculator_0721.xlsx 271.2 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/02. Payroll Data/Payroll Calculator_0821.xlsx 270.2 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/02. Payroll Data/Payroll Calculator_0921.xlsx 273.4 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/02. Payroll Data/Payroll Calculator_1021.xlsx 274.8 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/02. Payroll Data/Payroll Calculator_1121.xlsx 276.4 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/02. Payroll Data/Payroll Calculator_1221.xlsx 279.2 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/03. Others/Consol Payroll 2021.xlsx 2.4 MB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/04. Forecast/Forecast 2022.xlsx 2.2 MB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/01. Data/04. Forecast/PCost Analysis.xlsx 4.7 MB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/02. Map/Award List.xlsx 12.2 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/02. Map/CC List.xlsx 11.1 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/02. Map/Company.xlsx 9.9 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/02. Map/Payroll Calc Info.xlsx 24.8 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/02. Map/Rank List.xlsx 10 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/02. Map/Referral List.xlsx 11.3 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/02. Map/Salary List.xlsx 20.4 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/Payroll Calculator.xlsx 257.4 KB ~Get Your Files Here !/1. Data Cleansing & Manipulations/Automating HR Payroll Reports with Power Query/02. Done/~$Payroll Calc test.xlsx 165 B ~Get Your Files Here !/2. Automating Payroll Calculations using Power Query/1. Merge Query “Rules” To Payroll Calculator.mp4 279.5 MB ~Get Your Files Here !/2. Automating Payroll Calculations using Power Query/1. Merge Query “Rules” To Payroll Calculator.srt 43.6 KB ~Get Your Files Here !/2. Automating Payroll Calculations using Power Query/2. Calculate Payroll Using Simple Formula.mp4 57.8 MB ~Get Your Files Here !/2. Automating Payroll Calculations using Power Query/2. Calculate Payroll Using Simple Formula.srt 10.4 KB ~Get Your Files Here !/2. Automating Payroll Calculations using Power Query/3. Calculate Payroll Using Conditional Formula 1.mp4 58.3 MB ~Get Your Files Here !/2. Automating Payroll Calculations using Power Query/3. Calculate Payroll Using Conditional Formula 1.srt 10.2 KB ~Get Your Files Here !/2. Automating Payroll Calculations using Power Query/4. Calculate Payroll Using Conditional Formula 2.mp4 113.3 MB ~Get Your Files Here !/2. Automating Payroll Calculations using Power Query/4. Calculate Payroll Using Conditional Formula 2.srt 17.9 KB ~Get Your Files Here !/2. Automating Payroll Calculations using Power Query/4.1 Flow Chart.JPG 90.3 KB ~Get Your Files Here !/2. Automating Payroll Calculations using Power Query/5. Calculate Payroll Using Conditional Formula 3.mp4 145.9 MB ~Get Your Files Here !/2. Automating Payroll Calculations using Power Query/5. Calculate Payroll Using Conditional Formula 3.srt 19.6 KB ~Get Your Files Here !/2. Automating Payroll Calculations using Power Query/6. Calculate Payroll Using Conditional Formula 4.mp4 137.4 MB ~Get Your Files Here !/2. Automating Payroll Calculations using Power Query/6. Calculate Payroll Using Conditional Formula 4.srt 17.5 KB ~Get Your Files Here !/3. Automating Payroll Reports and Analysis using Pivot Tables/1. Creating Payroll Analysis.mp4 156.6 MB ~Get Your Files Here !/3. Automating Payroll Reports and Analysis using Pivot Tables/1. Creating Payroll Analysis.srt 23.2 KB ~Get Your Files Here !/4. Creating Payroll Reports for Finance Department/1. Creating Payroll Reports for Finance Department.mp4 134.4 MB ~Get Your Files Here !/4. Creating Payroll Reports for Finance Department/1. Creating Payroll Reports for Finance Department.srt 17.9 KB ~Get Your Files Here !/4. Creating Payroll Reports for Finance Department/2. Update and Consolidate Monthly Payroll Data.mp4 199.5 MB ~Get Your Files Here !/4. Creating Payroll Reports for Finance Department/2. Update and Consolidate Monthly Payroll Data.srt 27.5 KB ~Get Your Files Here !/5. Managing Budget & Forecast Exercises/1. Budget & Forecast Exercises – Personnel Cost 1.mp4 168.3 MB ~Get Your Files Here !/5. Managing Budget & Forecast Exercises/1. Budget & Forecast Exercises – Personnel Cost 1.srt 23.6 KB ~Get Your Files Here !/5. Managing Budget & Forecast Exercises/2. Budget & Forecast Exercises – Personnel Cost 2.mp4 153.9 MB ~Get Your Files Here !/5. Managing Budget & Forecast Exercises/2. Budget & Forecast Exercises – Personnel Cost 2.srt 24.1 KB ~Get Your Files Here !/5. Managing Budget & Forecast Exercises/3. Budget & Forecast Exercises – Personnel Cost 3.mp4 202.4 MB ~Get Your Files Here !/5. Managing Budget & Forecast Exercises/3. Budget & Forecast Exercises – Personnel Cost 3.srt 31.7 KB ~Get Your Files Here !/5. Managing Budget & Forecast Exercises/4. Budget & Forecast Exercises – Personnel Cost 4.mp4 173 MB ~Get Your Files Here !/5. Managing Budget & Forecast Exercises/4. Budget & Forecast Exercises – Personnel Cost 4.srt 25 KB ~Get Your Files Here !/5. Managing Budget & Forecast Exercises/5. Personnel Cost Analysis Using Pivot Tables 1.mp4 172.7 MB ~Get Your Files Here !/5. Managing Budget & Forecast Exercises/5. Personnel Cost Analysis Using Pivot Tables 1.srt 22.9 KB