Mr Excel & excelisfun Trick 23: Excel 2010 New Functions
Loading...
Loading...
16,324
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (7)
-
Not until about April, 2010.
-
Is 2010 out ?
-
You are welcome! It is fun to see all the new things!
Loading...
6:08
Mr Excel & excelisfun Trick 24: VLOOKUP, MAX, Boolean, IF, Which is Best?by ExcelIsFun3,733 views- 11:15
Mr Excel & excelisfun Trick 22: Conditional Formatting VBA or OFFSET?by ExcelIsFun4,378 views
- 2:52
Excel 2010 Preview #2: Copy & Paste Special Magicby ExcelIsFun22,177 views
- 9:28
Mr Excel & excelisfun Trick 25: Extract Records NOT Swim or Ski (Filter or Formula?)by ExcelIsFun1,939 views
- 6:46
Working with Pivot Tables in Excel 2010 - Part 3by titantechtraining23,109 views
- 29:31
Excel 2010 Statistics 03: Calculations, Formulas, Functions, Math & Comparative Operatorsby ExcelIsFun6,805 views
- 3:10
Excel Magic Trick 343: Delete Blanks Rows & Keyboard Magicby ExcelIsFun9,128 views
- 12:27
Total Training Microsoft Excel 2010: Essentials Ch 1 Lesson 1. Introducing Excelby totaltraining11,477 views
- 3:41
Excel 2010: Conditional Formattingby gcflearnfree23,841 views
- 12:43
Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formulaby ExcelIsFun22,271 views
- 7:53
Mr Excel & excelisfun Trick 19: VLOOKUP to Left (MATCH & INDEX or LOOKUP)by ExcelIsFun9,848 views
- 8:04
Mr Excel & excelisfun Trick 18: IF function with FIND SEARCH AND OR ISERROR & ISNUMBER functionsby ExcelIsFun12,666 views
- 7:22
Mr Excel & excelisfun Trick 34: Dynamic Range for Adding Three Methodsby ExcelIsFun8,391 views
- 10:27
Mr Excel & excelisfun Trick 54: Approximate Lookup To Return Multiple Itemsby ExcelIsFun3,727 views
- 9:03
Mr Excel & excelisfun Trick 74: Dynamic Range For VLOOKUP & Data Validation List - Table Featureby ExcelIsFun3,718 views
- 3:50
Excel Dynamic Chart #3: Table Feature (Excel 2010 / 2007) List Feature (Excel 2003)by ExcelIsFun26,131 views
- 3:25
Excel 2010 - New Featuresby gcflearnfree13,173 views
- 7:34
Microsoft Excel VLOOKUP Tutorial for Beginners - Office Excel 2003, 2007, 2010by jdflynn5561,430 views
- 8:58
Mr Excel & excelisfun Trick 40: VLOOKUP to 3 Different Lookup Tables (3 table_arrays)by ExcelIsFun5,557 views
- 7:18
Microsoft Excel 2010 Expert Level 1 Introductionby 599CD13,962 views
How did you get the FX bar to appear so you can type in a cell?
i cannpt find out how to get it on mine?
Thanks
alexandra9124 1 year ago
Go to the View Ribbon/Tab, then in the Show group check the Formula Bar check box.
You can type a formula in a cell without the Fx button.
The keyboard shortcut for the Fx Insert Funtcion dialog box is Shift + F3.
ExcelIsFun 1 year ago
Please.. Why excel 2010 doesn't have one Query function, like Google Docs!!... See the example below that google docs already suport.
=Query("Some List Range";"select A, Sum(B) Where A >"&A1&"group by A")
Or they could put query option in pivot table! The best part, is the I can put flexible formula variables inside the selec! (A1 could be a data)
Mrs Excel.. you have the power to suggest that!..
Thaks you!
murtamurta 2 years ago
Wow! That is cool!
Google has a great lookup function also that will look up search stuff!
ExcelIsFun 2 years ago
You guys totally rock
stevebrooks01 2 years ago
Just having fun with Excel!!
ExcelIsFun 2 years ago