Other
Microsoft Excel Functions, Formulas, Analysis, & Dashboards
Torrent info
Torrent Files List
[TutsNode.com] - Microsoft Excel Functions, Formulas, Analysis, & Dashboards (Size: 2.47 GB) (Files: 146)
[TutsNode.com] - Microsoft Excel Functions, Formulas, Analysis, & Dashboards
4. Level 4 Compiling data
1. Vlookup.mp4
1. Vlookup.srt
1.1 Vlookup.xlsx
2. Hlookup.mp4
2. Hlookup.srt
2.1 Hlookup.xlsx
3. Consolidate.mp4
3. Consolidate.srt
3.1 Consolidate.xlsx
4. Append data with Power Query.mp4
4. Append data with Power Query.srt
4.1 MonthlySalesFiles.zip
1. Level 1 Getting to know Excel
1. Introduction to Spreadsheet, Cell, Column and Row.mp4
1. Introduction to Spreadsheet, Cell, Column and Row.srt
2. Learning keyboard shortcuts to navigatge in a sheet, to add columns and rows.mp4
2. Learning keyboard shortcuts to navigatge in a sheet, to add columns and rows.srt
3. Understanding cell format.mp4
3. Understanding cell format.srt
4. Autofill.mp4
4. Autofill.srt
5. Basic Mathamatical functions.mp4
5. Basic Mathamatical functions.srt
6. Practice on real data.mp4
6. Practice on real data.srt
6.1 Practice sheet.xlsx
2. Level 2 Cleaning data
1. Remove duplicates.mp4
1. Remove duplicates.srt
1.1 Product-Lookup - removing duplicates.xlsx
2. Removing spaces.mp4
2. Removing spaces.srt
2.1 Product-Lookup - removing spaces.xlsx
3. Spell check.mp4
3. Spell check.srt
3.1 Product-Lookup - spell check.xlsx
4. Find Find & Replace.mp4
4. Find Find & Replace.srt
4.1 Product-Lookup - find find and replace.xlsx
5. Replacing blank cells.mp4
5. Replacing blank cells.srt
5.1 Product-Lookup - blanks.xlsx
6. Using proper fonts.mp4
6. Using proper fonts.srt
6.1 Product-Lookup - Proper case.xlsx
3. Level 3 Transforming Data
1. Merging data in cells.mp4
1. Merging data in cells.srt
1.1 Product-Lookup - merging data in columns.xlsx
2. Text to Columns.mp4
2. Text to Columns.srt
2.1 Product-Lookup - unmerge or delimate.xlsx
3. Data Sorting.mp4
3. Data Sorting.srt
3.1 Product-Lookup - sorting.xlsx
4. Transpose Data.mp4
4. Transpose Data.srt
4.1 Transpose.xlsx
5. Flash Fill.mp4
5. Flash Fill.srt
5.1 Flash fill.xlsx
5. Level 5 Getting ready for Data Analysis
1. Manipulating dates - Date Month Year.mp4
1. Manipulating dates - Date Month Year.srt
1.1 Getting ready for data analysis - lectures.xlsx
2. Manipulate dates - Name of the Day Name of the Month.mp4
2. Manipulate dates - Name of the Day Name of the Month.srt
3. Manipulating dates - Day of the week Week of the year.mp4
3. Manipulating dates - Day of the week Week of the year.srt
4. Day of the Year.mp4
4. Day of the Year.srt
5. Quarter of the Year.mp4
5. Quarter of the Year.srt
6. Dynamic TODAY Tomorrow Yesterday.mp4
6. Dynamic TODAY Tomorrow Yesterday.srt
7. Calculating Age.mp4
7. Calculating Age.srt
8. Adding conditional columns based on IF.mp4
8. Adding conditional columns based on IF.srt
9. NESTED IF.mp4
9. NESTED IF.srt
10. IF OR.mp4
10. IF OR.srt
11. IF OR Multiple Column.mp4
11. IF OR Multiple Column.srt
12. IF OR OR OR Practice.mp4
12. IF OR OR OR Practice.srt
13. IF AND.mp4
13. IF AND.srt
14. IF AND AND AND Practice.mp4
14. IF AND AND AND Practice.srt
6. Level 6 Basic Data Analysis (Ad hoc Data Analysis)
1. Freeze Panes.mp4
1. Freeze Panes.srt
1.1 Analysis sheet.xlsx
2. Filters and advance filters.mp4
2. Filters and advance filters.srt
3. Conditional Formatting.mp4
3. Conditional Formatting.srt
4. Subtotals.mp4
4. Subtotals.srt
5. COUNTIF.mp4
5. COUNTIF.srt
6. COUNTIFS.mp4
6. COUNTIFS.srt
7. SUMIF.mp4
7. SUMIF.srt
8. SUMIFS.mp4
8. SUMIFS.srt
7. Level 7 Data Analysis
1. Introduction to Data Analaysis and Data.mp4
1. Introduction to Data Analaysis and Data.srt
1.1 Analysis - lectures.xlsx
2. Summay by a parameter.mp4
2. Summay by a parameter.srt
3. Adding parameters with drill down and drill up.mp4
3. Adding parameters with drill down and drill up.srt
4. Breaking down information by Column.mp4
4. Breaking down information by Column.srt
5. Filtering the data in reports.mp4
5. Filtering the data in reports.srt
6. Understanding Value Field Settings.mp4
6. Understanding Value Field Settings.srt
7. Working with Dates in rows.mp4
7. Working with Dates in rows.srt
8. Grouping example.mp4
8. Grouping example.srt
9. Compiling data on one sheet.mp4
9. Compiling data on one sheet.srt
10. Slicers.mp4
10. Slicers.srt
11. Timeline.mp4
11. Timeline.srt
8. Preparing Dashboard
1. Introduction and first chart.mp4
1. Introduction and first chart.srt
1.1 Dashboard - data.xlsx
2. Exploring the chart options further.mp4
2. Exploring the chart options further.srt
3. Compiling data on one sheet.mp4
3. Compiling data on one sheet.srt
4. Adding timeline (time slicer) on dashboard.mp4
4. Adding timeline (time slicer) on dashboard.srt
5. Adding and adjusting slicers.mp4
5. Adding and adjusting slicers.srt
6. Adding trendline charts.mp4
6. Adding trendline charts.srt
9. Keyboard Shortcuts Masterclass
1. Shortcuts Masterclass Part 1.mp4
1. Shortcuts Masterclass Part 1.srt
2. Shortcuts Masterclass Part 2.mp4
2. Shortcuts Masterclass Part 2.srt
TutsNode.com.txt
[TGx]Downloaded from torrentgalaxy.to .txt
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch Microsoft Excel Functions, Formulas, Analysis, & Dashboards Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
