Office Blogs: Helping business analysts take full advantage of Excel 2016 and the new Power BI

Surely you have already installed the Office 2016 Preview - check out this post about Excel 2016 and Power BI features on Office Blogs.

Office 2016 Preview is here!

Microsoft has released Office 2016 Preview. Check it out!

Excel Help Forums

Just thought of sharing links to those Excel forums I have found useful:

• stackoverflow
• Microsoft Answers
• MrExcel Message Board

I know there tons of others too; please share your favorite Excel forum in the comments and I'll add all quality sites to a new post!

My 'Getting Things Done' Tip - Disable all Message Arrival Notifications

Here's my two cents for the GTD idea bucket:

Remove all message arrival notifications.

If you are using Microsoft Outlook, here's how to do this in Outlook 2010:

• Go to File -> Options

• Open Mail tab

• Uncheck all options under Message Arrival

Excel: Sum Value of Same Cell Across Multiple Sheets

Heres a tip how to sum value of the same cell across multiple worksheets:

=SUM(Sheet1:Sheet3!B3)

This sums cell B3 from Sheet1, Sheet 2 and Sheet 3 - voilá!

European Spreadsheet Risks Interest Group (Excel Horror Stories)

Scary Excel Horror Stories here.

Excel VBA: Create Masked Password Dialog

Want to make a masked password dialog for your workbook?

Check this tip from Microsoft.