• views: 111
• date: 19 January 2023
• posted by: voska89

What you'll learn
Identify the problem causing Financial Loss in the Case Study
Combine, Clean up & Format Data
Rearranging 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 begin 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 terminated 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 termination dates3. Start Date Report While this course is tailored for beginner 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 Rearranging the Data With Pivot Tables
Lecture 4 Utilizing the Employee Start Date Report
Lecture 5 Utilizing the Employee Termination 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

https://www.udemy.com/course/realfinance/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.