Tutorialsplanet NET Udemy - EXCEL at Work - Complete MS Excel Mastery Beginner to Pro

1. 1. Introduction to Microsoft Excel/1. Introduction.mp428.2MB
2. 1. Introduction to Microsoft Excel/2. How to Get the Most Out of This Course.mp479.75MB
3. 1. Introduction to Microsoft Excel/3. Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon.mp468.2MB
4. 1. Introduction to Microsoft Excel/4. Using Excel Templates to Save Time and Effort.mp480.59MB
5. 10. Importing Data from Other Sources/1. Import from Web, CopyPaste, and Cleaning Up Data.mp468.19MB
6. 11. New Features for Excel 2016/1. What's New in Excel 2016.mp445.57MB
7. 11. New Features for Excel 2016/2. 6 New Chart Types for 2016.mp455.98MB
8. 11. New Features for Excel 2016/3. Tell Me What You Want To Do - The New Help Feature.mp423.23MB
9. 11. New Features for Excel 2016/4. 1-Click Forecasting.mp450.31MB
10. 11. New Features for Excel 2016/5. 3D Maps.mp4138.11MB
11. 12. Excel Quick Tips and Tricks/1. Flash Fill and Auto Fill for Fast Data Entry.mp441.14MB
12. 12. Excel Quick Tips and Tricks/2. Shortcut Keystrokes for Working Faster.mp482.89MB
13. 12. Excel Quick Tips and Tricks/3. Paste Special for Better Pasting.mp4170MB
14. 12. Excel Quick Tips and Tricks/4. Laying Out Pages and Printing.mp440.27MB
15. 12. Excel Quick Tips and Tricks/5. Find and Delete Empty Cells Located Outside of Your Data.mp445.94MB
16. 12. Excel Quick Tips and Tricks/6. Use the Power of Tables.mp4177.65MB
17. 13. Conclusion/1. Conclusion.mp432.94MB
18. 2. Creating Your First Excel Document/1. Saving Your Document Where You Can Find It.mp414.72MB
19. 2. Creating Your First Excel Document/2. Entering Data and Navagating Around the Cells.mp417.31MB
20. 2. Creating Your First Excel Document/3. Creating Simple Formulas to Do Powerful Calculations.mp442.17MB
21. 2. Creating Your First Excel Document/4. Working with Workbooks and Worksheets.mp447.8MB
22. 3. Create a Kitchen Remodel Cost Worksheet/1. Introduction - Creating and Formatting Your Heading.mp422.52MB
23. 3. Create a Kitchen Remodel Cost Worksheet/2. Formatting Subheadings and Columns and Alphabetizings Lists.mp423.44MB
24. 3. Create a Kitchen Remodel Cost Worksheet/3. Entering and Formatting Numbers.mp421.56MB
25. 3. Create a Kitchen Remodel Cost Worksheet/4. Create Formulas to Quickly Calculate Your Costs.mp447.31MB
26. 3. Create a Kitchen Remodel Cost Worksheet/5. Formatting - Grids and Spacing.mp430.33MB
27. 4. Introduction to Excel Formulas and Functions/1. Introduction to Excel Formulas and Functions.mp432.41MB
28. 4. Introduction to Excel Formulas and Functions/2. What is a Formula and What Can It DO for You.mp410.38MB
29. 4. Introduction to Excel Formulas and Functions/3. What is a Function and What Does IT Do.mp459.82MB
30. 5. 3 Things to Know Before You Start Using Functions/1. The Anatomy of a Formula.mp448.99MB
31. 5. 3 Things to Know Before You Start Using Functions/2. Quickly Select Cells to Use in Your Formula.mp431.9MB
32. 5. 3 Things to Know Before You Start Using Functions/3. Absolute vs. Relative Cell References.mp440.12MB
33. 6. How to Use the 7 Most Popular Excel Functions/1. How to Use the Downloads to Learn Functions Faster.mp432.74MB
34. 6. How to Use the 7 Most Popular Excel Functions/2. AVERAGE and AVERAGEA Functions.mp418.49MB
35. 6. How to Use the 7 Most Popular Excel Functions/3. COUNT, COUNTA and COUNTBLANK Functions.mp429.23MB
36. 6. How to Use the 7 Most Popular Excel Functions/4. IF Functions.mp473.68MB
37. 6. How to Use the 7 Most Popular Excel Functions/5. SUMIF and SUMIFS Functions.mp448.02MB
38. 6. How to Use the 7 Most Popular Excel Functions/6. COUNTIF and COUNTIFS Functions.mp435.94MB
39. 6. How to Use the 7 Most Popular Excel Functions/7. VLOOKUP Function.mp4113.68MB
40. 6. How to Use the 7 Most Popular Excel Functions/8. LEFT, RIGHT and MID Functions.mp460.17MB
41. 7. Other Popular Excel Functions/1. CONCATENATE - Combining Text.mp427.53MB
42. 7. Other Popular Excel Functions/10. INDEX and MATCH.mp424MB
43. 7. Other Popular Excel Functions/11. UPPER, LOWER, and PROPER.mp425.85MB
44. 7. Other Popular Excel Functions/2. LEN - Length of Text.mp417.55MB
45. 7. Other Popular Excel Functions/3. FIND and SEARCH.mp420.84MB
46. 7. Other Popular Excel Functions/4. MIN and MAX.mp431.06MB
47. 7. Other Popular Excel Functions/5. AND and OR.mp444.62MB
48. 7. Other Popular Excel Functions/6. ROUND, CEILING and FLOOR.mp472.91MB
49. 7. Other Popular Excel Functions/7. TODAY and NOW.mp44.74MB
50. 7. Other Popular Excel Functions/8. CONDITIONAL FORMATTING.mp469.55MB
51. 7. Other Popular Excel Functions/9. ALT Shortcut Keys for INDEXMATCH Lecture.mp49.39MB
52. 8. Creating Charts From Your Spreadsheet/2. Introduction - How to Create a Chart.mp455.09MB
53. 8. Creating Charts From Your Spreadsheet/3. Format Your Chart.mp441.6MB
54. 8. Creating Charts From Your Spreadsheet/4. Create a Bar Chart.mp443.2MB
55. 8. Creating Charts From Your Spreadsheet/5. Create a Pie Chart.mp468.45MB
56. 8. Creating Charts From Your Spreadsheet/6. Create a Line Chart.mp440.31MB
57. 9. Pivot Tables and Pivot Charts/2. Introduction to Pivot Tables - Preparing Your Data.mp4101.2MB
58. 9. Pivot Tables and Pivot Charts/3. How to Create a Pivot Table.mp498.48MB
59. 9. Pivot Tables and Pivot Charts/4. Put Your Pivot Table to Work.mp4122.2MB
60. 9. Pivot Tables and Pivot Charts/6. Pivot Charts.mp458.04MB