Published 1/2023MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 949.12 MB | Duration: 0h 59m
Learn Problem Solving, Basic Formatting in Excel, Data Clean-up & Data Analysis What you'll learn Identify the problem causing Financial Loss in the Case Study Combine, Clean up & Format Data Rearrag the Data With Pivot Tables Utilizing multiple reports to help with solving the problem Simplifying Data Analysis with new data Requirements Microsoft Excel No prior knowledge required Desire to learn new things Willingness to learn and practice Description Welcome to the Excel For The Real World Course where I will walk you through a Financial Impact Case Study!This course designed to give you the knowledge and tools you need to confidently analyze and interpret financial data using Excel. The course solves the below real world scenario:The employer pays a semi-monthly Remote Work Stipend to cover any expenses (i.e., internet). On December 23rd 2022 the Accounting Department submitted payments for everyone from January 1st, 2023, to December 31st, 2023. After a review by an auditor, it turns out that there was a 91-day waiting period from the hire date for the employee to b receiving the semi-monthly stipend. The auditor also found that some of the employees that received the Remote Work stipend were not eligible because they had been teated from the job.Your task as an analyst is to analyze the data and figure out the financial impact of this error.Reports needed:1. Employer payment report showing each employee payments by month2. Report showing teation dates3. Start Date Report While this course is tailored for bner and intermediate users, the problem solving skills displayed in the this can help advanced users as well. Therefore, This course is perfect for professionals in finance, accounting, and business who want to take their Excel skills to the next level and make better, data-driven decisions. Overview Section 1: Microsoft Excel For The Real World: Financial Impact Case Study Lecture 1 Our Problem and What We Need to Solve it Lecture 2 Combine, Clean up & Format Data Lecture 3 Rearrag the Data With Pivot Tables Lecture 4 Utilizing the Employee Start Date Report Lecture 5 Utilizing the Employee Teation Date Report Lecture 6 Analysis With New Data Any Analyst who works with Data,Anyone wanting to improve their Excel problem solving skills,Students looking for real world examples of how Excel is used HomePage:
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.