|
/.../4. Formatting & Presenting Data/
|
|
19. PROJECT FOUR Formatting Facebook Inc.’s Actual Income Statement.mp4
|
173.6 MB
|
|
1. 04.01 - Inserting and Deleting Columns & Rows.mp4
|
30.4 MB
|
|
1. 04.01 - Inserting and Deleting Columns & Rows.vtt
|
3.7 KB
|
|
2. 04.02 - Hiding and Unhiding Columns & Rows.mp4
|
65.5 MB
|
|
2. 04.02 - Hiding and Unhiding Columns & Rows.vtt
|
6.1 KB
|
|
3. 04.03 - Adding, Modifying, and Removing Cell Borders.mp4
|
30.0 MB
|
|
3. 04.03 - Adding, Modifying, and Removing Cell Borders.vtt
|
5.7 KB
|
|
4. 04.04 - Applying Different Number Formats.mp4
|
31.2 MB
|
|
4. 04.04 - Applying Different Number Formats.vtt
|
6.2 KB
|
|
5. 04.05 - Adjusting the Number of Decimals Displayed.mp4
|
29.1 MB
|
|
5. 04.05 - Adjusting the Number of Decimals Displayed.vtt
|
5.2 KB
|
|
6. 04.06 - Changing the Widths and Heights of Columns & Rows.mp4
|
58.9 MB
|
|
6. 04.06 - Changing the Widths and Heights of Columns & Rows.vtt
|
5.7 KB
|
|
7. 04.07 - Wrapping Text.mp4
|
22.5 MB
|
|
7. 04.07 - Wrapping Text.vtt
|
4.2 KB
|
|
8. 04.08 - Merging Contents from Multiple Cells.mp4
|
20.6 MB
|
|
8. 04.08 - Merging Contents from Multiple Cells.vtt
|
4.2 KB
|
|
9. 04.09 - Modifying Cell Font.mp4
|
20.0 MB
|
|
9. 04.09 - Modifying Cell Font.vtt
|
4.6 KB
|
|
10. 04.10 - Using Cell Alignment.mp4
|
19.4 MB
|
|
10. 04.10 - Using Cell Alignment.vtt
|
5.0 KB
|
|
11. 04.11 - Using Cell Alignment.mp4
|
13.9 MB
|
|
11. 04.11 - Using Cell Alignment.vtt
|
3.5 KB
|
|
12. 04.12 - Using Cell Orientation.mp4
|
16.9 MB
|
|
12. 04.12 - Using Cell Orientation.vtt
|
3.9 KB
|
|
13. 04.13 - Using the Format Painter.mp4
|
31.1 MB
|
|
13. 04.13 - Using the Format Painter.vtt
|
6.3 KB
|
|
14. 04.14 - Using Paste Special for Formatting.mp4
|
19.6 MB
|
|
14. 04.14 - Using Paste Special for Formatting.vtt
|
4.5 KB
|
|
15. 04.15 - Clearing Cell Formatting.mp4
|
18.7 MB
|
|
15. 04.15 - Clearing Cell Formatting.vtt
|
3.7 KB
|
|
16. 04.16 - Clearing Cell Contents AND Formatting.mp4
|
20.6 MB
|
|
16. 04.16 - Clearing Cell Contents AND Formatting.vtt
|
4.5 KB
|
|
17. 04.17 - Inserting & Using Shapes.mp4
|
25.2 MB
|
|
17. 04.17 - Inserting & Using Shapes.vtt
|
5.8 KB
|
|
18. 04.18 - Inserting Pictures & Other Visual Elements.mp4
|
27.7 MB
|
|
18. 04.18 - Inserting Pictures & Other Visual Elements.vtt
|
5.1 KB
|
|
19. PROJECT FOUR Formatting Facebook Inc.’s Actual Income Statement.vtt
|
20.7 KB
|
|
/
|
|
Visit Coursedrive.org.url
|
0.1 KB
|
|
Course Downloaded from coursedrive.org.txt
|
0.5 KB
|
|
/Microsoft Excel Beginner & Intermediate Training w Projects/
|
|
ReadMe.txt
|
0.5 KB
|
|
Visit Coursedrive.org.url
|
0.1 KB
|
|
/.../1. Getting Started with Excel 2013/
|
|
1. Introduction.mp4
|
9.8 MB
|
|
1. Introduction.vtt
|
3.1 KB
|
|
2. DOWNLOAD Course PDF.pdf
|
739.4 KB
|
|
3. DOWNLOAD Course Excel Files & Individual Project Files.mp4
|
27.0 MB
|
|
3. DOWNLOAD Course Excel Files & Individual Project Files.vtt
|
7.8 KB
|
|
3.1 ProductivityMe Excel Files (Udemy).zip.zip
|
2.0 MB
|
|
4. 01.01 - What is Excel.mp4
|
7.4 MB
|
|
4. 01.01 - What is Excel.vtt
|
2.6 KB
|
|
5. 01.02 - Using Excels Menu System.mp4
|
99.4 MB
|
|
5. 01.02 - Using Excels Menu System.vtt
|
10.3 KB
|
|
6. 01.03 - Using the Quick Access Toolbar.mp4
|
34.8 MB
|
|
6. 01.03 - Using the Quick Access Toolbar.vtt
|
8.1 KB
|
|
7. 01.04 - The Structure of a Worksheet or Workbook.mp4
|
17.3 MB
|
|
7. 01.04 - The Structure of a Worksheet or Workbook.vtt
|
4.5 KB
|
|
8. 01.05 - Using the Formula Bar.mp4
|
12.0 MB
|
|
8. 01.05 - Using the Formula Bar.vtt
|
2.9 KB
|
|
9. 01.06 - Using the Status Bar.mp4
|
37.6 MB
|
|
9. 01.06 - Using the Status Bar.vtt
|
7.1 KB
|
|
10. 01.07 - Navigating Worksheets & Workbooks.mp4
|
61.7 MB
|
|
10. 01.07 - Navigating Worksheets & Workbooks.vtt
|
7.3 KB
|
|
11. 01.08 - Shortcut Menus and the Mini Toolbar.mp4
|
19.1 MB
|
|
11. 01.08 - Shortcut Menus and the Mini Toolbar.vtt
|
4.6 KB
|
|
12. 01.09 - Using Excel's Built-in Help Function.mp4
|
24.5 MB
|
|
12. 01.09 - Using Excel's Built-in Help Function.vtt
|
5.2 KB
|
|
13. 01.10 - Creating New File; Saving That File.mp4
|
29.5 MB
|
|
13. 01.10 - Creating New File; Saving That File.vtt
|
6.1 KB
|
|
14. 01.11 - Opening Existing File; Using Save As.mp4
|
34.5 MB
|
|
14. 01.11 - Opening Existing File; Using Save As.vtt
|
7.2 KB
|
|
Must Read.txt
|
0.5 KB
|
|
Visit Coursedrive.org.url
|
0.1 KB
|
|
/2. Entering Data/
|
|
1. 02.01 - Entering Data.mp4
|
23.6 MB
|
|
1. 02.01 - Entering Data.vtt
|
6.3 KB
|
|
2. 02.02 - Editing Data.mp4
|
17.3 MB
|
|
2. 02.02 - Editing Data.vtt
|
4.0 KB
|
|
3. 02.03 - Undo & Redo.mp4
|
19.6 MB
|
|
3. 02.03 - Undo & Redo.vtt
|
5.3 KB
|
|
4. 02.04 - Navigating within a Worksheet.mp4
|
32.8 MB
|
|
4. 02.04 - Navigating within a Worksheet.vtt
|
7.0 KB
|
|
5. 02.05 - Making Desired Selection.mp4
|
35.5 MB
|
|
5. 02.05 - Making Desired Selection.vtt
|
8.3 KB
|
|
6. 02.06 - Using the Fill Handle.mp4
|
29.3 MB
|
|
6. 02.06 - Using the Fill Handle.vtt
|
6.1 KB
|
|
7. 02.07 - Autocomplete & AutoFill.mp4
|
45.4 MB
|
|
7. 02.07 - Autocomplete & AutoFill.vtt
|
7.9 KB
|
|
8. PROJECT TWO Creating a Simple Income Statement and Attendance Sheet.mp4
|
100.3 MB
|
|
8. PROJECT TWO Creating a Simple Income Statement and Attendance Sheet.vtt
|
15.8 KB
|
|
/.../3. Formulas and Functions/
|
|
1. 03.01 - Entering Basic Math Formulas, Totals, and Averages in Excel..mp4
|
36.6 MB
|
|
1. 03.01 - Entering Basic Math Formulas, Totals, and Averages in Excel..vtt
|
8.7 KB
|
|
2. 03.02 - Replicating Formula from a Near-by Cell.mp4
|
19.5 MB
|
|
2. 03.02 - Replicating Formula from a Near-by Cell.vtt
|
5.5 KB
|
|
3. 03.03 - Applying Varying Formulas Based on Cell's Context.mp4
|
13.1 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
|
27.5 MB
|
|
4. 03.04 - Quickly Remembering Order of Operations in with a Function.vtt
|
6.5 KB
|
|
5. 03.05 - Using Relative, Absolute, and Mixed References.mp4
|
70.5 MB
|
|
5. 03.05 - Using Relative, Absolute, and Mixed References.vtt
|
10.5 KB
|
|
6. 03.06 - Exploring Basic Excel Functions - SUM.mp4
|
20.0 MB
|
|
6. 03.06 - Exploring Basic Excel Functions - SUM.vtt
|
5.0 KB
|
|
7. 03.07 - Exploring Basic Excel Functions - PRODUCT.mp4
|
21.0 MB
|
|
7. 03.07 - Exploring Basic Excel Functions - PRODUCT.vtt
|
4.8 KB
|
|
8. 03.08 - Exploring Basic Excel Functions - AVERAGE.mp4
|
13.7 MB
|
|
8. 03.08 - Exploring Basic Excel Functions - AVERAGE.vtt
|
3.0 KB
|
|
9. 03.09 - Exploring Basic Excel Functions - MIN & MAX.mp4
|
23.8 MB
|
|
9. 03.09 - Exploring Basic Excel Functions - MIN & MAX.vtt
|
4.1 KB
|
|
10. 03.10 - Exploring Basic Excel Functions - COUNT, COUNTA, COUNTBLANK.mp4
|
33.7 MB
|
|
10. 03.10 - Exploring Basic Excel Functions - COUNT, COUNTA, COUNTBLANK.vtt
|
5.4 KB
|
|
11. PROJECT THREE Creating a Gradebook.mp4
|
122.6 MB
|
|
11. PROJECT THREE Creating a Gradebook.vtt
|
18.5 KB
|
|
/5. Database Features/
|
|
1. 05.01 - Sorting Data.mp4
|
89.4 MB
|
|
1. 05.01 - Sorting Data.vtt
|
7.2 KB
|
|
2. 05.02 - Inserting Subtotals within Active Worksheet.mp4
|
88.9 MB
|
|
2. 05.02 - Inserting Subtotals within Active Worksheet.vtt
|
7.9 KB
|
|
3. 05.03 - Filtering Data.mp4
|
100.9 MB
|
|
3. 05.03 - Filtering Data.vtt
|
8.7 KB
|
|
4. 05.04 - Data Tool Text to Columns (Delimited).mp4
|
60.2 MB
|
|
4. 05.04 - Data Tool Text to Columns (Delimited).vtt
|
6.6 KB
|
|
5. 05.05 - Data Tool Text to Columns (Fixed Width).mp4
|
32.7 MB
|
|
5. 05.05 - Data Tool Text to Columns (Fixed Width).vtt
|
4.8 KB
|
|
6. 05.06 - New to Excel 2013 Using Flash Fill.mp4
|
40.3 MB
|
|
6. 05.06 - New to Excel 2013 Using Flash Fill.vtt
|
4.4 KB
|
|
7. 05.07 - Removing Duplicates from Selected Range.mp4
|
54.6 MB
|
|
7. 05.07 - Removing Duplicates from Selected Range.vtt
|
4.3 KB
|
|
8. PROJECT FIVE Sorting Data with an Employee Reference Sheet.mp4
|
162.8 MB
|
|
8. PROJECT FIVE Sorting Data with an Employee Reference Sheet.vtt
|
12.6 KB
|
|
/6. Using Tables/
|
|
1. 06.01 - Getting Started with Tables.mp4
|
27.3 MB
|
|
1. 06.01 - Getting Started with Tables.vtt
|
3.2 KB
|
|
2. 06.02 - Inserting Tables & Understanding Contextual Tabs.mp4
|
35.9 MB
|
|
2. 06.02 - Inserting Tables & Understanding Contextual Tabs.vtt
|
3.6 KB
|
|
3. 06.03 - Modifying Table Formatting & Design.mp4
|
41.0 MB
|
|
3. 06.03 - Modifying Table Formatting & Design.vtt
|
3.3 KB
|
|
4. 06.04 - Filtering a Table & Using the Search Functionality.mp4
|
54.8 MB
|
|
4. 06.04 - Filtering a Table & Using the Search Functionality.vtt
|
3.9 KB
|
|
5. 06.05 - Adding Rows & Columns to a Table.mp4
|
51.9 MB
|
|
5. 06.05 - Adding Rows & Columns to a Table.vtt
|
3.9 KB
|
|
6. 06.06 - Converting a Table to a Range.mp4
|
37.0 MB
|
|
6. 06.06 - Converting a Table to a Range.vtt
|
3.8 KB
|
|
7. PROJECT SIX Using Tables to Store a Class Gradebook.mp4
|
122.3 MB
|
|
7. PROJECT SIX Using Tables to Store a Class Gradebook.vtt
|
11.9 KB
|
|
ReadMe.txt
|
0.5 KB
|
|
Visit Coursedrive.org.url
|
0.1 KB
|
|
/7. Charts & Graphs/
|
|
1. 07.01 - Getting Started with Charts.mp4
|
8.1 MB
|
|
1. 07.01 - Getting Started with Charts.vtt
|
2.1 KB
|
|
2. 07.02 - Inserting Charts in Excel.mp4
|
23.2 MB
|
|
2. 07.02 - Inserting Charts in Excel.vtt
|
4.9 KB
|
|
3. 07.03 - New to Excel 2013 Recommended Charts.mp4
|
27.1 MB
|
|
3. 07.03 - New to Excel 2013 Recommended Charts.vtt
|
5.8 KB
|
|
4. 07.04 - Understanding Chart Data & Chart Elements.mp4
|
27.0 MB
|
|
4. 07.04 - Understanding Chart Data & Chart Elements.vtt
|
4.9 KB
|
|
5. 07.05 - Modifying Chart Type.mp4
|
17.3 MB
|
|
5. 07.05 - Modifying Chart Type.vtt
|
3.9 KB
|
|
6. 07.06 - Formatting the Data, Type, Location, and Elements of a Chart.mp4
|
36.9 MB
|
|
6. 07.06 - Formatting the Data, Type, Location, and Elements of a Chart.vtt
|
5.9 KB
|
|
7. 07.07 - Modifying Chart Axis, Labels, Gridlines, Etc..mp4
|
19.6 MB
|
|
7. 07.07 - Modifying Chart Axis, Labels, Gridlines, Etc..vtt
|
3.9 KB
|
|
8. 07.08 - Copying & Pasting Charts in Excel.mp4
|
20.5 MB
|
|
8. 07.08 - Copying & Pasting Charts in Excel.vtt
|
3.6 KB
|
|
9. 07.09 - New to Excel 2013 Sparklines (In-Cell MiniGraphs).mp4
|
27.6 MB
|
|
9. 07.09 - New to Excel 2013 Sparklines (In-Cell MiniGraphs).vtt
|
6.2 KB
|
|
10. PROJECT SEVEN Graphing Sales Data from Apple Inc. Annual Report.mp4
|
76.9 MB
|
|
10. PROJECT SEVEN Graphing Sales Data from Apple Inc. Annual Report.vtt
|
11.9 KB
|
|
/.../8. Modifying & Adjusting Data/
|
|
1. 08.01 - Modifying Cells - Dragging, Dropping, and Using Fill Handel (in Same Wor.mp4
|
13.0 MB
|
|
1. 08.01 - Modifying Cells - Dragging, Dropping, and Using Fill Handel (in Same Wor.vtt
|
3.2 KB
|
|
2. 08.02 - Cutting, Copying, and Pasting (in Same Worksheet).mp4
|
18.8 MB
|
|
2. 08.02 - Cutting, Copying, and Pasting (in Same Worksheet).vtt
|
2.7 KB
|
|
3. 08.03 - Dragging & Dropping Contents (between Multiple Worksheets).mp4
|
17.8 MB
|
|
3. 08.03 - Dragging & Dropping Contents (between Multiple Worksheets).vtt
|
3.5 KB
|
|
4. 08.04 - Cutting, Copying, and Pasting (between Multiple Worksheets).mp4
|
15.6 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
|
43.6 MB
|
|
5. 08.05 - Using Paste Special for More than Formatting.vtt
|
6.3 KB
|
|
6. 08.06 - Finding & Replacing Cell Contents.mp4
|
74.9 MB
|
|
6. 08.06 - Finding & Replacing Cell Contents.vtt
|
6.4 KB
|
|
7. 08.07 - Using Spellcheck in Excel.mp4
|
21.7 MB
|
|
7. 08.07 - Using Spellcheck in Excel.vtt
|
4.7 KB
|
|
8. PROJECT EIGHT Using Data from Apple Inc. Net Sales by Operating Segment.mp4
|
73.5 MB
|
|
8. PROJECT EIGHT Using Data from Apple Inc. Net Sales by Operating Segment.vtt
|
10.9 KB
|
|
/.../9. Using Special View Features within Workbooks/
|
|
1. 09.01 - Adding Comments to a Worksheet.mp4
|
41.8 MB
|
|
1. 09.01 - Adding Comments to a Worksheet.vtt
|
4.0 KB
|
|
2. 09.02 - Freezing & Unfreezing Panes in Active Sheet.mp4
|
67.9 MB
|
|
2. 09.02 - Freezing & Unfreezing Panes in Active Sheet.vtt
|
4.3 KB
|
|
3. 09.03 - Splitting Screens in Excel (Horizontally & Vertically).mp4
|
60.2 MB
|
|
3. 09.03 - Splitting Screens in Excel (Horizontally & Vertically).vtt
|
4.7 KB
|
|
4. 09.04 - Displaying Multiple Worksheets or Workbooks.mp4
|
38.5 MB
|
|
4. 09.04 - Displaying Multiple Worksheets or Workbooks.vtt
|
6.1 KB
|
|
5. PROJECT NINE Looking at Hiring Interns as a Manager at Facebook.mp4
|
73.8 MB
|
|
5. PROJECT NINE Looking at Hiring Interns as a Manager at Facebook.vtt
|
6.9 KB
|
|
/.../10. Section 10 Managing Worksheets within a Workbook/
|
|
1. 10.01 - Renaming a Worksheet; Coloring a Worksheet.mp4
|
19.6 MB
|
|
1. 10.01 - Renaming a Worksheet; Coloring a Worksheet.vtt
|
3.8 KB
|
|
2. 10.02 - Inserting & Deleting Worksheets.mp4
|
14.7 MB
|
|
2. 10.02 - Inserting & Deleting Worksheets.vtt
|
3.4 KB
|
|
3. 10.03 - Moving, Copying, and Grouping Sheets.mp4
|
35.6 MB
|
|
3. 10.03 - Moving, Copying, and Grouping Sheets.vtt
|
6.4 KB
|
|
4. 10.04 - Modifying Multiple Worksheets Simultaneously.mp4
|
19.2 MB
|
|
4. 10.04 - Modifying Multiple Worksheets Simultaneously.vtt
|
3.8 KB
|
|
5. PROJECT TEN Tracking Facebook Inc. Active Daily Users (2011-2014).mp4
|
38.9 MB
|
|
5. PROJECT TEN Tracking Facebook Inc. Active Daily Users (2011-2014).vtt
|
7.5 KB
|
|
/.../11. Course Wrap-Up/
|
|
1. Final Thoughts & Next Steps.mp4
|
23.9 MB
|
|
1. Final Thoughts & Next Steps.vtt
|
4.1 KB
|
|
ReadMe.txt
|
0.5 KB
|
|
Visit Coursedrive.org.url
|
0.1 KB
|
|
Total files 202
|
