FreeCourseWeb com Udemy Microsoft Excel Crash Course for Business Analysts

FreeCourseWeb com Udemy Microsoft Excel Crash Course for Business Analysts

Name	[ FreeCourseWeb.com ] Udemy - Microsoft Excel Crash Course for Business Analysts	DOWNLOAD Copy Link
Total Size	4.0 GB
Total Files	303
Last Seen	2024-10-04 23:53
Hash	CB1F185261B50134F40673BC5D869A87938F9BB5

/
Get Bonus Downloads Here.url	0.2 KB
/.../1 - Introduction and Getting Started/
1 - Download Microsoft Excel.txt	0.0 KB
1 - Downloading Excel English.srt	2.1 KB
1 - Downloading Excel.mp4	10.1 MB
1 - Excel-for-Business-Analysts-All-Slides.pdf	3.3 MB
2 - Excel Shortcuts Master List.txt	0.1 KB
2 - Why Should You Use Excel English.srt	2.6 KB
2 - Why Should You Use Excel.mp4	60.4 MB
3 - Getting Familiar with the Excel Interface English.srt	9.2 KB
3 - Getting Familiar with the Excel Interface.mp4	52.0 MB
4 - The Excel Ribbon English.srt	2.8 KB
4 - The Excel Ribbon.mp4	27.0 MB
5 - How to Use the Course Resources.html	1.5 KB
/.../10 - MBA Unit 1 Performing a Digital Marketing Keyword Analysis/
100 - 5.Exercise-Segmentation-Labeling.xlsx	22.6 KB
100 - Exercise Labeling Our Keywords.html	1.5 KB
101 - 6.Bringing-It-Together.xlsx	22.8 KB
101 - Bringing It All Together English.srt	4.9 KB
101 - Bringing It All Together.mp4	44.1 MB
102 - 7.Pivot-and-Describe.xlsx	27.9 KB
102 - Using Pivot Tables to Explore Our Data English.srt	8.6 KB
102 - Using Pivot Tables to Explore Our Data.mp4	56.5 MB
89 - Slides.pdf	911.9 KB
89 - What is Search Marketing English.srt	3.7 KB
89 - What is Search Marketing.mp4	69.5 MB
90 - What is Search Intent English.srt	4.5 KB
90 - What is Search Intent.mp4	48.0 MB
91 - What is Keyword Analysis and What are the Steps English.srt	3.5 KB
91 - What is Keyword Analysis and What are the Steps.mp4	24.0 MB
92 - Case Study Creating an ECommerce Site English.srt	2.9 KB
92 - Case Study Creating an ECommerce Site.mp4	3.9 MB
93 - Create a Seed List for Keyword Analysis English.srt	4.4 KB
93 - Create a Seed List for Keyword Analysis.mp4	8.7 MB
94 - 1.Google-Keyword-Planner.xlsx	10.3 KB
94 - Finding Keyword Ideas Using Google Keyword Planner English.srt	9.8 KB
94 - Finding Keyword Ideas Using Google Keyword Planner.mp4	66.1 MB
95 - Manipulate Your Data Steps English.srt	2.2 KB
95 - Manipulate Your Data Steps.mp4	4.0 MB
96 - 2.Preliminary-Cleaning.xlsx	304.8 KB
96 - Manipulate Your Data Preliminary Data Cleaning English.srt	5.1 KB
96 - Manipulate Your Data Preliminary Data Cleaning.mp4	39.2 MB
97 - 3.Keyword-Cleaning.xlsx	16.2 KB
97 - Manipulate Your Data Keyword Cleaning English.srt	9.5 KB
97 - Manipulate Your Data Keyword Cleaning.mp4	74.9 MB
98 - 4.Segmentation-Labeling.xlsx	18.4 KB
98 - Manipulate Your Data Keyword Labeling English.srt	12.2 KB
98 - Manipulate Your Data Keyword Labeling.mp4	96.9 MB
99 - Optional Creating a Key for Keyword Analysis.html	0.6 KB
/.../11 - MBA Unit 2 Building Basic Financial Models/
103 - 12.Answers-Fundamentals-of-Finance.xlsx	98.8 KB
103 - 12.Start-Fundamentals-of-Finance.xlsx	93.6 KB
103 - Slides.pdf	818.2 KB
103 - The Time Value of Money and the Financial Cycle English.srt	3.4 KB
103 - The Time Value of Money and the Financial Cycle.mp4	71.4 MB
104 - Compound Interest English.srt	3.6 KB
104 - Compound Interest.mp4	43.9 MB
105 - Using Excels Future Value FV Function English.srt	3.8 KB
105 - Using Excels Future Value FV Function.mp4	11.3 MB
106 - Calculating Compound Interest English.srt	4.5 KB
106 - Calculating Compound Interest.mp4	18.5 MB
107 - Using the Future Value Mathematical Formula English.srt	3.5 KB
107 - Using the Future Value Mathematical Formula.mp4	12.6 MB
108 - How Compounding Frequency Affects Future Value English.srt	5.0 KB
108 - How Compounding Frequency Affects Future Value.mp4	19.5 MB
109 - Exercise Compounding Problem Set.html	1.3 KB
110 - What is Present Value English.srt	6.1 KB
110 - What is Present Value.mp4	17.6 MB
111 - Using Excels Present Value Function English.srt	3.6 KB
111 - Using Excels Present Value Function.mp4	10.2 MB
112 - Present Value of a Stream of Cash Flows English.srt	8.1 KB
112 - Present Value of a Stream of Cash Flows.mp4	69.1 MB
113 - Opportunity Cost English.srt	2.3 KB
113 - Opportunity Cost.mp4	27.5 MB
114 - Opportunity Cost of Capital English.srt	6.5 KB
114 - Opportunity Cost of Capital.mp4	123.6 MB
115 - Opportunity Cost of Capital in Action English.srt	3.8 KB
115 - Opportunity Cost of Capital in Action.mp4	12.5 MB
116 - Exercise Present Value Discounting Problem Set.html	1.9 KB
117 - Net Present Value NPV English.srt	4.6 KB
117 - Net Present Value NPV.mp4	16.0 MB
118 - NPV Function in Excel English.srt	1.9 KB
118 - NPV Function in Excel.mp4	5.5 MB
119 - Internal Rate of Return IRR English.srt	3.2 KB
119 - Internal Rate of Return IRR.mp4	13.2 MB
120 - Investment Decision Rules English.srt	5.4 KB
120 - Investment Decision Rules.mp4	14.1 MB
121 - Exercise Investment Decision 1.html	0.9 KB
122 - Exercise Investment Decision 2.html	1.2 KB
123 - -Answers-Solar-Case.xlsx	1.5 MB
123 - -Start-Solar-Case.xlsx	828.9 KB
123 - Case Study Solar Farms Investment Decision.html	0.1 KB
123 - Case-Study-Solar-Farms-Making-an-Investment-Decision-2.pdf	335.1 KB
124 - Case Study Solution Walkthrough English.srt	19.1 KB
124 - Case Study Solution Walkthrough.mp4	155.8 MB
/.../12 - MBA Unit 3 Performing Regression Analysis for Predictive Modeling/
125 - 13.Answers-Linear-Regression.xlsx	102.7 KB
125 - 13.Start-Linear-Regression.xlsx	49.7 KB
125 - Slides.pdf	570.4 KB
125 - What is Correlation English.srt	10.1 KB
125 - What is Correlation.mp4	22.9 MB
126 - Calculating the Correlation Coefficient in Excel English.srt	1.8 KB
126 - Calculating the Correlation Coefficient in Excel.mp4	5.2 MB
127 - What is Regression English.srt	4.0 KB
127 - What is Regression.mp4	7.1 MB
128 - Calculating the Equation of the Regression Line in Excel English.srt	3.5 KB
128 - Calculating the Equation of the Regression Line in Excel.mp4	9.5 MB
129 - Graphing the Regression Line in Excel English.srt	2.4 KB
129 - Graphing the Regression Line in Excel.mp4	9.7 MB
130 - Shortcut to Find the Regression Equation in Excel English.srt	0.9 KB
130 - Shortcut to Find the Regression Equation in Excel.mp4	3.0 MB
131 - Regression Diagnostics.html	1.7 KB
132 - What are Residuals in Regression Analysis English.srt	2.3 KB
132 - What are Residuals in Regression Analysis.mp4	4.5 MB
133 - Enabling Data Analysis Toolpak.html	2.0 KB
134 - Performing Regression with Analysis Toolpak and Finding Residuals English.srt	3.0 KB
134 - Performing Regression with Analysis Toolpak and Finding Residuals.mp4	36.0 MB
135 - Visual Diagnostics Using Residuals to Detect Nonlinearity English.srt	3.3 KB
135 - Visual Diagnostics Using Residuals to Detect Nonlinearity.mp4	27.8 MB
136 - Visual Diagnostics Using Residuals to detect Heteroscedasticity English.srt	3.3 KB
136 - Visual Diagnostics Using Residuals to detect Heteroscedasticity.mp4	29.2 MB
137 - Numerical Diagnostics Using PValues to Determine the Strength of a Correlation English.srt	4.3 KB
137 - Numerical Diagnostics Using PValues to Determine the Strength of a Correlation.mp4	35.4 MB
/.../2 - Entering and Editing Data and Formulas/
10 - Using the Fill Handle to Autofill Data in Excel English.srt	3.3 KB
10 - Using the Fill Handle to Autofill Data in Excel.mp4	9.3 MB
11 - Percentages.txt	0.0 KB
11 - Relative Absolute and Mixed Cell References in Excel English.srt	9.7 KB
11 - Relative Absolute and Mixed Cell References in Excel.mp4	68.3 MB
12 - Named Cells and Ranges in Excel English.srt	4.9 KB
12 - Named Cells and Ranges in Excel.mp4	35.2 MB
13 - Exercise Personal Budget.html	2.1 KB
6 - 2.Answers-Data-and-Formulas.xlsx	35.1 KB
6 - 2.Slides.pdf	233.8 KB
6 - 2.Start-Data-and-Formulas.xlsx	31.7 KB
6 - Basics of Data Entry and Formatting English.srt	9.8 KB
6 - Basics of Data Entry and Formatting.mp4	33.9 MB
6 - Function FN Lock.txt	0.1 KB
7 - Working with Date Values in Excel English.srt	6.0 KB
7 - Working with Date Values in Excel.mp4	22.7 MB
8 - Introduction to Cell References in Excel English.srt	5.3 KB
8 - Introduction to Cell References in Excel.mp4	19.4 MB
9 - Arithmetic Operators.txt	0.1 KB
9 - Arithmetic and Mathematical Operators in Excel English.srt	5.2 KB
9 - Arithmetic and Mathematical Operators in Excel.mp4	56.3 MB
/.../3 - Formatting Your Excel Worksheet/
14 - 3.Answers-Formatting.xlsx	47.4 KB
14 - 3.Start-Formatting.xlsx	44.8 KB
14 - Mac Users Alt Software.txt	0.0 KB
14 - Using ALT as a Shortcut and Other Shortcuts English.srt	7.3 KB
14 - Using ALT as a Shortcut and Other Shortcuts.mp4	48.5 MB
15 - Font Formatting Text Alignment and Merging Cells English.srt	11.4 KB
15 - Font Formatting Text Alignment and Merging Cells.mp4	43.5 MB
16 - Inserting and Deleting Cells Rows and Columns English.srt	5.8 KB
16 - Inserting and Deleting Cells Rows and Columns.mp4	22.5 MB
17 - Hiding and Unhiding Rows and Columns English.srt	3.5 KB
17 - Hiding and Unhiding Rows and Columns.mp4	12.8 MB
18 - Borders Fill Colors English.srt	4.9 KB
18 - Borders Fill Colors.mp4	17.7 MB
19 - Conditional Formatting English.srt	11.4 KB
19 - Conditional Formatting.mp4	90.9 MB
19 - US Census Bureau.txt	0.0 KB
20 - Hyperlinks in Excel English.srt	2.2 KB
20 - Hyperlinks in Excel.mp4	15.7 MB
21 - Protecting Excel Worksheets and Workbooks English.srt	3.3 KB
21 - Protecting Excel Worksheets and Workbooks.mp4	15.1 MB
22 - Data Validation and How to Create a Dropdown List English.srt	9.7 KB
22 - Data Validation and How to Create a Dropdown List.mp4	42.6 MB
23 - Exercise Conditional Formatting.html	1.3 KB
24 - Exercise Creating a Table of Contents.html	1.8 KB
/4 - Excel Functions/
25 - 4.Answers-Basic-Excel-Functions.xlsx	42.4 KB
25 - 4.Slides.pdf	81.6 KB
25 - 4.Start-Basic-Excel-Functions.xlsx	37.1 KB
25 - What is a Function in Excel English.srt	3.4 KB
25 - What is a Function in Excel.mp4	5.3 MB
26 - Order of Operations Order of Precedence in Excel English.srt	2.5 KB
26 - Order of Operations Order of Precedence in Excel.mp4	5.8 MB
27 - SUM and the AUTOSUM Feature in Excel English.srt	5.3 KB
27 - SUM and the AUTOSUM Feature in Excel.mp4	19.3 MB
28 - COUNT COUNTA and COUNTBLANK English.srt	5.3 KB
28 - COUNT COUNTA and COUNTBLANK.mp4	14.3 MB
29 - AVERAGE English.srt	3.3 KB
29 - AVERAGE.mp4	9.3 MB
30 - MIN and MAX English.srt	4.3 KB
30 - MIN and MAX.mp4	13.8 MB
31 - ISBLANK ISNUMBER ISTEXT and ISERROR English.srt	4.2 KB
31 - ISBLANK ISNUMBER ISTEXT and ISERROR.mp4	11.4 MB
32 - Booleans and Logical Operators in Excel English.srt	3.2 KB
32 - Booleans and Logical Operators in Excel.mp4	5.9 MB
33 - Exercise Logical Operators.html	0.7 KB
34 - IF English.srt	8.3 KB
34 - IF.mp4	32.6 MB
35 - VLOOKUP English.srt	6.8 KB
35 - VLOOKUP.mp4	32.7 MB
36 - CONCATENATE TRIM and TEXTSPLIT English.srt	6.2 KB
36 - CONCATENATE TRIM and TEXTSPLIT.mp4	22.3 MB
37 - Using SEARCH and ISNUMBER to Find If a Cell Contains Specific Text English.srt	4.0 KB
37 - Using SEARCH and ISNUMBER to Find If a Cell Contains Specific Text.mp4	53.6 MB
38 - Exercise Student Grades.html	1.4 KB
39 - INDEX MATCH AND INDEX MATCH English.srt	10.1 KB
39 - INDEX MATCH AND INDEX MATCH.mp4	48.8 MB
/.../5 - Navigating and Exploring Larger Datasets/
40 - 5.Answers-Navigating-and-Exploring.xlsx	71.1 KB
40 - 5.Start-Navigating-and-Exploring.xlsx	70.1 KB
40 - How to Freeze Panes Rows and Columns in Excel English.srt	5.4 KB
40 - How to Freeze Panes Rows and Columns in Excel.mp4	44.9 MB
41 - How to Sort Lists in Excel English.srt	10.5 KB
41 - How to Sort Lists in Excel.mp4	150.4 MB
42 - How to Use Excel Filters English.srt	15.1 KB
42 - How to Use Excel Filters.mp4	76.9 MB
43 - Shortcuts for Filtering and Sorting English.srt	4.7 KB
43 - Shortcuts for Filtering and Sorting.mp4	20.8 MB
44 - Unsort and Revert Back to Original Order English.srt	2.7 KB
44 - Unsort and Revert Back to Original Order.mp4	22.4 MB
45 - Exercise Bestselling Artists.html	1.8 KB
/.../6 - Cleaning and Processing Your Data in Excel/
46 - 6.Answers-Cleaning-and-Processing.xlsx	90.2 KB
46 - 6.Slides.pdf	65.4 KB
46 - 6.Start-Cleaning-and-Processing.xlsx	80.9 KB
46 - What is Data Cleaning and the Data Cleaning Process English.srt	6.5 KB
46 - What is Data Cleaning and the Data Cleaning Process.mp4	15.2 MB
47 - Remove Blank Rows English.srt	2.6 KB
47 - Remove Blank Rows.mp4	19.2 MB
48 - Remove Rows with Blank Cells English.srt	1.3 KB
48 - Remove Rows with Blank Cells.mp4	11.5 MB
49 - How to Fill or Replace Blank Cells in Excel English.srt	5.4 KB
49 - How to Fill or Replace Blank Cells in Excel.mp4	48.3 MB
50 - Remove Duplicates English.srt	3.4 KB
50 - Remove Duplicates.mp4	20.5 MB
51 - Using Find and Find and Replace English.srt	2.7 KB
51 - Using Find and Find and Replace.mp4	14.9 MB
52 - SUBSTITUTE Function English.srt	1.6 KB
52 - SUBSTITUTE Function.mp4	6.3 MB
53 - Data Cleaning Pro Tip Creating a Key English.srt	8.0 KB
53 - Data Cleaning Pro Tip Creating a Key.mp4	30.3 MB
54 - 6.CSV-Import-Cleaning-and-Processing.xlsx	16.1 KB
54 - 6.TSV-Import-Cleaning-and-Processing.txt	6.5 KB
54 - 6.TXT-Import-Cleaning-and-Processing.txt	6.5 KB
54 - Importing CSV TSV and TXT and Text to Columns English.srt	6.5 KB
54 - Importing CSV TSV and TXT and Text to Columns.mp4	89.7 MB
55 - Exercise States.html	2.3 KB
56 - Sources of Data for Your Personal Projects.html	1.5 KB
/.../7 - Excel Pivot Tables for Summary and Analysis/
57 - 7.Answers-Pivot-Tables.xlsx	556.6 KB
57 - 7.Slides.pdf	164.2 KB
57 - 7.Start-Pivot-Tables.xlsx	319.0 KB
57 - What is a Pivot Table English.srt	3.9 KB
57 - What is a Pivot Table.mp4	10.1 MB
58 - Fundamentals Creating a Pivot Table The Field List and Aggregators English.srt	14.7 KB
58 - Fundamentals Creating a Pivot Table The Field List and Aggregators.mp4	133.0 MB
59 - Bonus Count Unique Distinct Count with Pivot Tables English.srt	2.3 KB
59 - Bonus Count Unique Distinct Count with Pivot Tables.mp4	20.3 MB
60 - Adding Data to Pivot Tables English.srt	9.4 KB
60 - Adding Data to Pivot Tables.mp4	49.5 MB
61 - Data Best Practices Source Data Formatting and Organization English.srt	4.2 KB
61 - Data Best Practices Source Data Formatting and Organization.mp4	9.1 MB
62 - Formatting Pivot Table Dates and Numbers English.srt	7.5 KB
62 - Formatting Pivot Table Dates and Numbers.mp4	29.9 MB
63 - Sorting and Filtering with Pivot Tables English.srt	7.9 KB
63 - Sorting and Filtering with Pivot Tables.mp4	126.7 MB
64 - Exercise Animal Bites.html	2.3 KB
65 - Calculate Values in a Pivot Table English.srt	12.8 KB
65 - Calculate Values in a Pivot Table.mp4	122.1 MB
66 - Custom Calculations with Pivot Tables English.srt	2.0 KB
66 - Custom Calculations with Pivot Tables.mp4	9.0 MB
67 - Slicers and Timelines English.srt	3.5 KB
67 - Slicers and Timelines.mp4	29.5 MB
68 - Exercise IMDB Movie Database.html	2.8 KB
69 - Pivot Table Tabular Form to Export Data English.srt	2.0 KB
69 - Pivot Table Tabular Form to Export Data.mp4	19.5 MB
/8 - Data Visualization/
70 - 9.Answers-Data-Visualization.xlsx	1.3 MB
70 - 9.Start-Data-Visualization.xlsx	1.3 MB
70 - Tips for Effective Data Visualization English.srt	3.6 KB
70 - Tips for Effective Data Visualization.mp4	93.7 MB
71 - Parts of an Excel Chart.html	0.9 KB
72 - Types of Data.html	1.9 KB
73 - How to Insert a Chart and Add Chart Elements English.srt	6.9 KB
73 - How to Insert a Chart and Add Chart Elements.mp4	23.5 MB
74 - How to Insert Bar and Column Charts Excel English.srt	4.4 KB
74 - How to Insert Bar and Column Charts Excel.mp4	16.9 MB
75 - Format Chart Area Tutorial English.srt	6.6 KB
75 - Format Chart Area Tutorial.mp4	22.4 MB
76 - Sparklines English.srt	1.5 KB
76 - Sparklines.mp4	6.4 MB
77 - Combo Charts TwoAxis Charts English.srt	3.3 KB
77 - Combo Charts TwoAxis Charts.mp4	9.4 MB
77 - What is PPC Marketing.txt	0.0 KB
78 - Line Charts and Trendlines English.srt	8.8 KB
78 - Line Charts and Trendlines.mp4	60.7 MB
78 - What is the Gini Coefficient.txt	0.0 KB
79 - Pie Charts English.srt	3.6 KB
79 - Pie Charts.mp4	17.2 MB
80 - Scatter Plots English.srt	4.6 KB
80 - Scatter Plots.mp4	18.5 MB
81 - Bubble Charts English.srt	8.1 KB
81 - Bubble Charts.mp4	58.4 MB
82 - Histograms and Pareto Charts English.srt	5.5 KB
82 - Histograms and Pareto Charts.mp4	37.7 MB
83 - Box and Whisker Plots English.srt	4.3 KB
83 - Box and Whisker Plots.mp4	14.6 MB
83 - What Are Quartiles.txt	0.0 KB
84 - Heat Maps English.srt	1.9 KB
84 - Heat Maps.mp4	17.3 MB
/.../9 - Data Analyst Fundamentals/
85 - Slides.pdf	396.6 KB
85 - The Scientific Method and How It Applies to Data Analysis.html	2.6 KB
86 - Types of Data Analysis English.srt	5.5 KB
86 - Types of Data Analysis.mp4	15.7 MB
87 - Data Analysts vs Data Scientists English.srt	11.6 KB
87 - Data Analysts vs Data Scientists.mp4	43.3 MB
88 - Independent vs Dependent Variables English.srt	1.9 KB
88 - Independent vs Dependent Variables.mp4	18.7 MB
/~Get Your Files Here !/
Bonus Resources.txt	0.4 KB
Total files 303