FreeTutorials Us learn-microsoft-excel-formulas-and-functions-with-examples

1. 01-welcome-to-the-course-be-a-professional-excel-user-with-this-course/001-0101-welcome-to-the-course.mp47.67MB
2. 01-welcome-to-the-course-be-a-professional-excel-user-with-this-course/004-0102-how-to-best-view-this-course.mp433.81MB
3. 01-welcome-to-the-course-be-a-professional-excel-user-with-this-course/005-0103-how-to-review-this-course-and-obtain-your-certificate-of-completion.mp48.43MB
4. 02-formula-and-function-basics/006-0201-operators-used-in-formulas-and-how-to-build-basic-formulas.mp444.14MB
5. 02-formula-and-function-basics/007-0202-operator-precedence-in-formulas.mp445.73MB
6. 02-formula-and-function-basics/008-0203-how-built-in-excel-functions-make-your-job-easier.mp426.64MB
7. 02-formula-and-function-basics/009-0204-inserting-functions-into-formulas-effectively.mp438.43MB
8. 02-formula-and-function-basics/010-0205-relative-cell-references-using-relative-cell-references-to-copy-formulas.mp414.56MB
9. 02-formula-and-function-basics/011-0208-subtotal-function-using-subtotal-function-effectively.mp429.16MB
10. 02-formula-and-function-basics/012-0209-using-formulas-in-tables-summarizing-and-referencing-data-in-a-table.mp451.44MB
11. 02-formula-and-function-basics/013-0210-use-structured-references-in-excel-tables.mp442.79MB
12. 02-formula-and-function-basics/014-0211-displaying-all-the-formulas-on-a-worksheet.mp412.54MB
13. 02-formula-and-function-basics/015-0212-handling-circular-references.mp412MB
14. 02-formula-and-function-basics/016-0213-using-named-cells-and-ranges-in-the-formulas.mp432.56MB
15. 02-formula-and-function-basics/017-0214-using-names-for-constants-formulas-applying-names-to-existing-reference.mp431.33MB
16. 02-formula-and-function-basics/018-0215-union-and-intersection-of-ranges.mp422.45MB
17. 02-formula-and-function-basics/019-0216-some-tips-on-how-to-work-with-formulas.mp411.93MB
18. 03-useful-mathematical-functions/020-0301-sum...-function-the-most-useful-function-in-excel.mp435.48MB
19. 03-useful-mathematical-functions/021-0302-mathematical-functions-average-max-and-min.mp428.88MB
20. 03-useful-mathematical-functions/022-0303-mathematical-functions-int-mod-round-rand-and-randbetween.mp430.66MB
21. 03-useful-mathematical-functions/023-0304-count-functions-in-excel.mp411.53MB
22. 03-useful-mathematical-functions/024-0305-learn-about-3d-reference-in-excel.mp427.38MB
23. 04-advanced-excel-formulas/025-0401-using-the-if...-function.mp431.72MB
24. 04-advanced-excel-formulas/026-0402-using-if...-iferror...-function-to-hide-excel-errors.mp424.04MB
25. 04-advanced-excel-formulas/027-0403-datedif...-function-a-useful-function.mp441.21MB
26. 04-advanced-excel-formulas/028-0404-left...-right...-mid...-len...-and-find...-functions.mp427.57MB
27. 04-advanced-excel-formulas/029-0405-concatenating-text-using-concatenate...-function-and-ampersand-operator.mp418.26MB
28. 04-advanced-excel-formulas/030-0406-using-text...-function-to-manipulate-numbers.mp418.18MB
29. 04-advanced-excel-formulas/031-0407-rept...-function-using-rept...-function-to-make-a-histogram.mp427.04MB
30. 04-advanced-excel-formulas/032-0408-date-manipulation-functions.mp437.04MB
31. 04-advanced-excel-formulas/033-0410-use-of-rank-functions-to-calculate-placings.mp432.07MB
32. 04-advanced-excel-formulas/034-0412-weekday...-function-use-of-weekday...-function.mp418.16MB
33. 04-advanced-excel-formulas/035-0413-or...-function-using-or...-function.mp412.32MB
34. 04-advanced-excel-formulas/036-0414-istext...-function-using-istext...-function.mp410.12MB
35. 04-advanced-excel-formulas/037-0415-row...-and-column...-functions.mp46.69MB
36. 04-advanced-excel-formulas/038-0416-indirect...-creating-a-dependent-drop-down-list-in-excel.mp415.47MB
37. 05-creating-formulas-that-manipulate-text/039-0501-finding-and-searching-within-a-text.mp427.81MB
38. 05-creating-formulas-that-manipulate-text/040-0502-counting-specific-characters-in-a-cell.mp410.91MB
39. 05-creating-formulas-that-manipulate-text/041-0503-counting-the-occurrences-of-a-substring-in-a-cell.mp410.43MB
40. 05-creating-formulas-that-manipulate-text/042-0504-extracting-the-first-and-last-words-of-a-string.mp424.47MB
41. 05-creating-formulas-that-manipulate-text/043-0505-extracting-all-but-the-first-word-from-a-text-or-string.mp49.05MB
42. 05-creating-formulas-that-manipulate-text/044-0506-separating-the-first-middle-and-last-names-from-the-full-names.mp419.73MB
43. 05-creating-formulas-that-manipulate-text/045-0507-counting-the-number-of-words-in-a-cell.mp415.55MB
44. 06-project-develop-a-professional-excel-template-using-excel-formulas/046-0601-introducing-array-formulas-how-to-enter-arrays-into-worksheet-cells.mp423.89MB
45. 06-project-develop-a-professional-excel-template-using-excel-formulas/047-0602-introducing-array-formulas-how-to-create-array-formulas-with-examples.mp423.34MB
46. 06-project-develop-a-professional-excel-template-using-excel-formulas/048-0603-index...-function-in-excel.mp430.1MB
47. 06-project-develop-a-professional-excel-template-using-excel-formulas/049-0604-vlookup...-function-in-excel.mp420.78MB
48. 06-project-develop-a-professional-excel-template-using-excel-formulas/050-0605-invoice-template-in-excel-part-1.mp427.12MB
49. 06-project-develop-a-professional-excel-template-using-excel-formulas/051-0606-invoice-template-in-excel-part-2.mp436.56MB
50. 06-project-develop-a-professional-excel-template-using-excel-formulas/052-0607-invoice-template-in-excel-part-3.mp454.29MB
51. 06-project-develop-a-professional-excel-template-using-excel-formulas/053-0608-invoice-template-in-excel-part-4.mp457.43MB