Скачать или смотреть New Perspectives Excel 2019 Module 8 SAM Project 1a Step-by-Step Solution Tutorial Cairo Consulting

#Excel2019Module8#Excel2019SAMProject1a#Excel2019SAM#Excel2019Tutorial#Excel2019Assignment#Excel2019Capstone

Excel 2019 Module 8 SAM Project 1a Project Step by Step Tutorial

In this video, I will guide you through the Excel 2019 Module 8 SAM Project 1a. This project is based on Cairo Consulting and covers financial analysis, data tables, scenario manager, solver, pivot tables, and pivot charts. Perfect for students working on Excel assignments, projects, or exams.

Contact me for your assighnments and full course:

Email : [email protected]
WhatsApp Direct Chat : https://wa.me/+923025881332
WhatsApp Number : +923025881332

⏱️ Timestamps :

00:00 – Introduction New Perspectives Excel 2019 | Module 8: SAM Project 1a
05:58 Step 1 – One-variable Data Table
➡ Creating a one-variable data table to calculate sales, expenses, and profit based on the hours of management consulting.

12:23 Step 2 – Two-variable Data Table
➡ Making a two-variable data table to calculate gross profit using both hours contracted and hourly rate charged.

17:03 Step 3 – Scatter Chart (Change worksheet)
➡ Inserting a Scatter with Straight Lines chart for break-even analysis of organizational change.

18:24 Step 4 – Chart Modifications
➡ Resizing chart, removing title, and adding axis titles for Sales, Expenses, and Hours Contracted.

22:14 Step 5 – Axis Bounds & Formatting
➡ Adjusting axis minimum & maximum bounds, applying currency format, and customizing the chart scale.

27:19 Step 6 – Scenario Manager (Standard vs Certified)
➡ Creating two scenarios in Scenario Manager to compare costs of standard consultants vs certified consultants.

32:07 Step 7 – Scatter Chart (Process worksheet)
➡ Building another Scatter with Straight Lines chart for Process Consulting – Net Income Analysis and formatting it.



What you will learn in this tutorial:
How to create One-variable and Two-variable Data Tables in Excel
How to insert and format Scatter Charts with Straight Lines
How to apply Axis Bounds, Number Formatting, and Currency Symbols
How to use Scenario Manager to compare costs and profits
How to run Solver in Excel for cost minimization and optimization
How to build Scenario Summary Reports & PivotTables
How to add and format a PivotChart for better visualization


This video is especially useful for:
Students working on Excel 2019 SAM or Capstone Projects
Learners preparing for Excel practical exams
Professionals learning Excel for financial and business data analysis


#New Perspectives Excel 2019, #Excel 2019 Module 8 SAM Project 1a, #Excel SAM Project 2019, #Excel Module 8 Tutorial, #Excel SAM Capstone Project, #Excel 2019 Training, #Excel 2019 Data Analysis, #Excel 2019 Homework Help, #Excel 2019 Assignment Solution, #SAM Project Excel 2019 Module 8, #Excel 2019 Project Step by Step, #New Perspectives Excel Tutorial, #Excel 2019 Practice Project, #Excel 2019 What If Analysis, #Excel 2019 PivotTable Project, #Excel 2019 Solver Project


#Excel2019Module8,#Excel2019SAMProject1a,#Excel2019SAM,#Excel2019Tutorial,#Excel2019Assignment,#Excel2019Capstone,#Excel2019Practice,#Excel2019Projects,#Excel2019Students,#Excel2019,#SAMProject,#ExcelTutorial,#ExcelAssignment,#ExcelTraining,#ExcelCapstone,#ExcelPractice,#ExcelProjects,#ExcelStudents,#ExcelWorkbook,#NewPerspectivesExcel,#ExcelDataAnalysis,#ExcelStepByStep,#ExcelLearning,#ExcelHomeworkHelp,#Cairo Consulting,#Consulting,#NP_EX19_8a,#EX19_8a,#8a