Complete Excel Functions - From Beginner to Mastery UdemyLibrary com

1. 1. Introduction/1. Introduction.mp471.97MB
2. 1. Introduction/4. How to get Excel.mp450.76MB
3. 1. Introduction/3. Course requirements.mp423.57MB
4. 1. Introduction/2. Introduction of the instructor.mp420.46MB
5. 2. Introduction to Excel/1. Introduction To Excel.mp4136.74MB
6. 2. Introduction to Excel/4. Making A Simple But Effective Income Statement.mp488.79MB
7. 2. Introduction to Excel/5. Making A Productivity Chart In Excel.mp473.68MB
8. 2. Introduction to Excel/2. Introduction To Graphs.mp455.17MB
9. 2. Introduction to Excel/3. Adding In Multiple Sheets.mp454.46MB
10. 2. Introduction to Excel/6. Making A Budget.mp453.68MB
11. 3. Excel Logic and Lookup Functions Projects/6. Section Summary.mp481.82MB
12. 3. Excel Logic and Lookup Functions Projects/3. Nest And() Andor Or() Functions Within Reference Functions.mp470.61MB
13. 3. Excel Logic and Lookup Functions Projects/4. Work With Choose(), Vlookup(), Index(), And Match() Functions.mp469.14MB
14. 3. Excel Logic and Lookup Functions Projects/5. Create A Vlookup() Function.mp438.87MB
15. 3. Excel Logic and Lookup Functions Projects/2. Create An If() Function.mp437.69MB
16. 3. Excel Logic and Lookup Functions Projects/1. What will we learn in this section.mp416.8MB
17. 4. Excel Math and Finance Functions Projects/2. Aggregate Data Using Both The Sum And Subtotal Functions.mp463.9MB
18. 4. Excel Math and Finance Functions Projects/6. Section Summary.mp463.71MB
19. 4. Excel Math and Finance Functions Projects/4. Use the Forecast function to forecast numbers along a trend.mp458.32MB
20. 4. Excel Math and Finance Functions Projects/5. Generate a net present value using a formula.mp448.14MB
21. 4. Excel Math and Finance Functions Projects/3. Calculate minimums, maximums and averages from data sets.mp433.43MB
22. 4. Excel Math and Finance Functions Projects/1. What will we learn in this section.mp422.89MB
23. 5. Excel Date and Time Functions Projects/2. Work with Excel’s date manipulation functions.mp483.99MB
24. 5. Excel Date and Time Functions Projects/3. Build a holiday date calculator.mp441.75MB
25. 5. Excel Date and Time Functions Projects/4. Section Summary.mp440.82MB
26. 5. Excel Date and Time Functions Projects/1. What will we learn in this section.mp413.02MB
27. 6. Excel Text and Information Functions Projects/6. Work with key informational functions for evaluating and responding correctly to.mp4102.23MB
28. 6. Excel Text and Information Functions Projects/8. Section Summary.mp452.98MB
29. 6. Excel Text and Information Functions Projects/5. Put textual data back together with formulae.mp451.71MB
30. 6. Excel Text and Information Functions Projects/3. Manipulate textual data.mp444.77MB
31. 6. Excel Text and Information Functions Projects/4. Replace portions of textual data.mp442.04MB
32. 6. Excel Text and Information Functions Projects/7. Use the Hyperlink function to build navigational menus inside an Excel Worksheet.mp437.79MB
33. 6. Excel Text and Information Functions Projects/2. Split textual data apart.mp433.85MB
34. 6. Excel Text and Information Functions Projects/1. What will we learn in this section.mp433MB
35. 7. Excel Lists/4. How to freeze rows or columns.mp4110.21MB
36. 7. Excel Lists/3. Sorting List without messing up the data.mp4103.01MB
37. 7. Excel Lists/2. How to filter items in a list.mp479.71MB
38. 7. Excel Lists/5. Remove duplicates from a list.mp465.97MB
39. 7. Excel Lists/6. Section Summary.mp465.14MB
40. 7. Excel Lists/1. What will we learn in this section.mp444.93MB
41. 8. Other Excel useful functions/6. Create an invoice template in Excel.mp4155.23MB
42. 8. Other Excel useful functions/2. COUNT, COUNTA and COUNTIF Functions.mp4135.32MB
43. 8. Other Excel useful functions/5. Format row based on a cell value.mp4108.05MB
44. 8. Other Excel useful functions/4. Work with ISNUMBER and SEARCH functions within text functions.mp486.19MB
45. 8. Other Excel useful functions/3. Create a drop down list.mp479.39MB
46. 8. Other Excel useful functions/7. Section Summary.mp443.56MB
47. 8. Other Excel useful functions/1. What will we learn in this section.mp423.19MB