Udemy Excel with The Ultimate Microsoft Excel Course | 6133405D307198DA4D33B7D241150FA3CF769925

Udemy Excel with The Ultimate Microsoft Excel Course

Name	Udemy.Excel.with.The.Ultimate.Microsoft.Excel.Course	DOWNLOAD Copy Link
Total Size	2.6 GB
Total Files	157
Hash	6133405D307198DA4D33B7D241150FA3CF769925

/0 - Course Overview/
Course Overview.mp4	33.0 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
/1 - Excel Basics/
Using Excel Templates to Save Time and Effort.mp4	42.0 MB
Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon.mp4	36.3 MB
Working with Workbooks and Worksheets.mp4	27.8 MB
Printing Your Work.mp4	21.6 MB
Creating Simple Formulas to do Powerful Calculations.mp4	21.1 MB
Entering Data and Navagating Around the Cells.mp4	8.4 MB
Saving Your Document Where You Can Find It.mp4	8.0 MB
Introduction to Excel Basics.mp4	4.0 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
/10 - PIVOT TABLES - Business Case Studies/
BUSINESS CASE STUDY - Pivot Table Slicer & Chart EXCEL DASHBOARD.mp4	70.2 MB
PIVOT-TABLE-Bonus-Videos.zip	48.4 MB
BUSINESS CASE STUDY - Actuals v Plan with Calculated Fields.mp4	47.8 MB
MY OTHER UDEMY COURSE - Excel with Excel Pivot Tables.mp4	30.8 MB
BUSINESS CASE STUDY - Live forecasting with GETPIVOTDATA.mp4	26.6 MB
BONUS VIDEO - Record a Macro to Refresh a Pivot Table.mp4	22.2 MB
BUSINESS CASE STUDY - Select a Monthly P&L report with a Slicer.mp4	17.7 MB
BONUS VIDEO - Reducing File Memory by Deleting the Data source.mp4	13.1 MB
BONUS VIDEO - Reducing File Memory by Copying an existing Pivot Table.mp4	9.7 MB
BUSINESS CASE STUDY - Top 5 Expenses report.mp4	9.6 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
/11 - Excel Macros and VBA/
Introduction to Excel Macros.mp4	20.8 MB
Introduction to Excel Macros and VBA with Kyle.mp4	7.3 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
MonthlySales-01.xlsx	13.9 KB
/12 - Excel Macro and VBA Project #1/
Creating Macro with Excel's Macro Recorder Tool.mp4	40.3 MB
Creating Excel VBA Variables to Create Dynamic Code.mp4	28.9 MB
Working with the ActiveSheet VBA Object.mp4	25.6 MB
Editing an Excel Macro with VBA.mp4	21.1 MB
Introduction to Excel Macro Project #1.mp4	14.2 MB
Running the New, Edited Macro.mp4	9.9 MB
Running an Excel Macro.mp4	6.4 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
/13 - Excel Macro and VBA Project #2/
Using the AddItem VBA Method on a ComboBox Control.mp4	33.9 MB
Setting the Value of a Text Box Control with VBA.mp4	31.9 MB
Adding VBA Code to the Open Event of a Workbook.mp4	23.2 MB
Controlling the Properties of the Form Controls.mp4	21.1 MB
Working with the Change Event for a ComboBox Control.mp4	19.9 MB
Adding Controls to the Excel User Form.mp4	16.8 MB
Introduction to Excel Macro Project #2.mp4	16.1 MB
Adding VBA Code to a Button Control.mp4	14.4 MB
Creating an Excel VBA User Form.mp4	11.1 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
/14 - Create Custom Excel Functions with VBA Project #3/
Introduction to Excel Macro Project #3.mp4	19.4 MB
Creating a Custom Excel Function.mp4	11.7 MB
Adding Help to a Custom Excel Function.mp4	9.7 MB
Adding Conditional Logic to a Custom Function with VBA's IF Structure.mp4	9.2 MB
Understanding a Custom Excel Function.mp4	8.0 MB
Using a Custom Excel Function in a Worksheet.mp4	7.9 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
/15 - [BONUS] More Excel Topics to Learn/
Excel Keyboard Shortcuts.mp4	58.1 MB
Conditional Formatting.mp4	41.5 MB
Data Validation.mp4	34.0 MB
Find and Replace.mp4	17.6 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
Excel-Shortcut-Keys-List.pdf	295.3 KB
Bonus-Section.xlsx	52.1 KB
/16 - New for Excel 2016/
3D Maps in Excel 2016.mp4	65.5 MB
New Chart Types in Excel 2016.mp4	31.1 MB
1-Click Forecasting in Excel 2016.mp4	27.0 MB
New Features in Excel 2016.mp4	25.9 MB
The New Help Feature for Excel 2016.mp4	11.8 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
Excel-2016-3D-Maps-Vacation-Download.xlsx	684.6 KB
Excel-2016-One-Click-Forecasting-Download.xlsx	16.9 KB
/2 - Create Your First Excel Spreadsheet From Scratch/
Create Formulas to Quickly Calculate Your Costs.mp4	20.6 MB
Formatting - Grids and Spacing.mp4	13.9 MB
Formatting Subheadings and Columns, and Alphabetizings Lists.mp4	12.0 MB
Introduction - Creating and Formatting Your Heading.mp4	11.4 MB
Entering and Formatting Numbers.mp4	10.3 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
Kitchen-Remodel-Worksheet-Download.xlsx	10.6 KB
/3 - Charts - How to Create Bar, Column and Pie Charts/
Create a Pie Chart.mp4	38.7 MB
Introduction - How to Create a Chart.mp4	29.1 MB
Create a Bar Chart.mp4	24.9 MB
Create a Line Chart.mp4	23.4 MB
Format Your Chart.mp4	20.8 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
Excel-2016-Charts-Download-New.xlsx	36.5 KB
/4 - Introduction to Excel Formulas and Functions/
What is a Function.mp4	27.4 MB
The Anatomy of a Formula.mp4	20.4 MB
Absolute vs. Relative Cell References.mp4	16.9 MB
How to Quickly Select Cells to Use in Your Formula.mp4	14.9 MB
What is a Formula.mp4	4.7 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
Excel-2016-Absolute-vs-Relative-Cell-Ref-Download.xlsx	11.5 KB
/5 - Top 50 Excel Formulas/
Logic Formulas.mp4	43.0 MB
Text Formulas.mp4	26.1 MB
Financial Formulas.mp4	20.5 MB
Informational Formulas.mp4	14.3 MB
Date and Time Formulas.mp4	13.9 MB
Mathematical Formulas.mp4	12.4 MB
Quick Tips to Master These Formulas.mp4	8.0 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
Top-50-formulas.xlsx	406.9 KB
/6 - VLOOKUP Deep Dive/
Looking to the Left.mp4	96.7 MB
2-Way Lookup.mp4	87.0 MB
Vlookup Tips & Tricks.mp4	76.6 MB
Wildcard Search.mp4	51.6 MB
Menu Example.mp4	30.8 MB
Comparing Lists.mp4	13.0 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
More-Vlookup-Examples.xlsx	747.8 KB
/7 - Working with Excel Tables/
Adding Row Calculations and Changing the Table Size.mp4	18.7 MB
Format Excel List as Excel Table.mp4	13.8 MB
Filter Records Using an Excel Slicer.mp4	13.2 MB
Filtering Records in an Excel Table.mp4	11.1 MB
Adding the Total Row to an Excel Table.mp4	9.8 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
ExcelTables-01.xlsx	17.5 KB
/8 - PIVOT TABLES - Customization/
CUSTOMIZING - Pivot Table Styles.mp4	19.9 MB
CUSTOMIZING - No Gaps.mp4	15.6 MB
CUSTOMIZING - Tabular Format.mp4	14.9 MB
CUSTOMIZING - Excel Tables.mp4	14.5 MB
CUSTOMIZING - Report Layouts.mp4	12.8 MB
CUSTOMIZING - Inserting a Pivot Table.mp4	12.7 MB
CUSTOMIZING - Drill down to audit.mp4	10.5 MB
CUSTOMIZING - Formatting.mp4	5.5 MB
CUSTOMIZING - Change Count of to Sum of.mp4	5.5 MB
CUSTOMIZING - Refresh a Pivot Table.mp4	4.8 MB
CUSTOMIZING - Move a Pivot Table.mp4	4.6 MB
CUSTOMIZING - Format error values.mp4	3.2 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
CUSTOMIZING - Show_Hide Field List.mp4	1.6 MB
PIVOT-TABLES-Customizing.zip	698.4 KB
/9 - PIVOT TABLES - Analytical Tools/
FILTERING - Filter by Dates.mp4	25.7 MB
SHOW VALUES AS - % Difference From.mp4	22.8 MB
GETPIVOTDATA - Create a custom report.mp4	19.6 MB
CALCULATED FIELD - Creating a Calculated Field.mp4	19.4 MB
GETPIVOTDATA - Introduction.mp4	19.4 MB
CALCULATED ITEM - Creating a Calculated Item.mp4	17.8 MB
GROUPING - Group by Date.mp4	17.2 MB
GROUPING - Group by Sales ranges.mp4	16.3 MB
SUMMARIZE VALUES BY - Count.mp4	15.6 MB
SUMMARIZE VALUES BY - Average.mp4	15.2 MB
FILTERING - Filter by Values.mp4	14.8 MB
CONDITIONAL FORMATTING - Introduction.mp4	14.1 MB
SORTING - Sort using a Custom List.mp4	13.8 MB
SLICERS - Insert a Slicer.mp4	13.6 MB
SLICERS - Slicer Connections for multiple Pivot Tables.mp4	13.6 MB
PIVOT CHARTS - Insert a Pivot Chart.mp4	12.6 MB
SHOW VALUES AS - % of Grand Total.mp4	12.2 MB
SHOW VALUES AS - Running Total In (Year to Date).mp4	12.1 MB
SLICERS - Slicer Styles.mp4	10.8 MB
FILTERING - Filter by Text.mp4	10.4 MB
SUMMARIZE VALUES BY - Maximum.mp4	8.3 MB
PIVOT CHARTS - Insert a Slicer with a Pivot Chart.mp4	7.9 MB
SORTING - Sort manually (drag, write, right click).mp4	7.3 MB
GROUPING - Group by Text fields.mp4	7.2 MB
SORTING - Sorting by Largest or Smallest.mp4	6.9 MB
CONDITIONAL FORMATTING - Highlight Cell Rules based on date labels.mp4	6.1 MB
CONDITIONAL FORMATTING - Highlight Cell Rules based on values.mp4	5.6 MB
CONDITIONAL FORMATTING - Highlight Cell Rules based on text labels.mp4	4.2 MB
PIVOT-TABLES-Analytical-Tools.zip	1.7 MB
Udemy Excel with The Ultimate Microsoft Excel Course.mp4	1.7 MB
/
Info.txt	0.1 KB
Total files 157