Beginner to Pro in Microsoft Excel: Business Data Analysis

Focused View

Peter Mutunga

5:33:09

307 View

1. Introduction Shopping List Data

1.1 Quick Guide to the Excel Worksheet Window.html

1. The Excel Window.mp4

07:24

2. Entering Data & Performing Simple Calculations.mp4

08:56

3. Knowledge Check.html

4. Quick Overview Editing and Formatting.mp4

03:28

5. Visualizing Data.mp4

04:41

6. Basic Formatting and Calculation Practice.html

2. Getting Familiar With Excel E-Commerce Data

1.1 Lecture 5.xlsx

1. Formatting.mp4

15:47

2. Functions and Formulas.mp4

13:08

3. Basic Data Analysis Descriptive Statistics.mp4

07:28

4. Introduction to Microsoft Excel.html

5. Mixed and Cross Referencing.mp4

11:00

6. Visual Analysis Graphs and Sparklines.mp4

13:31

7. Cross Referencing.html

3. Advance Formulas, Functions, and Formatting Real Estate Data

1.1 Real Estate Mortgage.xlsx

1. Loan Terms Analysis Interest Rates, Monthly Payments, Name Range.mp4

19:39

2. Multi-Level Sorting, Subtotals, Interactive Summary Report and Chart.mp4

10:13

3. Accuracy Check.html

4. Data Filtration With Excel.mp4

09:24

5. Progress Assessment.html

6. Advance Formatting Conditional Formatting.mp4

07:52

7. Grouping with Pivot Tables.mp4

11:42

8. Pivot Table Assignment.html

4. Data Consolidation and Validation IT Services Business Data

1.1 Grouping Data.xlsx

1. Grouping and Formatting Multiple Worksheets.mp4

08:50

2. 3D Formulas for Consolidation.mp4

09:50

3. Data Validation Rule Error Alert.mp4

06:10

4. SUMIF and Cell Linking.mp4

09:58

5. Demo Calculator Validation Rules and VLOOKUP.mp4

12:47

6. VLOOKUP Exercise.html

5. Advance Applications Mortgage & Rental Income Data

1.1 Section 5.xlsx

1. Logic Operations Logical Comparison.mp4

14:06

2. Create a Search Function Index, Match, IFERROR, and Freeze Panes.mp4

18:49

3. Loan Amortization Monthly Pay, Payment Date, Principle Payment, Ending Balance.mp4

16:23

4. Test your understanding.html

5. Excel Efficiency AVERAGEIF vs Pivot Tables.mp4

13:50

6. Section 6 Income Statement Analysis

1.1 Section 6_.xlsx

1. What If Analysis One-Variable Table.mp4

11:06

2. What If Analysis Two-Variable Table and Goal Seek.mp4

10:56

3. What If analysis Scenario Summary.mp4

10:48

4. Scenario Summary Practice.html

7. Section 6 Expert Tools

1. Upload and Format TXT file.mp4

08:55

2. Email Automation Customer Thank You Email.mp4

14:23

3. Simple Data Entry Forms.mp4

09:18

4. Macros in Excel.mp4

12:47

5. Import Text to Excel.html

Description

Analyze business data: includes business scenarios, loan data, real estates data, pivot table analysis, and more!

What You'll Learn?

Given business information throughout the course, students will be able to demonstrate the following course objectives by the end of this course:
Organize and format business data using appropriate cell formatting, page options, cell ranges, and documentation sheets to document the spreadsheet.
Create a spreadsheet that allows for data input and output as well as data analysis in response to a business case that requires the use of formulas.
Forecast future sales, profits, or expenses using the What-If analysis to facilitate business decision making.
Analyze and then graphically present data from a business case involving various categories of data using charts.
Given a business case requiring the analysis of data, develop and perform strategies to sort, search, retrieve, and interpret data.
Summarize similar data for multiple divisions of a company and organize and present this data into useful information for business reporting and decision making
Given a business case requiring data input by other users, create a spreadsheet to accept user input, perform calculations, and automate repetitive tasks
Develop documentation for Excel files and devise security measures to protect the integrity of the file’s functions and design.
Import, clean, and analyze data from text file types.
Add relevant hyperlinks and create reusable "thank you" email templates for your customers or target audience.

Who is this for?

Small and medium-sized business owners

Online sellers on eBay, Alibaba, Amazon, BestBuy, e.t.c.

Upcoming online business owners

What You Need to Know?

No MS Excel experience needed. Students will learn everything about MS Excel from scratch. More importantly, you'll practice with different business data, including real estate, e-Commerce, and banking data (loans).

Excel (2010 - Office 365)

More details

Description
From beginner to expert in Microsoft Excel
This course will provide step-by-step tutorials to help you build and acquire basic Microsoft Excel skills. It doesnâ€™t matter if you have experience working with MS Excel or not; this course is designed to walk you through all the basic and most advanced functions of Excel.

