Udemy - Microsoft Excel - Data Analysis, Management and Visualiza...

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction to Microsoft Excel
• 1 - Overview of Microsoft Excel Interface.mp4 (47.9 MB)
• 2 - Workbook and Worksheet Management.mp4 (56.7 MB)
• 3 - Data Entry and Editing.mp4 (56.8 MB)
• 4 - Basic Formatting Techniques.mp4 (73.5 MB)
• 5 - Saving and Printing Workbooks.mp4 (56.5 MB)
2 - Essential Excel Functions and Formulas
• 1 - Basic Formulas (SUM, AVERAGE, MIN, MAX).mp4 (37.2 MB)
• 2 - Relative, Absolute, and Mixed References.mp4 (39.6 MB)
• 3 - Logical Functions (IF, AND, OR, NOT).mp4 (74.3 MB)
• 4 - Text Functions (LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN).mp4 (74.0 MB)
• 5 - Date and Time Functions (TODAY, NOW, DATEDIF, EOMONTH).mp4 (44.4 MB)
3 - Data Management and Organization
• 1 - Sorting and Filtering Data.mp4 (41.0 MB)
• 2 - Data Validation and Drop-Down Lists.mp4 (33.6 MB)
• 3 - Conditional Formatting.mp4 (49.4 MB)
• 4 - Flash Fill and AutoFill.mp4 (31.9 MB)
• 5 - Remove Duplicates and Text to Columns.mp4 (42.3 MB)
4 - Data Analysis with Excel
• 1 - Introduction to Pivot Tables and Pivot Charts.mp4 (59.1 MB)
• 2 - Using Slicers and Timelines.mp4 (56.2 MB)
• 3 - Subtotals and Grouping Data.mp4 (57.5 MB)
• 4 - Descriptive Statistics with Data Analysis Toolpak.mp4 (70.1 MB)
• 5 - Scenario Manager, Goal Seek, and Data Tables.mp4 (62.9 MB)
5 - Data Visualization
• 1 - Creating and Formatting Charts (Column, Line, Pie, Bar, Area).mp4 (58.5 MB)
• 2 - Advanced Charts (Combo Charts, Sparklines, Waterfall).mp4 (74.7 MB)
• 3 - Customizing Chart Elements.mp4 (58.3 MB)
• 4 - Inserting and Designing SmartArt.mp4 (52.3 MB)
6 - Advanced Excel Functions
• 1 - Lookup Functions (VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP).mp4 (76.3 MB)
• 2 - Array Formulas and Dynamic Arrays (SEQUENCE, FILTER, SORT).mp4 (84.9 MB)
• 3 - Error Handling Functions (IFERROR, ISERROR).mp4 (54.0 MB)
• Bonus Resources.txt (0.1 KB)