The Business Statistics and Analysis Capstone is an opportunity to apply various skills developed across the four courses in the specialization to a real life data. The Capstone, in collaboration with an industry partner uses publicly available ‘Housing Data’ to pose various questions typically a client would pose to a data analyst. Your job is to do the relevant statistical analysis and report your findings in response to the questions in a way that anyone can understand. Please remember that this is a Capstone, and has a degree of difficulty/ambiguity higher than the previous four courses. The aim being to mimic a real life application as close as possible.

This course provides an intensive conceptual and applied introduction to auditing in society. It focuses on concepts and applications related to financial-statement auditors’ professional responsibilities as well as major facets of the audit process including risk assessment and audit reporting. In the U.S. financial-statement audits and related services generally are provided by Certified Public Accountants (CPAs). To succeed in this course, you should anticipate engaging in critical thinking and thoughtful communication about audit professionals' decision environments, decision processes, and deliverables. Additionally, you should understand the macro-level learning objectives in each of the course's weekly modules.

This lesson is part of a full course, Speak English Professionally: In Person, Online & On the Phone. Take this lesson to get a short tutorial on the learning objectives covered. To dive deeper into this topic, take the full course. By the end of this lesson, you will be able to: - Practice and prepare yourself for an interview - Examine appropriate body language for interviews

This course is the third course in the five-course Financial Reporting Specialization. This course begins with a discussion of current liabilities and contingencies and continues with long-term debt and bonds. The course next explores accounting model for leases, both lessees and lessors, and a discussion on deferred tax assets and liabilities. Participants will learn the latest accounting standards including the new accounting model for leases effective for public companies in 2019 and private companies in 2020.

This project will give you the opportunity to familiarize yourself with the cloud-based platform, ProfitBooks. We will start this project by introducing you to the platform through creating an online account and taking a virtual tour of the software. This step will include updating your company profile in the settings. We will continue our introduction by building out a CRM through the customer profile feature. Once the customer profiles are created, you will be introduced to some beginner features on the platform. This project will focus on the Item feature for products and services & invoice feature for billing. Upon completion of this project, you will understand how to add customers to your CRM, inventory items and services, and invoice customers. You will have the confidence to continue towards intermediate use of ProfitBooks in a continuation series. ProfitBooks is an online accounting and payroll management software for small businesses. It allows users to organize offices finances and track all activities related to their business. This free online tool allows you to manage your money without accounting knowledge, grow sales with powerful invoicing tools, track inventory with ease, and run your business with total confidence. ProfitBooks hosts your information on the secure and widely-trusted Amazon Web Services (AWS) while implementing additional security features like secure-access, built-in firewalls, encrypted data storage and periodic back-ups. You can read more about their security policy here: https://www.profitbooks.net/cloud-data-security/.

Wharton's Applied Knowledge Capstone Project enables you to apply your analytic skills to real business challenges – including your own. You’ll use your newly earned business skills to thoughtfully evaluate a real situation or opportunity from Wharton-governed companies like Shazam and SnapDeal.

In this 2 hours project-based course you will explore Stormboard and learn all of its main functionalities, creating a business model brainstorm for your team. You will create and share "storms", use sticky notes and connectors to organize flows and dependencies, add rich content and collaborate with shared documents and virtual whiteboards.

By the end of this project, you will learn how to enhance organizational communications with Slack, the business communications platform. To complete this project, you will create your own workspace, add public and private channels, and develop a collaborative environment. To support your new digital environment, you'll invite others to your Slack workspace and bring their contributions into unique channels for work projects, planning, brainstorming, problem-solving, and information-sharing. You will also amp up the effectiveness of workspace communications by using channel and individual tags to loop others in on relevant information. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

The use of Excel is widespread in the industry. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning. This is an introductory course in the use of Excel and is designed to give you a working knowledge of Excel with the aim of getting to use it for more advance topics in Business Statistics later. The course is designed keeping in mind two kinds of learners - those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills. The course takes you from basic operations such as reading data into excel using various data formats, organizing and manipulating data, to some of the more advanced functionality of Excel. All along, Excel functionality is introduced using easy to understand examples which are demonstrated in a way that learners can become comfortable in understanding and applying them. To successfully complete course assignments, students must have access to a Windows version of Microsoft Excel 2010 or later. ________________________________________ WEEK 1 Module 1: Introduction to Spreadsheets In this module, you will be introduced to the use of Excel spreadsheets and various basic data functions of Excel. Topics covered include: • Reading data into Excel using various formats • Basic functions in Excel, arithmetic as well as various logical functions • Formatting rows and columns • Using formulas in Excel and their copy and paste using absolute and relative referencing ________________________________________ WEEK 2 Module 2: Spreadsheet Functions to Organize Data This module introduces various Excel functions to organize and query data. Learners are introduced to the IF, nested IF, VLOOKUP and the HLOOKUP functions of Excel. Topics covered include: • IF and the nested IF functions • VLOOKUP and HLOOKUP • The RANDBETWEEN function ________________________________________ WEEK 3 Module 3: Introduction to Filtering, Pivot Tables, and Charts This module introduces various data filtering capabilities of Excel. You’ll learn how to set filters in data to selectively access data. A very powerful data summarizing tool, the Pivot Table, is also explained and we begin to introduce the charting feature of Excel. Topics covered include: • VLOOKUP across worksheets • Data filtering in Excel • Use of Pivot tables with categorical as well as numerical data • Introduction to the charting capability of Excel ________________________________________ WEEK 4 Module 4: Advanced Graphing and Charting This module explores various advanced graphing and charting techniques available in Excel. Starting with various line, bar and pie charts we introduce pivot charts, scatter plots and histograms. You will get to understand these various charts and get to build them on your own. Topics covered include • Line, Bar and Pie charts • Pivot charts • Scatter plots • Histograms

The course builds on my Introduction to Financial Accounting course, which you should complete first. In this course, you will learn how to read, understand, and analyze most of the information provided by companies in their financial statements. These skills will help you make more informed decisions using financial information.