This Microsoft Excel course involves using four (4) different business scenarios/cases to help you grasp the effectiveness of Excel across different settings.
In Section One, weâ€™ll use a sample e-Commerce data set to understand the basic functions of Excel in business.
In Section Two, weâ€™ll use real estate sales data for more complex Excel functions such as reporting, visual presentations, and mortgage calculations.
In Section Three, weâ€™ll use IT Service Business data to demonstrate Excel's complex functions, data validation, and consolidation features.
In Section Four, weâ€™ll use Rental Income data to search and compare logic conditions and perform a loan amortization schedule for house buyers.
Finally, weâ€™ll step into a more advanced Excel tool for data forecast and prediction. Weâ€™ll utilize the What-If analysis to analyze the Income Statement under three conditions:
Using a one-variable data set
Using a two-variable data set
Using optimistic, midrange, and pessimistic business scenarios.
But thatâ€™s not all! How about we fire up more advanced features in Excel, including the Developer Tool (Macros), hyperlinks, and automatic emails, and convert TXT (text) files to CSV (MS Excel) files?

You will master the Learning Objectives as you work through these tutorials, which will provide you with a strong foundation in advanced spreadsheet functionality and enable you to astound your coworkers, friends, and family as you investigate numerous ways spreadsheets could be used to access, manage, manipulate, and report data. You'll learn how to use spreadsheets to help you make better business decisions through tutorials and case studies.

This course starts with the basics of Microsoft Excel, intended to refresh your knowledge and understanding of the Microsoft Excel interface. The first few lectures discuss formatting, editing, basic calculations, manipulation, and general data entry activities. We'll slowly transition into advanced topics in Excel, where your learning will be significantly enhanced. As we progress towards advanced topics in Microsoft Excel, we'll think about how this product contributes to business decision-making through data analysis in the work environment or your everyday life. Below are just a few topics that you will master:
Excel Fundamentals and Formulas: entering data to spreadsheets, creating formulas and functions that require relative and absolute cell referencing; format cells based on different data types (i.e., dates, numbers, currency, etc.); format spreadsheet background to promote readability; merge cells; arrange worksheets into logical sections to allow reusability and reliability of your Excel files; simplify expressions used in calculations.
Excelâ€™s Advanced Formulas, Functions, and Charts: Utilize typical financial, mathematical, string, lookup, and logical functions; explore functions such as PMT(), FV(), PV(), IPMT(), PPMT(), NPV(), LEFT(), RIGHT(), VLOOKUP(), and logic operators (AND, OR); Identify the type of chart (line, bar, pie) that is most appropriate for your business case scenario; interpret and summarize the findings of your graphs and data analysis.
Data Analysis Functions: provide meaningful names to cell ranges to improve efficiency and productivity when working with Excel; create a spreadsheet for efficient retrieval and entry of data; create automated data analysis techniques for better and efficient data presentation and analysis; create pivot tables and conditional formation rules; create filters to meet specific criteria, utilize subtotals to summarize listed information.
Consolidating Data: add comments in cells to label or clarify characteristics of data; consolidate and automatically summarize information from various sources such as different workbooks and multiple worksheets; manage multiple and individual worksheets by grouping; utilize 3-D references and mathematical functions to consolidate data from other worksheets; merge data collection from multiple sources into a single worksheet.
What-If Analysis, Importing, and Macros: determine the optimal solution for business considering given parameters and constraints; utilize Goal Seek to predict sales; infer meaning to the results of forecasts and multiple What-If analyses; import, clean, and analyze text data in Excel; define and implement security precautions in your spreadsheet; identify the repetitive task and automate them with Macros; create validation rules to restrict the entry of new or inappropriate data.

Whatâ€™s Included?
5+ hours of step-by-step video lectures by an experienced trainer.
Quizzes and prompt questions to test your understanding of course material.
Downloadable files you can use to follow along and practice with.
Labs at the end of each section to test your understanding.
I have designed this course so that you can master Microsoft Excel in less time and with ease. If you are an absolute beginner at Excel or are interested in getting to know the program better, this course will teach you how to use Excel's features for data analysis.
Enrolling in this course marks your journey to mastering Excel and becoming an Expert who is confident in your ability to use Microsoft Excel for various tasks.

Who this course is for:
Small and medium-sized business owners
Online sellers on eBay, Alibaba, Amazon, BestBuy, e.t.c.
Upcoming online business owners

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

Business Analysis

Excel

Business Analytics

Peter Mutunga

Instructor's Courses

Peter is a Math and Statistics teacher and has been teaching college and high school students for the past 8+ years using various computer applications, including:Microsoft Office ApplicationsPythonR ProgramSPSSPeter is a Jomo Kenyatta University of Agriculture and Technology graduate in the Applied Mathematics and Statistics program. He has worked with students and learning institutions across the globe as a teacher in Mathematics, Statistics, Physics, and Project Management. Peter has facilitated classes that range from 1-on-1 interactions with students from the US, UK, and Canada, including live sessions and interactive/lab classes.Peter has also worked in other competitive sectors, thanks to his Project Management skills. He has worked with individuals and small to medium-sized companies, mainly focusing on Software Development Projects, Business Plans, budgets, financial projects, and integrated planning to maintain organizational systems and structures.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.