Udemy - Microsoft Excel Beginner & Intermediate Training w Projec...

Files:

• 19. PROJECT FOUR Formatting Facebook Inc.’s Actual Income Statement.mp4 (165.5 MB)
• 1. 04.01 - Inserting and Deleting Columns & Rows.mp4 (29.0 MB)
• 1. 04.01 - Inserting and Deleting Columns & Rows.vtt (3.7 KB)
• 2. 04.02 - Hiding and Unhiding Columns & Rows.mp4 (62.5 MB)
• 2. 04.02 - Hiding and Unhiding Columns & Rows.vtt (6.0 KB)
• 3. 04.03 - Adding, Modifying, and Removing Cell Borders.mp4 (28.6 MB)
• 3. 04.03 - Adding, Modifying, and Removing Cell Borders.vtt (5.6 KB)
• 4. 04.04 - Applying Different Number Formats.mp4 (29.7 MB)
• 4. 04.04 - Applying Different Number Formats.vtt (6.1 KB)
• 5. 04.05 - Adjusting the Number of Decimals Displayed.mp4 (27.7 MB)
• 5. 04.05 - Adjusting the Number of Decimals Displayed.vtt (5.1 KB)
• 6. 04.06 - Changing the Widths and Heights of Columns & Rows.mp4 (56.2 MB)
• 6. 04.06 - Changing the Widths and Heights of Columns & Rows.vtt (5.5 KB)
• 7. 04.07 - Wrapping Text.mp4 (21.5 MB)
• 7. 04.07 - Wrapping Text.vtt (4.1 KB)
• 8. 04.08 - Merging Contents from Multiple Cells.mp4 (19.6 MB)
• 8. 04.08 - Merging Contents from Multiple Cells.vtt (4.1 KB)
• 9. 04.09 - Modifying Cell Font.mp4 (19.1 MB)
• 9. 04.09 - Modifying Cell Font.vtt (4.5 KB)
• 10. 04.10 - Using Cell Alignment.mp4 (18.5 MB)
• 10. 04.10 - Using Cell Alignment.vtt (4.9 KB)
• 11. 04.11 - Using Cell Alignment.mp4 (13.2 MB)
• 11. 04.11 - Using Cell Alignment.vtt (3.4 KB)
• 12. 04.12 - Using Cell Orientation.mp4 (16.2 MB)
• 12. 04.12 - Using Cell Orientation.vtt (3.8 KB)
• 13. 04.13 - Using the Format Painter.mp4 (29.7 MB)
• 13. 04.13 - Using the Format Painter.vtt (6.1 KB)
• 14. 04.14 - Using Paste Special for Formatting.mp4 (18.7 MB)
• 14. 04.14 - Using Paste Special for Formatting.vtt (4.4 KB)
• 15. 04.15 - Clearing Cell Formatting.mp4 (17.9 MB)
• 15. 04.15 - Clearing Cell Formatting.vtt (3.6 KB)
• 16. 04.16 - Clearing Cell Contents AND Formatting.mp4 (19.6 MB)
• 16. 04.16 - Clearing Cell Contents AND Formatting.vtt (4.4 KB)
• 17. 04.17 - Inserting & Using Shapes.mp4 (24.1 MB)
• 17. 04.17 - Inserting & Using Shapes.vtt (5.7 KB)
• 18. 04.18 - Inserting Pictures & Other Visual Elements.mp4 (26.4 MB)
• 18. 04.18 - Inserting Pictures & Other Visual Elements.vtt (5.0 KB)
• 19. PROJECT FOUR Formatting Facebook Inc.’s Actual Income Statement.vtt (20.2 KB)

