GigaCourse Com Udemy The Excel Bootcamp Zero to Mastery | 79D6AF7082B1D04C5E7110AE07E88AF59C9069A0

GigaCourse Com Udemy The Excel Bootcamp Zero to Mastery

Name	[GigaCourse.Com] Udemy - The Excel Bootcamp Zero to Mastery	DOWNLOAD Copy Link
Total Size	6.2 GB
Total Files	339
Last Seen	2024-07-20 23:56
Hash	79D6AF7082B1D04C5E7110AE07E88AF59C9069A0

/0. Websites you may like/
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/1. Introduction/
1. Course Outline.mp4	33.3 MB
1. Course Outline.srt	7.5 KB
2. Join Our Online Classroom!.mp4	79.0 MB
2. Join Our Online Classroom!.srt	6.1 KB
3. Exercise Meet Your Classmates and Instructor.html	3.7 KB
4. Cheatsheet.html	0.4 KB
/10. Modeling in Excel/
1. Intro to Modeling.mp4	9.8 MB
1. Intro to Modeling.srt	4.2 KB
2. The PMT Function.mp4	37.8 MB
2. The PMT Function.srt	9.7 KB
2.1 The PMT Function.xlsx	10.7 KB
3. Data Validation Lists.mp4	42.7 MB
3. Data Validation Lists.srt	11.4 KB
3.1 Data Validation Lists.xlsx	19.1 KB
4. Scroll Bars.mp4	87.5 MB
4. Scroll Bars.srt	22.7 KB
4.1 Scroll Bars.xlsx	16.6 KB
5. Named Ranges.mp4	63.3 MB
5. Named Ranges.srt	15.3 KB
5.1 Named Ranges.xlsx	23.1 KB
6. Model Design.mp4	39.7 MB
6. Model Design.srt	10.9 KB
6.1 Model Design.xlsx	23.9 KB
7. Exercise Modeling.html	2.6 KB
7.1 Modeling in Excel - Exercise Solution.xlsx	23.4 KB
7.2 Modeling in Excel - Exercise Starter.xlsx	16.3 KB
8. Budget Project Modeling.mp4	71.0 MB
8. Budget Project Modeling.srt	16.9 KB
8.1 Modeling in Excel - Budget Project Solution File.xlsx	90.9 KB
8.2 Modeling in Excel - Budget Project Starter File.xlsx	86.7 KB
/11. Data Visualization in Excel/
1. Custom Formats.mp4	45.6 MB
1. Custom Formats.srt	12.6 KB
1.1 Custom Formats.xlsx	16.9 KB
2. Conditional Formatting I.mp4	45.7 MB
2. Conditional Formatting I.srt	10.3 KB
2.1 Conditional Formatting I.xlsx	16.0 KB
3. Conditional Formatting II.mp4	74.0 MB
3. Conditional Formatting II.srt	14.9 KB
3.1 Conditional Formatting II.xlsx	16.1 KB
4. Introducing Charts.mp4	77.5 MB
4. Introducing Charts.srt	18.5 KB
4.1 Introducing Charts.xlsx	37.4 KB
5. Column Charts.mp4	51.1 MB
5. Column Charts.srt	10.2 KB
5.1 Column Charts.xlsx	27.8 KB
6. Line Charts.mp4	106.7 MB
6. Line Charts.srt	17.1 KB
6.1 Line Charts.xlsx	37.9 KB
7. Exercise Data Visualization.html	4.3 KB
7.1 Data Visualization - Exercise Solutions.xlsx	128.6 KB
7.2 Data Visualization - Exercise Starter.xlsx	96.6 KB
8. Budget Project Data Visualization.mp4	72.1 MB
8. Budget Project Data Visualization.srt	14.2 KB
8.1 Data Visualization - Budget Project Solution File.xlsx	100.8 KB
8.2 Data Visualization - Budget Project Starter File.xlsx	90.9 KB
/12. Working With Structured Data in Excel/
1. Text to Columns.mp4	46.8 MB
1. Text to Columns.srt	8.5 KB
1.1 Text to Columns.xlsx	18.0 KB
2. External Data.mp4	77.6 MB
2. External Data.srt	13.8 KB
3. Table Features.mp4	91.1 MB
3. Table Features.srt	14.2 KB
3.1 Table Features.xlsx	4.6 MB
4. Tables as Named Ranges.mp4	155.6 MB
4. Tables as Named Ranges.srt	20.0 KB
4.1 Line Charts.xlsx	32.0 KB
4.2 Tables as Named Ranges.xlsx	11.7 MB
5. Exercise Working With Structured Data in Excel.html	3.6 KB
5.1 External Data Files.zip	46.4 KB
5.2 Working With Structured Data - Exercise Solutions.xlsx	125.4 KB
5.3 Working With Structured Data - Starter.xlsx	54.9 KB
6. Budget Project Structured Data.mp4	81.8 MB
6. Budget Project Structured Data.srt	13.1 KB
6.1 Categories.xlsx	16.3 KB
6.2 Structured Data - Budget Project Solution File.xlsx	135.9 KB
6.3 Structured Data - Budget Project Starter File.xlsx	111.1 KB
/13. Pivot Tables/
1. Intro to Pivot Tables.mp4	115.3 MB
1. Intro to Pivot Tables.srt	18.4 KB
1.1 Intro to Pivot Tables.xlsx	11.4 MB
2. Adding Layers to Pivot Tables.mp4	141.3 MB
2. Adding Layers to Pivot Tables.srt	20.4 KB
2.1 Adding Layers to Pivot Tables.xlsx	14.9 MB
3. Pivot Table Formatting and Layout.mp4	88.9 MB
3. Pivot Table Formatting and Layout.srt	15.4 KB
3.1 Pivot Table Formatting and Layout.xlsx	14.8 MB
4. Filtering Pivot Tables.mp4	78.8 MB
4. Filtering Pivot Tables.srt	14.4 KB
4.1 Filtering Pivot Tables.xlsx	14.8 MB
5. Slicers.mp4	96.6 MB
5. Slicers.srt	16.1 KB
5.1 Slicers.xlsx	14.8 MB
6. Pivot Table Math.mp4	86.4 MB
6. Pivot Table Math.srt	13.9 KB
6.1 Pivot Table Math.xlsx	15.7 MB
7. Exercise Pivot Tables.html	3.3 KB
7.1 Pivot Tables - Exercise Solutions.xlsx	147.3 KB
7.2 Pivot Tables - Exercise Starter.xlsx	84.1 KB
8. Budget Project Pivot Tables.mp4	64.3 MB
8. Budget Project Pivot Tables.srt	8.9 KB
8.1 Pivot Tables - Budget Project Solution File.xlsx	158.6 KB
8.2 Pivot Tables - Budget Project Starter File.xlsx	127.0 KB
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/14. Macros and VBA/
1. Intro to Macros.mp4	40.7 MB
1. Intro to Macros.srt	13.3 KB
1.1 Hello World - 1.xlsm	19.3 KB
2. Running Macros With Buttons.mp4	20.3 MB
2. Running Macros With Buttons.srt	7.0 KB
2.1 Hello World - 2.xlsm	23.0 KB
3. Editing Macros.mp4	66.1 MB
3. Editing Macros.srt	13.7 KB
3.1 Editing Macros.xlsm	22.8 KB
4. Macros - A Case Study.mp4	158.8 MB
4. Macros - A Case Study.srt	27.3 KB
4.1 CSV Data.csv.zip	1.1 MB
4.2 Employee Performace Report - Template.xlsm	14.5 MB
5. Exercise Macros and VBA.html	4.3 KB
5.1 Customer Reviews Template.xlsm	25.4 KB
5.2 Macros - Starter.xlsx	19.8 KB
6. Budget Project Macros and VBA.mp4	62.7 MB
6. Budget Project Macros and VBA.srt	9.4 KB
6.1 Data Extract.xlsx	19.4 KB
6.2 Macros - Budget Project Solution File.xlsm	167.8 KB
6.3 Macros - Budget Project Starter File.xlsx	162.4 KB
/15. Where To Go From Here/
1. Thank You!.mp4	17.7 MB
1. Thank You!.srt	2.0 KB
2. Become An Alumni.html	0.9 KB
3. LinkedIn Endorsements.html	1.4 KB
4. Learning Guideline.html	0.3 KB
/16. BONUS SECTION/
1. Bonus Lecture.html	1.2 KB
/2. Excel 101/
1. Hello Excel Part 1.mp4	61.3 MB
1. Hello Excel Part 1.srt	13.4 KB
10. Working With Multiple Worksheets.mp4	66.2 MB
10. Working With Multiple Worksheets.srt	14.2 KB
10.1 Working With Multiple Worksheets.xlsx	14.0 KB
11. Find and Replace.mp4	101.5 MB
11. Find and Replace.srt	18.5 KB
11.1 Find and Replace.xlsx	14.0 KB
12. Working With Multiple Workbooks.mp4	88.1 MB
12. Working With Multiple Workbooks.srt	14.1 KB
12.1 Working With Multiple Workbooks.xlsx	16.4 KB
13. Intro to Formatting.mp4	21.0 MB
13. Intro to Formatting.srt	6.1 KB
14. Formatting Numbers.mp4	72.0 MB
14. Formatting Numbers.srt	14.9 KB
14.1 Formatting Numbers.xlsx	15.6 KB
15. Formatting Dates and Times.mp4	64.3 MB
15. Formatting Dates and Times.srt	14.9 KB
15.1 Formatting Dates and Times.xlsx	15.7 KB
16. Font Styles.mp4	110.1 MB
16. Font Styles.srt	15.6 KB
16.1 Font Styles.xlsx	25.9 KB
17. Text Wrapping and Alignment.mp4	84.6 MB
17. Text Wrapping and Alignment.srt	15.1 KB
17.1 Text Wrapping and Alignment.xlsx	15.9 KB
18. Cell Borders and Merging.mp4	49.9 MB
18. Cell Borders and Merging.srt	12.6 KB
18.1 Cell Borders and Merging.xlsx	22.7 KB
19. Exercise Excel 101.html	3.7 KB
19.1 Customer Reviews 08-12-2021.xlsx	19.8 KB
19.2 Customer Reviews.xlsx	20.7 KB
2. Hello Excel Part 2.mp4	65.8 MB
2. Hello Excel Part 2.srt	16.8 KB
3. Data Entry Part 1.mp4	54.8 MB
3. Data Entry Part 1.srt	15.6 KB
4. Data Entry Part 2.mp4	56.8 MB
4. Data Entry Part 2.srt	13.7 KB
5. Autofill.mp4	54.8 MB
5. Autofill.srt	14.0 KB
6. Working With Ranges.mp4	71.9 MB
6. Working With Ranges.srt	15.1 KB
6.1 Working With Ranges.xlsx	10.7 KB
7. Working With Rows and Columns.mp4	80.5 MB
7. Working With Rows and Columns.srt	12.9 KB
7.1 Working With Rows and Columns.xlsx	13.5 KB
8. Resizing Rows and Columns.mp4	77.6 MB
8. Resizing Rows and Columns.srt	12.9 KB
8.1 Resizing Rows and Columns.xlsx	18.7 KB
9. Freezing Rows and Columns.mp4	85.1 MB
9. Freezing Rows and Columns.srt	12.9 KB
9.1 Freezing Rows and Columns.xlsx	14.0 KB
/3. Filtering and Sorting Data/
1. Intro to Filtering.mp4	60.9 MB
1. Intro to Filtering.srt	11.4 KB
1.1 Intro to Filtering.xlsx	16.8 KB
2. Advanced Filtering.mp4	142.7 MB
2. Advanced Filtering.srt	22.4 KB
2.1 Advanced Filtering.xlsx	17.7 KB
3. Sorting in Excel.mp4	158.4 MB
3. Sorting in Excel.srt	20.6 KB
3.1 Sorting in Excel.xlsx	17.7 KB
4. Exercise Filtering and Sorting Data.html	1.4 KB
4.1 Filtering and Sorting - Exercise Solution.xlsx	23.2 KB
4.2 Filtering and Sorting - Starter.xlsx	20.9 KB
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/4. Excel Formulas 101/
1. Intro to Formulas.mp4	32.5 MB
1. Intro to Formulas.srt	11.3 KB
10. Budget Project Formulas 101.mp4	31.7 MB
10. Budget Project Formulas 101.srt	7.7 KB
10.1 Formulas 101 - Budget Project Solution File.xlsx	16.0 KB
2. Arithmetic Formulas.mp4	37.2 MB
2. Arithmetic Formulas.srt	12.7 KB
2.1 Arithmetic Formulas.xlsx	11.9 KB
3. Applying Formulas to Text.mp4	33.3 MB
3. Applying Formulas to Text.srt	10.3 KB
3.1 Applying Formulas to Text.xlsx	9.6 KB
4. Applying Formulas to Dates.mp4	42.7 MB
4. Applying Formulas to Dates.srt	11.7 KB
4.1 Applying Formulas to Dates.xlsx	13.0 KB
5. Copying and Cutting Formulas.mp4	93.4 MB
5. Copying and Cutting Formulas.srt	16.9 KB
5.1 Copying and Cutting Formulas.xlsx	25.3 KB
6. Cell References.mp4	111.0 MB
6. Cell References.srt	18.5 KB
6.1 Investment Calendar.xlsx	19.2 KB
7. Hiding Rows and Columns.mp4	20.7 MB
7. Hiding Rows and Columns.srt	4.3 KB
8. Exercise Formulas 101.html	1.8 KB
8.1 Excel Formulas - Exercise Solution.xlsx	28.7 KB
8.2 Excel Formulas - Starter.xlsx	25.8 KB
9. Budget Project Introduction.mp4	13.3 MB
9. Budget Project Introduction.srt	2.7 KB
/5. Crunching Numbers With Excel Functions/
1. Intro to Excel Functions.mp4	36.3 MB
1. Intro to Excel Functions.srt	15.2 KB
1.1 Intro to Excel Functions.xlsx	16.7 KB
2. Arithmetic Functions.mp4	108.0 MB
2. Arithmetic Functions.srt	20.6 KB
2.1 Arithmetic Functions.xlsx	26.0 KB
3. Counting Functions.mp4	43.2 MB
3. Counting Functions.srt	8.3 KB
3.1 Counting Functions.xlsx	26.1 KB
4. The Status Bar.mp4	9.5 MB
4. The Status Bar.srt	3.4 KB
4.1 The Status Bar.xlsx	10.2 KB
5. Rounding and Truncation.mp4	36.9 MB
5. Rounding and Truncation.srt	11.7 KB
5.1 Rounding and Truncation.xlsx	10.6 KB
6. Median.mp4	35.8 MB
6. Median.srt	11.1 KB
6.1 Median.xlsx	17.1 KB
7. Standard Deviation.mp4	35.4 MB
7. Standard Deviation.srt	10.5 KB
7.1 Standard Deviation.xlsx	11.1 KB
8. Exercise Crunching Numbers With Excel Functions.html	1.6 KB
8.1 Crunching Numbers With Functions - Exercise Solutions.xlsx	103.9 KB
8.2 Home Sale Data.xlsx	84.0 KB
9. Budget Project Crunching Numbers With Excel Functions.mp4	27.4 MB
9. Budget Project Crunching Numbers With Excel Functions.srt	7.6 KB
9.1 Crunching Numbers With Excel Functions - Budget Project Solution File.xlsx	18.1 KB
9.2 Crunching Numbers With Excel Functions - Budget Project Starter File.xlsx	16.0 KB
9.3 Income & Expenses.xlsx	15.8 KB
/6. Conditional Calculations/
1. Conditional Calculations I.mp4	79.3 MB
1. Conditional Calculations I.srt	16.2 KB
1.1 Conditional Calculations I.xlsx	18.5 KB
2. Conditional Calculations II.mp4	83.4 MB
2. Conditional Calculations II.srt	16.1 KB
2.1 Conditional Calculations II.xlsx	25.1 KB
3. Conditional Calculations III.mp4	115.3 MB
3. Conditional Calculations III.srt	18.7 KB
3.1 Conditional Calculations III.xlsx	28.0 KB
4. Exercise Conditional Calculations.html	2.1 KB
4.1 Conditional Calculations - Exercise Solutions.xlsx	86.2 KB
4.2 Home Sale Data.xlsx	84.7 KB
5. Budget Project Conditional Calculations.mp4	36.9 MB
5. Budget Project Conditional Calculations.srt	6.7 KB
5.1 Conditional Calculations - Budget Project Solution File.xlsx	93.4 KB
5.2 Conditional Calculations - Budget Project Starter File.xlsx	18.1 KB
5.3 Transaction History.xlsx	80.3 KB
6. Exercise Imposter Syndrome.mp4	41.1 MB
6. Exercise Imposter Syndrome.srt	4.7 KB
/7. Date and Time Functions/
1. Introducing Date and Time Functions.mp4	11.1 MB
1. Introducing Date and Time Functions.srt	5.8 KB
1.1 Introducing Date and Time Functions.xlsx	10.4 KB
2. Parsing Date and Time Components.mp4	31.8 MB
2. Parsing Date and Time Components.srt	10.3 KB
2.1 Parsing Date and Time Components.xlsx	10.6 KB
3. The DATE Function.mp4	30.4 MB
3. The DATE Function.srt	7.7 KB
3.1 Beginning of Month.xlsx	10.4 KB
4. Applying the DATE and TIME Functions.mp4	41.9 MB
4. Applying the DATE and TIME Functions.srt	10.3 KB
4.1 Applying the DATE and TIME Functions.xlsx	12.3 KB
5. DATEDIF and NETWORKDAYS.mp4	41.6 MB
5. DATEDIF and NETWORKDAYS.srt	13.0 KB
5.1 DATEDIF and NETWORKDAYS.xlsx	13.3 KB
6. Transforming Date Values.mp4	54.8 MB
6. Transforming Date Values.srt	9.0 KB
6.1 Transforming Date Values.xlsx	20.1 KB
7. Exercise Date and Time Functions.html	2.8 KB
7.1 Date and Time Functions - Exercise Solutions.xlsx	44.8 KB
7.2 Date and Time Functions - Exercises.xlsx	36.4 KB
8. Budget Project Date and Time Functions.mp4	47.0 MB
8. Budget Project Date and Time Functions.srt	10.9 KB
8.1 Date and Time Functions - Budget Project Solution File.xlsx	84.5 KB
8.2 Date and Time Functions - Budget Project Starter File.xlsx	83.2 KB
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
/8. Text Functions/
1. LEFT, RIGHT, and MID.mp4	37.2 MB
1. LEFT, RIGHT, and MID.srt	9.2 KB
1.1 LEFT, RIGHT, and MID.xlsx	15.2 KB
2. FIND and LEN.mp4	132.2 MB
2. FIND and LEN.srt	22.6 KB
2.1 FIND and LEN.xlsx	16.9 KB
3. Text Cleaning Functions.mp4	111.7 MB
3. Text Cleaning Functions.srt	14.3 KB
3.1 Messy Names.xlsx	24.6 KB
4. Exercise Text Functions.html	1.6 KB
4.1 Text Functions - Exercise Solutions.xlsx	26.5 KB
4.2 Text Functions - Exercises.xlsx	14.7 KB
5. Budget Project Text Functions.mp4	47.8 MB
5. Budget Project Text Functions.srt	11.5 KB
5.1 Text Functions - Budget Project Solution File.xlsx	86.5 KB
5.2 Text Functions - Budget Project Starter File.xlsx	84.7 KB
/9. Logical and Lookup Functions/
1. The IF Function.mp4	93.6 MB
1. The IF Function.srt	20.9 KB
1.1 Shave Ice Tracker - 1.xlsx	16.9 KB
1.2 The IF Function.xlsx	10.6 KB
2. AND and OR.mp4	76.0 MB
2. AND and OR.srt	13.8 KB
2.1 AND and OR.xlsx	10.4 KB
2.2 Shave Ice Tracker - 2.xlsx	28.1 KB
3. VLOOKUP.mp4	67.6 MB
3. VLOOKUP.srt	14.2 KB
3.1 Shave Ice Tracker - 3.xlsx	19.1 KB
3.2 VLOOKUP.xlsx	9.8 KB
4. VLOOKUP with IFERROR.mp4	85.7 MB
4. VLOOKUP with IFERROR.srt	13.1 KB
4.1 Shave Ice Tracker - 4.xlsx	31.1 KB
5. Exercise Logical and Lookup Functions.html	3.2 KB
5.1 Logical and Lookup Functions - Exercise Solutions.xlsx	37.0 KB
5.2 Logical and Lookup Functions - Exercises.xlsx	30.0 KB
6. Budget Project IF Statements.mp4	24.2 MB
6. Budget Project IF Statements.srt	5.4 KB
6.1 IF Statements - Budget Project Solution File.xlsx	86.7 KB
6.2 IF Statements - Budget Project Starter File.xlsx	86.4 KB
/
[CourseClub.Me].url	0.1 KB
[GigaCourse.Com].url	0.0 KB
Total files 339