Udemy - The Ultimate Microsoft Excel 2010 Training Course - 14 Ho...

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Intro to Excel 2010
• 1 - Introduction and Overview of Excel Course English.vtt (1.4 KB)
• 1 - Introduction and Overview of Excel Course.mp4 (1.3 MB)
• 2 - READ ME Essential Information for a Successful Training Experience.html (1.9 KB)
• 3 - Overview of the Excel Window English.vtt (16.0 KB)
• 3 - Overview of the Excel Window.mp4 (19.3 MB)
• 4 - Working with the Mouse English.vtt (5.2 KB)
• 4 - Working with the Mouse.mp4 (6.6 MB)
• 5 - Excel Options English.vtt (3.7 KB)
• 5 - Excel Options.mp4 (5.1 MB)
10 - Formatting Worksheets
• 34 - Cell Formatting English.vtt (14.7 KB)
• 34 - Cell Formatting.mp4 (38.5 MB)
• 35 - Number Formatting English.vtt (12.7 KB)
• 35 - Number Formatting.mp4 (26.1 MB)
• 36 - Borders and Shading English.vtt (12.0 KB)
• 36 - Borders and Shading.mp4 (36.4 MB)
• 37 - Format as Table English.vtt (8.6 KB)
• 37 - Format as Table.mp4 (25.9 MB)
• 38 - Using Styles English.vtt (10.7 KB)
• 38 - Using Styles.mp4 (31.8 MB)
• 39 - Using Format Painter English.vtt (5.5 KB)
• 39 - Using Format Painter.mp4 (15.3 MB)
• 40 - Protecting Sheets English.vtt (14.2 KB)
• 40 - Protecting Sheets.mp4 (34.0 MB)
• 41 - Fill Handle and Custom Lists English.vtt (8.7 KB)
• 41 - Fill Handle and Custom Lists.mp4 (17.9 MB)
11 - Charts
• 42 - Creating Charts English.vtt (14.2 KB)
• 42 - Creating Charts.mp4 (23.9 MB)
• 43 - Types of Charts English.vtt (6.0 KB)
• 43 - Types of Charts.mp4 (10.8 MB)
• 44 - Editing Charts English.vtt (13.2 KB)
• 44 - Editing Charts.mp4 (26.0 MB)
• 45 - Using Graphics to Enhance Charts English.vtt (7.2 KB)
• 45 - Using Graphics to Enhance Charts.mp4 (19.9 MB)
• 46 - Course Review English.vtt (0.9 KB)
• 46 - Course Review.mp4 (937.3 KB)
12 - Working with Names
• 47 - Creating Range Names English.vtt (12.7 KB)
• 47 - Creating Range Names.mp4 (38.9 MB)
• 48 - Managing Names English.vtt (3.4 KB)
• 48 - Managing Names.mp4 (9.6 MB)
• 49 - Using Names in Formulas English.vtt (6.9 KB)
• 49 - Using Names in Formulas.mp4 (12.5 MB)
13 - Sorting and Filtering
• 50 - Removing Duplicates English.vtt (11.8 KB)
• 50 - Removing Duplicates.mp4 (56.1 MB)
• 51 - Sort Data English.vtt (14.1 KB)
• 51 - Sort Data.mp4 (61.7 MB)
• 52 - Filter Data English.vtt (13.9 KB)
• 52 - Filter Data.mp4 (68.1 MB)
• 53 - Advanced Filters English.vtt (4.7 KB)
• 53 - Advanced Filters.mp4 (23.1 MB)
14 - Outlining and Subtotaling
• 54 - Creating an Outline Part 1 English.vtt (10.2 KB)
• 54 - Creating an Outline Part 1.mp4 (25.0 MB)
• 55 - Creating an Outline Part 2 English.vtt (6.5 KB)
• 55 - Creating an Outline Part 2.mp4 (15.4 MB)
• 56 - Subtotals English.vtt (12.1 KB)
• 56 - Subtotals.mp4 (71.0 MB)
15 - Working with Views
• 57 - New Window Option English.vtt (4.3 KB)
• 57 - New Window Option.mp4 (11.2 MB)
• 58 - Arrange File Options English.vtt (3.4 KB)
• 58 - Arrange File Options.mp4 (7.7 MB)
• 59 - Creating a Workspace English.vtt (5.5 KB)
• 59 - Creating a Workspace.mp4 (12.1 MB)
• 60 - Custom Views English.vtt (7.4 KB)
• 60 - Custom Views.mp4 (20.7 MB)
• 61 - Scenarios English.vtt (7.9 KB)
• 61 - Scenarios.mp4 (18.7 MB)
16 - Linking Files
• 62 - Creating Formulas between Files English.vtt (9.9 KB)
• 62 - Creating Formulas between Files.mp4 (17.7 MB)
• 63 - Working with Links English.vtt (6.1 KB)
• 63 - Working with Links.mp4 (10.1 MB)
17 - Advanced Formula Creation
• 64 - IF Statement English.vtt (11.7 KB)
• 64 - IF Statement.mp4 (28.7 MB)
• 65 - VLookups English.vtt (9.1 KB)
• 65 - VLookups.mp4 (23.4 MB)
• 66 - Consolidating Data English.vtt (5.6 KB)
• 66 - Consolidating Data.mp4 (12.0 MB)
• 67 - Data Validation English.vtt (11.3 KB)
• 67 - Data Validation.mp4 (22.7 MB)
• 68 - Formula Auditing English.vtt (5.1 KB)
• 68 - Formula Auditing.mp4 (8.4 MB)
18 - Additional Excel Features
• 69 - Comments English.vtt (7.9 KB)
• 69 - Comments.mp4 (24.4 MB)
• 70 - Goal Seeker English.vtt (2.5 KB)
• 70 - Goal Seeker.mp4 (4.0 MB)
• 71 - Text to Columns Option English.vtt (3.4 KB)
• 71 - Text to Columns Option.mp4 (15.0 MB)
• 72 - Watch Window English.vtt (3.8 KB)
• 72 - Watch Window.mp4 (5.7 MB)
19 - Conclusion
• 73 - Closing Video English.vtt (0.7 KB)
• 73 - Closing Video.mp4 (769.7 KB)
2 - Getting Started Creating a New Workbook
• 10 - Working withe Ranges English.vtt (6.6 KB)
• 10 - Working withe Ranges.mp4 (10.0 MB)
• 6 - Entering Text and Numbers English.vtt (7.3 KB)
• 6 - Entering Text and Numbers.mp4 (9.1 MB)
• 7 - Creating Basic Formulas English.vtt (9.1 KB)
• 7 - Creating Basic Formulas.mp4 (15.2 MB)
• 8 - Relative References English.vtt (2.2 KB)
• 8 - Relative References.mp4 (4.4 MB)
• 9 - Order of Operations English.vtt (6.0 KB)
• 9 - Order of Operations.mp4 (10.9 MB)
20 - Intro to Excel 2010 Advanced Basic Steps for Charts Graphs
• 74 - Introduction to Advanced Excel 2010 English.vtt (3.5 KB)
• 74 - Introduction to Advanced Excel 2010.mp4 (5.8 MB)
• 75 - READ ME Essential Information for a Successful Training Experience.html (1.9 KB)
• 76 - Four Basic Steps When Creating ChartsGraphs English.vtt (11.4 KB)
• 76 - Four Basic Steps When Creating ChartsGraphs.mp4 (20.9 MB)
• 77 - Additional Features to Help Create ChartsGraphs English.vtt (15.0 KB)
• 77 - Additional Features to Help Create ChartsGraphs.mp4 (33.6 MB)
• 78 - Additional Features to Help Create ChartsGraphs Part 2 English.vtt (13.6 KB)
• 78 - Additional Features to Help Create ChartsGraphs Part 2.mp4 (32.5 MB)
21 - Layout Tab
• 79 - Detailed Formatting for ChartsGraphs English.vtt (13.1 KB)
• 79 - Detailed Formatting for ChartsGraphs.mp4 (24.1 MB)
• 80 - Formatting Legends within ChartsGraphs English.vtt (15.0 KB)
• 80 - Formatting Legends within ChartsGraphs.mp4 (29.4 MB)
• 81 - Formatting Axes and Gridlines within ChartsGraphs English.vtt (15.2 KB)
• 81 - Formatting Axes and Gridlines within ChartsGraphs.mp4 (34.6 MB)
22 - Trends
• 82 - Trends within Charts and Graphs English.vtt (11.8 KB)
• 82 - Trends within Charts and Graphs.mp4 (24.6 MB)
• 83 - Complex Trends within Charts and Graphs English.vtt (14.6 KB)
• 83 - Complex Trends within Charts and Graphs.mp4 (33.2 MB)
• 84 - Trends over Time within Charts and Graphs English.vtt (14.4 KB)
• 84 - Trends over Time within Charts and Graphs.mp4 (34.2 MB)
23 - Differences
• 85 - Showing Differences Using Bar Charts English.vtt (15.4 KB)
• 85 - Showing Differences Using Bar Charts.mp4 (32.0 MB)
• 86 - Showing Differences Using Pie Charts English.vtt (15.2 KB)
• 86 - Showing Differences Using Pie Charts.mp4 (35.0 MB)
• 87 - Limitations with Pie Charts How to Correct English.vtt (16.6 KB)
• 87 - Limitations with Pie Charts How to Correct.mp4 (33.0 MB)
• 88 - Alternative Ways to Show Differences English.vtt (13.4 KB)
• 88 - Alternative Ways to Show Differences.mp4 (26.7 MB)
24 - Relationships
• 89 - Using Charts Graphs to Show Relationships Part English.vtt (14.6 KB)
• 89 - Using Charts Graphs to Show Relationships Part.mp4 (30.2 MB)
• 90 - Using Charts Graphs to Show Relationships Part 2 English.vtt (14.4 KB)
• 90 - Using Charts Graphs to Show Relationships Part 2.mp4 (32.0 MB)
25 - Stock
• 91 - Charting Graphing Financial Information English.vtt (16.1 KB)
• 91 - Charting Graphing Financial Information.mp4 (47.3 MB)
• 92 - Charting Graphing Financial Information Part 2 English.vtt (10.0 KB)
• 92 - Charting Graphing Financial Information Part 2.mp4 (34.9 MB)
• 93 - Specific Charts for Finance Information English.vtt (13.5 KB)
• 93 - Specific Charts for Finance Information.mp4 (47.0 MB)
• 94 - Setting Up Live Charts English.vtt (13.0 KB)
• 94 - Setting Up Live Charts.mp4 (28.4 MB)
26 - Sparklines
• 95 - Using Sparklines for Data Visualization English.vtt (13.9 KB)
• 95 - Using Sparklines for Data Visualization.mp4 (34.3 MB)
27 - Data Bars Conditional Formatting
• 96 - Using and Formatting Data Bars Color Scales Icon Sets English.vtt (16.4 KB)
• 96 - Using and Formatting Data Bars Color Scales Icon Sets.mp4 (35.5 MB)
28 - Pivot Tables
• 100 - New Features for Pivot TablesCharts English.vtt (12.0 KB)
• 100 - New Features for Pivot TablesCharts.mp4 (34.2 MB)
• 97 - Setting Up Pivot TablesCharts English.vtt (14.6 KB)
• 97 - Setting Up Pivot TablesCharts.mp4 (34.2 MB)
• 98 - Setting Up Pivot TablesCharts Part 2 English.vtt (13.4 KB)
• 98 - Setting Up Pivot TablesCharts Part 2.mp4 (32.8 MB)
• 99 - Filtering Pivot TablesCharts English.vtt (12.2 KB)
• 99 - Filtering Pivot TablesCharts.mp4 (30.0 MB)
29 - Graphics
• 101 - Graphics Tools English.vtt (14.4 KB)
• 101 - Graphics Tools.mp4 (30.3 MB)
• 102 - Graphics Tools Part 2 English.vtt (10.6 KB)
• 102 - Graphics Tools Part 2.mp4 (37.2 MB)
3 - Saving Workbooks
• 11 - Working with Save and Save As Commands English.vtt (7.2 KB)
• 11 - Working with Save and Save As Commands.mp4 (10.9 MB)
• 12 - File Extensions English.vtt (4.8 KB)
• 12 - File Extensions.mp4 (7.8 MB)
30 - Exporting
• 103 - Exporting Charts and Graphs English.vtt (14.5 KB)
• 103 - Exporting Charts and Graphs.mp4 (30.7 MB)
• 104 - Exporting Charts and Graphs Part 2 English.vtt (13.6 KB)
• 104 - Exporting Charts and Graphs Part 2.mp4 (31.1 MB)
4 - Navigating Workbooks
• 13 - Opening a File English.vtt (6.2 KB)
• 13 - Opening a File.mp4 (11.0 MB)
• 14 - Working with Larger Files English.vtt (8.3 KB)
• 14 - Working with Larger Files.mp4 (22.7 MB)
• 15 - Freeze Panes Options English.vtt (3.2 KB)
• 15 - Freeze Panes Options.mp4 (9.5 MB)
• 16 - Split Screen Option English.vtt (4.6 KB)
• 16 - Split Screen Option.mp4 (14.7 MB)
5 - Printing
• 17 - Page Setup Options English.vtt (7.0 KB)
• 17 - Page Setup Options.mp4 (18.2 MB)
• 18 - Headers and Footers English.vtt (9.4 KB)
• 18 - Headers and Footers.mp4 (22.7 MB)
• 19 - Print Titles English.vtt (3.2 KB)
• 19 - Print Titles.mp4 (8.0 MB)
• 20 - Comments English.vtt (5.8 KB)
• 20 - Comments.mp4 (14.7 MB)
• 21 - Fit to print on one page English.vtt (6.9 KB)
• 21 - Fit to print on one page.mp4 (17.8 MB)
• 22 - Printing Workbooks English.vtt (3.1 KB)
• 22 - Printing Workbooks.mp4 (6.3 MB)
6 - Working with Rows Columns and Cells
• 23 - Adding and Deleting Rows Columns and Cells English.vtt (7.0 KB)
• 23 - Adding and Deleting Rows Columns and Cells.mp4 (17.1 MB)
• 24 - Changing Column and Row Widths English.vtt (5.5 KB)
• 24 - Changing Column and Row Widths.mp4 (13.5 MB)
7 - Moving Data
• 25 - Cut Copy and Paste English.vtt (8.2 KB)
• 25 - Cut Copy and Paste.mp4 (18.7 MB)
• 26 - Copying Formulas English.vtt (5.1 KB)
• 26 - Copying Formulas.mp4 (12.0 MB)
8 - Formulas and Functions
• 27 - Overview of Formulas English.vtt (4.1 KB)
• 27 - Overview of Formulas.mp4 (8.6 MB)
• 28 - Create Formulas using Functions Part 1 English.vtt (13.2 KB)
• 28 - Create Formulas using Functions Part 1.mp4 (31.9 MB)
• 29 - Create Formulas using Functions Part 2 English.vtt (8.9 KB)
• 29 - Create Formulas using Functions Part 2.mp4 (22.4 MB)
• 30 - Absolute Values English.vtt (7.2 KB)
• 30 - Absolute Values.mp4 (16.3 MB)
9 - Working with Worksheets
• 31 - Adding Deleting and Renaming Sheets English.vtt (8.3 KB)
• 31 - Adding Deleting and Renaming Sheets.mp4 (15.1 MB)
• 32 - Additional Sheet Tab Options English.vtt (6.7 KB)
• 32 - Additional Sheet Tab Options.mp4 (12.1 MB)
• 33 - 3D Formulas English.vtt (9.4 KB)
• 33 - 3D Formulas.mp4 (15.5 MB)
• Bonus Resources.txt (0.4 KB)