Excel 2010 - 20 New Features - Northwest Accounting Educators Conference 2011

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm
In This video:
Some New features in Excel 2010:
1 Sparklines (1:00 min)
2 Ctrl Keyboard Shortcuts (4:34 min)
3 PivotTable Slicers (8:49 min)
4 New Print Preview and Print Options combined (12:32 min)
5 Conditional Formatting Negative Data Bars (16:11 min)
6 New PivotTable Calculations (20:28 min)
7 NETWORKDAYS Old 'Compatibility' Function (28:48 min)
8 NETWORKDAYS.INTL New 2010 Function (29:36 min)
9 WORKDAY Old 'Compatibility' Function (31:09 min)
10 WORKDAY.INTL New 2010 Function (32:04 min)
About 50 new Statistic Functions: (34:00 min)
11 STDEV Old 'Compatibility' Function (36:16 min)
12 STDEV.S New 2010 Function (36:16 min)
13 NORMSDIST Old 'Compatibility' Function (38:04 min)
14 NORM.S.DIST New 2010 Function (38:04 min)
15 RANK Old 'Compatibility' Function (40:47 min)
16 RANK.AVE New 2010 Function (40:47 min)
17 RANK.EQ New 2010 Function (40:47 min)
18 AGGREGATE New 2010 Function (43:28 min)
19 Customize Ribbon and QAT (44:11 min)
20 SUMIFS, COUNTIFS, AVERAGEIFS (New in 2007) (48:45 min)

Category:

Education

Tags:

• Excel
• 2007
• 2010
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• NAE
• Northwest
• Accounting
• Educators
• Conference
• 2011
• Diane
• Michael
• O'Neal
• Slaying
• Dragons
• Data
• Sparklines
• Ctrl
• Keyboard
• Shortcuts
• PivotTable
• Slicers
• Print
• Conditional
• Formatting
• Negative
• Bars
• NETWORKDAYS.INTL
• WORKDAY.INTL
• 50
• new
• Statistic
• Functions
• STDEV.S
• NORM.S.DIST
• Function
• RANK.AVE
• RANK.EQ
• AGGREGATE
• Customize
• Ribbon
• and
• QAT
• SUMIFS
• COUNTIFS
• AVERAGEIFS

[juanconradodelacruz]

Thank you for this wonderful knowledge that you shared.

[ExcelIsFun]

@juanconradodelacruz , you are welcome!

[HOASIASCYC]

And another great tribute to the World of Excel.

Thanks again (for the umpteenth time) for all the knowledge and information you share.

I think that I become (or still am) an "ExcelIsFun-addict" :) Please don't try to cure me or suggest a treatment :):)

Kind regards,

Jan Bolhuis

[ExcelIsFun]

@HOASIASCYC , Cool!! Me too: I am an Excel-fun-addict!!!

[SolZocalo]

Again - Nice Vid Mike. I loved the part about customizing the ribbon. I think the power, at least for me, used to be writing my own macros and being able to tie the macro code to a custom button (which I could design the icon too...). It seems like this new version of Excel is more complicated to do this same thing. Do you know if this capability exists or where to learn how to specifically do this same customization? I love VBA, but the ribbon is... well... I'd better stop now... Advice?

[ExcelIsFun]

@SolZocalo , no I don't know how to customize the bottons (like in the old versions - I used to love to draw my own button, pixel by pixel...). Try asking the Excel masters at:

mrexcel [dot] com/forum

[ExcelIsFun]

@FlamingSpaz29 , I am glad that the videos help!

[FlamingSpaz29]

Im so disappointed I can't compete in Spreadsheet Applications for FBLA anymore because I attended the National Leadership Conference. This stuff helps me understand so much on how Excel works. I watch the entire sermon and I love it. I will continue to learn and explore Excel.