DevCourseWeb com Udemy Master Excel From Novice to Expert | 19EA089524671FAF80742BC8F3CCA364A2288D0F

DevCourseWeb com Udemy Master Excel From Novice to Expert

Name	[ DevCourseWeb.com ] Udemy - Master Excel From Novice to Expert!	DOWNLOAD Copy Link
Total Size	2.2 GB
Total Files	88
Last Seen	2024-07-23 01:02
Hash	19EA089524671FAF80742BC8F3CCA364A2288D0F

/
Get Bonus Downloads Here.url	0.2 KB
/.../1. Getting started with Excel/
1. Account Information.mp4	5.5 MB
2. Introduction to the Course.mp4	21.1 MB
3. Excel Interface.mp4	14.8 MB
4. Customising the Quick Access Toolbar.mp4	21.4 MB
5. Customising Excel Ribbon.mp4	21.9 MB
6. Common Excel Shortcut Keys.mp4	5.5 MB
7. Workbook vs Worksheet.mp4	4.3 MB
8. How to save an Excel File.mp4	13.1 MB
/.../10. Excel Templates/
1. Introduction to Excel Templates.mp4	18.6 MB
2. Creating a Custom Template.mp4	23.1 MB
/.../11. Sorting Data/
1. Getting Started with Sorting Data.mp4	16.1 MB
1.1 Practice File.xlsx	43.7 KB
2. Sorting Data.mp4	20.0 MB
3. Multi Level Sorting.mp4	22.2 MB
4. Custom Sorting.mp4	20.0 MB
5. Applying Filters to Datasets.mp4	32.4 MB
6. Converting Datasets into Tables.mp4	49.1 MB
/.../12. Data Validation/
1. Introduction to Data Validation.mp4	7.3 MB
2. Data Validation Drop Down List.mp4	11.9 MB
3. Different Types of Data Validation.mp4	29.5 MB
4. Dynamic Drop Down List.mp4	18.6 MB
5. Custom Error Alerts.mp4	22.5 MB
/.../13. Database Functions/
1. SUMIF and SUMIFS Function.mp4	75.6 MB
2. DSUM Function.mp4	57.6 MB
3. Benefits of using DSUM Function.mp4	41.1 MB
4. SUBTOTAL Function.mp4	64.9 MB
/.../14. Pivot Tables/
1. Creating a Pivot Table.mp4	53.8 MB
2. Modifying Excel Pivot Tables.mp4	28.3 MB
3. More on Modifying Pivot Tables.mp4	32.2 MB
4. Grouping and Filtering Data in Pivot Tables.mp4	61.2 MB
5. Drilling Down feature in Excel Pivot Tables.mp4	22.7 MB
6. Pivot Charts and Slicers.mp4	76.4 MB
/.../15. Excel's Conditional Functions/
1. IF() Function.mp4	29.7 MB
2. IF() Function and AND() Function.mp4	51.2 MB
3. IF() and OR() Function.mp4	29.3 MB
4. Nesting Multiple IF() Functions.mp4	33.6 MB
5. COUNTIF() Function.mp4	25.8 MB
/.../16. Excel's Lookup Functions/
1. VLOOKUP() Function.mp4	69.4 MB
2. HLOOKUP() Function.mp4	33.5 MB
3. INDEX() Function.mp4	28.2 MB
4. MATCH() Function.mp4	18.7 MB
5. INDEX() AND MATCH() Functions Together.mp4	33.6 MB
/.../17. Whatif Tools/
1. Scenario Manager.mp4	25.9 MB
2. Goal Seek.mp4	14.5 MB
/.../18. Text Based Functions/
1. LEFT(), MID() and RIGHT() Function.mp4	30.2 MB
2. CONCATENATE() Function.mp4	14.2 MB
/19. Auditing/
1. Tracing Precedents and Dependents.mp4	20.8 MB
2. Show Formulas feature.mp4	15.1 MB
3. Grouping Data.mp4	28.5 MB
4. 3D referencing in Excel.mp4	29.1 MB
5. Freeze Pans.mp4	33.9 MB
/.../2. Values, Referencing and Formulas/
1. Labels and Entering Data.mp4	17.7 MB
2. Formating Date Values.mp4	27.1 MB
3. Getting Started with Formulas.mp4	19.1 MB
4. Fill Handle.mp4	12.3 MB
5. Relative vs Absolute Cell Reference.mp4	25.6 MB
/.../3. Getting Started with Excel Functions/
1. Introduction to Excel Functions.mp4	11.8 MB
2. More on Excel Functions.mp4	27.6 MB
3. AVERAGE Function, MIN Function and More.mp4	23.0 MB
/.../4. Adjusting Excel Worksheets/
1. How to Move and Copy Data.mp4	12.2 MB
2. Inserting and Deleting Rows and Columns.mp4	23.9 MB
3. Adjusting Width and Height of Columns.mp4	18.7 MB
4. Hiding and Unhiding Rows and Columns.mp4	12.9 MB
5. How to Make a Copy, Rename and Delete a Worksheet.mp4	12.8 MB
/.../5. Protection in Excel/
1. Protecting Worksheets and Specific Cells.mp4	21.1 MB
2. Protecting Workbook.mp4	10.1 MB
3. Encrypting Excel Workbook with a Password.mp4	12.4 MB
/.../6. Formatting to Make Cells Look Good/
1. Formatting Cells and Fonts.mp4	23.0 MB
2. Formatting Numbers.mp4	11.9 MB
3. Format Painter.mp4	10.9 MB
4. Cell Styles.mp4	17.0 MB
5. Merging Cells.mp4	8.9 MB
6. Introduction to Conditional Formatting.mp4	22.0 MB
7. More on Conditional Formatting.mp4	22.7 MB
/.../7. Inserting Shapes and Images/
1. How to Insert Shapes and Images.mp4	24.1 MB
2. More on Shapes.mp4	41.2 MB
3. Smart Art.mp4	31.5 MB
/.../8. Learn to use Charts/
1. Introduction to Charts.mp4	17.0 MB
2. Formatting a Chart.mp4	14.2 MB
3. Formatting Individual Elements of a Chart.mp4	35.6 MB
4. More on Charts.mp4	34.6 MB
5. Moving a Chart and Introduction to Pie Charts.mp4	51.8 MB
/9. Printing/
1. Introduction to Printing Options.mp4	26.7 MB
2. Page Layout View.mp4	28.7 MB
3. Headers and Footers.mp4	18.6 MB
4. Printing Specific Cells.mp4	19.1 MB
/~Get Your Files Here !/
Bonus Resources.txt	0.4 KB
Total files 88