INTRODUCTION: Conquer some of the most daunting features in Microsoft Excel once and for all. In this 2013 update to his popular series, aut...
INTRODUCTION:
Conquer some of the most daunting features in Microsoft Excel once and for all. In this 2013 update to his popular series, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. The course starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. Dennis then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and work with financial data using advanced formulas. Dennis focuses on practical examples that transition effortlessly to real-world scenarios
Topics include:
- Displaying and highlighting formulas
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Understanding the hierarchy of operations in formulas
- Using absolute and relative references
- Creating and expanding the use of nested IF statements
- Looking up information with VLOOKUP, MATCH, and INDEX
- Using the power functions: COUNTIF, SUMIF, and AVERAGEIF
- Analyzing data with the statistical functions
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Checking for errors with formulas
Tutorials from [41-60] Watch here Tutorials from [61-73] Watch here
1. Excel 2013 Advanced Formulas and Functions 00 01 intro
2. Excel 2013 Advanced Formulas and Functions 00 02 exFiles
3. Excel 2013 Advanced Formulas and Functions 01 01 display Formulas
4. Excel 2013 Advanced Formulas and Functions 01 02 AuditingTools
5. Excel 2013 Advanced Formulas and Functions 01 03 row Column Refs
6. Excel 2013 Advanced Formulas and Functions 01 04 copy Column Formulas
7. Excel 2013 Advanced Formulas and Functions 01 05 convert Formulas
8. Excel 2013 Advanced Formulas and Functions 01 06 update Values
9. Excel 2013 Advanced Formulas and Functions 01 07 debug Formulas
10. Excel 2013 Advanced Formulas and Functions 01 08 range Names
11. Excel 2013 Advanced Formulas and Functions 01 09 3D formulas
12. Excel 2013 Advanced Formulas and Functions 02 01 hierarchy
13. Excel 2013 Advanced Formulas and Functions 02 02 formulas Tab
14. Excel 2013 Advanced Formulas and Functions 02 03 insert Function
15. Excel 2013 Advanced Formulas and Functions 02 04 AutoSum
16. Excel 2013 Advanced Formulas and Functions 02 05 absolute Relative
17. Excel 2013 Advanced Formulas and Functions 02 06 mixed Reference
18. Excel 2013 Advanced Formulas and Functions 03 01 IF relational
19. Excel 2013 Advanced Formulas and Functions 03 02 IF nested
20. Excel 2013 Advanced Formulas and Functions 03 03 IF compound
21. Excel 2013 Advanced Formulas and Functions 04 01 VLOOKUP and HLOOKUP
22. Excel 2013 Advanced Formulas and Functions 04 02 approx Match
23. Excel 2013 Advanced Formulas and Functions 04 03 exact Match
24. Excel 2013 Advanced Formulas and Functions 04 04 nested Vlookup
25. Excel 2013 Advanced Formulas and Functions 04 05 large Vlookup
26. Excel 2013 Advanced Formulas and Functions 04 06 CHOOSE
27. Excel 2013 Advanced Formulas and Functions 04 07 MATCH
28. Excel 2013 Advanced Formulas and Functions 04 08 INDEX
29. Excel 2013 Advanced Formulas and Functions 04 09 MATCH INDEX
30. Excel 2013 Advanced Formulas and Functions 05 01 Single Criterion
31. Excel 2013 Advanced Formulas and Functions 05 02 Multiple Criteria
32. Excel 2013 Advanced Formulas and Functions 06 01 MEDIAN
33. Excel 2013 Advanced Formulas and Functions 06 02 RANK
34. Excel 2013 Advanced Formulas and Functions 06 03 LARGE SMALL
35. Excel 2013 Advanced Formulas and Functions 06 04 COUNT BLANK
36. Excel 2013 Advanced Formulas and Functions 06 05 COUNT
37. Excel 2013 Advanced Formulas and Functions 07 01 ROUND
38. Excel 2013 Advanced Formulas and Functions 07 02 MROUND
39. Excel 2013 Advanced Formulas and Functions 07 03 TRUNC
40. Excel 2013 Advanced Formulas and Functions 07 04 MOD
41. Excel 2013 Advanced Formulas and Functions 07 05 RAND
42. Excel 2013 Advanced Formulas and Functions 07 06 CONVERT
43. Excel 2013 Advanced Formulas and Functions 07 07 AGGREGATE
44. Excel 2013 Advanced Formulas and Functions 07 08 Roman Arabic
45. Excel 2013 Advanced Formulas and Functions 08 01 Dates
46. Excel 2013 Advanced Formulas and Functions 08 02 TODAY NOW
47. Excel 2013 Advanced Formulas and Functions 08 03 WEEKDAY
48. Excel 2013 Advanced Formulas and Functions 08 04 NETWORK DAYS
49. Excel 2013 Advanced Formulas and Functions 08 05 WORKDAY
50. Excel 2013 Advanced Formulas and Functions 08 06 DATED IF
51. Excel 2013 Advanced Formulas and Functions 08 07 EDATE EO MONTH
52. Excel 2013 Advanced Formulas and Functions 08 08 DATE VALUE
53. Excel 2013 Advanced Formulas and Functions 09 01 ARRAYS
54. Excel 2013 Advanced Formulas and Functions 09 02 Unique
55. Excel 2013 Advanced Formulas and Functions 09 03 FREQUENCY
56. Excel 2013 Advanced Formulas and Functions 09 04 TRANSPOSE
57. Excel 2013 Advanced Formulas and Functions 09 05 TREND GROWTH
58. Excel 2013 Advanced Formulas and Functions 09 06 Array MATCH
59. Excel 2013 Advanced Formulas and Functions 10 01 OFFSET
60. Excel 2013 Advanced Formulas and Functions 10 02 INDIRECT
61. Excel 2013 Advanced Formulas and Functions 10 03 Pick List
62. Excel 2013 Advanced Formulas and Functions 11 01 FIND MID
63. Excel 2013 Advanced Formulas and Functions 11 02 LEFT RIGHT
64. Excel 2013 Advanced Formulas and Functions 11 03 TRIM
65. Excel 2013 Advanced Formulas and Functions 11 04 Concatenate
66. Excel 2013 Advanced Formulas and Functions 11 05 PROPER
67. Excel 2013 Advanced Formulas and Functions 11 06 REPLACE
68. Excel 2013 Advanced Formulas and Functions 11 07 other Text Functions
69. Excel 2013 Advanced Formulas and Functions 12 01 CELL INFO
70. Excel 2013 Advanced Formulas and Functions 12 02 IS Functions
71. Excel 2013 Advanced Formulas and Functions 12 03 error Checking
72. Excel 2013 Advanced Formulas and Functions 12 04 IS FORMULA
73. Excel 2013 Advanced Formulas and Functions 13 01 goodbye
