Torrent Downloads » Other » [ FreeCourseWeb com ] Udemy - Microsoft Excel- Complete Master Program in MS Excel [2021]
Other
[ FreeCourseWeb com ] Udemy - Microsoft Excel- Complete Master Program in MS Excel [2021]
Torrent info
Torrent Files List
Get Bonus Downloads Here.url (Size: 3.81 GB) (Files: 298)
Get Bonus Downloads Here.url
~Get Your Files Here !
1. Introduction
1. Shortcuts-entering data.mp4
1. Shortcuts-entering data.srt
2. How i Design this course.mp4
2. How i Design this course.srt
10. Core Formulas and Functions - (Module III)
1. What is a Formula and function.mp4
1. What is a Formula and function.srt
2. How to use operators in formulas.mp4
2. How to use operators in formulas.srt
3. The order of operations.mp4
3. The order of operations.srt
11. Cell References in Excel
1. What is a cell reference.mp4
1. What is a cell reference.srt
2. What's a relative reference.mp4
2. What's a relative reference.srt
3. relative references - example.mp4
3. relative references - example.srt
4. What's an absolute reference.mp4
4. What's an absolute reference.srt
5. absolute references - examples.mp4
5. absolute references - examples.srt
6. Mixed reference in Excel.mp4
6. Mixed reference in Excel.srt
12. Named ranges
1. Named ranges as absolute references.mp4
1. Named ranges as absolute references.srt
2. create a named range.mp4
2. create a named range.srt
3. create a named constant.mp4
3. create a named constant.srt
4. What is a dynamic named range.mp4
4. What is a dynamic named range.srt
5. create a dynamic named range with a Table.mp4
5. create a dynamic named range with a Table.srt
13. Date and Time Functions
1. Create Full Date using DATE Function.mp4
1. Create Full Date using DATE Function.srt
2. Extract Year, Day, Month values using YEAR, MONTH, DAY functions.mp4
2. Extract Year, Day, Month values using YEAR, MONTH, DAY functions.srt
3. Generate Time Using HOUR,MINUTE,SECOND and TIME Functions.mp4
3. Generate Time Using HOUR,MINUTE,SECOND and TIME Functions.srt
4. get time between dates in years, months, or days using DATEDIF and YEARFRAC.mp4
4. get time between dates in years, months, or days using DATEDIF and YEARFRAC.srt
5. Generate past, future and end dates using EDATE() and EOMONTH() Function.mp4
5. Generate past, future and end dates using EDATE() and EOMONTH() Function.srt
6. Generate weekday and week number using WEEKDAY() and WEEKNUM() functions.mp4
6. Generate weekday and week number using WEEKDAY() and WEEKNUM() functions.srt
14. Information Function in Excel
1. Information Functions -ISNUMBER, ISTEXT, ISBLANK, ISERROR.mp4
1. Information Functions -ISNUMBER, ISTEXT, ISBLANK, ISERROR.srt
15. Excel- Logical Functions
1. Logical Functions - AND () Function.mp4
1. Logical Functions - AND () Function.srt
2. Logical Functions - OR () Function.mp4
2. Logical Functions - OR () Function.srt
3. Logical Functions - NOT() Function.mp4
3. Logical Functions - NOT() Function.srt
4. Logical Functions - IF and IFS functions.mp4
4. Logical Functions - IF and IFS functions.srt
16. Excel- Statistics Functions
1. Count Items using COUNT () Function.mp4
1. Count Items using COUNT () Function.srt
2. Count items based on criteria using COUNTIF() Function.mp4
2. Count items based on criteria using COUNTIF() Function.srt
3. Find Total using SUM () Function.mp4
3. Find Total using SUM () Function.srt
4. Find Total based on conditions using SUMIF () Function.mp4
4. Find Total based on conditions using SUMIF () Function.srt
5. Find Minimum and Maximum values using MIN () and MAX () Function.mp4
5. Find Minimum and Maximum values using MIN () and MAX () Function.srt
6. Generate averages using AVERAGE () Function.mp4
6. Generate averages using AVERAGE () Function.srt
17. Excel- Text Functions
1. TEXT Functions--- LEFT, RIGHT, MID () Functions.mp4
1. TEXT Functions--- LEFT, RIGHT, MID () Functions.srt
2. TEXT Functions ----- LEN () Function.mp4
2. TEXT Functions ----- LEN () Function.srt
3. TEXT FUNCTIONS ----- TRIM, CLEAN() Functions.mp4
3. TEXT FUNCTIONS ----- TRIM, CLEAN() Functions.srt
4. TEXT Functions ------ UPPER, LOWER, PROPER() Functions.mp4
4. TEXT Functions ------ UPPER, LOWER, PROPER() Functions.srt
18. Microsoft Excel Tables (Module- IV)
1. What is an Excel Table.mp4
1. What is an Excel Table.srt
2. create an Excel Table.mp4
2. create an Excel Table.srt
3. Excel Table Options.mp4
3. Excel Table Options.srt
4. remove an Excel Table.mp4
4. remove an Excel Table.srt
19. Working with tables
1. Working with table rows and columns.mp4
1. Working with table rows and columns.srt
2. How Excel Table ranges work.mp4
2. How Excel Table ranges work.srt
3. How to use Table filters.mp4
3. How to use Table filters.srt
4. How to sort an Excel Table.mp4
4. How to sort an Excel Table.srt
5. How to add a totals row to a Table.mp4
5. How to add a totals row to a Table.srt
6. remove duplicates from a table.mp4
6. remove duplicates from a table.srt
2. Microsoft Excel Basics (Module-I)
1. Excel - Overview.mp4
1. Excel - Overview.srt
10. Change Row Height in Excel.mp4
10. Change Row Height in Excel.srt
11. Change Column Width in Excel.mp4
11. Change Column Width in Excel.srt
12. Hide and unhide Rows and Columns in Excel.mp4
12. Hide and unhide Rows and Columns in Excel.srt
13. Insert Rows and Columns in Excel.mp4
13. Insert Rows and Columns in Excel.srt
14. Insert and Delete cells in Excel.mp4
14. Insert and Delete cells in Excel.srt
15. Delete Rows and Columns in Excel.mp4
15. Delete Rows and Columns in Excel.srt
16. Range and Types of Ranges in Excel.mp4
16. Range and Types of Ranges in Excel.srt
17. Insert, Rename and Delete worksheets in Excel.mp4
17. Insert, Rename and Delete worksheets in Excel.srt
18. Hide and Unhide Worksheets.mp4
18. Hide and Unhide Worksheets.srt
19. Free panes Rows and Columns in Excel.mp4
19. Free panes Rows and Columns in Excel.srt
2. Open and Close Excel Appilication.mp4
2. Open and Close Excel Appilication.srt
3. Window controls to Maximize, Minimize and Restore Excel Window.mp4
3. Window controls to Maximize, Minimize and Restore Excel Window.srt
4. Resize and Move Excel Window.mp4
4. Resize and Move Excel Window.srt
5. Components of excel workbook user interface.mp4
5. Components of excel workbook user interface.srt
6. Customize Excel Ribbon.mp4
6. Customize Excel Ribbon.srt
7. Quick Access Tool Bar in Excel.mp4
7. Quick Access Tool Bar in Excel.srt
8. Configure password for Excel file to prevent unauthorized Access.mp4
8. Configure password for Excel file to prevent unauthorized Access.srt
9. Row, Column and Cells in Excel Worksheets.mp4
9. Row, Column and Cells in Excel Worksheets.srt
20. Table formula examples in Excel
1. use SUMIFS with an Excel Table.mp4
1. use SUMIFS with an Excel Table.srt
2. Use VLOOKUP with a table.mp4
2. Use VLOOKUP with a table.srt
3. set up a running total in a table.mp4
3. set up a running total in a table.srt
4. Conditional formatting formula in a table.mp4
4. Conditional formatting formula in a table.srt
5. Data validation with an Excel table.mp4
5. Data validation with an Excel table.srt
21. Table Slicers in Excel
1. add a slicer to a table.mp4
1. add a slicer to a table.srt
2. use table slicer options.mp4
2. use table slicer options.srt
22. Table styles in Excel
1. Introduction to table styles.mp4
1. Introduction to table styles.srt
2. How to apply a table style.mp4
2. How to apply a table style.srt
3. How to create a new table style.mp4
3. How to create a new table style.srt
4. How to copy a table style to another file.mp4
4. How to copy a table style to another file.srt
23. Practical Scenarios on table
1. Why you should use a table for your pivot table.mp4
1. Why you should use a table for your pivot table.srt
2. build a simple summary table.mp4
2. build a simple summary table.srt
3. count items in a filtered list.mp4
3. count items in a filtered list.srt
24. Microsoft Excel- Shortcuts ( Module-V)
1. Excel Shortcuts -File Commands.mp4
1. Excel Shortcuts -File Commands.srt
2. Excel Shortcuts- Cell Editing.mp4
2. Excel Shortcuts- Cell Editing.srt
3. Excel Shortcuts-Cut, Copy and Paste.mp4
3. Excel Shortcuts-Cut, Copy and Paste.srt
4. Excel Shortcuts- Undo, Redo.mp4
4. Excel Shortcuts- Undo, Redo.srt
5. Excel Shortcuts- Entering Data.mp4
5. Excel Shortcuts- Entering Data.srt
6. Excel Shortcuts-Find and Replace.mp4
6. Excel Shortcuts-Find and Replace.srt
7. Excel Shortcuts - Navigate workbook.mp4
7. Excel Shortcuts - Navigate workbook.srt
8. Excel Shortcuts- Selecting Cells.mp4
8. Excel Shortcuts- Selecting Cells.srt
9. Excel Shortcuts - Insert Rows and columns.mp4
9. Excel Shortcuts - Insert Rows and columns.srt
25. Data Analysis With Pivot Tables- Introduction ( Module VI)
1. Introduction to Pivot Tables.mp4
1. Introduction to Pivot Tables.srt
26. Building Pivot Tables
1. Add fields to a pivot table.mp4
1. Add fields to a pivot table.srt
2. rearrange fields in a pivot table.mp4
2. rearrange fields in a pivot table.srt
3. access field settings in a pivot table.mp4
3. access field settings in a pivot table.srt
4. format numbers in a pivot table.mp4
4. format numbers in a pivot table.srt
5. change the math used for pivot table values.mp4
5. change the math used for pivot table values.srt
6. control grand totals in a pivot table.mp4
6. control grand totals in a pivot table.srt
7. control subtotals in a pivot table.mp4
7. control subtotals in a pivot table.srt
27. Date Visualization with Core Charts (Module VII)
1. Data Visualization with bar chart.mp4
1. Data Visualization with bar chart.srt
2. Data Visualization with line chart.mp4
2. Data Visualization with line chart.srt
3. Data Visualization with column chart.mp4
3. Data Visualization with column chart.srt
3. Entering Data in Excel
1. Enter Data in Excel.mp4
1. Enter Data in Excel.srt
2. Delete Data in Excel.mp4
2. Delete Data in Excel.srt
3. Edit Data in Excel.mp4
3. Edit Data in Excel.srt
4. Use the fill handle to enter data in Excel.mp4
4. Use the fill handle to enter data in Excel.srt
5. enter custom patterns with the fill handle in Excel.mp4
5. enter custom patterns with the fill handle in Excel.srt
6. Move data in Excel.mp4
6. Move data in Excel.srt
7. Duplicate Data in Excel.mp4
7. Duplicate Data in Excel.srt
8. Use drag and drop in Excel.mp4
8. Use drag and drop in Excel.srt
4. Find and Replace in Excel
1. find a value in Excel.mp4
1. find a value in Excel.srt
2. find a formatted value in Excel.mp4
2. find a formatted value in Excel.srt
3. find all matches at once in Excel.mp4
3. find all matches at once in Excel.srt
4. find and replace a value.mp4
4. find and replace a value.srt
5. find and replace formatted values in Excel.mp4
5. find and replace formatted values in Excel.srt
5. Font Formatting in Excel
1. Format Font and Font Size.mp4
1. Format Font and Font Size.srt
2. Bold, italic and underlining styles.mp4
2. Bold, italic and underlining styles.srt
3. Change font colour.mp4
3. Change font colour.srt
4. Different Underlining options in Excel.mp4
4. Different Underlining options in Excel.srt
5. apply subscript, superscript, and strikethrough formatting in Excel.mp4
5. apply subscript, superscript, and strikethrough formatting in Excel.srt
6. insert symbols and special characters in Excel.mp4
6. insert symbols and special characters in Excel.srt
7. format individual characters in Excel.mp4
7. format individual characters in Excel.srt
6. Borders and fills
1. apply a border to cells in Excel.mp4
1. apply a border to cells in Excel.srt
2. apply a fill to cells in Excel.mp4
2. apply a fill to cells in Excel.srt
3. draw borders and border grids in Excel.mp4
3. draw borders and border grids in Excel.srt
4. apply a border using ribbon presets in Excel.mp4
4. apply a border using ribbon presets in Excel.srt
5. remove existing borders and fills in Excel.mp4
5. remove existing borders and fills in Excel.srt
7. Conditional Formatting in Excel (Module -II)
1. What is Conditional Formatting.mp4
1. What is Conditional Formatting.srt
2. Create Conditional formatting Rule.mp4
2. Create Conditional formatting Rule.srt
3. Edit Conditional formatting Rule.mp4
3. Edit Conditional formatting Rule.srt
4. Add Additional conditional formatting Rule.mp4
4. Add Additional conditional formatting Rule.srt
5. Delete Conditional formatting Rule.mp4
5. Delete Conditional formatting Rule.srt
8. Built in Conditional Format Rules
1. Highlight Top and Bottom Values.mp4
1. Highlight Top and Bottom Values.srt
2. highlight above and below average values.mp4
2. highlight above and below average values.srt
3. use data bars with conditional formatting.mp4
3. use data bars with conditional formatting.srt
4. use color scales with conditional formatting.mp4
4. use color scales with conditional formatting.srt
5. use Icon sets with conditional formatting.mp4
5. use Icon sets with conditional formatting.srt
6. highlight text values with conditional formatting.mp4
6. highlight text values with conditional formatting.srt
7. show duplicate values with conditional formatting.mp4
7. show duplicate values with conditional formatting.srt
9. Conditional formatting with formulas
1. apply conditional formatting with a formula.mp4
1. apply conditional formatting with a formula.srt
10. create zebra stripes with conditional formatting.mp4
10. create zebra stripes with conditional formatting.srt
11. compare two lists and highlight differences.mp4
11. compare two lists and highlight differences.srt
2. Conditional formatting based on a different cell.mp4
2. Conditional formatting based on a different cell.srt
3. Conditional formatting with one variable input.mp4
3. Conditional formatting with one variable input.srt
4. Conditional formatting with two variable inputs.mp4
4. Conditional formatting with two variable inputs.srt
5. highlight rows with conditional formatting.mp4
5. highlight rows with conditional formatting.srt
6. highlight rows using multiple criteria.mp4
6. highlight rows using multiple criteria.srt
7. add a conditional formatting key.mp4
7. add a conditional formatting key.srt
8. check line length with conditional formatting.mp4
8. check line length with conditional formatting.srt
9. build a search box with conditional formatting.mp4
9. build a search box with conditional formatting.srt
Bonus Resources.txt
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [ FreeCourseWeb com ] Udemy - Microsoft Excel- Complete Master Program in MS Excel [2021] Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