• ReadMe.txt (0.5 KB)
• Visit Coursedrive.org.url (0.1 KB)
1. Getting Started with Excel 2013
• 1. Introduction.mp4 (9.4 MB)
• 1. Introduction.vtt (3.0 KB)
• 2. DOWNLOAD Course PDF.pdf (722.0 KB)
• 3. DOWNLOAD Course Excel Files & Individual Project Files.mp4 (25.8 MB)
• 3. DOWNLOAD Course Excel Files & Individual Project Files.vtt (7.6 KB)
• 3.1 ProductivityMe Excel Files (Udemy).zip.zip (1.9 MB)
• 4. 01.01 - What is Excel.mp4 (7.1 MB)
• 4. 01.01 - What is Excel.vtt (2.5 KB)
• 5. 01.02 - Using Excels Menu System.mp4 (94.8 MB)
• 5. 01.02 - Using Excels Menu System.vtt (10.1 KB)
• 6. 01.03 - Using the Quick Access Toolbar.mp4 (33.1 MB)
• 6. 01.03 - Using the Quick Access Toolbar.vtt (7.9 KB)
• 7. 01.04 - The Structure of a Worksheet or Workbook.mp4 (16.5 MB)
• 7. 01.04 - The Structure of a Worksheet or Workbook.vtt (4.4 KB)
• 8. 01.05 - Using the Formula Bar.mp4 (11.4 MB)
• 8. 01.05 - Using the Formula Bar.vtt (2.8 KB)
• 9. 01.06 - Using the Status Bar.mp4 (35.8 MB)
• 9. 01.06 - Using the Status Bar.vtt (6.9 KB)
• 10. 01.07 - Navigating Worksheets & Workbooks.mp4 (58.8 MB)
• 10. 01.07 - Navigating Worksheets & Workbooks.vtt (7.1 KB)
• 11. 01.08 - Shortcut Menus and the Mini Toolbar.mp4 (18.2 MB)
• 11. 01.08 - Shortcut Menus and the Mini Toolbar.vtt (4.5 KB)
• 12. 01.09 - Using Excel's Built-in Help Function.mp4 (23.4 MB)
• 12. 01.09 - Using Excel's Built-in Help Function.vtt (5.1 KB)
• 13. 01.10 - Creating New File; Saving That File.mp4 (28.1 MB)
• 13. 01.10 - Creating New File; Saving That File.vtt (6.0 KB)
• 14. 01.11 - Opening Existing File; Using Save As.mp4 (32.9 MB)
• 14. 01.11 - Opening Existing File; Using Save As.vtt (7.0 KB)
• Must Read.txt (0.5 KB)
• Visit Coursedrive.org.url (0.1 KB)
2. Entering Data
• 1. 02.01 - Entering Data.mp4 (22.5 MB)
• 1. 02.01 - Entering Data.vtt (6.1 KB)
• 2. 02.02 - Editing Data.mp4 (16.5 MB)
• 2. 02.02 - Editing Data.vtt (3.9 KB)
• 3. 02.03 - Undo & Redo.mp4 (18.7 MB)
• 3. 02.03 - Undo & Redo.vtt (5.1 KB)
• 4. 02.04 - Navigating within a Worksheet.mp4 (31.3 MB)
• 4. 02.04 - Navigating within a Worksheet.vtt (6.8 KB)
• 5. 02.05 - Making Desired Selection.mp4 (33.9 MB)
• 5. 02.05 - Making Desired Selection.vtt (8.1 KB)
• 6. 02.06 - Using the Fill Handle.mp4 (28.0 MB)
• 6. 02.06 - Using the Fill Handle.vtt (6.0 KB)
• 7. 02.07 - Autocomplete & AutoFill.mp4 (43.3 MB)
• 7. 02.07 - Autocomplete & AutoFill.vtt (7.7 KB)
• 8. PROJECT TWO Creating a Simple Income Statement and Attendance Sheet.mp4 (95.7 MB)
• 8. PROJECT TWO Creating a Simple Income Statement and Attendance Sheet.vtt (15.4 KB)
3. Formulas and Functions
• 1. 03.01 - Entering Basic Math Formulas, Totals, and Averages in Excel..mp4 (34.9 MB)
• 1. 03.01 - Entering Basic Math Formulas, Totals, and Averages in Excel..vtt (8.5 KB)
• 2. 03.02 - Replicating Formula from a Near-by Cell.mp4 (18.6 MB)
• 2. 03.02 - Replicating Formula from a Near-by Cell.vtt (5.4 KB)
• 3. 03.03 - Applying Varying Formulas Based on Cell's Context.mp4 (12.5 MB)
• 3. 03.03 - Applying Varying Formulas Based on Cell's Context.vtt (3.4 KB)
• 4. 03.04 - Quickly Remembering Order of Operations in with a Function.mp4 (26.2 MB)
• 4. 03.04 - Quickly Remembering Order of Operations in with a Function.vtt (6.4 KB)
• 5. 03.05 - Using Relative, Absolute, and Mixed References.mp4 (67.2 MB)
• 5. 03.05 - Using Relative, Absolute, and Mixed References.vtt (10.2 KB)
• 6. 03.06 - Exploring Basic Excel Functions - SUM.mp4 (19.1 MB)
• 6. 03.06 - Exploring Basic Excel Functions - SUM.vtt (4.9 KB)
• 7. 03.07 - Exploring Basic Excel Functions - PRODUCT.mp4 (20.0 MB)
• 7. 03.07 - Exploring Basic Excel Functions - PRODUCT.vtt (4.7 KB)
• 8. 03.08 - Exploring Basic Excel Functions - AVERAGE.mp4 (13.0 MB)
• 8. 03.08 - Exploring Basic Excel Functions - AVERAGE.vtt (2.9 KB)
• 9. 03.09 - Exploring Basic Excel Functions - MIN & MAX.mp4 (22.7 MB)
• 9. 03.09 - Exploring Basic Excel Functions - MIN & MAX.vtt (4.0 KB)
• 10. 03.10 - Exploring Basic Excel Functions - COUNT, COUNTA, COUNTBLANK.mp4 (32.1 MB)
• 10. 03.10 - Exploring Basic Excel Functions - COUNT, COUNTA, COUNTBLANK.vtt (5.3 KB)
• 11. PROJECT THREE Creating a Gradebook.mp4 (116.9 MB)
• 11. PROJECT THREE Creating a Gradebook.vtt (18.0 KB)
5. Database Features
• 1. 05.01 - Sorting Data.mp4 (85.2 MB)
• 1. 05.01 - Sorting Data.vtt (7.1 KB)
• 2. 05.02 - Inserting Subtotals within Active Worksheet.mp4 (84.8 MB)
• 2. 05.02 - Inserting Subtotals within Active Worksheet.vtt (7.7 KB)
• 3. 05.03 - Filtering Data.mp4 (96.2 MB)
• 3. 05.03 - Filtering Data.vtt (8.5 KB)
• 4. 05.04 - Data Tool Text to Columns (Delimited).mp4 (57.4 MB)
• 4. 05.04 - Data Tool Text to Columns (Delimited).vtt (6.5 KB)
• 5. 05.05 - Data Tool Text to Columns (Fixed Width).mp4 (31.2 MB)
• 5. 05.05 - Data Tool Text to Columns (Fixed Width).vtt (4.7 KB)
• 6. 05.06 - New to Excel 2013 Using Flash Fill.mp4 (38.4 MB)
• 6. 05.06 - New to Excel 2013 Using Flash Fill.vtt (4.3 KB)
• 7. 05.07 - Removing Duplicates from Selected Range.mp4 (52.1 MB)
• 7. 05.07 - Removing Duplicates from Selected Range.vtt (4.2 KB)
• 8. PROJECT FIVE Sorting Data with an Employee Reference Sheet.mp4 (155.2 MB)
• 8. PROJECT FIVE Sorting Data with an Employee Reference Sheet.vtt (12.3 KB)
6. Using Tables
• 1. 06.01 - Getting Started with Tables.mp4 (26.0 MB)
• 1. 06.01 - Getting Started with Tables.vtt (3.1 KB)
• 2. 06.02 - Inserting Tables & Understanding Contextual Tabs.mp4 (34.3 MB)
• 2. 06.02 - Inserting Tables & Understanding Contextual Tabs.vtt (3.5 KB)
• 3. 06.03 - Modifying Table Formatting & Design.mp4 (39.1 MB)
• 3. 06.03 - Modifying Table Formatting & Design.vtt (3.2 KB)
• 4. 06.04 - Filtering a Table & Using the Search Functionality.mp4 (52.3 MB)
• 4. 06.04 - Filtering a Table & Using the Search Functionality.vtt (3.8 KB)
• 5. 06.05 - Adding Rows & Columns to a Table.mp4 (49.5 MB)
• 5. 06.05 - Adding Rows & Columns to a Table.vtt (3.8 KB)
• 6. 06.06 - Converting a Table to a Range.mp4 (35.3 MB)
• 6. 06.06 - Converting a Table to a Range.vtt (3.7 KB)
• 7. PROJECT SIX Using Tables to Store a Class Gradebook.mp4 (116.6 MB)
• 7. PROJECT SIX Using Tables to Store a Class Gradebook.vtt (11.6 KB)
• ReadMe.txt (0.5 KB)
• Visit Coursedrive.org.url (0.1 KB)
7. Charts & Graphs
• 1. 07.01 - Getting Started with Charts.mp4 (7.7 MB)
• 1. 07.01 - Getting Started with Charts.vtt (2.1 KB)
• 2. 07.02 - Inserting Charts in Excel.mp4 (22.1 MB)
• 2. 07.02 - Inserting Charts in Excel.vtt (4.8 KB)
• 3. 07.03 - New to Excel 2013 Recommended Charts.mp4 (25.8 MB)
• 3. 07.03 - New to Excel 2013 Recommended Charts.vtt (5.6 KB)
• 4. 07.04 - Understanding Chart Data & Chart Elements.mp4 (25.7 MB)
• 4. 07.04 - Understanding Chart Data & Chart Elements.vtt (4.7 KB)
• 5. 07.05 - Modifying Chart Type.mp4 (16.5 MB)
• 5. 07.05 - Modifying Chart Type.vtt (3.8 KB)
• 6. 07.06 - Formatting the Data, Type, Location, and Elements of a Chart.mp4 (35.2 MB)
• 6. 07.06 - Formatting the Data, Type, Location, and Elements of a Chart.vtt (5.8 KB)
• 7. 07.07 - Modifying Chart Axis, Labels, Gridlines, Etc..mp4 (18.7 MB)
• 7. 07.07 - Modifying Chart Axis, Labels, Gridlines, Etc..vtt (3.8 KB)
• 8. 07.08 - Copying & Pasting Charts in Excel.mp4 (19.6 MB)
• 8. 07.08 - Copying & Pasting Charts in Excel.vtt (3.5 KB)
• 9. 07.09 - New to Excel 2013 Sparklines (In-Cell MiniGraphs).mp4 (26.3 MB)
• 9. 07.09 - New to Excel 2013 Sparklines (In-Cell MiniGraphs).vtt (6.0 KB)
• 10. PROJECT SEVEN Graphing Sales Data from Apple Inc. Annual Report.mp4 (73.3 MB)
• 10. PROJECT SEVEN Graphing Sales Data from Apple Inc. Annual Report.vtt (11.7 KB)
8. Modifying & Adjusting Data
• 1. 08.01 - Modifying Cells - Dragging, Dropping, and Using Fill Handel (in Same Wor.mp4 (12.4 MB)
• 1. 08.01 - Modifying Cells - Dragging, Dropping, and Using Fill Handel (in Same Wor.vtt (3.1 KB)
• 2. 08.02 - Cutting, Copying, and Pasting (in Same Worksheet).mp4 (17.9 MB)
• 2. 08.02 - Cutting, Copying, and Pasting (in Same Worksheet).vtt (2.6 KB)
• 3. 08.03 - Dragging & Dropping Contents (between Multiple Worksheets).mp4 (17.0 MB)
• 3. 08.03 - Dragging & Dropping Contents (between Multiple Worksheets).vtt (3.4 KB)
• 4. 08.04 - Cutting, Copying, and Pasting (between Multiple Worksheets).mp4 (14.9 MB)
• 4. 08.04 - Cutting, Copying, and Pasting (between Multiple Worksheets).vtt (3.1 KB)
• 5. 08.05 - Using Paste Special for More than Formatting.mp4 (41.6 MB)
• 5. 08.05 - Using Paste Special for More than Formatting.vtt (6.1 KB)
• 6. 08.06 - Finding & Replacing Cell Contents.mp4 (71.4 MB)
• 6. 08.06 - Finding & Replacing Cell Contents.vtt (6.2 KB)
• 7. 08.07 - Using Spellcheck in Excel.mp4 (20.7 MB)
• 7. 08.07 - Using Spellcheck in Excel.vtt (4.6 KB)
• 8. PROJECT EIGHT Using Data from Apple Inc. Net Sales by Operating Segment.mp4 (70.1 MB)
• 8. PROJECT EIGHT Using Data from Apple Inc. Net Sales by Operating Segment.vtt (10.7 KB)
9. Using Special View Features within Workbooks
• 1. 09.01 - Adding Comments to a Worksheet.mp4 (39.9 MB)
• 1. 09.01 - Adding Comments to a Worksheet.vtt (3.9 KB)
• 2. 09.02 - Freezing & Unfreezing Panes in Active Sheet.mp4 (64.7 MB)
• 2. 09.02 - Freezing & Unfreezing Panes in Active Sheet.vtt (4.2 KB)
• 3. 09.03 - Splitting Screens in Excel (Horizontally & Vertically).mp4 (57.4 MB)
• 3. 09.03 - Splitting Screens in Excel (Horizontally & Vertically).vtt (4.6 KB)
• 4. 09.04 - Displaying Multiple Worksheets or Workbooks.mp4 (36.7 MB)
• 4. 09.04 - Displaying Multiple Worksheets or Workbooks.vtt (5.9 KB)
• 5. PROJECT NINE Looking at Hiring Interns as a Manager at Facebook.mp4 (70.4 MB)
• 5. PROJECT NINE Looking at Hiring Interns as a Manager at Facebook.vtt (6.7 KB)
10. Section 10 Managing Worksheets within a Workbook
• 1. 10.01 - Renaming a Worksheet; Coloring a Worksheet.mp4 (18.7 MB)
• 1. 10.01 - Renaming a Worksheet; Coloring a Worksheet.vtt (3.7 KB)
• 2. 10.02 - Inserting & Deleting Worksheets.mp4 (14.1 MB)
• 2. 10.02 - Inserting & Deleting Worksheets.vtt (3.3 KB)
• 3. 10.03 - Moving, Copying, and Grouping Sheets.mp4 (33.9 MB)
• 3. 10.03 - Moving, Copying, and Grouping Sheets.vtt (6.2 KB)
• 4. 10.04 - Modifying Multiple Worksheets Simultaneously.mp4 (18.3 MB)
• 4. 10.04 - Modifying Multiple Worksheets Simultaneously.vtt (3.7 KB)
• 5. PROJECT TEN Tracking Facebook Inc. Active Daily Users (2011-2014).mp4 (37.1 MB)
• 5. PROJECT TEN Tracking Facebook Inc. Active Daily Users (2011-2014).vtt (7.3 KB)
11. Course Wrap-Up
• 1. Final Thoughts & Next Steps.mp4 (22.8 MB)
• 1. Final Thoughts & Next Steps.vtt (4.0 KB)
• ReadMe.txt (0.5 KB)
• Visit Coursedrive.org.url (0.1 KB)
• Visit Coursedrive.org.url (0.1 KB)
• Course Downloaded from coursedrive.org.txt (0.5 KB)